对oracle net manager 的监听程序修改后保存退出,出现“要求有效的日志文件”,还有这个端口要不要把1521改成2030呢??
解决方案 »
- 2008下的oracle10g,注册表HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE下没有\HOME0
- PL/SQL格式混乱
- Oracle安装时Oracle_Base放到存储上还是本地磁盘呢?
- 请教linux环境下oracle无法连接
- 无法从源表中获取一组稳定的数据
- 刚开始ORACLE,问2个基础问题
- 我用Database Configuration Assistant 初始化不了 实例,报无法打开tns 文件。
- 各位大哥有没有民航网上订票系统的库啊?
- 存储过程下载!!
- 关于oracle816中的syaman密码问题(急!在线等待中!高分)
- 我该怎么办呢
- oracle10g安装有问题
--监听配置文件LISTENER.ORA的内容,参照一下:# LISTENER.ORA Network Configuration File: /oracle/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xx)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl.xxx.com) --服务器提供的全局服务名
(ORACLE_HOME = /oracle/oracle)
(SID_NAME = orcl)
)
)
--监听启动后,使用net configuration assistant配置连接串,或直接修改TNSNAMES.ORA此文件,参照:# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.orcl_xx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)orcl =
(description =
(address_list =
(address = (protocol =tcp)(host=192.168.0.180)(port=1521))
)
(connect_data=(service_name=orcl.XXX.com))
)
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.orcl_xx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)orcl =
(description =
(address_list =
(address = (protocol =tcp)(host=192.168.0.xxx)(port=1521)) --服务器的IP地址
)
(connect_data=(service_name=orcl.XXX.com)) --使用全局服务名)
改回原来的HOST ,port 改为1521端口SERVICE_NAME 改为原来的SID
一样方便
我用netca重新配置,提示说:“为此监听程序提供的信息正由此计算机的其他监听程序使用,可以按现状配置,只有当解决冲突之后才能启动该监听程序。” 我的监听服务启动了,我怎么启动监听程序啊?????