我的ora文件如下,在lsnrctl中启动时说我TNS的名称位置不正确,但在NETWORK ASSISTANT 中打不开监听器啊。
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.48.60)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = NSGHR)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = NSGHR)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.48.60)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = NSGHR)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = NSGHR)
)
)
解决方案 »
- oracle新手求教,连接oracle后,Backspace和Delete键这些无法使用
- 逻辑备份不支持BINARY_DOUBLE,数据不能导出
- 菜鸟求救ORACLE10启动的问题
- 建立新的实例是发生错误!
- Oracle SQL语句中char类型 比较
- ORA-39112:错误原因及解决办法,求大虾指点
- oracle在aix系统中后缀为trc是什么文件??
- 50分 求xsql的文档 求大家帮帮忙 没有文档 说说是作什么的也可以呀!!
- 新手问一下关于执行命令后返回的信息是个2是什么意思??
- 在RAC环境中oracle如何将崩溃的节点的脏数据写入到磁盘
- 怎样在db2中修改存储过程的名字!(急!!!!!!!!!!!!!!!!!!)
- 请问oracle数据库存储问题
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.136.15.13)(PORT = 1522))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oracle816/app/product/8.1.6)
(GLOBAL_DBNAME= bill)
(SID_NAME = bill)
)
)