Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privilegesORA-01031: insufficient privileg

Steve Yang_2
Advisor

ORA-01031: insufficient privilegesORA-01031: insufficient privileg

Hi, there:

Oracle 9.2.0 can not be connected. Password had been recreated once. It worked for 1 day and when the database hang, I reboot the system. Found that could not connect the database.

Any ideas will be welcome!

Thanks
steve_yxf
3 REPLIES
Brian Crabtree
Honored Contributor

Re: ORA-01031: insufficient privilegesORA-01031: insufficient privileg

1. You are logged in as the DB binaries owner, and you are in the DBA group specified when you did the installation (most likely, DBA). Try:

sqlplus "/ as sysdba"

Otherwise, you might have to recreate the password file, although this should always get you in.

Thanks,

Brian
Steven E. Protter
Exalted Contributor

Re: ORA-01031: insufficient privilegesORA-01031: insufficient privileg

connect internal was deprecated in this release.

sqlplus "/ as sysdba"

Will always get the oracle user in with normal priviledges.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steve Yang_2
Advisor

Re: ORA-01031: insufficient privilegesORA-01031: insufficient privileg

Thank you!

I think I set the wrong INSTANCE_ID and recreate the wrong passwd file.

now connected.

steve_yxf