DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: on Unix based ????

  1. 05-20-2003, 11:46 AM #1
    seshib
    seshib is offline Junior Member
    Join Date
    Feb 2003
    Posts
    69

    on Unix based ????

    hi all,

    Please help to reply this.

    My question is on unix os, how can i find which databases are in my system and what database up and running ? which command will help me to find this ?

    ----------
    HTML
    Reply With Quote Reply With Quote
  2. 05-20-2003, 11:54 AM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    ps -ef|grep pmon for databases running.

    Places to look for

    $ORACLE_BASE/admin
    $ORACLE_HOME/dbs/sp* or int* or orapw*
    /etc/oratab or /var/opt/oratab or ... depends upon ur OS Flavour...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  3. 05-20-2003, 11:55 AM #3
    jodie
    jodie is offline Still Learning
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    ps -ef | grep pmon

    Will tell you which databases are running. PMON has to be running for the database to be up.


    Jodie
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width