Re: Help on ora-07318

The problem is likely that the permissions on the $ORACLE_HOME/bin/oracle executable are incorrect.

Run the following:

chown oracle $ORACLE_HOME/bin/oracle
chmod 4755 $ORACLE_HOME/bin/oracle

and attempt the connection again. It should work this time.

                                    Rick

lokikal_at_my-deja.com writes:

> 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.

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com