Oracle 11g RAC 使用sys 通过 tnsname 连接 rman 时报权限不足

xiangsir

数据库版本 11.2.0.3.0
错误描述如下



rman target sys/passwd@tns_db
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Oct 16 05:27:22 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

tns_db 在 /u01/app/oracle/product/11.2.0/db1/network/admin/tnsnames.ora 中已配置。


SQL>  select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE

SQL> show parameter remote_login_passwordfile

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

$ORACLE_HOME/dbs 下的口令文件都在，并尝试过重建

同一个rac上有4个数据库，就其中一个数据库 rman 无法连接上，求大侠相助！！

Maclean Liu(刘相兵

sqlplus sys/passwd@tns_db as sysdba

给出输出

tnsping tns_db

lsnrctl status
ls -l $ORACLE_HOME/dbs


echo $ORACLE_SID
ps -ef|grep pmon

xiangsir

sqlplus sys/passwd@tns_db as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 16 06:25:38 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining and Real Application Testing options

tnsping db_name

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 16-OCT-2013 06:26:05

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/db1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db_name.hostname)))
OK (0 msec)


ps -ef | grep pmon
oracle     606     1  0 Jul31 ?        00:01:50 asm_pmon_+ASM1
oracle   17324     1  0 03:23 ?        00:00:00 ora_pmon_db_name1

cd /u01/app/oracle/product/11.2.0/db1/dbs
ls -lrt orapw*
-rw-r----- 1 oracle oinstall 2048 Oct 16 05:20 orapwdb_name1


lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-OCT-2013 06:30:46

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                16-OCT-2013 04:00:20
Uptime                    0 days 2 hr. 30 min. 26 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/grid/11.2.0.3/network/admin/listener.ora
Listener Log File         /u01/app/grid/11.2.0.3/log/diag/tnslsnr/slcae039-p/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "db_name" has 1 instance(s).
  Instance "db_name1", status READY, has 1 handler(s) for this service...

Maclean Liu(刘相兵

似乎你对很多代码做了处理，如果真的是 需要保密的系统 建议你开  SR 而不是来社区提问