| Database Creation [message #97309] |
Sat, 02 March 2002 03:18  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
