Link to home
Start Free TrialLog in
Avatar of cat200757
cat200757

asked on

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?
Avatar of shahidns
shahidns

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.
Avatar of Acton Wang
go to <oracle_home>/network/admin

looking for files:

snmp_ro.ora
snmp_rw.ora
Avatar of cat200757

ASKER

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
no. not under /agen. looked at my post ...
are you referring to the services.ora file under $ORACLE_HOME\network\agent?
>>
 go to <oracle_home>/network/admin

looking for files:

snmp_ro.ora
snmp_rw.ora

These files are present

snmp_ro.ora
snmp_rw.ora
>> 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.
Can't do that.  There are reasons for the server name change, therefore not a solution.
>>snmp_ro.ora
>>snmp_rw.ora

did you change name in those files for agent? did you try it?
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.


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

Thanks :)

Document I.D: Note:71913.1 on Metalink
good.
ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial