how to check weather oracle db is started or not and how to start at oracle

[Former Member]

Hi

could u please tell me how to check weather database is started or not

and also how to start . (on unix and windows)

waiting for ur reply.

rajendra

[former_member227600]

Hi rajendra,

You can use the following command at Unix/Aix operating system.

login into unix/aix operating system

& run the following command.

sqlplus "connect /as sysdba"

you come in sql prompt

& than run the following query

sql>select status from v$instance;

In windos you can check DB status using MMC.

if you have any query than message me freely.

Karan

Edited by: karan Singh on Jun 24, 2008 5:10 PM

Edited by: karan Singh on Jun 24, 2008 5:12 PM

[Former Member]

Hi Rajendra,

Login to Oracle by using this command

SQLPLUS "/as sysdba"

select status from v$instance;

if it return as open you database is started and running.

this will work for both Windows / Unix environments,

ps-ef |grep ora -> by using this command you can see oracle process is running or not...

Hope this help.

Cheers,

Praveen

[markus_doehr2]

I would recommend you do the "2 day DBA" course online on

http://www.oracle.com/pls/db102/homepage?remark=tahiti

Markus