Re: urgent connect '/ as sysdba' insufficient privs
- From: Kip.Bryant@xxxxxxxxxx
- To: mburgess_nz@xxxxxxxxxxx
- Date: Wed, 30 Mar 2005 09:26:27 -0800
Hi Mark,
Interesting note about UID. Have you experienced this yourself? I went
through a disaster recovery drill at an outsourced site where everything was
built up from bare metal including accounts. My notes are not clear on when I
finally got annoyed enough to have the SA's create accounts with the original
UID so maybe I just got lucky. Startup with svrmgrl was OK. I added need for
documenting of original UID to procedures in the event that accounts still had
to be created from scratch.
Kip
|Hi April,
|have there been any previous changes to gid or uid for the oracle unix
|user after the last relink of the oracle executable? if so then you
|might have to relink the oracle binaries:
|$ORACLE_HOME/bin/relink all
|also check the permissions on $ORACLE_HOME/bin/oracle as well..they
|should be 6751 or rwsr-s--x
|from memory the uid and gid is stored in the oracle executable on
|relink..subsequent changes to the uid or gid for the oracle user can
|result in this sort of permissions error..
|aj wells wrote:
|> 9i instance
|> Linux
|>
|> Okay, we have an instance that we can log into connect sys/password as
|> sysdba and it works fine
|> however...
|> if we try to log in '/ as sysdba' it complains about insufficient privs...
|>
|>
|> suggestions would be most welcome
|>
|> have deleted password file and recreated password file
|> oracle user is a member of the dba group
|> relinked sqlplus
|> what are we missing?
|>
|> ajw
|> --
|> http://www.freelists.org/webpage/oracle-l
|>
|--
|http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: urgent connect '/ as sysdba' insufficient privs
- From: Mark Burgess
- References:
- urgent connect '/ as sysdba' insufficient privs
- From: aj wells
- Re: urgent connect '/ as sysdba' insufficient privs
- From: Mark Burgess
Other related posts:
- » urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- » RE: urgent connect '/ as sysdba' insufficient privs
- » RE: urgent connect '/ as sysdba' insufficient privs
- » Re: urgent connect '/ as sysdba' insufficient privs
- Re: urgent connect '/ as sysdba' insufficient privs
- From: Mark Burgess
- urgent connect '/ as sysdba' insufficient privs
- From: aj wells
- Re: urgent connect '/ as sysdba' insufficient privs
- From: Mark Burgess