Oracle?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Oracle?
# 1  
Old 10-22-2001
Tools Oracle?

Hi anyone. On my True64 unix, I was wondering if there is command in unix to see if the Database (Oracle8.X) up is??

thanks in advance.

Peterh
# 2  
Old 10-22-2001
You can use:

$ ps -ef |grep ora_
oracle 28331 1 0 Sep 29 ? 0:00 ora_dbw0_[instance name]
oracle 28335 1 0 Sep 29 ? 0:02 ora_ckpt_[instance name]
oracle 28329 1 0 Sep 29 ? 0:00 ora_pmon_[instance name]
oracle 28337 1 0 Sep 29 ? 0:01 ora_smon_[instance name]
oracle 28333 1 0 Sep 29 ? 0:04 ora_lgwr_[instance name]
oracle 28339 1 0 Sep 29 ? 0:00 ora_reco_[instance name]
oracle 28341 1 0 Sep 29 ? 0:00 ora_arc0_[instance name]

I these processes are up, then Oracle is running. (note
: [instance name] is the name of your istance)

HTT
# 3  
Old 10-23-2001
Thanks HTT
 
Login or Register to Ask a Question

Previous Thread | Next Thread

1 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
Login or Register to Ask a Question