Home » Infrastructure » Linux » Name of the Database
Name of the Database [message #237921] Wed, 16 May 2007 02:35 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

I was asked " How do you find the name of the database at the OS level in LINUX and also how do you find how many databases you have in the server at the OS level.


Can somebody help me in this regard plz.
Re: Name of the Database [message #237955 is a reply to message #237921] Wed, 16 May 2007 03:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

YOu can check ORATAB file for how many database or instance name.

Regards
Taj

Re: Name of the Database [message #237962 is a reply to message #237955] Wed, 16 May 2007 03:49 Go to previous messageGo to next message
jai_subi
Messages: 7
Registered: May 2007
Location: Chennai
Junior Member
To Find the databases at os level: oratab

Location of oratab:

Linux: /etc/oratab
Solaris: /var/opt/oracle/oratab

Rgds,
Subha.D.



Re: Name of the Database [message #424443 is a reply to message #237921] Fri, 02 October 2009 07:44 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
For every new database creation we need to specify the entry in Oratab.

You can check the location like /etc/oratab.

Thanks,
Afroze.
Re: Name of the Database [message #424448 is a reply to message #424443] Fri, 02 October 2009 07:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Will you add a new (useless) post to all old and closed topics?
Let them alone and answer to the new ones.

Regards
Michel

[Updated on: Fri, 02 October 2009 07:52]

Report message to a moderator

Re: Name of the Database [message #426599 is a reply to message #424448] Fri, 16 October 2009 16:14 Go to previous message
scripter
Messages: 6
Registered: October 2009
Location: India
Junior Member
To know the database running at OS level

$ps -ef | grep pmon

To know the database at OS level

$cat /ect/oratab
Previous Topic: start Oracle forms from linux
Next Topic: Oracle NetCA issues and configuration
Goto Forum:
  


Current Time: Thu Mar 28 03:37:21 CDT 2024