# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1522))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
)
)
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.OKC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
用Net Configuration Assistant添加了服务器名为OKC
进入sqlplus
conn scott/tiger@OKC 报 ora:12154
# Generated by Oracle configuration tools.LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1522))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
)
)
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.OKC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
用Net Configuration Assistant添加了服务器名为OKC
进入sqlplus
conn scott/tiger@OKC 报 ora:12154
解决方案 »
- linux 双机热备客户端连接时好时报错:12514无监听程序
- oracle游标问题-求救大哥大姐们
- 关于oracle9i备份在10g上导出遇到的问题
- 求Oracle安装目录OCI下面的samples中的例子!!
- 这样的SQL语句怎么写?
- 那位大哥有计算机方面的英文论文和译文啊!!
- ORACLE9.2.0.1.0老是安装不成功,请教怎么回事?急盼回复,感激不尽!
- 请问在oracle中对sql语句的审计结果保存在那个表中?我在aud$中没有找到
- 用sql语句查询各个学科分数最高的学生,如图:
- 为什么oracle定时任务 都用 insert语句不用crate as语句:
- Oracle 根据长度拆分列
- oracle中not exist 和not in的区别
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1522))
)OKC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))端口不一致阿
这样应该没影响吧,我用的是
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db767e10f7fd441)(PORT = 1521))
)
)