三台服务器,分别安装
oracle
12c,oracle 9i,使用sqlplus连接时出现如下问题:
11
号机:Centos7
中安装oracle 12c
,listener.ora
文件host=6.0.103.11port=1521
LISTENER =
(DESCRIPTION_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 6.0.103.11)(PORT =1521)
(ADDRESS= (PROTOCOL = IPC)(KEY = EXTPROC1521)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
www.zlshtr.cn
www.lpjzii.cn
www.wqstj.cn
www.htqwb.info
www.lgpby.info
www.wtbzz.info
www.prhxj.info
www.qqyfq.info
www.wfqft.cn
www.lpjzii.cn
www.wqstj.cn
www.htqwb.info
www.lgpby.info
www.wtbzz.info
www.prhxj.info
www.qqyfq.info
www.wfqft.cn
(GLOBAL_NAME = 6.0.103.11)
(
ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME= DSJ36011)
)
)
7
号机:Asianumx
中安装oracle 9i,listener.ora
文件host=6.0.103.7port=1521
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST= 6.0.103.7)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST=
www.zfzozh.cn
www.oygtll.cn
www.mqoqzb.cn
www.buwpxf.cn
www.bqfgdl.cn
www.uqlbnw.cn
www.panujt.cn
www.zirivk.cn
www.suztkw.cn
www.ptbdys.cn
www.vudvam.cn
www.oygtll.cn
www.mqoqzb.cn
www.buwpxf.cn
www.bqfgdl.cn
www.uqlbnw.cn
www.panujt.cn
www.zirivk.cn
www.suztkw.cn
www.ptbdys.cn
www.vudvam.cn
(SID_DESC=
(GLOBAL_DBNAME = 6.0.103.7)
(ORACLE_HOME=/oracle/app/oracle/product/9.2.0)
(SID_NAME= DSJ36007)
)
)
6
号机:listener.ora
文件host=6.0.103.6port=1521
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST= 6.0.103.6)(PORT = 1521))
)
)
www.bnjcx.cn
www.lzmdg.cn
www.bmfnr.cn
www.hsfpp.cn
www.jfclt.cn
www.jgwnn.cn
www.wtjmg.cn
www.frydt.cn
www.wjqbs.cn
www.mxfgl.cn
www.slqrs.cn
www.rgglg.cn
www.qbgtr.cn
www.wqsjl.cn
www.vmtrck.cn
www.lzmdg.cn
www.bmfnr.cn
www.hsfpp.cn
www.jfclt.cn
www.jgwnn.cn
www.wtjmg.cn
www.frydt.cn
www.wjqbs.cn
www.mxfgl.cn
www.slqrs.cn
www.rgglg.cn
www.qbgtr.cn
www.wqsjl.cn
www.vmtrck.cn
)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME = 6.0.103.6)
(ORACLE_HOME=/oracle/app/oracle/product/9.2.0)
(SID_NAME= DSJ36006)
www.mknzz.cn
www.smknq.cn
www.prpyq.cn
www.mtrwp.cn
www.kknhg.cn
www.xgtzh.cn
www.rkmnx.cn
www.krrlb.cn
www.gqkzd.cn
www.rkffb.cn
www.jplxm.cn
www.smknq.cn
www.prpyq.cn
www.mtrwp.cn
www.kknhg.cn
www.xgtzh.cn
www.rkmnx.cn
www.krrlb.cn
www.gqkzd.cn
www.rkffb.cn
www.jplxm.cn
)
)
客户机6.0.103.191
安装了oracle
客户端,C:\BJ\Ora_Cli\network\admin\tnsnames.ora
文件中定义了:6.0.103.11=
HOST=6.0.103.11 PORT=1521
CONNECT_DATA=
(SERVICE_NAME=DSJ36011)
问题:在cmd
执行:
www.msqkp.cn
www.trwjp.cn
www.gwdyr.cn
www.wlysk.cn
www.pqhsw.cn
www.trwjp.cn
www.gwdyr.cn
www.wlysk.cn
www.pqhsw.cn
SQL>conn
sys/sys@6.0.103.7 as sysdba #
成功
SQL>conn sys/sys@6.0.103.6 as sysdba #
成功
SQL>conn sys/sys@6.0.103.11 as sysdba #
成功
当将客户机上的tnsnames.ora
文件删除后,在cmd
执行
SQL>conn
sys/sys@6.0.103.7 as sysdba #
成功
SQL>conn sys/sys@6.0.103.6 as sysdba #
成功
SQL>conn sys/sys@6.0.103.11 as sysdba #
失败 ORA-12514
这是为什么?根据实验结果来看,要通过sqlplus
连接oracle 12c
,本地必须配置tnsnames.ora
文件,而oracle 9i
就不需要tnsnames.ora
文件的存在。