Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Test if Oracle listener is running
Special Forums UNIX and Linux Applications Infrastructure Monitoring Test if Oracle listener is running Post 302429766 by abdul bari on Tuesday 15th of June 2010 12:41:42 PM
Old 06-15-2010
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 01:45 PM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Linux

running test

-------------------------------------------------------------------------------- I am running a test command and if the user is not found you have to type exit and it wiil exit. Ok I did that. But if the user is found it is supposed to finger them. But my problem is it makes you type exit first... (2 Replies)
Discussion started by: skooly5
2 Replies

2. Shell Programming and Scripting

Script to test for scripts running

Hi, Im writing a script that will check which scripts are running. The script will run on a 5min loop and the status of the scripts will be written to the log. If any of the scripts arent running an email will be sent out. At the min if all scripts are running an entry is made to the log... (19 Replies)
Discussion started by: runnerpaul
19 Replies

3. UNIX and Linux Applications

A question/problem about oracle "tns listener" and "enterprise manager"

hi, I have * an IBM P550 machine, * an AIX 5.3 running on it and * an oracle database, already installed on it. The problem (or question of my own) is: Oracle tns listener, "CT_LISTENER", and the enterprise manager (EM) of the instance, which is uniq instance and called... (0 Replies)
Discussion started by: talipk
0 Replies

4. UNIX for Advanced & Expert Users

A question/problem about oracle "tns listener" and "enterprise manager"

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... (1 Reply)
Discussion started by: talipk
1 Replies

5. UNIX for Advanced & Expert Users

make test fails for DBD::Oracle installation

I've already installed the DBI Perl Module with no issues and now I'm attempting to install the DBD::Oracle driver on a Red Hat Enterprise 4 server and am having some trouble. I've checked through the forums and haven't seen anything helpful at this point. Everything goes fine during the perl... (1 Reply)
Discussion started by: pstrosnyder
1 Replies

6. UNIX and Linux Applications

Oracle - How to manage listener log files

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... (1 Reply)
Discussion started by: yhcheong
1 Replies

7. Red Hat

Oracle Listener Error on Red hat 5

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... (5 Replies)
Discussion started by: blacksteel1988
5 Replies

8. AIX

SIGHUP killing Oracle Listener Process

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 )... (2 Replies)
Discussion started by: jimthompson
2 Replies

9. Programming

Oracle Variable Passing Test

Hi, I am trying to get the oracle variables and pass the values in sql placed in procedure. VARIABLE vstat='ASDS,FGDS,VCGD,VCXC' Query : select distinct dept from College where section in ('C','D') AND CODES ='' AND NAMES IN ('RAJ','SAM'); I want CODES values to be taken from vstat... (1 Reply)
Discussion started by: Perlbaby
1 Replies

10. AIX

Oracle Listener gets killed when root session is closed

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... (5 Replies)
Discussion started by: filosophizer
5 Replies

LEARN ABOUT SUSE

ocf_heartbeat_oralsnr

OCF_HEARTBEAT_ORALSN(7) 					OCF resource agents					   OCF_HEARTBEAT_ORALSN(7)

NAME

       ocf_heartbeat_oralsnr - Manages an Oracle TNS listener

SYNOPSIS

       oralsnr [start | stop | status | monitor | validate-all | meta-data | methods]

DESCRIPTION

       Resource script for Oracle Listener. It manages an Oracle Listener instance as an HA resource.

SUPPORTED PARAMETERS

       sid
	   The Oracle SID (aka ORACLE_SID). Necessary for the monitor op, i.e. to do tnsping SID. (required, string, no default)

       home
	   The Oracle home directory (aka ORACLE_HOME). If not specified, then the SID should be listed in /etc/oratab. (optional, string, no
	   default)

       user
	   Run the listener as this user. (optional, string, no default)

       listener
	   Listener instance to be started (as defined in listener.ora). Defaults to LISTENER. (optional, string, no default)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 120.

       stop
	   Stops the resource. Suggested minimum timeout: 120.

       status
	   Performs a status check. Suggested minimum timeout: 60.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 10.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 5.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.

       methods
	   Suggested minimum timeout: 5.

EXAMPLE

       The following is an example configuration for a oralsnr resource using the crm(8) shell:

	   primitive example_oralsnr ocf:heartbeat:oralsnr 
	     params 
	       sid=string 
	     op monitor depth="0" timeout="30" interval="10"

SEE ALSO

       http://www.linux-ha.org/wiki/oralsnr_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents 1.0.3						    07/05/2010						   OCF_HEARTBEAT_ORALSN(7)
All times are GMT -4. The time now is 07:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy