GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle  >  Database Administration

 Print  |  
Question:  How to check that the three methods that can be used to determine wheather your database is up and running at OS level.




March 03, 2009 08:39:37 #2
 Punithavel   Member Since: June 2007    Total Comments: 6 

RE: How to check that the three methods that can be used to determine wheather your database is up and running at OS level.
 
1. Checking from O/S level

ps -ef | grep pmon

2. Checking through connectivity

sqlplus apps/apps

3. Checking the listener. (Listener can run even without DB startup) but without listener we cant connect to DB from outside of server.
     

 

Back To Question