OraFAQ Forum: Server Administration » Insufficient Privilege

Home » RDBMS Server » Server Administration » Insufficient Privilege (Oracle DB 10 g)

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

Insufficient Privilege [message #498547]

Thu, 10 March 2011 04:05

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

Dear All,

When i want to connect inro database by Following:

# sqlplus /nolog
sql>conn / as sysdba

Insufficient privilege.

What are the reasons. Please help me.

Sultan Mahmud

Report message to a moderator

Re: Insufficient Privilege [message #498549 is a reply to message #498547]

Thu, 10 March 2011 04:14

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You are not in the OS "dba" group.

Regards
Michel

Report message to a moderator

Re: Insufficient Privilege [message #498554 is a reply to message #498549]

Thu, 10 March 2011 04:36

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

I am sure that i am DBA group

Report message to a moderator

Re: Insufficient Privilege [message #498555 is a reply to message #498554]

Thu, 10 March 2011 04:38

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

I can connect sys as sysdba with password but sys / as sysdba cannot.

Report message to a moderator

Re: Insufficient Privilege [message #498560 is a reply to message #498555]

Thu, 10 March 2011 04:52

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post sqlnet.ora content.

Regards
Michel

Report message to a moderator

Re: Insufficient Privilege [message #498562 is a reply to message #498560]

Thu, 10 March 2011 04:58

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

Report message to a moderator

Re: Insufficient Privilege [message #498564 is a reply to message #498562]

Thu, 10 March 2011 05:02

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

My conclusion is still you are not in the OS dba group.

Regards
Michel

Report message to a moderator

Re: Insufficient Privilege [message #498565 is a reply to message #498564]

Thu, 10 March 2011 05:08

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

My Linux user "oracle" whose id is
uid=500(oracle) gid=500(oinstall) group 500(oinstall),501(dba)

Although if i am not the OS DBA group then how i can Backup by rman

Regards

Mahmud

Report message to a moderator

Re: Insufficient Privilege [message #498574 is a reply to message #498565]

Thu, 10 March 2011 05:36

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Although if i am not the OS DBA group then how i can Backup by rman

You can do it giving the password.

There are only 2 reasons you can't connect "/ as sysdba":
1/ You are not in the OS (sys)dba group
2/ SQLNET.AUTHENTICATION_SERVICES does not contain NTS

If you are sure you are in the OS dba group, then check you are actually using the sqlnet.ora you posted.

Regards
Michel

Report message to a moderator