Home » RDBMS Server » Server Administration » Unable to connect in sqlplus
Unable to connect in sqlplus [message #145960] Mon, 07 November 2005 20:03 Go to next message
Keith Tai
Messages: 6
Registered: April 2004
Junior Member
Hi, the environment is like this.

Sun Solaris 9 with Oracle9iR2 SE installed.

Last time I login to the system using root and 'connect / as sysdba', sqlplus allow to go now. But now it came out error

ORA01031: insufficient privileges

The error even come out if I login as oracle user.

It bugs me that it suddenly happen. Anyone encounter the same problem? My application requires that / thingy.

Help! I need somebody Smile

Report message to a moderator

Re: Unable to connect in sqlplus [message #145992 is a reply to message #145960] Tue, 08 November 2005 01:38 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
When you connect to oracle using the string "/ as sysdba" OS authentication takes place. In this case, only that OS user which is member of DBA group can get authenticated & log onto oracle.

Anyways, when you can login into system using root, all you need to do after that is "su -c <user owning oracle s/w>"
After that you can get in using the string "/ as sysdba" as well.
Or else, make root member of DBA group.

--Girish

Report message to a moderator

Previous Topic: access oracle database on a server
Next Topic: Tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 09:14:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.