subhash.terdale

 Profile Answers by subhash.terdale 

• Oct 3rd, 2008

 

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

sumer77

 Profile Answers by sumer77 

• Oct 24th, 2008

 

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

subhash.terdale

 Profile Answers by subhash.terdale 

• May 22nd, 2009

 

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

mmaz2002

 Profile Answers by mmaz2002 

• Jul 15th, 2009

 

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.

lakshmi143.e

 Profile Answers by lakshmi143.e 

• Sep 25th, 2009

 

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

select global_name from global_name;

select ora_database_name from dual;

vasanth_m11

 Profile Answers by vasanth_m11 

• Jan 4th, 2011

 

As a sys or system user,

select name from v$database;

As a normal user,

select global_name from global_name;
select ora_database_name from dual; - dual is a dummy table in oracle
show parameter db_name - has to be given in sql prompt.

abhishek singh

• Aug 1st, 2011

 

select db_name from v$database;
use echo command in linux environment

priyank

• May 10th, 2012

 

If you are using Unix/Linux environment then try to grep the oracle & tnslsnr processes to get the name of database service/process running. And, this will also give you path of tnsnames.ora file, where you check the Instance name.

chittu.kotian

 Profile Answers by chittu.kotian 

• May 16th, 2012

 

On Unix the command is ps -aef | grep -i pmon

sandeep

• Apr 26th, 2013

 

ps -ef | grep oracle