RE: SGADEF file?
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Aug 2006 13:03:33 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Tuesday, August 29, 2006 11:33 AM
To: onkarnath.tiwary@xxxxxxxxx; ORACLE-L
Cc: gogala@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Onkar N Tiwary
Sent: Tuesday, August 29, 2006 11:17 AM
To: ORACLE-L
Cc: gogala@xxxxxxxxxxxxx
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
Other related posts:
