| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8.1.7 Instance not creating an SGADEF file
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 Message-----
Sent: Tuesday, February 18, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
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?
FWIW:
The sgadef file had following text in 8.0.x versions:
This file is now obsolete. It will be removed in a future release. To determine whether an instance is up, you should check for the existence of the PMON process associated with the instance.
HTH,
-----Original Message-----
Sent: Tuesday, February 18, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L
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 running. I can connect to the instance from SVRMGRL on while logged onto the server. Any ideas why the file would not get created?
Thanks!
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 20 2003 - 09:29:00 CST
 |
 |