Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on ora-07318
check instance, is running ??
i
lokikal_at_my-deja.com napisał(a) w wiadomości:
<7m3pp5$v11$1_at_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
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>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 Sat Jul 10 1999 - 10:34:26 CDT