It sounds like you're using code that checks for the existence of the sgadef
file to see whether the instance was running. As part of our upgrade
process we changed our code that did that (there was a fair amount of it) to
check for the SMON process instead.
HTH,
Jay Miller
-Original
You can also use the $ORACLE_HOME/bin/sysresv to check whether an instance
is up or not.
-Original Message-
Sent: Thursday, February 20, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
It sounds like you're using code that checks for the existence of the sgadef
file to see
I have an 8.1.7 Oracle instance on a server that does not create an SGADEF
file when it is started up. There are no errors in the log or trace files.
As a result of this file not being created, I cannot connect to the database
from a remote client. I get an error that says the instance is not
Ron,
This is not a problem due to the absence of sgadef file. This file was obsolete with
8i.
Your problem seems to be Oracle environment /or Sql*Net related.
Please check tnsnames.ora, sqlnet.ora, service names etc. on the client. Can you
connect to any other instance from this client?
This file is an Oracle 7 artifact AFAIK. I have looked through our
8.1.7 instances to be sure and I don't have that file anywhere. You
might want to start checking your TNS setup. Can you tnsping the
instance from the client? On the server can you say sqlplus
system/passwd@instance and