Re: Oracle 7.1.4.1.10 can't connect after installation

John Dixon (jdixon_at_twinkie) wrote:
> David-Michael Lincke (dlincke_at_bandon.unisg.ch) wrote:
> : David-Michael Lincke (dlincke_at_bandon.unisg.ch) wrote:
> : > We've just installed Oracle 7.1.4.1.10 on HP-UX 9.05 and it seems the only
> : > user able to connect as user SYSTEM is oracle, the ORACLE_OWNER. Other
> : > users that are members of the dba group get the following:
 

> : > SQLDBA> connect
> : > Username: system
> : > Password:
> : > ORA-01034: ORACLE not available
> : > ORA-07320: smsget: shmat error when trying to attach sga.
> : > HP-UX Error: 13: Permission denied
 

> : Seems like the problem is even werse. No user except for the oracle user
> : can connect to the oracle db in any way!
 

> : A user, which is not a member of the dba group, receives the following on
> : attempting to connect to the db with sqlplus:
 

> : Enter user-name: stadler
> : Enter password:
> : ERROR: ORA-01034: ORACLE not available
> : ORA-07318: smsget: open error when opening sgadef.dbf file.
> : HP-UX Error: 13: Permission denied
 

> : Seems like the installation procedure majorly messed up with access rights.
> : The install log doesn't show any anomalies, though.
 

> : Any help is greatly appreciated.
 

> : Thanks,
> : dave
> : --
> : David-Michael Lincke Institute for Information Management at USG
> : EMail: dlincke_at_sgcl1.unisg.ch
> : URL: http://www-iwi.unisg.ch/about/team/dal.html
 

> Check the permissions on $ORACLE_HOME/bin/oracle. They should be
> -rwsr-sr-x (which is 6755)
> Note this sets user and group ID on execution. This is necessary in
> order for you to access the datafiles owned by oracle. This is
> normally set during the installation process.

That was the exact problem. root.sh didn't set those permissions, though. It was only after relinking the oracle server that the permissions were set.

Thanks a lot anyway,

dave

--
David-Michael Lincke	Institute for Information Management at USG
EMail: dlincke_at_sgcl1.unisg.ch
URL: http://www-iwi.unisg.ch/about/team/dal.html