I have seen several threads about this issue, but so far I can't figure it out. I don't know if my problem is different from the other people or if I am just missing something in the other threads.
I can login as SYSDBA if I set the ORACLE_SID variable, but if I try to specify it, with "/@FN91DMO", it won't work!.
Here's some commands to show you what is going on:
$echo $ORACLE_SID
FN91TRN
$ll $ORACLE_HOME/dbs/orapwd$ORACLE_SID
-rw-r-----. 1 oracle dba 1536 Dec 1 21:05 /oracle/home/dbhome_1/dbs/orapwdFN91TRN
$grep -i REMOTE_LOGIN_PASSWORDFILE /oracle/control/FN91TRN/initFN91TRN.ora
remote_login_passwordfile=exclusive
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 1 21:24:28 2011
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, OLAP, Data Mining and Real Application Testing options
SQL> show parameter REMOTE_LOGIN_PASSWORDFILE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> connect /@FN91TRN as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL>
I don't understand why I get the insufficient privileges.
I would be fine with just using the ORACLE_SID variable, but I need the @FN91TRN syntax for RMAN:
[oracle@lxdb02 ~]$ rman TARGET /@FN91DMO NOCATALOG AUXILIARY /@FN91TRN
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Dec 2 10:28:06 2011
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
Can anyone give me any tips to check toward fixing this? -- Thanks