ODACLI CREATE-DATABASE FAILS WITH DCS-10001(ASSOCIATE NETWORK WITH DATABASE)
(Doc ID 2875260.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]Information in this document applies to any platform.
Symptoms
odacli create-database fails with DCS-10001(associate network with database failure)
# odacli create-database --databaseUniqueName <DBUNIQUENAME> --dbname
<DBNAME> --pdbname <PDBNAME> --dbstorage ACFS --cdb --dbEdition EE --version
12.1.0.2
Enter SYS, SYSTEM and PDB Admin user password:
Retype SYS, SYSTEM and PDB Admin user password:
Job details
----------------------------------------------------------------
ID: fe46acad-14a5-462b-8c96-43daa55a0f09
Description: Database service creation with db name: CDBTEST
Status: Created
Created: April 19, 2022 12:47:29 PM JST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
After that,job result shows as follows.
# odacli describe-job -i fe46acad-14a5-462b-8c96-43daa55a0f09
Job details
----------------------------------------------------------------
ID: fe46acad-14a5-462b-8c96-43daa55a0f09
Description: Database service creation with db name: <DBNAME>
Status: Failure
Created: April 19, 2022 12:47:29 PM JST
Message: DCS-10001:Internal error encountered: Failed to associate network {06530393-0df4-4963-94cd-bff8f94b3a20} with database {d6d3c56a-378c-4045-a9bb-16408b04c98f}.
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Database Service creation April 19, 2022 12:47:47 PM JST April 19, 2022 1:06:11 PM JST Failure
Database Service creation April 19, 2022 12:47:47 PM JST April 19, 2022 1:06:11 PM JST Failure
Validating dbHome available space April 19, 2022 12:47:47 PM JST April 19, 2022 12:47:47 PM JST Success
Validating dbHome available space April 19, 2022 12:47:47 PM JST April 19, 2022 12:47:47 PM JST Success
Setting up ssh equivalance April 19, 2022 12:47:47 PM JST April 19, 2022 12:47:48 PM JST Success
Setting up ssh equivalance April 19, 2022 12:47:48 PM JST April 19, 2022 12:47:49 PM JST Success
Creating volume datCDBTEST April 19, 2022 12:47:49 PM JST April 19, 2022 12:48:08 PM JST Success
Creating volume rdoCDBTEST April 19, 2022 12:48:08 PM JST April 19, 2022 12:48:27 PM JST Success
Creating ACFS filesystem for DATA April 19, 2022 12:48:27 PM JST April 19, 2022 12:48:44 PM JST Success
Creating ACFS filesystem for RECO April 19, 2022 12:48:44 PM JST April 19, 2022 12:49:01 PM JST Success
Creating ACFS database home April 19, 2022 12:49:01 PM JST April 19, 2022 12:49:01 PM JST Success
Validating dbHome available space April 19, 2022 12:49:01 PM JST April 19, 2022 12:49:01 PM JST Success
Validating dbHome available space April 19, 2022 12:49:01 PM JST April 19, 2022 12:49:01 PM JST Success
Creating DbHome Directory April 19, 2022 12:49:01 PM JST April 19, 2022 12:49:01 PM JST Success
Create required directories April 19, 2022 12:49:01 PM JST April 19, 2022 12:49:01 PM JST Success
Extract DB clone April 19, 2022 12:49:01 PM JST April 19, 2022 12:50:32 PM JST Success
ProvDbHome by using RHP April 19, 2022 12:50:32 PM JST April 19, 2022 12:52:23 PM JST Success
Enable DB options April 19, 2022 12:52:23 PM JST April 19, 2022 12:52:31 PM JST Success
Creating wallet for DB Client April 19, 2022 12:52:36 PM JST April 19, 2022 12:52:37 PM JST Success
configuring Net Security April 19, 2022 12:52:37 PM JST April 19, 2022 12:52:37 PM JST Success
Database Service creation April 19, 2022 12:52:38 PM JST April 19, 2022 1:06:05 PM JST Success
Database Creation by RHP April 19, 2022 12:52:38 PM JST April 19, 2022 1:03:01 PM JST Success
Change permission for xdb wallet files April 19, 2022 1:03:01 PM JST April 19, 2022 1:03:01 PM JST Success
Add Startup Trigger to Open all PDBS April 19, 2022 1:03:01 PM JST April 19, 2022 1:03:02 PM JST Success
SqlPatch upgrade April 19, 2022 1:03:59 PM JST April 19, 2022 1:05:01 PM JST Success
Set log_archive_dest for Database April 19, 2022 1:05:01 PM JST April 19, 2022 1:05:02 PM JST Success
Updating the Database version April 19, 2022 1:05:02 PM JST April 19, 2022 1:05:05 PM JST Success
Set CPU pool April 19, 2022 1:05:05 PM JST April 19, 2022 1:05:05 PM JST Success
create Users tablespace April 19, 2022 1:06:05 PM JST April 19, 2022 1:06:08 PM JST Success
Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} April 19, 2022 1:06:08 PM JST April 19, 2022 1:06:09 PM JST Success
associate network with database April 19, 2022 1:06:09 PM JST April 19, 2022 1:06:11 PM JST Failure <<<<<<<<<< here
DB alert log shows as follows.
local_listener and remote_listener set once, but they have been removed since
then.
Tue Apr 19 13:05:50 2022
ALTER SYSTEM SET local_listener='
(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521))' SCOPE=MEMORY
SID='<INSTANCE1>';
Tue Apr 19 13:05:50 2022
ALTER SYSTEM SET remote_listener=' <SCANNAME>:1521' SCOPE=MEMORY
SID='<INSTANCE1>';
Tue Apr 19 13:05:50 2022
ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='<INSTANCE1>';
ALTER DATABASE MOUNT /* db agent *//* {1:4532:20899} */
Tue Apr 19 13:05:58 2022
...
Tue Apr 19 13:06:09 2022
ALTER SYSTEM SET listener_networks='' SCOPE=BOTH;
Tue Apr 19 13:06:09 2022
ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=IPC)(KEY=DUMMY))'
SCOPE=BOTH; <<<<<<<<<<
Tue Apr 19 13:06:09 2022
ALTER SYSTEM SET remote_listener='' SCOPE=BOTH; <<<<<<
Tue Apr 19 13:06:09 2022
DCS agent seems to remove local_listener and remote_listener,after that, DCS-10001 occur.
dcs-agent.log
-----
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.p.LocalObjectStore: This is a sortable entity
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.p.LocalObjectStore: Not include dbvm, but include local, return local list
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.c.ConfigParamValuesUtil: isFeatureEnabled feature-MultiUserAccess
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.DCSFileUtils: Appending id 3762 to the file sqlplus
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.DCSFileUtils: Final filename: /tmp/dcsfiles/sqlplus/sqlplus2022-04-19_13-06-09.05173762.sql
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.u.d.SqlPlusHelper: Sql statements are written to :/tmp/dcsfiles/sqlplus/sqlplus2022-04-19_13-06-09.05173762.sql
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.CommonsUtils:
ALTER SYSTEM SET LISTENER_NETWORKS='' ;
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.CommonsUtils:
ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS=(PROTOCOL=IPC)(KEY=DUMMY))' ;
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.CommonsUtils:
ALTER SYSTEM SET REMOTE_LISTENER='' ;
2022-04-19 13:06:09,517 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.CommonsUtils:
exit ;
2022-04-19 13:06:09,518 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.CommonsUtils:
set timing off ;
2022-04-19 13:06:09,518 DEBUG [Clear all listeners from Databse {d6d3c56a-378c-4045-a9bb-16408b04c98f} : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.CommonsUtils:
ALTER SYSTEM SET LISTENER_NETWORKS='' ;
...
2022-04-19 13:06:11,646 DEBUG [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.u.f.FileOpsUtils: File deleted
2022-04-19 13:06:11,646 DEBUG [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.u.d.SqlPlusHelper: Finished running Sql Script /tmp/dcsfiles/sqlplus/sqlplus2022-04-19_13-06-11.04963762.sql
2022-04-19 13:06:11,646 DEBUG [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.r.s.n.NetworkLifecycleUtils: Query Output : listener_networks |string |
2022-04-19 13:06:11,646 DEBUG [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.r.s.n.NetworkLifecycleUtils: sqlPaser.getProperty(selectValues): [{VALUE=null, TYPE=string, NAME=listener_networks}]
2022-04-19 13:06:11,646 DEBUG [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.r.s.n.NetworkLifecycleUtils: The current listener networks values got are:
2022-04-19 13:06:11,646 DEBUG [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.r.s.n.NetworkLifecycleUtils: The current listener networks entities got are: []
2022-04-19 13:06:11,646 ERROR [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.r.s.n.NetworkLifecycleUtils: Failed to associate network with name{Public-network} to database -- null
2022-04-19 13:06:11,646 ERROR [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.a.r.s.d.DbActions: Failed to associate network {06530393-0df4-4963-94cd-bff8f94b3a20} with database {d6d3c56a-378c-4045-a9bb-16408b04c98f}
2022-04-19 13:06:11,646 ERROR [associate network with database : JobId=fe46acad-14a5-462b-8c96-43daa55a0f09] [] c.o.d.c.j.JsonRequestProcessor: RPC request invocation failed on request: {"classz":"com.oracle.dcs.agent.rpc.service.db.DbActions","method":"associateNetworkWithDatabase","params":[{"type":"java.lang.String","value":"06530393-0df4-4963-94cd-bff8f94b3a20"},{"type":"java.lang.String","value":"d6d3c56a-378c-4045-a9bb-16408b04c98f"}],"revertable":false,"threadId":3762}
! com.oracle.dcs.commons.exception.DcsException: DCS-10001:Internal error encountered: Failed to associate network {06530393-0df4-4963-94cd-bff8f94b3a20} with database {d6d3c56a-378c-4045-a9bb-16408b04c98f}.
! at com.oracle.dcs.commons.exception.DcsException$Builder.build(DcsException.java:150)
! at com.oracle.dcs.agent.rpc.service.db.DbActions.associateNetworkWithDatabase(DbActions.java:2907)
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
! at java.lang.reflect.Method.invoke(Method.java:498)
! at com.oracle.dcs.commons.jrpc.JsonRequestProcessor.invokeRequest(JsonRequestProcessor.java:145)
! at com.oracle.dcs.commons.jrpc.JsonRequestProcessor.process(JsonRequestProcessor.java:187)
! at com.oracle.dcs.agent.task.TaskZJsonRpcExt.callInternal(TaskZJsonRpcExt.java:112)
! at com.oracle.dcs.agent.task.TaskZJsonRpc.call(TaskZJsonRpc.java:283)
! at com.oracle.dcs.agent.task.TaskZJsonRpc.call(TaskZJsonRpc.java:78)
! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:115)
! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:63)
! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:65)
! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:36)
! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:115)
! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:63)
! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:65)
! at com.oracle.dcs.agent.task.TaskZLockWrapper.call(TaskZLockWrapper.java:122)
! at com.oracle.dcs.agent.task.TaskZLockWrapper.call(TaskZLockWrapper.java:64)
! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:115)
! at com.oracle.dcs.commons.task.TaskApi.call(TaskApi.java:63)
! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:65)
! at com.oracle.dcs.commons.task.TaskSequential.call(TaskSequential.java:36)
! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:115)
! at com.oracle.dcs.commons.task.TaskWrapper.call(TaskWrapper.java:59)
! at java.util.concurrent.FutureTask.run(FutureTask.java:266)
! at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
! at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
! at java.lang.Thread.run(Thread.java:748)
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 |
| Cause |
| Solution |
| References |