OCI Classic: Create DBCS Instance Completed OCDE With Errors 'checkDatabaseConfig code: PSM-DB-015, message: Failed to configure Oracle Database Server' (Doc ID 2414653.1)

Last updated on JUNE 29, 2018

Applies to:

Symptoms

Creating a database instance from the OCI Classic - Database Cloud Service page fails with following exception

From PSM logs

    Job 3265727
    Domain idcs-xxxxyyyyyyxxxxxxxxxxxxx
    Service SOA-TST-DB
    Namespace dbaas
    Service Type dbaas
    Compute Site aucom-east-1
    Username abc.xyz@oracle.com
    Operation start-db-service
    Status Failed
    Sub Status
    Create Time 2018-06-19T03:49:21.546+00:00
    Start Time 2018-06-19T03:49:21.546+00:00
    End Time 2018-06-19T04:01:28.181+00:00
    Update Time 2018-06-19T04:01:28.182+00:00
    Job Info
    Request Parameters {{{identity_domain_id=idcs-xxxxyyyyyyxxxxxxxxxxxxx, noRetry=false, createStorageContainerIfMissing=false, cloudStorageUser=support-xx@123.com, assignPublicIP=true, serviceType=dbaas, version=12.2.0.1, ibkup=no, cloudStorageContainer=https://mystorage.au.storage.oraclecloud.com/v1/Storage-mystorage/dbcs-SOA-TST-DB, usableStorage=25, backupDestination=BOTH, useOAuthForStorage=false, namespace=dbaas, serviceInstance=SOA-TST-DB, region=aucom-east-1, charset=AL32UTF8, dbConsolePort=1158, subscriptionType=HOURLY, isBYOL=false, disasterRecovery=false, enableNotification=false, goldenGate=false, sid=ORCL, shape=oc3, emExpressPort=5500, ncharset=AL16UTF16, noRollback=false, edition=SE, listenerPort=1521, serviceEntitlementId=603926164, tenant=idcs-xxxxyyyyyyxxxxxxxxxxxxx, serviceVersion=12.2.0.1, hdg=false, failoverDatabase=false, operationName=start-db-service, sla=NONE, isRac=false, provisioningTimeout=120, ibkupOnPremise=false, level=PAAS, tags=[], useHighPerformanceStorage=false, pdbName=SOA, enableListenerPort=false, count=2, timezone=Australia/Sydney, description=SOA-TST-DB, computeSiteName=aucom-east-1, server_base_uri=http://psminternal.audc1.oraclecloud.com:8888/paas/service/dbcs/, vmPublicKeyText=ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCKCQ6PEnwiCLgE6E3HldZ7hgqiQiFdYcduWizZ+m8QxXuoyNM1NN9DRbe81W6rbi+6Rr1R9DAkB0Zrkhwtoa0PiD6R8DEQK5MZ/tPtkH0XMKA56e1VSCQasQXfTs7bBNqhEV1BVVZkrt8Us2tjC/wDBCZpLLpjJpNP7pWUzduPFQ5Wzd33qpfbAcB4vvKBBpT/NzfVHlkX1A0zJSo5ef/By/ap+jxgAf71+lfPo/SGrDGvk4gabbFtP9qKy+pRC/pDBGaGIIEVnTU95u+kTBXHNR+ayNxcUds93qmYGMGT1r/XVNRqWVfjSJnz5znEoAp5e5KklbZyTZDSSWXuHfdf, serviceName=SOA-TST-DB, trial=false}}}
    Supplemental Logs <2018-06-19T04:01:28.092+0000 check.db.logs.fail:Failed to configure Oracle Database Server...[ SCRIPT execution errors in [x.x.x.x]: OCDE failed with message: #### Completed OCDE with errors, please check logs #### _1 System name: Linux Node name: SOA-TST-DB Release: 4.1.12-112.14.10.el6uek.x86_64 Version: #2 SMP Mon Jan 8 18:24:01 PST 2018 ]
    >
    Summary

    Job <3265727> v45, pid=3265527, root pid=3265527, action=checkDatabaseConfig, Failed, namespace=dbaas, version=12.2.0.1, operation=start-db-service, cleanupActionIndex=-101, retryCount:0, jobRetryCount:0, jobRetryWaitTime:0, created: 2018-06-19T03:49:21.546+0000, started: 2018-06-19T03:49:21.546+0000, to retry: 2018-06-19T04:01:27.843+0000, failingStartTime: 2018-06-19T04:01:28.097+0000, domain:idcs-xxxxyyyyyyxxxxxxxxxxxxx, instance:SOA-TST-DB, wm:SM_server1, owner:abc.xyz@oracle.com

    FAILED CURRENT JOB 3265727: action: checkDatabaseConfig
       code: PSM-DB-015, message: Failed to configure Oracle Database Server...[
    SCRIPT execution errors in [x.x.x.x]:
    OCDE failed with message:

    ..........

    2018-06-19 14:01:07 - found match for bkup_cfg_db_spec, saving data dbcfg.spec
    2018-06-19 14:01:07 - processing line oss_url=https://mystorage.au.storage.oraclecloud.com/v1/Storage-mystorage/dbcs-SOA-TST-DB
    2018-06-19 14:01:07 - found match for oss_url, saving data https://mystorage.au.storage.oraclecloud.com/v1/Storage-mystorage/dbcs-SOA-TST-DB
    2018-06-19 14:01:07 - processing line bkup_oss_url=https://mystorage.au.storage.oraclecloud.com/v1/Storage-mystorage/dbcs-SOA-TST-DB
    2018-06-19 14:01:07 - found match for bkup_oss_url, saving data https://mystorage.au.storage.oraclecloud.com/v1/Storage-mystorage/dbcs-SOA-TST-DB

     2018-06-19 14:01:07 -
    at /var/opt/oracle/perl_lib/DBAAS/Common.pm line 567
    Common::parsecfg('Common=HASH(0xdb5c58)', '/var/opt/oracle/ocde/res/bkup.out', 'HASH(0x212b018)') called at /var/opt/oracle/ocde/ocde line 2498
    main::invoke_assistants('HASH(0xdb70b0)', 'logger=HASH(0xdb5748)') called at /var/opt/oracle/ocde/ocde line 731
    eval {...} called at /var/opt/oracle/ocde/ocde line 692
    2018-06-19 14:01:07 - INFO: Total time taken by ocde is 736 seconds
    2018-06-19 14:01:07 - OCDE failed with message:

    2018-06-19 14:01:07 -
    #### Completed OCDE with errors, please check logs ####
    2018-06-19 14:01:07 - Output from cmd touch /var/opt/oracle/log/ocde/ocde.log run on localhost  is:
    2018-06-19 14:01:07 - cmd took 0 seconds
    ...
    2018-06-19T04:01:28.093+00:00 [INFO]:Supplemental log added: check.db.logs.fail(2018-06-19 04:01:28 GMT)
    2018-06-19T04:01:28.093+00:00 [INFO]:Failed to configure Oracle Database Server...[
    SCRIPT execution errors in [x.x.x.x.22]:
    OCDE failed with message:

    #### Completed OCDE with errors, please check logs ####
    _1
    System name: Linux
    Node name: SOA-TST-DB
    Release: 4.1.12-112.14.10.el6uek.x86_64
    Version: #2 SMP Mon Jan 8 18:24:01 PST 2018

    ]
    2018-06-19T04:01:28.093+00:00 [INFO]:finished action: checkDatabaseConfig
    2018-06-19T04:01:28.093+00:00 [INFO]:Action returned code/message: PSM-DB-015: Failed to configure Oracle Database Server...[
    SCRIPT execution errors in [x.x.x.x]:
    OCDE failed with message:

    #### Completed OCDE with errors, please check logs ####
    _1
    System name: Linux
    Node name: SOA-TST-DB
    Release: 4.1.12-112.14.10.el6uek.x86_64
    Version: #2 SMP Mon Jan 8 18:24:01 PST 2018

    ]
    2018-06-19T04:01:28.093+00:00 [INFO]:Action returned status: FAILURE

Tried creating using REST API command getting 'HTTP/1.1 401 Unauthorized'

$ curl -i -X POST -u abc.xyz@oracle.com -H "X-ID-TENANT-NAME:mytest" -H "Content-Type:application/json" --data @db.json https://psm.aucom.oraclecloud.com/paas/service/dbcs/api/v1.1/instances/idcs-xxxxyyyyyyxxxxxxxxxxxxx
Enter host password for user 'abc.xyz@oracle.com':
HTTP/1.1 401 Unauthorized
Date: Wed, 20 Jun 2018 03:13:53 GMT
Content-Length: 0
X-ORACLE-DMS-ECID: 06536894-c68c-4a8d-ac31-f42291025f46-00087baf
WWW-Authenticate: Basic realm=owsm
Set-Cookie: BIGipServer~Public~psm.aucom.oraclecloud.com_pool=rd2o00000000000000000000ffff819a4018o7103; path=/

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.