on 06-24-2008 3:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would recommend you do the "2 day DBA" course online on
http://www.oracle.com/pls/db102/homepage?remark=tahiti
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.