OraFAQ Forum: Networking and Gateways » Oracle

Home » RDBMS Server » Networking and Gateways » Oracle_SID

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

Oracle_SID [message #148459]

Thu, 24 November 2005 05:26

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

Hi,
Could any one tell me what is this Oracle_SID and why do we need it?

Cheers
safeeq

Report message to a moderator

Re: Oracle_SID [message #148463 is a reply to message #148459]

Thu, 24 November 2005 05:48

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Did you try reading a book ???

from docs

ORACLE SID - This identifier is used to avoid confusion with other Oracle instances that you may create later and run concurrently on your system.

Report message to a moderator

Re: Oracle_SID [message #148464 is a reply to message #148459]

Thu, 24 November 2005 05:50

ramsat
Messages: 49
Registered: November 2005

Member

oracle_sid is nothing but the instance name.
Instance is that captured in the ram for database operation

One database can have more than one instance

and normally the instance name is the database name itself.

Report message to a moderator

Previous Topic:	Poor performance database.. pls help me
Next Topic:	Can't able to start SNMP services on AIX 5.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:19:03 CDT 2024