ITPub博客

首页 > 数据库 > Oracle > GRANT SYSDBA TO USER

GRANT SYSDBA TO USER

原创 Oracle 作者:haitsun 时间:2007-06-25 15:30:35 0 删除 编辑
GRANT SYSDBA TO USER
Doc ID: Note:2064783.6Type: PROBLEM
Last Revision Date: 02-JUL-2002Status: PUBLISHED

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.ora 
remote_login_passwordfile=exclusive        
 
3) Grant SYSDBA or SYSOPER to a user 
 
Example: 
 
%sqldba mode=line 
SQLDBA> connect internal 
 
SQLDBA> show parameter remote_login_passwordfile 
NAME                    TYPE    VALUE 
-------------------- ------- ------------------------------ 
remote_login_passwordfile        string  EXCLUSIVE 
  
SQLDBA> select * from v$pwfile_users; 
USERNAME  SYSDB SYSOP 
------------------------------ ----- ----- 
INTERNAL        TRUE  TRUE 
SYS                            TRUE  TRUE 
2 rows selected. 
 
SQLDBA> grant sysdba to scott; 
SQLDBA> disconnect 
SQLDBA> connect scott/tiger as sysdba; 
SQLDBA> {shutdown and startup can be entered}

.
[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/421207/viewspace-921036/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    16
  • 访问量
    324943