OraFAQ Forum: Unix » Multiple Databases on Single Server

Home » Infrastructure » Unix » Multiple Databases on Single Server (IBM-AIX and Oracle Database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multiple Databases on Single Server [message #382425]

Thu, 22 January 2009 04:37

askshirsagar
Messages: 9
Registered: February 2006
Location: India

Junior Member

Hello,

Please help me.

Where I can get multiple database names and their details on single server. Please let me know if you know file path or table name(s) for the same.

TNSNAME.ORA provides multiple database name but this will not help to my answer as HOST ip address will be different for each database

My requirement is as below:
Following is the out put of SQLServer on Windows. We need similar attribute details for Oracle on HP-UX/IBM-AIX from command prompt of UNIX server (root) or oracle login.

SQLServer Output:

<database name="C_EmilLundgren1">

<collation>SQL_Latin1_General_CP1_CI_AS</collation>

<users>dbo;qondoc;ssa</users>

<size>244</size>

<filepath>C:\Program Files\Microsoft SQL Server\MSSQL\Data\C_EmilLundgren1.mdf</filepath>

<transize>51</transize>

<tranfilepath>C:\Program Files\Microsoft SQL Server\MSSQL\Data\C_EmilLundgren1_log.ldf</tranfilepath>

<servername>SEGOTJOSA001</servername>

<options>0;0;0;0;1;1;1;0;</options>

</database>

Many thanks for your help.

Avinash

Report message to a moderator

Re: Multiple Databases on Single Server [message #382428 is a reply to message #382425]

Thu, 22 January 2009 04:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is the requirements in words.

Regards
Michel

Report message to a moderator

Re: Multiple Databases on Single Server [message #382430 is a reply to message #382428]

Thu, 22 January 2009 04:55

askshirsagar
Messages: 9
Registered: February 2006
Location: India

Junior Member

Thanks for your prompt reply.

If I want a list of multiple databases running on single server then where I can get a list of the same database name, file path and size of the database?

Thanks
Avinash

Report message to a moderator

Re: Multiple Databases on Single Server [message #382433 is a reply to message #382430]

Thu, 22 January 2009 05:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't do it in Oracle. You have to first know all the databases/instances running on your server.

Regards
Michel

[Updated on: Thu, 22 January 2009 05:14]

Report message to a moderator

Previous Topic:	Need document to learn basic essential concepts of HP-UX
Next Topic:	use

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 13:59:39 CST 2024