How to create database(1 CDB and 2 PDB) by dbca silent mode with response file, oracle 12c

oracle-12c

I want create a new database with 1 CDB and 2 PDB, so i write response file and use dbca tool with silent mode. But it must Manual input PDBADMIN password through terminal and only create 1 CDB and 0 PDB. Here is my response file sample:

[GENERAL]
RESPONSEFILE_VERSION=12.1.0
OPERATION_TYPE=createDatabase
[CREATEDATABASE]
GDBNAME=orcl1
SID=orcl1
CREATEASCONTAINERDATABASE=true
NUMBEROFPDBS=2
PDBNAME=pdb1/pdb2
TEMPLATENAME=General_Purpose.dbc
SYSPASSWORD=Welcome1
SYSTEMPASSWORD=Welcome1
EMCONFIGURATION=NONE
DATABASETYPE=MULTIPURPOSE
LISTENERS=LISTENER

anybody knows how can fix it?

Best Answer

I think you need to add a 'pdbAdminPassword' parameter to your response file.

The following worked for me:

[oracle@ora12c66 CDBORCL]$ dbca -silent -createPluggableDatabase -sourceDB cdborcl  -pdbName pdb4 -createPDBFrom default  -pdbAdminUserName pdb4  -pdbAdminPassword qwe123 -createUserTableSpace true -sampleSchema true -TEMPLATENAME General_Purpose.dbc
Creating Pluggable Database 
4% complete
12% complete
21% complete
38% complete
85% complete
Completing Pluggable Database Creation
100% complete
Look at the log file "/u01/cfgtoollogs/dbca/cdborcl/pdb4/cdborcl0.log" for further details.

Related Solutions

How to force oracle 12c to create histograms

A friend of mine told me today, that using the following command

begin
  DBMS_STATS.GATHER_TABLE_STATS (
    ownname => USER,
    tabname => 'H_LINEITEM',
    estimate_percent => 100,
    method_opt=>'FOR ALL COLUMNS SIZE AUTO FOR COLUMNS SIZE 254 SYS_STU3ZM$X#P01D3JFWNOWKQ7DD$'
  );
end;
/

where SYS_STU3ZM$X#P01D3JFWNOWKQ7DD$ is the automatically generated name of the column group,

one can manually create a histogram for a given column / column group.

A description can be found here.

Using Oracle 12c database (SCAN) with Oracle 8 client

Oracle will try to have at least one active scan listener on every node of the cluster. They are running on a vip and that vip can be relocated to any of the nodes.

As long as your app does not care in what instance it connects, it does not matter where your connection takes you. Problem comes when your app tries to connect to a specific service that is not on the node where the first returned listener address is located. In that case you are better off with a regular address list.

The scan address is unavailable during maintenance and while it is reassigned.

Best Answer

Related Solutions

How to force oracle 12c to create histograms

Using Oracle 12c database (SCAN) with Oracle 8 client

Related Question