OraFAQ Forum: Server Administration » ORA-01031: insufficient privileges when trying to connect as sysdba

Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges when trying to connect as sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges when trying to connect as sysdba [message #260132]

Fri, 17 August 2007 09:57

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Wrong password?

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

use CUT & PASTE to show results of following command
id

Report message to a moderator

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

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

$:/u/oracle >id
uid=501(oracle) gid=501(oinstall) groups=502(dba),505(cadbaops)

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Which group "owns" the files in $ORACLE_HOME/bin?

Report message to a moderator

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

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

oinstall

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Also who started the listener?
post "ls -l $ORACLE/bin/oracle $ORACLE/bin/sqlplus $ORACLE/bin/rman"

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	instance recovery....
Next Topic:	Oracle is consuming all available memory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:32:14 CST 2024