-
Hi,
I'm facing problems whith DATABASE LINK.
Check following files if there is any problems.
File : listener.ora
*******************
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
# )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /data1/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = condb)
(ORACLE_HOME = /data1/oracle)
(SID_NAME = condb)
)
)
File: tnsnames.ora
******************
remote_service_name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
(CONNECT_DATA =
(SID = condb)
)
)
________________________________________________________________
$ tnsping remote_service_name
TNS Ping Utility for Solaris: Version 8.1.6.0.0 - Production on 02-AUG-2001 20:17:25
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.6)(PORT=1521)) OK (80 msec)
------------------------------------------------------
$ trcroute remote_service_name
Trace Route Utility for Solaris: Version 8.1.6.0.0 - Production on 02-AUG-2001 22:06:20
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Route of TrcRoute:
------------------
Node: Client Time and address of entry into node:
-------------------------------------------------------------
02-AUG-2001 22:06:20 ADDRESS= PROTOCOL=TCP HOST=0.0.0.0 PORT=1521
Node: Server Time and address of entry into node:
-------------------------------------------------------------
02-AUG-2001 22:06:21
REMOTE DATABASE NAME : condb
LOCAL DATABASE NAME : condb
$ sqlplus username/password
SQL> create public database link remote_link
2 connect to username identified by password
3 using 'remote_service_name';
Database link created.
SQL> select count(*)from emp@remote_link;
select count(*)from bd_list_fplist@remote_link
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
I tried with following also
SQL> create public database link condb
2 connect to username identified by password
3 using 'remote_service_name';
connect to username identified by password
*
ERROR at line 2:
ORA-02082: a loopback database link must have a connection qualifier
Please tellme me what is the exact problem, code and limitations.
Thanks,
Nilopher.
-
can you:
$ sqlplus username/password@condb
from the SERVER?
Jeff Hunter
-
We faced some problem when the database was in NT and the other in Sun and the db_domain were different, metalink provided with some documents which of course were not of much help and we dropped the db link, and used table level exp with where clause and imported.
I'm not sure if u are facing the same problem, check with the db_domain in initSID.ora in both systems and sqlnet.ora from where you are trying to access from.
If u search metalink for 19307.1 they have explaind the problems clearly.
HTH
-Dharma
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|