Test if Oracle listener is running

Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
Test if Oracle listener is running

Hi All ,

I am new to shall scripting, i want write an script for oracle tns and listener.

If tns working i want o/p as "Listener and TNS are working"
else o/p should be ""Listener and TNS are not Working"

below is the command in unix to check the tns status, if no output it means TNS is working fine otherwise there TNS or Listener are not working.

Can anybody help to achieve this.

Thanks in Advance.
# 2  
Code:
if [ -z "$(Your_TNS_Cmd)" ]; then echo "Listener and TNS are working"; else echo "Listener and TNS are not working"; fi

# 3  
The script looks like below.

Code:
if [ -z "$tnsping ora_tns_name |grep TNS- "]; then
        echo "Listener and TNS are working";
else
echo "Listener and TNS are not working";
fi

if tns is working value of "$tnsping ora_tns_name |grep TNS- " is null ( i mean no o/p).

otherwise it gives some value.

can you suggest how to proceed with the above if condition.

Thanks again.

Last edited by Scott; 06-15-2010 at 12:45 PM.. Reason: Please use code tags
# 4  
Hi.

I may be wrong, but tnsping output will never be "null".

IMO, the answer that jim mcnamara gave, which he has since deleted, was the correct answer.

You should test the result of the tnsping command, not necessarily the output.

Code:
# Listener not running...
/home/oracle > tnsping db1

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 15-JUN-2010 17:08:51

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB1)))
TNS-12541: TNS:no listener
/home/oracle > echo $?
1


# Start listener
/home/oracle > lsnrctl start

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 15-JUN-2010 17:08:59

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/10.2/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date                15-JUN-2010 17:08:59
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "DB1" has 1 instance(s).
  Instance "DB1", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

# Listener running
/home/oracle > tnsping db1  

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 15-JUN-2010 17:09:04

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB1)))
OK (10 msec)
/home/oracle > echo $?      
0

So...
Code:
if tnsping db1 > /dev/null; then
  echo Listener running
else
  echo Listener not running
fi

This says absolutely nothing about whether any database is actually running!


edit: I've renamed your thread from if else question in unix to Test if Oracle listener is running (which may not be a perfect title, but at least other forum members who know about Oracle will see it, and may offer better help Smilie)

Last edited by Scott; 06-15-2010 at 01:54 PM..
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Oracle Listener gets killed when root session is closed
filosophizer
Hi everyone, This is a strange thing, sometimes when I type > exit from root session, i get a message > There are processes running after this message is displayed the oracle listener dies out and have to startup the listener again. but this doesn't have always. Where should I start to...... AIX
5
AIX
SIGHUP killing Oracle Listener Process
jimthompson
I have a cold backup script which backs up my database and then restarts the oracle listener and database at around 01:30 I can see at this time that my database and listener are indeed running. However at around 02:17 my listener process receives a SIGHUP 1 signal from the AIX OS ( version 5.3 )...... AIX
2
AIX
Oracle Listener Error on Red hat 5
blacksteel1988
Hello everybody, the reason why im posting this thread is because i've installed an oracle test database on RHEL 5, on a localhost (Since it is for test)... the thing is, after i have installed the DB it works just fine, but after i re start it, i get the following errors when i want to go into the...... Red Hat
5
Red Hat
Oracle - How to manage listener log files
yhcheong
Dear expert, I'm newbie in oracle, I have a problem regarding the listener log files under alert directory and trace directory(please refer to below). As the oracle hard disk size only 10GB, I have to manually delete the log files under alert directory and trace directory. Is that anyway for...... UNIX and Linux Applications
1
UNIX and Linux Applications
A question/problem about oracle "tns listener" and "enterprise manager"
talipk
hi, I have a problem about the Oracle related components. I'm not able to find any answer yet, and waiting for your responses... Here is the configuration of my system: * an IBM P550 machine, * an AIX 5.3 running on it and * an oracle database, already installed on it. The problem (or...... UNIX for Advanced & Expert Users
1
UNIX for Advanced & Expert Users