$ export ORACLE_SID=orcl2
$ export ORACLE_UNQNAME=orcl
$ emctl upload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error: Failed to upload file A0000243.xml: HTTP error.
Response received: ERROR-400|ORA-28239: no key provided
ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 3
ORA-06512: at "SYS.DBMS_CRYPTO", line 13
ORA-06512: at "SYSMAN.ENCRYPT", line 9
ORA-06512: at "SYSMAN.MGMT_CREDS_INS_UPD", line 7
ORA-04088: error during execution of trigger 'SYSMAN.MGMT_CREDS_INS_UPD'
$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.5
OMS Version : 10.2.0.4.5
Protocol Version : 10.2.0.4.5
Agent Home : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl
Agent binaries : /d01/app/oracle/product/11.2.0/dbhome
Agent Process ID : 11993508
Parent Process ID : 14745618
Agent URL : https://rac02.prod.com:1830/emd/main
Repository URL : https://rac02.prod.com:5500/em/upload/
Started at : 2017-06-20 13:01:39
Started by user : oracle
Last Reload : 2017-07-08 00:57:12
Last successful upload : 2017-07-07 09:31:27
Total Megabytes of XML files uploaded so far : 513.19
Number of XML files pending upload : 924
Size of XML files pending upload(MB) : 20.07
Available disk space on upload filesystem : 52.68%
Data channel upload directory : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/recv
Collection Status : Disabled by Upload Manager <<<<===Upload Failed=====
Last successful heartbeat to OMS : 2017-07-14 10:21:31
---------------------------------------------------------------
Agent is Running and Ready
Solution:
========
$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://rac02.prod.com:5500/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
... Stopped.
Then go to thesysman/emd folder
> Delete or compress or move lastupld.xml file
Then go to thesysman/emd/upload folder
> Delete or compress or move all the file inside sysman/emd/upload folder
$ cd /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/emd
$ compress lastupld.xml
$ cd /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/emd/upload
$ rm *
$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://rac02.prod.com:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...... started.
------------------------------------------------------------------
Logs are generated in directory /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/log
$ emctl upload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.5
OMS Version : 10.2.0.4.5
Protocol Version : 10.2.0.4.5
Agent Home : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl
Agent binaries : /d01/app/oracle/product/11.2.0/dbhome
Agent Process ID : 9961834
Parent Process ID : 11402312
Agent URL : https://rac02.prod.com:1830/emd/main
Repository URL : https://rac02.prod.com:5500/em/upload/
Started at : 2017-07-14 10:33:29
Started by user : oracle
Last Reload : 2017-07-14 10:33:29
Last successful upload : 2017-07-14 10:34:28
Total Megabytes of XML files uploaded so far : 15.29
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 81.33%
Data channel upload directory : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/recv <<<<<<< It's Working Now
Last successful heartbeat to OMS : 2017-07-14 10:34:45
---------------------------------------------------------------
Agent is Running and Ready
$ export ORACLE_UNQNAME=orcl
$ emctl upload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error: Failed to upload file A0000243.xml: HTTP error.
Response received: ERROR-400|ORA-28239: no key provided
ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 3
ORA-06512: at "SYS.DBMS_CRYPTO", line 13
ORA-06512: at "SYSMAN.ENCRYPT", line 9
ORA-06512: at "SYSMAN.MGMT_CREDS_INS_UPD", line 7
ORA-04088: error during execution of trigger 'SYSMAN.MGMT_CREDS_INS_UPD'
$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.5
OMS Version : 10.2.0.4.5
Protocol Version : 10.2.0.4.5
Agent Home : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl
Agent binaries : /d01/app/oracle/product/11.2.0/dbhome
Agent Process ID : 11993508
Parent Process ID : 14745618
Agent URL : https://rac02.prod.com:1830/emd/main
Repository URL : https://rac02.prod.com:5500/em/upload/
Started at : 2017-06-20 13:01:39
Started by user : oracle
Last Reload : 2017-07-08 00:57:12
Last successful upload : 2017-07-07 09:31:27
Total Megabytes of XML files uploaded so far : 513.19
Number of XML files pending upload : 924
Size of XML files pending upload(MB) : 20.07
Available disk space on upload filesystem : 52.68%
Data channel upload directory : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/recv
Collection Status : Disabled by Upload Manager <<<<===Upload Failed=====
Last successful heartbeat to OMS : 2017-07-14 10:21:31
---------------------------------------------------------------
Agent is Running and Ready
Solution:
========
$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://rac02.prod.com:5500/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
... Stopped.
Then go to the
> Delete or compress or move lastupld.xml file
Then go to the
> Delete or compress or move all the file inside sysman/emd/upload folder
$ cd /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/emd
$ compress lastupld.xml
$ cd /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/emd/upload
$ rm *
$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://rac02.prod.com:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...... started.
------------------------------------------------------------------
Logs are generated in directory /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/log
$ emctl upload agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
$ emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.5
OMS Version : 10.2.0.4.5
Protocol Version : 10.2.0.4.5
Agent Home : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl
Agent binaries : /d01/app/oracle/product/11.2.0/dbhome
Agent Process ID : 9961834
Parent Process ID : 11402312
Agent URL : https://rac02.prod.com:1830/emd/main
Repository URL : https://rac02.prod.com:5500/em/upload/
Started at : 2017-07-14 10:33:29
Started by user : oracle
Last Reload : 2017-07-14 10:33:29
Last successful upload : 2017-07-14 10:34:28
Total Megabytes of XML files uploaded so far : 15.29
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 81.33%
Data channel upload directory : /d01/app/oracle/product/11.2.0/dbhome/rac02_orcl/sysman/recv <<<<<<< It's Working Now
Last successful heartbeat to OMS : 2017-07-14 10:34:45
---------------------------------------------------------------
Agent is Running and Ready
No comments:
Post a Comment