家里机器安装Linux系统,上面装好了oracle10g。所有的配置都好了,在linux本地可以登录并进行数据库操作。
同时监听也打开了。我家里机器的外网IP地址可以与一个域名绑定(使用的是gnway)。
现在我想用单位的机器来连家里机器的oracle,可是用pl/sql登录时老是报tns没有监听器。
服务器的listener.ora如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-server)(PORT = 1522))
)
)
服务器的tnsname.ora如下 :LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-server)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-server)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
单位机器的tnsnames.ora如下:
POWPRO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = powpro.gnway.net)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)其中linux-server是我机器的名字,powpro.gnway.net是外围IP对应的域名
同时监听也打开了。我家里机器的外网IP地址可以与一个域名绑定(使用的是gnway)。
现在我想用单位的机器来连家里机器的oracle,可是用pl/sql登录时老是报tns没有监听器。
服务器的listener.ora如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-server)(PORT = 1522))
)
)
服务器的tnsname.ora如下 :LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-server)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-server)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
单位机器的tnsnames.ora如下:
POWPRO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = powpro.gnway.net)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)其中linux-server是我机器的名字,powpro.gnway.net是外围IP对应的域名
(PORT = 1522)
???