I need help in linking 2 databses on the same server for query purposes
only. I have done the following:
- create database link in "Document" database to connect
to second database ("Infowhse") ON SAME SERVER
create public database link infowhse.anacortes
using infowhse.anacortes
- Tnsnames.ora (on local machine)
INFOWHSE.ANACORTES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Shaw)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = infowhse.anacortes)
)
)
- Tnsnames.ora (on server)
INFOWHSE.ANACORTES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = shaw)(PORT = 1521))
)
(CONNECT_DATA = (SID = INFOWHSE)(SERVER = DEDICATED))
)
- Creates successfully. When tested from within DB Studio, I get
the following error message:
The database link is not active
- If I key the following sql:
select sysdate from dual_at_infowhse.anacortes
- I get the following error message:
ORA-12154: TNS:could not resolve service name
Thank you!!!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Sep 06 2000 - 19:54:09 CDT
