本人菜鸟,刚接触数据库,使用oracle10g数据库客户端连接数据库时出现错误,请大神帮忙,一直是这个问题。我的是win7系统,安装了oracle10g和oracle11g。但是都连接不上。都出现这个问题。
直接用图说话吧。求大神指教。
# listener.ora Network Configuration File: C:\oracle10g\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle10g\product\10.2.0\db_1)
(PROGRAM = extproc)
)
#add by zhk 2015-04-29
(SID_DESC=
(GLOBAL_DBNAME=orcl10g)
(ORACLE_HOME=C:\oracle10g)
(SID_NAME=orcl10g)
)
)
#add by zhk 2015-04-29 2012-20140404QB
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.102 )(PORT = 1521))
)
)
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
# tnsnames.ora Network Configuration File: C:\oracle10g\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl10g)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)