ORA-01031: insufficient privilegesORA-01031: insufficient privileg

[Steve Yang_2]

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

[Brian Crabtree]

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]

connect internal was deprecated in this release.

sqlplus "/ as sysdba"

Will always get the oracle user in with normal priviledges.

SEP

[Steve Yang_2]

Thank you!

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

now connected.