Re: Oracle 7.1.4.1.10 can't connect after installation

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