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?
Can someone shed some light please?
go to <oracle_home>/network/admi n
looking for files:
snmp_ro.ora
snmp_rw.ora
looking for files:
snmp_ro.ora
snmp_rw.ora
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
Thanks,
Cathy
no. not under /agen. looked at my post ...
ASKER
are you referring to the services.ora file under $ORACLE_HOME\network\agent ?
>>
go to <oracle_home>/network/admi n
looking for files:
snmp_ro.ora
snmp_rw.ora
go to <oracle_home>/network/admi
looking for files:
snmp_ro.ora
snmp_rw.ora
ASKER
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.
The problem is because the server name is changed. Change the server name again to the previous name.
ASKER
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?
>>snmp_rw.ora
did you change name in those files for agent? did you try it?
In file %ORACLE_HOME%\network\admi n\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/admi n/snmp_ro. ora (same method as above),
and to delete all files which extension is .q in <ORACLE_HOME>/network/agen t.
Backup first the files you will delete for backup reasons.
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/admi
and to delete all files which extension is .q in <ORACLE_HOME>/network/agen
Backup first the files you will delete for backup reasons.
ASKER
Thanks all, but I have located a document on Metalink that outlines the solution
Could you share what you found?
Thanks :)
Thanks :)
ASKER
Document I.D: Note:71913.1 on Metalink
good.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regards.
Shahid.