首页 > 数据库 > Oracle > GRANT SYSDBA TO USER
Solution Description: ===================== How to Enable Remote Access with ORAPWD on Oracle Parallel Server Refer to the manual: Oracle7 Server Documentation Addendum Release 7.1 for a complete reference on ORAPWD (Chapter 5 Database Connection Security). To enable remote access, create a password file: 1) run 'orapwd' to create the password file 2) set the init.ora praameter 'remote_login_passwordfile' to 'exclusive' or 'shared' For Parallel Server: Assuming that each node has its own ORACLE_HOME on its local hard disk and a unique ORACLE_SID, you would need to configure this for each Node. TO DETERMINE IF REMOTE ACCESS HAS BEEN ENABLED: Example (here it has not been configured): %sqldba mode=line SQLDBA> connect internal SQLDBA> show parameter remote_login_passwordfile NAME TYPE VALUE -------------------- ------- ------------------------------ remote_login_passwordfile string NONE SQLDBA> select * from v$pwfile_users; USERNAME SYSDB SYSOP ------------------------------ ----- ----- 0 rows selected. TO CONFIGURE A REMOTE ACCESS PASSWORD FILE 1) run 'orapwd' to create the password file Example: % orapwd file=/u01/oracle/V722/dbs/orapwV722 password=letmeon entries=1 where /u01/oracle/V722 is ORACLE_HOME which creates a file like this: -rwSr----- 1 oracle dba 6144 Mar 18 10:51 orapwV722 2) set the init.ora parameter 'remote_login_passwordfile' to 'exclusive' or 'shared' Example: % vi init. | ||||||||||||||||
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/421207/viewspace-921036/ ,如需转载,请注明出处,否则将追究法律责任。