OraFAQ Forum: Server Administration » Unable to login to SQLPLUS to start an Instance

Home » RDBMS Server » Server Administration » Unable to login to SQLPLUS to start an Instance

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

Unable to login to SQLPLUS to start an Instance [message #265387]

Thu, 06 September 2007 04:16

srelia
Messages: 4
Registered: September 2007

Junior Member

Hi everybody,
I am struggling to log into sqlplus to start an instance. I get the calssic "ORA-01031: insufficient privileges" error when I try SQL> conn / as sysdba.

I am logged into the server using ssh, using my NIS credentials. Then I sudo as root and set the environment variables to login as sqlplus /nolog. I have set the authentication parameter in sqlnet.ora. However when I tried adding myself to the dba group. I couldn't find the dba group.

I have 4 questions around this.
1) why is it that dba group isn't there
2)should i create it
3)whom should i add in there. Root or myself.
4)Lastly, please let me know if there is another way around this to fix the issue.

Thanks and Regards,
Saurabh Relia

Report message to a moderator

Re: Unable to login to SQLPLUS to start an Instance [message #265392 is a reply to message #265387]

Thu, 06 September 2007 04:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

1)Because it is not created.
2) your wish
3) The user you use to login through sqlplus
4)Creating password file.

Report message to a moderator

Re: Unable to login to SQLPLUS to start an Instance [message #265539 is a reply to message #265392]

Thu, 06 September 2007 11:12

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Then I sudo as root and set the environment variables to login as sqlplus /nolog.

Why didn't as a user Oracle or who owns Oracle.

Quote:

1) why is it that dba group isn't there

$ id
uid=2003(oracle) gid=1000(dba)

Quote:

2)should i create it

Double check weather its exist or not and then..

Quote:

4)Lastly, please let me know if there is another way around this to fix the issue.

1st check Your settings..

Report message to a moderator

Re: Unable to login to SQLPLUS to start an Instance [message #265545 is a reply to message #265387]

Thu, 06 September 2007 11:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Solution could depend upon OS name & version and Oracle version to FOUR decimal places.

I recently saw very similar results when OS user was NOT member of "dba" group.

It would be nice if OP read & followed all posting guidelines as stated in STICKY post at top of this forum.

Use CUT & PASTE plus <code tags> to post results from:
id
sqlplus
/ as sysdba
startup
exit

Report message to a moderator

Re: Unable to login to SQLPLUS to start an Instance [message #265748 is a reply to message #265392]

Fri, 07 September 2007 04:38

srelia
Messages: 4
Registered: September 2007

Junior Member

Thank You Arju,
Your answer did clarify some of my doubts.
Thank you Dreamz,
I did try using the db owner and was able to start the instance.
Thanks Anadecent. I have been able to sort the issue.
However there is one question that I still have and am unclear of it's answer. How come dba group doesn't exist? I doubt that it is created during install. However i will just go through the installation notes to check that. Please share with me your understanding about this.
Regards,
Saurabh

Report message to a moderator