ORA-01031 following install of 8.1.7.4 patch

Hi,

I've spent the last day trying to figure out what's going wrong...

I am running 8.1.7.4.0, having just patched up from 8.1.7.0.0

When I try to connect internal to the database, instead of it just connecting (like it used to do) it prompts for a password, and regardless of what I type, comes back with the "ORA-01031: insufficient privileges" message.

OK, I have reviewed as many prior posts as possible on this issue, here's my log of unsuccesful activities:

• I've tried mods to the sqlnet.ora as suggested [either sql_net.dba_authorization = (NONE) || SQLNET.AUTHENTICATION = (NONE) ], no success
• I am running svrmgrl as the oracle owner of the db, the oracle utilities, and all files - db and oracle binaries - belong to the same unix group [dba2, note not dba]
• I cannot see any exising pwd files, but tried using orapwd to make a new one, and still no change [mind you, I don't know by what mechanism oracle knows to look in the $ORACLE_HOME/dbs/ loc'n for it]
• I have $ORACLE_SID set (but I didn't think this is required for just connect internal)
• I do know that connect internal is deprecated in 8i, and have tried also going in via sqlplus & then connect x/y as sysdba...
• re-linked all libs [ran 'relink all']

OS: Solaris 5.8, 32-bit
Oracle: 8.1.7.4.0

OK, my brief question is how can I just get connect internal to "work" [no pwd prompt] as before? I do notice in the *.aud files [$ORACLE_HOME/rdbms/audit] say I also have 1017 error (which I think is wrong userid/pwd)...

Finally, all of this "stopped working" after installing the 8.1.7.4 patch. I did have some trouble running the runInstaller, so eventually had to relink some of the files by hand [running make at the command line].

Any help, pointers appreciated.

Thanks

Steve Received on Thu Sep 11 2003 - 10:29:07 CDT