sgadef.dbf would be a file that only exists while the database is up.
Sounds like a problem related to file permissions, like maybe you started
the database under the wrong oracle software owner.
<lokikal_at_my-deja.com> wrote in message news: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 Fri Jul 09 1999 - 22:14:48 CDT
