对oracle net manager 的监听程序修改后保存退出,出现“要求有效的日志文件”,还有这个端口要不要把1521改成2030呢?? 对oracle net manager 的监听程序修改后保存退出,出现“要求有效的日志文件”,还有这个端口要不要把1521改成2030呢?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --监听配置文件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)) --使用全局服务名) 恢复监听listenner.ora改回原来的HOST ,port 改为1521端口SERVICE_NAME 改为原来的SID 直接修改 LISTENER.ORA 也可以,端口1521可以改呀,不过改了之后,TNSNAMES.ORA 文件中对应的端口也要修改 直接修改$ORACLE_HOME/network/admin里面的listener.ora,和tnsnamens.ora,最简单的方法是直接起netca配置跟windows一样方便 我用netca重新配置,提示说:“为此监听程序提供的信息正由此计算机的其他监听程序使用,可以按现状配置,只有当解决冲突之后才能启动该监听程序。” 我的监听服务启动了,我怎么启动监听程序啊????? 使用net configuration assistant配置你的连接串(本地服务名),测试成功后,在sqlplus等工具中使用:conn system/manager@连接串; 关于oracle锁表的问题 请教oracle中的blob类型支持何种类型的文件 关于oracle,请各位大哥帮忙! ORACLE92 full join 和 join 到底有什么区别? 问一个链接的问题。 数据库把时间字段存成vchar类型,该怎么比较时间呢 关于使用distinct的问题 请问oracle数据库中两个大的表进行比较,看匹配程度 linux 使用 oracle 怎样控制光标? Oralce11g net configuration assistant 我该怎么办呢 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重新配置,提示说:“为此监听程序提供的信息正由此计算机的其他监听程序使用,可以按现状配置,只有当解决冲突之后才能启动该监听程序。” 我的监听服务启动了,我怎么启动监听程序啊?????