Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges when trying to connect as sysdba
icon4.gif  ORA-01031: insufficient privileges when trying to connect as sysdba [message #260132] Fri, 17 August 2007 09:57 Go to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Hello All,

I am trying to connect to the database as sys user
Enter Username: sys@rman as sysdba
Enter Password: xxxx

It gives me error ORA-01031: insufficient privileges

But i am able to connect when NOT using the connection string
Enter Username: sys as sysdba
Enter Password:

I checked my Environmental Variables, tried re-creating the password file, and has the remote_login_passwordfile=EXCLUSIVE

But i am able to connect to the Database using the connection string when it is up and running. And NOT able to do the samething when it is shutdown or i am not able to startup the database when using the connection string.

I would greatly appreciate if someone can shed light or let me know if i am missing something here.

Thanks,
Vikram
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260146 is a reply to message #260132] Fri, 17 August 2007 10:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wrong password?

Regards
Michel
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260151 is a reply to message #260132] Fri, 17 August 2007 10:54 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Michel,

I have the right password. I am not able to understand if i am missing anything there.

-Vikram
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260163 is a reply to message #260151] Fri, 17 August 2007 11:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure you are using the password that is in the password file?
Restart the database and post "show parameter remote_login_passwordfile".

Regards
Michel
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260170 is a reply to message #260132] Fri, 17 August 2007 11:30 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Yes, I am using the same password in the password file.

And below is the output you asked me for


SQL> show parameter remote_login_passwordfile

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

Let me know if you need any other information

Thanks,
Vikram
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260173 is a reply to message #260170] Fri, 17 August 2007 11:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you restart the database after changing the parameter?
Did you check you use the tnsnames.ora you think you use (check tns_admin parameter)?
Did you check your alias point to the database you want to connect (check tnsping rman and tnsnames.ora file)?
Which OS are you using?

Regards
Michel
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260178 is a reply to message #260132] Fri, 17 August 2007 11:47 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Michel,

I am working on AIX. tnsping works fine and returns

$/u/oracle >tnsping rman

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production on
17-AUG-2007 12:39:22

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = xx.x.xx.xx)(PORT = 1521))) (CONNECT_DATA = (SERVER=DEDICATED) (SERVICE_NAME = rman)))

My tnsnames.ora file looks good.

I am not using sqlnet.ora file at all. Do you think that might have something to do with my issue.

And just to let you know, if i use the connection string to connect to the database it works fine if the database is up and running. But if i shutdown the database using 'sys as sysdba' and try to start it with the connect string sys@rman as sysdba, it fails.

Thanks,
Vikram
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260191 is a reply to message #260178] Fri, 17 August 2007 12:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah ha! It does not happen every time but only after you shut down.
Does it happen if you exit SQL*Plus and start a new SQL*Plus?

Regards
Michel
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260204 is a reply to message #260132] Fri, 17 August 2007 12:56 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Thats true, it happens when i shutdown the database and tries to connect using the connection string.

Does it happen if you exit SQL*Plus and start a new SQL*Plus?

Yes
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260210 is a reply to message #260204] Fri, 17 August 2007 13:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Let's make an experience.
Use "rman target sys/psw@rman"
and try to startup from RMAN.
What do you get?

Regards
Michel
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260214 is a reply to message #260132] Fri, 17 August 2007 13:32 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
I have shutdown the database and tried doing this, i get

$:/u/oracle >rman target sys/xxxx@rman nocatalog

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. 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

But again, i started the database and did the same thing, i get

$:/u/oracle >rman target sys/xxxx@rman nocatalog

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: RMAN (DBID=1441339890)
using target database controlfile instead of recovery catalog

RMAN>

-Vikram
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260217 is a reply to message #260132] Fri, 17 August 2007 13:34 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
I have shutdown the database and tried doing this, i get

$:/u/oracle >rman target sys/xxxx@rman nocatalog

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. 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

But again, i started the database and did the same thing, i get

$:/u/oracle >rman target sys/xxxx@rman nocatalog

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: RMAN (DBID=1441339890)
using target database controlfile instead of recovery catalog

RMAN>

-Vikram
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260219 is a reply to message #260132] Fri, 17 August 2007 13:37 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
use CUT & PASTE to show results of following command
id
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260222 is a reply to message #260132] Fri, 17 August 2007 13:40 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
$:/u/oracle >id
uid=501(oracle) gid=501(oinstall) groups=502(dba),505(cadbaops)
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260226 is a reply to message #260132] Fri, 17 August 2007 13:48 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Which group "owns" the files in $ORACLE_HOME/bin?
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260227 is a reply to message #260132] Fri, 17 August 2007 13:50 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
oinstall
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260229 is a reply to message #260227] Fri, 17 August 2007 13:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also who started the listener?
post "ls -l $ORACLE/bin/oracle $ORACLE/bin/sqlplus $ORACLE/bin/rman"

Regards
Michel
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260231 is a reply to message #260132] Fri, 17 August 2007 14:00 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Listener was started by Oracle user

and the output you asked for

$:/u01/app/oracle/product/9.2.0/bin >ls -l oracle sqlplus rman
-rwxr-xr-x 1 oracle oinstall 75454211 Apr 03 2005 oracle
-rwxr-xr-x 1 oracle oinstall 23041226 Apr 03 2005 rman
-rwxr-xr-x 1 oracle oinstall 15686550 Apr 03 2005 sqlplus
Re: ORA-01031: insufficient privileges when trying to connect as sysdba [message #260246 is a reply to message #260132] Fri, 17 August 2007 15:10 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
What is your OS name & version?
Are you logged directly to the same system where the DB itself is installed & runs?
If so, why are you trying to make a SQL*Net connection (as oppose to using BEQ protocol).
Do you see a record of the connection attemp in listener.log file?
Please post the contents of your listener.ora file.
Previous Topic: instance recovery....
Next Topic: Oracle is consuming all available memory
Goto Forum:
  


Current Time: Sat Dec 10 14:59:47 CST 2016

Total time taken to generate the page: 0.24368 seconds