- 论坛徽章:
- 0
|
主机 winxp + oracle 完全版 TNSListener服务已经启动
客户机 oracle 客户端
在主机上 connect system/manager@NETSERVER1
ERROR:
ORA-12514:TNS:监听进程不能解析在连接描述符中给出的 SERVICE_NAME
在客户机上 connect system/manager@aaa
ERROR:
ORA-12514:TNS:监听进程不能解析在连接描述符中给出的 SERVICE_NAME
--------------------------------------------
客户机配置
tnsnames.ora文件内容
aaa =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.30.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = wangzht)
)
)
--------------------------------------------
主机配置
tnsnames.ora文件内容
NETSERVER1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wangzht)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 10.20.30.29)
(INSTANCE_NAME = oraclesid1)
)
)
ORACLEDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = oraclesid1)
(PRESENTATION = RO)
)
)
sqlnet.ora文件内容
SQLNET.AUTHENTICATION_SERVICES= ()
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
listener.ora文件内容
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.30.29)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wangzht)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracledb1)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = oraclesid1)
)
) |
|