Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't Login with SID

Stephen PhillipsDec 2 2011 — edited Dec 3 2011
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
This post has been answered by 738992 on Dec 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2011
Added on Dec 2 2011
9 comments
1,536 views