OraFAQ Forum: Server Administration » how to findout what are Oracle Instance is avaliable on different Unix boxes

Home » RDBMS Server » Server Administration » how to findout what are Oracle Instance is avaliable on different Unix boxes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to findout what are Oracle Instance is avaliable on different Unix boxes [message #132650]

Mon, 15 August 2005 09:04

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi group..

Hope to find everyone in best of health and sprits

How to find out what all instance of oracle (up and down) are avaliable on different Unix Box.

I'll be connecting these boxes through putty session
(not as root user)

Regards
Puneet

Report message to a moderator

Re: how to findout what are Oracle Instance is avaliable on different Unix boxes [message #132655 is a reply to message #132650]

Mon, 15 August 2005 09:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

to find the instances , this will do.
ps -ef | grep smon

this will show only the instances that were started.
Will not show whether the databases are available for public.
a simple sql*plus login,query dual and logout will do that for you.

If OFA conventions are used, the oratab file should have entries for all the databases registered for that ORACLE_HOME.

Report message to a moderator

Re: how to findout what are Oracle Instance is avaliable on different Unix boxes [message #132887 is a reply to message #132655]

Tue, 16 August 2005 10:59

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi Thanks for the help

I used the Ps -ef| grep SMON and in one server i got 2 service runing for it

but when I go and do TNSPING with the SID avaliable in tnsora file it showz me oracle instance is there

Here is example

orabent 11852 1 0 Jan 27 ? 130:46 ora_smon_BENT
orah001 14679 14435 0 16:32:52 pts/5 0:00 grep smon
orah001 18304 1 0 Nov 05 ? 211:25 ora_smon_H001

and when I do TNSPING DBA (with sid = DBA) its working fine

what is this...

Puneet

Report message to a moderator

Re: how to findout what are Oracle Instance is avaliable on different Unix boxes [message #132890 is a reply to message #132887]

Tue, 16 August 2005 11:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

tnsping looks for the availablity of the listener.
It has nothing to do with instance.
assume a listener say LISTENER_A is up and available and is configured to listen the incoming calls for DB1,DB2.
assume you have entries in tnsnames.ora as DB1,DB2 that talks to respective datatabases.
then issue
$tnsping DB1
which will be OK, if the listener is listening to this incoming connection ( even if the database DB1 is down).

Report message to a moderator

Re: how to findout what are Oracle Instance is avaliable on different Unix boxes [message #132892 is a reply to message #132890]

Tue, 16 August 2005 11:24

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

wonderful,

Does it means I can only check for the instance running not for instances which are down.

As my user down have ROOT privilage.. so I guess this is my limitation.

Correct me If I'm wrong!

Puneet

Report message to a moderator

Re: how to findout what are Oracle Instance is avaliable on different Unix boxes [message #132894 is a reply to message #132892]

Tue, 16 August 2005 11:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>As my user down have ROOT privilage.. so I guess this is my limitation.
root priv has nothing to do with this.

>>Does it means I can only check for the instance running not for instances which are down.

have a closer look at your own question.
It is very trivial.
When a instance is down, it leaves no traces in memory.
So how can you search something, without knowing what you are searching?

so have a list of all instances/databases available.
Look for those instances (a simple sql connect will do).

Report message to a moderator

Previous Topic:	Introduction to the storage script
Next Topic:	defrag database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 00:27:20 CST 2025