Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1092
  • Last Modified:

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?
0
cat200757
Asked:
cat200757
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now