06-15-2010
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.
10 More Discussions You Might Find Interesting
1. Linux
--------------------------------------------------------------------------------
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
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
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
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
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
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
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
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
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
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 SUNOS
delete-http-listener
asadmin-delete-http-listener(1AS) User Commands asadmin-delete-http-listener(1AS)
NAME
asadmin-delete-http-listener, delete-http-listener - removes the HTTP listener
SYNOPSIS
delete-http-listener --user admin_user[--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
[--terse=false] [--echo=false] [--interactive=true] httplistener_ID
Removes the HTTP listeners. This command is supported in remote mode only.
OPTIONS
--user authorized domain application server administrative username.
--password password to administer the domain application server.
--host machine name where the domain application server is running.
--port port number of the domain application server listening for administration requests.
--secure if true, uses SSL/TLS to communicate with the domain application server.
--passwordfile file containing the domain application server password.
--terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
formatted data for consumption by a script. Default is false.
--echo setting to true will echo the command line statement on the standard output. Default is false.
--interactive if set to true (default), only the required password options are prompted.
OPERANDS
listener_id listener ID of the HTTP listener.
Example 1: Using delete-http-listener
asadmin> delete-http-listener --user admin1
--password adminadmin1 --host pigeon --port 5001 sampleListener
Deleted http listener with id = sampleListener
Where: sampleListener is the HTTP listener deleted.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-create-http-listener(1AS), asadmin-list-http-listeners(1AS)
J2EE 1.4 SDK March 2004 asadmin-delete-http-listener(1AS)