Re: ORA-07318 sgadef.dbf

From: Rick Wessman <rwessman_at_us.oracle.com>
Date: 09 Aug 1999 12:30:08 -0400
Message-ID: <u4si8apdb.fsf@us.oracle.com>

Check your listener.ora on the remote machine. Make that sure that the address to which you are connecting specifies the correct ORACLE_SID and ORACLE_HOME.

                                        Rick

"Dan Knott" <dankno_at_saif.com> writes:

> I'm trying to connect from SQL*Plus 3.3.4 on a HPUX 10.2 server to an 8.1.5
> database on NT4 SP5.
>
> After changing the ORACLE_SID environmental variable, I launch SQL*Plus and
> get the following error when I try to log on.
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07318: smsget: open error when opening sgadef.dbf file.
> HP-UX Error: 2: No such file or directory.
>
> I'm able to signon with SQL*Plus to a local database and do a successful
> conn scott/tiger_at_nt8i. I'm also able to create and use a database link from
> the local database to the 8.1.5 database.
>
> Why is SQL*Plus looking for the address of a remote SGA on launch?
>
> Thanks for any help.
>
>
>

--

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

Received on Mon Aug 09 1999 - 11:30:08 CDT