RE: SGADEF file?

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 29 Aug 2006 13:03:33 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050846E2DE@usahm236.amer.corp.eds.com>

I will agree with Mr. Bobak. Connect to test that the database is not only started but is accessible to a non-privileged username.

IMHO -- Mark D Powell --

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark

	Sent: Tuesday, August 29, 2006 11:33 AM
	To: onkarnath.tiwary_at_gmail.com; ORACLE-L
	Cc: gogala_at_sbcglobal.net
	Subject: RE: SGADEF file?
	
	
	The best way to check if an instance is up and running is to

connect to it. If connection is not successful, report the specific Oracle error encountered. Checking for pmon or smon and a listener process is not good enough. What if archive log area is full? ORA-257 What if the audit destination is full? ORA-9817 Always attempt connection to check if database instance is available.

SGADEF has been obselete since at least 8i.

Hope that helps,

-Mark

	-- 
	Mark J. Bobak 
	Senior Oracle Architect 
	ProQuest Information & Learning 

	Ours is the age that is proud of machines that can think and

suspicious of men who try to. --H. Mumford Jones, 1892-1980

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary

	Sent: Tuesday, August 29, 2006 11:17 AM
	To: ORACLE-L
	Cc: gogala_at_sbcglobal.net
	Subject: SGADEF file?
	
	
	hi all,
	 
	I have a question (may sound silly to some of you) :
	 
	1. what are the different ways of checking if an oracle instance
is up and running or not?
	2. what is the use of "sgadef" file and what is the location of

this file on unix box? If this file is supported in oracle 8i and later or not?

Thanks in advance.

	-- 
	Thanks & Regards,
	T. Onkar Nath

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 29 2006 - 12:03:33 CDT