Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
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