Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Tuesday, April 3, 2018

Oracle Backup Cloud Assistant bkup_api - API::ERROR KBHS-00715: HTTP error occurred 'oracle-error'


When trying to take Oracle Database Cloud Backup using Cloud Backup AssistantI got the below errors.

Error:
-> API::ERROR  KBHS-00715 HTTP CONNECTION ERROR
 -> API::ERROR -Detail
 -> API::ERROR KBHS-00715: HTTP error occurred 'oracle-error'
 -> API::ERROR OBKUP:: ..... FAIL
 -> API::ERROR ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
 -> API::ERROR ORA-19554: error allocating device, device type: SBT_TAPE, device name:
 -> API::ERROR ORA-27023: skgfqsbi: media manager protocol error


After some digging realized that this is a known issue with Oracle Cloud Backup  Assistant.



[root@salesdev ~]# /var/opt/oracle/bkup_api/bkup_api bkup_status
DBaaS Backup API V1.5 @2016 Multi-Oracle home
DBaaS Backup API V1.5 @2015 Multi-Oracle home
-> Action : bkup_status
-> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
 Warning: unable to get current configuration of: catalog
* Current backup settings:
* Last registered Bkup: 04-01 08:44 API::9070:: Starting dbaas backup process
* Bkup state: finished
**************************************************
* API History: API steps
  API:: NEW PROCESS 9070
  API:: Starting dbaas backup process
* DBaaS Error trace:
 -> API::ERROR  An http error was detected please verify your connectivity
 -> API::ERROR  Cannot complete the backup to cloud storage
 -> API::ERROR  KBHS-00715 HTTP CONNECTION ERROR
 -> API::ERROR -Detail
 -> API::ERROR KBHS-00715: HTTP error occurred 'oracle-error'
 -> API::ERROR OBKUP:: ..... FAIL
 -> API::ERROR ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
 -> API::ERROR ORA-19554: error allocating device, device type: SBT_TAPE, device name:
 -> API::ERROR ORA-27023: skgfqsbi: media manager protocol error
 -> API::ERROR RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 -> API::ERROR RMAN-03002: failure of backup command at 04/01/2018 04:45:18
-> Oracle Error Codes found:
          KBHS-00712: ORA-29024 received from local HTTP service
          ORA-27023: skgfqsbi: media manager protocol error
          ORA-19554: error allocating device, device type: SBT_TAPE, device name:
          ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
*
* RETURN CODE:1


Fix;
Include the  variable _OPC_VALIDATE_CERT=TRUE 

in the opc<SID>.ora configuration file under $ORACLE_HOME/dbs



[oracle@salesdev dbs]$ cat opcsalesdev.ora
OPC_HOST=https://shaiksameer.us.storage.oraclecloud.com/v1/Storage-shaiksameer
OPC_WALLET='LOCATION=file:/u01/app/oracle/admin/salesdev/opc_wallet CREDENTIAL_ALIAS=alias_opc'

OPC_CONTAINER=dbbackups

_OPC_DEFERRED_DELETE=true

_OPC_VALIDATE_CERT=TRUE



Hope this will save some time in your troubleshooting efforts.

No comments: