Re: Oracle 7.1.4.1.10 can't connect after installation

Hi

The same permission (6755) apply to $ORACLE_HOME/bin/orasrv.

Dennis at Lockheed Martin
In article <9167cb$314d.1e0_at_nntp.bsis.com>, jdixon_at_twinkie (John Dixon) writes:
> 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.
>
> John Dixon
> jhd_at_bsis.com
>
Received on Fri Sep 22 1995 - 00:00:00 CEST