|
用php网页连接oracle,可以在本机上连接,可是在其他机器上连时出现如下错误:
[unixODBC][Easysoft][Oracle]TNS: Could not resolve TARGETDB parameter as service name, SQL state 08001 in SQLConnect
我的tnsname.ora,listener.ora和sqlnet.ora文件内容如下:
tnsname.ora:
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
KEJIE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.91.230.4 (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kejie)
)
)
EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
**********************************
**********************************
listener.ora
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = kejie)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(PROGRAM = extproc)
)
)
**************************************
*************************************
sqlnet.ora:
# SQLNET.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
# NAMES.DEFAULT_DOMAIN = LOCALDOMAIN
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
我糊涂了,请指教问题所在。。
急!!!! |
|