Currently both DBs are up and running. I had already accessed one DB Console to administer. (Which took a while to bring up due to requirements for providing explicit security policies and having service run as Local System) In any case system was up.
Then I went to second service and used the port 5500+1. Which I got to. When I tried to set up DB Back up, and test the backup disk drive, it gave me an error that the Host user does not have specific rights to execute a perl command. This is the same error I was getting before on the other instance.
It seems odd to get that error since both instances are using the same oracle account and have the same privileges.
In any case I stopped the service and tried to bring it back up, I kept getting Net HELPMSG 3547. I thought to stop the other emctl service (wrong mistake).. Once doing that I can not get neither consoles up.
emctl status agent: it states agent is not running.
I tried to start it, and I get Net HELPMSG 2185.
Now I can't start consoles (emctl start dbconsole (after setting ORACLE_SID).
Does anyone have any thoughts or suggestions. It would be greatly appreciated.
Asad:
TRACE FILE DATA FOR BOTH INSTANCES:
========================================
INSTANCE 1:
SQL = " OCISessionBegin"...
LOGIN = dbsnmp/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=magellan)(PORT=1521))(CONNECT_DATA=(SID=pcm)))
2007-07-03 04:23:33 Thread-2552 ERROR vpxoci: ORA-01033: ORACLE initialization or shutdown in progress
2007-07-03 04:23:45 Thread-3116 ERROR upload: Failed to upload file B0000974.xml, ret = -2
2007-07-03 04:23:45 Thread-3116 ERROR upload: Failed to upload file B0000974.xml, ret = -2
2007-07-03 04:23:46 Thread-3116 ERROR upload: Failed to upload file B0000974.xml, ret = -2
2007-07-03 04:23:46 Thread-3116 ERROR upload: 3 Failures in a row for B0000974.xml, we give up
2007-07-03 04:23:46 Thread-3116 ERROR upload: Error in uploadXMLFiles. Trying again in 300.00 seconds.
2007-07-03 04:23:47 Thread-3100 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2007-07-03 04:23:48 Thread-3100 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2007-07-03 04:23:48 Thread-2552 WARN vpxoci: OCI Error -- ErrorCode(1033): ORA-01033: ORACLE initialization or shutdown in progress
SQL = " OCISessionBegin"...
LOGIN = dbsnmp/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=magellan)(PORT=1521))(CONNECT_DATA=(SID=pcm)))
2007-07-03 04:23:48 Thread-2552 ERROR vpxoci: ORA-01033: ORACLE initialization or shutdown in progress
2007-07-03 04:24:03 Thread-2552 WARN vpxoci: OCI Error -- ErrorCode(1033): ORA-01033: ORACLE initialization or shutdown in progress
SQL = " OCISessionBegin"...
LOGIN = dbsnmp/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=magellan)(PORT=1521))(CONNECT_DATA=(SID=pcm)))
2007-07-03 04:24:03 Thread-2552 ERROR vpxoci: ORA-01033: ORACLE initialization or shutdown in progress
2007-07-03 04:24:12 Thread-1664 ERROR upload: Failed to upload file B0000974.xml, ret = -2
2007-07-03 04:27:58 Thread-2348 ERROR recvlets: Inserted target oracle_database pcm.pcimail.com into hash table
2007-07-03 04:27:58 Thread-2348 WARN upload: Upload manager has no Failure script: disabled
2007-07-03 13:17:27 Thread-2772 ERROR http: 1832: snmehl_read: error on read: An existing connection was forcibly closed by the remote host.
(error = 10054)
2007-07-03 13:17:27 Thread-2772 ERROR http: 1832: SNMEHL_READ_ERROR
2007-07-03 13:17:27 Thread-2772 ERROR http: --- Error context dump begin for incoming request ---
2007-07-03 13:17:27 Thread-2772 ERROR http: version=http/1.1 secure = 0
2007-07-03 13:17:27 Thread-2772 ERROR http: primary header = NULL
2007-07-03 13:17:27 Thread-2772 ERROR http: --- Error context dump end for incoming request ---
2007-07-03 13:19:58 Thread-2336 WARN http: 304,-1: nmehl_httpListener: signaled to exit from emctl
=============
INSTANCE 2
============
2007-07-03 04:14:25 Thread-3680 ERROR fetchlets.oslinetok: Metric execution timed out in 120 seconds
2007-07-03 04:14:35 Thread-3680 ERROR command: killed process 692 running F:\oracle\product\10.1.0\Db_1/bin/nmupm and failed to WaitForSingleObject within 10 seconds.: (error=109, no message available)
2007-07-03 04:14:35 Thread-3680 ERROR engine: [host,magellan,_LoadInternal] : nmeegd_GetMetricData failed : Metric execution timed out in 120 seconds
2007-07-03 04:14:35 Thread-3680 ERROR engine: [magellan,host] Failure in step [3] : _LoadInternal. Metric execution timed out in 120 seconds. Stopping execution
2007-07-03 04:14:35 Thread-3680 ERROR engine: [magellan,host] : Load : nmeeam_GetMetricData failed
2007-07-03 04:14:35 Thread-3680 ERROR engine: [host,magellan,Load] : nmeegd_GetMetricData failed : Metric execution timed out in 120 seconds
2007-07-03 04:19:05 Thread-3600 ERROR fetchlets.oslinetok: Metric execution timed out in 120 seconds
2007-07-03 04:19:15 Thread-3600 ERROR command: killed process 2116 running F:\oracle\product\10.1.0\Db_1/bin/nmupm and failed to WaitForSingleObject within 10 seconds.: (error=87, no message available)
2007-07-03 04:19:15 Thread-3600 ERROR engine: [host,magellan,DiskActivity] : nmeegd_GetMetricData failed : Metric execution timed out in 120 seconds
2007-07-03 04:19:15 Thread-3600 ERROR engine: [magellan,host] Failure in step [0] : DiskActivity. Metric execution timed out in 120 seconds. Stopping execution
2007-07-03 04:19:15 Thread-3600 ERROR engine: [magellan,host] : Load : nmeeam_GetMetricData failed
2007-07-03 04:19:15 Thread-3600 ERROR engine: [host,magellan,Load] : nmeegd_GetMetricData failed : Metric execution timed out in 120 seconds
2007-07-03 04:22:05 Thread-2664 ERROR fetchlets.oslinetok: Metric execution timed out in 120 seconds
2007-07-03 04:22:15 Thread-2664 ERROR command: killed process 2144 running F:\oracle\product\10.1.0\Db_1/bin/nmupm and failed to WaitForSingleObject within 10 seconds.: (error=87, no message available)
2007-07-03 04:22:15 Thread-2664 ERROR engine: [host,magellan,DiskActivity] : nmeegd_GetMetricData failed : Metric execution timed out in 120 seconds
2007-07-03 04:22:15 Thread-2664 ERROR engine: [magellan,host] Failure in step [0] : DiskActivity. Metric execution timed out in 120 seconds. Stopping execution
2007-07-03 04:22:15 Thread-2664 ERROR engine: [magellan,host] : Load : nmeeam_GetMetricData failed
2007-07-03 04:22:15 Thread-2664 ERROR engine: [host,magellan,Load] : nmeegd_GetMetricData failed : Metric execution timed out in 120 seconds
2007-07-03 13:04:21 Thread-784 WARN http: 304,-1: nmehl_httpListener: signaled to exit from emctl
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
1)As long as u use dbconsole but not grid control, u should check not the agent but if the console is running
emctl status dbconsole
That will show if the console is running and the address where it listens
2)The backup is run not in the name of the user owning the Oracle software, but in the name of the user, specified as a preferred OS user credentials in the dbconsole of the database, so there is no reasons these users to be equal. Go to the upper right corner of the dbconsole home page and click preferences. Find the preffered credentials and change the preferred credentilal for the host OS user, then delete and resubmit the backup job
Reply With Quote
Bookmarks