OracleOra92Agent fails with error 1063

we just upgraded to oracle 9.2.0.3 on Windows 2003.  After the upgrade, we cannot start the OracleOra92Agent it fails with error 1063.  Prior to the upgrade the server name was changed.  I found  a note on the internet that indicates that this can happen after a server name change but nothing about how to resolve this issue.

Can someone shed some light please?
cat200757Asked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
shahidnsCommented:
Check the agent parameter file for the hostname. It may still have the old server name. You will find this file under $ORACLE_HOME/network/agent

Regards.
Shahid.
0
 
actonwangCommented:
go to <oracle_home>/network/admin

looking for files:

snmp_ro.ora
snmp_rw.ora
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
cat200757Author Commented:
I looked under $ORACLE_HOME/network/agent  and there are several files under here, I can't find anything relating to the 'server name'.  Can you be more specific as to the file I need to locate?

Thanks,

Cathy
0
 
actonwangCommented:
no. not under /agen. looked at my post ...
0
 
cat200757Author Commented:
are you referring to the services.ora file under $ORACLE_HOME\network\agent?
0
 
actonwangCommented:
>>
 go to <oracle_home>/network/admin

looking for files:

snmp_ro.ora
snmp_rw.ora
0
 
cat200757Author Commented:

These files are present

snmp_ro.ora
snmp_rw.ora
0
 
MohanKNairCommented:
>> Prior to the upgrade the server name was changed.
The problem is because the server name is changed. Change the server name again to the previous name.
0
 
cat200757Author Commented:
Can't do that.  There are reasons for the server name change, therefore not a solution.
0
 
actonwangCommented:
>>snmp_ro.ora
>>snmp_rw.ora

did you change name in those files for agent? did you try it?
0
 
schwertnerCommented:
In file %ORACLE_HOME%\network\admin\listener.ora
LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = some_host)(PORT = 1521))
     )
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
     )
   )
 )

Change the values of host.

For the service OracleOraHome92Agent,
 you'll have to modify <ORACLE_HOME>/network/admin/snmp_ro.ora (same method as above),
and to delete all files which extension is .q in <ORACLE_HOME>/network/agent.

Backup first the files you will delete for backup reasons.
0
 
cat200757Author Commented:


Thanks all, but I have located a document on Metalink that outlines the solution
0
 
actonwangCommented:
Could you share what you found?

Thanks :)
0
 
cat200757Author Commented:

Document I.D: Note:71913.1 on Metalink
0
 
actonwangCommented:
good.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.