RE: Determining Oracle status

Raj, excuse my ignorance of all things shell script like, but when I try to run this I keep getting the error "CHECK_CONNECT=$$.CHECK_CONNECT: is not an identified." any thoughts on this one. Regards, Kev. "hit any supermassive black hole to continue" __ Kevin Thomas Technical

RE: Determining Oracle status - thanks!

SMTP:[EMAIL PROTECTED]] > Sent: 18 September 2001 19:45 > To: Multiple recipients of list ORACLE-L > Subject: RE: Determining Oracle status > > tnsping $ORACLE_SID works pretty well... > > Nick > > -Original Message- > From: Barry Deevey [ <mailto:[E

Re: Determining Oracle status

Check out the following script. *** SCRIPT STARTS HERE* #!/usr/bin/sh ### # # Auther : Raj Sakthi # # Modification History: #

RE: Determining Oracle status

Use sqlplus internal, although this goes away with 9i "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Prince

RE: Determining Oracle status

#x27;$DB' is _NOT_ Accessible\n" fi fi rm /tmp/$$.1 # --- End of File HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Barry Deevey [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, September 18, 2001 1

Re: Determining Oracle status

Don't know how to change it to only 1 login attempt. But I would do a "select sysdate from dual;" after connect via sqlplus. This way if the 1st login failed, the SQL statement will cause the next two attemt fail as well and sqlplus will exit. Richard Ji >>> [EMAIL PROTECTED] 09/18/01 11:45A

RE: Determining Oracle status

Barry: I've seen responses saying to use TNSPING, but all that does is tell you if the listener is running on the destination machine. If the listener is up and no databases are up you will still get a positive response from TNSPING. So, here's what we do. This ksh function snippet requires th

RE: Determining Oracle status

Here's mine. Substitute 'user/pass' for 'internal' when running against external instances... if sqlplus -s

Re:RE: Determining Oracle status

Andreas > -- > Von: Barry Deevey[SMTP:[EMAIL PROTECTED]] > Gesendet: Dienstag, 18. September 2001 17:45 > An: Multiple recipients of list ORACLE-L > Betreff: Determining Oracle status > > Hi all, > > I am trying to write a script in unix th

Re: Determining Oracle status

cc: Sent by: Subject: Determining Oracle status [EM

RE: Determining Oracle status

gt; Gesendet:     Dienstag, 18. September 2001 17:45> An:     Multiple recipients of list ORACLE-L> Betreff:     Determining Oracle status> > Hi all, > > I am trying to write a script in unix that determines if a specific oracle> instance is available. I'm trying to avoi

RE: Determining Oracle status

Title: RE: Determining Oracle status tnsping $ORACLE_SID works pretty well...   Nick -Original Message- From: Barry Deevey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: Determining Oracle status Hi all

RE: Determining Oracle status

own ( tnsping returned $?)" fi - Hope this helps, Andreas > -- > Von: Barry Deevey[SMTP:[EMAIL PROTECTED]] > Gesendet: Dienstag, 18. September 2001 17:45 > An: Multiple recipients of list ORACLE-L > B

RE: Determining Oracle status

--- > Von: Barry Deevey[SMTP:[EMAIL PROTECTED]] > Gesendet: Dienstag, 18. September 2001 17:45 > An: Multiple recipients of list ORACLE-L > Betreff: Determining Oracle status > > Hi all, > > I am trying to write a script in unix that determines if a specific

RE: Determining Oracle status

Barry, A while ago, when I wrote a script to do this for a site, I attempted to login with a bogus userid/password and then checked for the Oracle error message. Thereby, eliminating a security hole, and not "hugely" impacting Oracle by logging in for a simple check. Also, I was poking around S

Re: Determining Oracle status

here is a snippet i use to determine if the db is up. u can use any sql script, i choose to get the db name and compare to sid. if [ `which sqlplus | grep "no sqlplus" | wc -l` -eq 0 ] && [ "`print "\n\n\n" | sqlplus -s guest/guest@$sid @$ORABIN/db_get_dbname | grep Instance_Name | awk '{p

Determining Oracle status

Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem