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 : June-2018

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


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]


I am certified Oracle Cloud Architect:
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Cloud Infrastructure Classic 2018 Certified Architect 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: