Solved

rac install

Posted on 2015-01-21
3
113 Views
Last Modified: 2015-01-25
which way we can find  whether RAC is install/Running on UNIX box and Window Box.
0
Comment
Question by:jeevan mathew
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40563240
Are you asking if RAC is installed or if a particular database is running in RAC?

To see if a database is running in RAC check the CLUSTER_DATABASE spfile parameter:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams028.htm#REFRN10015

To see if it is installed I would run the installer and look for the clusterware pieces.
0
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
ID: 40568065
Hi!

Here are some usefull RAC articles.
http://oracle-base.com/articles/rac/articles-rac.php

To see whether RAC is running you can issue this command
srvctl -h ( -h is help )
srvctl -v
in a command window in windows or shell in unix.

http://docs.oracle.com/cd/E11882_01/rac.112/e41960/srvctladmin.htm#RACAD5006

If this command is missing you are not running a RAC on that server.

You can also look for rac info using SQLPLUS like this
sqlplus / as sysdba

and the issue this sql command

SELECT inst_name FROM v$active_instances;

if you see :rac...

Then you are running RAC database
Regards,
     Tomas Helgi
0
 

Author Closing Comment

by:jeevan mathew
ID: 40569745
Good
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Error executing command from server 6 49
case statement in where clause with not exist 15 52
How to free up undo space? 3 39
SQL query question 8 73
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the dā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question