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 FEBRUARY 16, 2020
Applies to:
Oracle Database Cloud Service - Version N/A and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |