Home » Infrastructure » Unix » Database Creation
Database Creation [message #97309] Sat, 02 March 2002 03:18 Go to next message
Murali Krisna
Messages: 3
Registered: March 2002
Junior Member
I have 2 NT Server and each contains separate Database . Both the Database names are ORCL.
Our Windows clients are connecting to Only one ORCL.
How can I connect my Client to another Database.
Please help me out
Re: Database Creation [message #97315 is a reply to message #97309] Wed, 06 March 2002 18:19 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
First, you should have same name for two database, and this will cause some confuse to users.

To connect to another ORCL. you need to configure hostname in tnsname.ora to point to this database. You should use service name in tnsname.ora as ORCL.

e.g

ORCL.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname/IP)
(Port = ORCL port)
)
)
(CONNECT_DATA = (SID = ORCL)
)
ORCL1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname/IP)
(Port = ORCL port)
)
)
(CONNECT_DATA = (SID = ORCL)
)

So the clien can connect either ORCL or ORCL1. Hope this is helping. Thanks
Previous Topic: Re: oracle8i on redhat 7.1
Next Topic: Re: Oracle 8.1.6 installation on Linux
Goto Forum:
  


Current Time: Sun May 26 06:35:15 CDT 2024