Concepts and Architecture - What is the command to find the database that already present before connecting ?

GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture

Go To First | Previous Question | Next Question

Concepts and Architecture | Question 73 of 74

What is the command to find the database that already present before connecting ?

Total Answers and Comments: 5

Last Update: September 25, 2009 Asked by: mojidra

Sponsored Links

Best Rated Answer

—

Submitted by: mmaz2002

In UNIX ps -ef || grep Oracle command can be used to know if all the bgprocesses are up and running & in WINDOWS services needs to be checked.

Above answer was rated as good by the following members:
SOMU123

October 03, 2008 05:46:52

subhash.terdale

Member Since: October 2008 Contribution: 11

RE: What is the command to find the database that already present before connecting ?

For unix u use ps grep|oracle
and in windows u can see in services

Is this answer useful? Yes | No

October 24, 2008 16:42:01

sumer77

Member Since: October 2008 Contribution: 4

RE: What is the command to find the database that already present before connecting ?

In Unix: ps -ef | grep pmon
In Windows: You can check the database service is runnig or not.

Is this answer useful? Yes | No

May 22, 2009 05:07:16

subhash.terdale

Member Since: October 2008 Contribution: 11

RE: What is the command to find the database that already present before connecting ?

In UNIX u can use ps -ef|grep pmon or u can check oratab or listener file listner.ora
In Windows u can check servises for Oracle

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 15, 2009 03:07:29

mmaz2002

Member Since: May 2009 Contribution: 3

RE: What is the command to find the database that already present before connecting ?

In UNIX ps -ef || grep Oracle command can be used to know if all the bgprocesses are up and running & in WINDOWS services needs to be checked.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 25, 2009 07:15:56

lakshmi143.e

Member Since: September 2009 Contribution: 2

RE: What is the command to find the database that already present before connecting ?

select name as "DB Name" from v$database;

select global_name from global_name;

select ora_database_name from dual;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank