ORA-02085 database link string connects to string Cause: The database link attempted to connect to a database with a different name. The name of the database link must be the same name as the name of the database. Action: Create a database link with the same name as the database to which it connects.
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = <oracle_sid)
(CONNECT_DATA = (SID = extproc))
)23=
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 192.168.99.23)(Port= 1521))
(CONNECT_DATA = (SID = orcl1))
)24=
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 192.168.99.23)(Port= 1521))
(CONNECT_DATA = (SID = orcl))
)
是这样的吧!
而listerner 也只是说明以下数据库就可以拉呀!
SQLPLUS ALS/ALS@24没见过这么定义TNSNAME的.
按前面的:
tnsname.ora is:
orcl1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = htgzln023)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl1)
)
)orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = htgzln023)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)listener.ora is:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl1)
(ORACLE_HOME = /u01/app/oracle/product/8.0.5)
(SID_NAME = orcl1)
) (SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME =/u01/app/oracle/product/8.0.5)
(SID_NAME = orcl)
select * from a@yyyy;
error:ORA-02085: database link YUDY3.WORLD connects to ORCL.WORLD
why!?
Cause: The database link attempted to connect to a database with a different
name. The name of the database link must be the same name as the name of the
database.
Action: Create a database link with the same name as the database to which it
connects.