计算机主机名改变后Oracle需要修改的设置

显示全部楼层 · 2017-3-27 08:04:23

如题!
本人在修改主机名后对network/admin下的tnsnames.ora和listener.ora做了修改,但OracleOraHome92Agent服务不能启动
请问还有作那些修改????

千问 · 2017-3-27 08:04:23

Read Note:236334.1 "Oracle Intelligent Agent not starting errors with nmiumini_initializeUM: Unable to initialize UQFailed". In case you don't have access, in short, the procedure is
- backup the files from C:\ORACLE\network\agent\
- delete the *.q files from this directory
- Start the Intelligent Agent, it will starts without any error.
Yong Huang

千问 · 2017-3-27 08:04:23

great! Thanks
May I ask a question:
what are the Q files used for??

千问 · 2017-3-27 08:04:23

3楼的问题没人回答么？我也想知道。。顺便麻烦再问个问题。。。。
按照2楼那么做。。顺利启动AGENT，但关闭的时候总有问题。。
[oracle@localhost oracle]$ agentctl stop agent

DBSNMP for Linux: Version 9.2.0.4.0 - Production on 16-AUG-2006 11:15:19

Copyright (c) 2003 Oracle Corporation.All rights reserved.

Agent shutdown failed

千问 · 2017-3-27 08:04:23

没用过三层，倒不如敲sqlplus来得快。