My Oracle Support Banner

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 FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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' '<dbname>' '-pdbName' '<PDBname>' '-createPDBFrom' 'DEFAULT' '-pdbDataFileDestination' '+DATADG1' '-pdbAdminPassword' 'xxx' '-pdbAdminUserName' '<pdbadmin>'
[FATAL] [DBT-11502] The instance (<instancename>) 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 <dbname> is up and running.


oracle@testrac1 ~]$ srvctl config database -d <dbname>
Database unique name: <dbname>===========>
Database name: <dbname>
Oracle home: $DB_HOME
Oracle user: oracle
Spfile: +MGMT/ORCL/PARAMETERFILE/spfile.308.945856625
Password file: +MGMT/ORCL/PASSWORD/pwdorcl.287.945856225
Domain: <domain>
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

 

 

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
References


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