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, - Kirti -----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
