topic Re: ORA-01031: insufficient privilegesORA-01031: insufficient privileg in Operating System - HP-UX

ORA-01031: insufficient privilegesORA-01031: insufficient privileg

Steve Yang_2 — Tue, 17 Feb 2004 17:23:16 GMT

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

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

Brian Crabtree — Tue, 17 Feb 2004 17:27:41 GMT

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

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

Steven E. Protter — Tue, 17 Feb 2004 17:29:12 GMT

connect internal was deprecated in this release.

sqlplus "/ as sysdba"

Will always get the oracle user in with normal priviledges.

SEP

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

Steve Yang_2 — Tue, 17 Feb 2004 18:53:26 GMT

Thank you!

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

now connected.