script to find oracle databases that are not in cluster

Tags

shell scripts

Top Forums Shell Programming and Scripting script to find oracle databases that are not in cluster

08-31-2012

Registered User

16, 0

Join Date: Jul 2008

Last Activity: 13 July 2013, 6:43 AM EDT

Location: Ireland

Posts: 16

Thanks Given: 11

Thanked 0 Times in 0 Posts

script to find oracle databases that are not in cluster

I need to create a script to list all the databases that are in cluster environment.
The reason is that there are databases which are not in under cluster control and we need to identify those.
The easiest way to identify is:
clrt list (if SUNW.oracle_server:6, SUNW.oracle_listener:5 are not listed, then they are not in cluster environment)

but is there a better way and how to incorporate this into a script?
Our environment is quite big and I do have a list of all servers

thx

Moderator's Comments:

duplicate thread

Last edited by jim mcnamara; 08-31-2012 at 01:40 PM..

misterx12345

View Public Profile for misterx12345

Find all posts by misterx12345

Previous Thread | Next Thread

2 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Automation script for Oracle queries for two different Databases

Hi Team, I am Oracle Databse developer. I am currently working on two databases. DB1 and DB2. in DB1 I have a Select query which will return 100 records. In Db2 I have a Select query which also return 100 records. In these two tables ( in different Schemas) we have a common column. ...

2. UNIX and Linux Applications

Monitoring Tablespaces on Oracle Databases.

can anyone provide me with a basic command that can do this? like, is there a one liner command line i can run that will spit out some digits to me. (digits i can write a script to monitor)???

Shell Programming and Scripting