RMAN问题

FOR_FREE

RMAN无法用sys用户连接，提示用户权限不足！！怎么解决？另外数据库用的操作系统认证，好像sqlplus xxx/xxx as sysdba，其中xxx为任意字符串均可连接，改为ORACLE认证后用sys用户无法连接，可以保证用户名密码没错，使用orapwd重建密码文件同样错误，求解决方法。

Ziqiu

注释掉sqlnet.ora文件中类似SQLNET.AUTHENTICATION_SERVICES = (NTS)那行试试

FOR_FREE

试过了，在initxx.ora里面也有remote_login_passwordfile＝'exclusive'这一行

Ziqiu

原帖由 FOR_FREE 于 2007-12-24 12:15 发表
试过了，在initxx.ora里面也有remote_login_passwordfile＝'exclusive'这一行

这个参数是针对密码文件的

Ziqiu

sqlnet注释掉前

C:\Documents and Settings\ThinkPad>sqlplus xxx/xxxx as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 24 12:44:59 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> exit
注释掉后
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:\Documents and Settings\ThinkPad>sqlplus xxx/xxxx as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 24 12:45:09 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝


请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝


SP2-0157: 在 3 次尝试之后无法连接到 ORACLE, 退出 SQL*Plus

C:\Documents and Settings\ThinkPad>sqlplus sys/sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 24 12:45:17 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:\Documents and Settings\ThinkPad>rman target sys/sys nocatalog

恢复管理器: Release 10.2.0.1.0 - Production on 星期一 12月 24 12:45:42 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到目标数据库: TEST (DBID=1934973662)
使用目标数据库控制文件替代恢复目录

RMAN> exit


恢复管理器完成。

C:\Documents and Settings\ThinkPad>sqlplus sys/sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 24 12:45:49 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter login

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

FOR_FREE

-bash-3.00$ vi sqlnet.ora
"sqlnet.ora" 5 lines, 204 characters
D
# sqlnet.ora Network Configuration File: /data/oracle/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
#SQLNET.AUTHENTICATION_SERVICES=NONE


-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 24 13:07:22 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

还是可以连接

FOR_FREE

SQL> select * from V_$PWFILE_USERS;

no rows selected

SQL>
发现PWFILE根本就没用起来，但是在initxx.ora中有这个参数
*.remote_login_passwordfile='EXCLUSIVE'
并且PWFILE用orapwd重新建过