| Help me: ORA-12514 [message #405833] |
Fri, 29 May 2009 17:10  |
nqtrung
Messages: 25
Registered: April 2007
|
Junior Member |
|
|
Hi all
My server have 2 ethernet card and I have created 2 listener for DB server:
- Listener1 is binding on IP1 (10.36.70.xxx), port 1521.
- Listener2 is binding on IP2 (192.168.2.xxx), port 1522.
- Parameter: SERVICE_NAME=world.db1
On client, I have configed tnsnames.ora:
DB_PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.70.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = db1)
)
)
DB_DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.xxx)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = world.db1)
)
)
Then try to connect DB server:
sqlplus user/pass@db_prod ---> OK
sqlplus user/pass@db_dev ---> Error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I don't know why this case I can't use parameter SERVICE_NAME. Can you help me, pls
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
