1)XP系统安装了11G客户端,服务器上win2008装11g服务端,都是32位 ,2)设定了环境变量:
ORACLE_HOME=d:\app\Administrator\product\11.2.0\client_1
TNS_ADMIN=d:\app\Administrator\product\11.2.0\client_1
NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8,(服务端的 LANG也是 32UTF8)3)TNS:
# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.HANATECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hanatech)
)
)4)sqlnet.ora
# sqlnet.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)5)listener.ora:
# listener.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC2011041117gbm)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)ADR_BASE_LISTENER = d:\app\Administrator目前 客户端连接不上服务端,服务器上能登陆!PlSQL也能登陆!,哪里弄的不对,请指教下!
ORACLE_HOME=d:\app\Administrator\product\11.2.0\client_1
TNS_ADMIN=d:\app\Administrator\product\11.2.0\client_1
NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8,(服务端的 LANG也是 32UTF8)3)TNS:
# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.HANATECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hanatech)
)
)4)sqlnet.ora
# sqlnet.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)5)listener.ora:
# listener.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC2011041117gbm)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)ADR_BASE_LISTENER = d:\app\Administrator目前 客户端连接不上服务端,服务器上能登陆!PlSQL也能登陆!,哪里弄的不对,请指教下!
客户端TNS内容如何的
# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.HANATECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hanatech)
)
)
其他所以内容都是客户端的,服务器上能正常运行问题:客户端测试连接不上 服务端