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 DEBIAN
osd_cat
XOSD(1) General Commands Manual XOSD(1)
NAME
osd_cat - X on-screen file displayer
SYNOPSIS
osd_cat [OPTION] [FILE]...
osd_cat -b percentage|slider [OPTION]
DESCRIPTION
Display FILE, or standard input, on X screen.
-p, --pos=POS
This option tells osd_cat where to display the text. POS can be top, middle, or bottom. The default is top.
-o, --offset=OFFSET
This option specifies the offset from the top or bottom of screen the text is displayed. The default is 0.
-A, --align=ALIGN
This option tells osd_cat where to display the text. ALIGN can be left, right or center. The default is left.
-i, --indent=OFFSET
This option specifies the INDENT from the left of screen the text is displayed. The default is 0.
-f, --font=FONT
This option specifies the FONT to be used for displaying the text. The default is fixed.
-c, --color=COLOR
This option specifies the COLOR to be used for displaying the text. The default is red.
-d, --delay=TIME
This option specifies the number of seconds the text is displayed. The default is 5 seconds.
-l, --lines=LINES
This option specifies the number of LINES to scroll the display over. The default is 5.
-s, --shadow=OFFSET
This option specifies the OFFSET of the text shadow. The default is 0, which means no text shadow is created.
-S, --shadowcolour=COLOUR
This option specifies the COLOUR of the text shadow. The default is black.
-O, --outline=WIDTH
This option specifies the WIDTH of the text outline. The default is 0, which is no outline.
-u, --outlinecolour=COLOUR
This option specifies the COLOUR of the text outline. The default is black.
-a, --age[=SCROLL_AGE]
This option affects screen redrawing. If SCROLL_AGE seconds pass before a new line is ready (for example, you're reading from a
pipe), all lines are cleared at once instead of being scrolled off as new lines replace old lines. The default is 0.
When no SCROLL_AGE is explicitly given, the current value from DELAY is used.
-w, --wait
This option also affects screen redrawing. When there is data ready to be put on screen, this option will cause osd_cat to wait
until the display is clear. An alternative to scrolling.
-b, --barmode=TYPE
Lets you display a percentage or slider bar instead of just text. TYPE may be percentage or slider. In this mode no text is read
from any file, but the following options can be used:
-P, --percentage=PERCENTAGE
This option specified the position of the percentage / slider bar. PERCENTAGE may be in the range from 0 to 100, the default is 50.
-T, --text=TEXT
This option specifies an optional TEXT which gets displayed above the percentage bar. The default is empty, so no additional text
is displayed.
-h, --help
display help (which is often more up to date) and exit
With no FILE, or when FILE is -, read standard input.
AUTHOR
Martijn van de Streek <martijn@foodfight.org>, Some patching done by Malcolm Valentine <farkit@iprimus.com.au> and Tim Wright
<tim@ignavus.net>.
xosd was written by Andre Renaud <andre@ignavus.net> and is maintained by Tim Wright <tim@ignavus.net>
SEE ALSO
More information on the X OSD Library and its author can be found on http://www.ignavus.net/software.html
<http://www.ignavus.net/software.html>
COPYRIGHT
It is distributed under the GNU General Public License.
X OSD cat January 2001 XOSD(1)