Re: ORA-01031 following install of 8.1.7.4 patch

See Metalink Note 69642.1

"UNIX: Checklist for Resolving Connect AS SYSDBA Issues"

"This bulletin lists the documented causes of getting prompted for a password when trying to CONNECT INTERNAL (or as SYSDBA) through "svrmgrl" or "sqlplus". In other words, if you get prompted for a password when trying to CONNECT INTERNAL, use the following to troubleshoot the problem."

Also see Note 1048876.6

"UNIX: Connect internal prompts for password after install"

HTH,
Dave

Steve Ball wrote:
> 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 - 14:45:54 CDT