ORCL79 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)( HOST = harold)(PORT = 1521))
)
(CONNECT_DATA =
( SERVICE_NAME = oracle79)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)( HOST = harold)(PORT = 1521))
)
(CONNECT_DATA =
( SERVICE_NAME = oracle79)
)
)
#这是客户端tnsnames.ora中的一段连接配置......
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
( GLOBAL_DBNAME = oracle79)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
( SID_NAME = orcl)
)
)
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
( GLOBAL_DBNAME = oracle79)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
( SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)( HOST = harold)(PORT = 1521))
)
)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)( HOST = harold)(PORT = 1521))
)
)
#这是服务端listner.ora中的一段监听器配置.....
确认一:客户端tnsnames.ora中的
HOST为要连接主机的IP地址或主机名;
确认二:客户端tnsnames.ora中的
SERVICE_NAME为目标主机中listner.ora文件中的
GLOBAL_DBNAME或
SID_NAME的值(GLOBAL_DBNAME不是必需);
确认三:服务端listner.ora中监听器配置的
HOST值一定要是本地的主机名或本地IP;
搞不懂的:服务端listner.ora中监听器配置的
HOST值一定要是本地的主机名或本直IP吗?如果不是,那是不是此服务器会把此连接转向到此IP对应的主机那里?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/635599/viewspace-561412/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/635599/viewspace-561412/