12.2 PDB Creation Using DBCA Failing with Error [FATAL] [DBT-11502] The instance <instance name> is not running on the local node (Doc ID 2296555.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Pluggable database creation using dbca is failing with below error.

 

 $ORACLE_HOME/bin/dbca '-silent' '-createPluggableDatabase' '-createUserTableSpace' 'true' '-sourceDB' 'ORCL' '-pdbName' 'OraclePDB' '-createPDBFrom' 'DEFAULT' '-pdbDataFileDestination' '+DATADG1' '-pdbAdminPassword' 'xxx' '-pdbAdminUserName' 'pdbadmin'
[FATAL] [DBT-11502] The instance (ORCL) is not running on the local node.

CAUSE: A locally running instance is required to perform the selected operation.
ACTION: Specify a locally running database, or execute DBCA on a node where the database instance is running.
[FATAL] [DBT-11508] The selected database is not a Container database.
CAUSE: PDB operations can be performed only on a Container database.

 

From the srvctl output, we could see the database ORCL is up and running.


oracle@testrac1 ~]$ srvctl config database -d ORCL
Database unique name: orcl===========>
Database name: orcl
Oracle home: /u01/app/oracle/product/12.2.0/dbhome_1
Oracle user: oracle
Spfile: +MGMT/ORCL/PARAMETERFILE/spfile.308.945856625
Password file: +MGMT/ORCL/PASSWORD/pwdorcl.287.945856225
Domain: us.oracle.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: MGMT
Mount point paths:
Services:

Background process is also running.

[oracle@testrac1 ~]$ ps -ef | grep pmon
grid 8092 1 0 Jul13 ? 00:01:09 asm_pmon_+ASM2
grid 8404 1 0 Jul13 ? 00:01:19 apx_pmon_+APX2
oracle 8479 1 0 Jul13 ? 00:01:20 ora_pmon_orcl2 =====>
oracle 8834 2202 0 11:14 pts/1 00:00:00 grep pmon

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms