I'm running an Oracle 10G database on Windows XP. I have installed EM Database Control which appears to function correctly, i.e. I can log-on through a web browser and perform administrative tasks, performance tuning, etc as expected.
I have noticed -- because my anti-virus software was very active -- that an error is being persistently written to my EM agent trace file. The error is as follows:
SQL = "/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.enabl"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1521))(CONNECT_DATA=(SID=test1)))
2006-10-08 14:19:18 Thread-2380 ERROR recvlets.aq: Error enabling user dbsnmp for aq agent xxxx_3938 on test1.world: ORA-24047: invalid agent name xxxx_3938, agent name should be of the form NAME
ORA-06512: at line 1
2006-10-08 14:19:18 Thread-2380 ERROR recvlets.aq: unable to create subscription on oracle_database test1.world
I have checked the following:
ORA-24047: can't find much on this on forums or Google;
Port 3938: this matches the entry for the EM agent port specified in <ORA_HOME>\install\portlist.ini;
Firewall: I currently have my Windows firewall turned off;
The only questionalble part I can find is the hostname "xxxx" in the error message above. In the database connect string it is correct, but when mentioned with reference to the agent one letter has been concatentated. I am assuming that this is a problem with the error logging and not my configuration as the host name seems to be correct in most place.
Any ideas where the agent name is configured?
Any ideas where the port is configured for client and server (I'm not sure which one the file portlist.ini refers to)?
Any other suggestions?