Help on ora-07318

From: <lokikal_at_my-deja.com>
Date: Fri, 09 Jul 1999 03:20:13 GMT
Message-ID: <7m3pp5$v11$1@nnrp1.deja.com>

Hi folks,
After creating an Oracle7.3.2.1 instance on solaris 2.6 I get the following error when I try to connect to the instance using sqlplus.
prompt> sqlplus scott/tiger

SQL*Plus: Release 3.3.2.0.0 - Production on Thu Jul 8 20:05:14 1999

ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file. SVR4 Error: 13: Permission denied

Enter user-name:

Although I looked up ORA-07318 and ORA-1034 in the oracle error messages manual and followed the suggestion of shutting down and starting the DB again (including removing the instance and recreating it), I continue to get this error.

sgadef.dbf has rw-r----- for the user oracle, dba and so do the other *.dbf files.

Can any of the gurs give me a clue as to why I get the above error message?

Thanks in advance for your time and help, Sumi

p.s: when I remove the instance, I remove all the *.dbf files and *.ctl files. Is there any other file associated with an instance?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 22:20:13 CDT