Home > Default > Error when creating Oracle12c PDB using DBCA response file in silent mode

Error when creating Oracle12c PDB using DBCA response file in silent mode

October 11Hits:0
Advertisement
I am getting an Oracle dbca NullPointerException when trying to create a PDB (Pluggable Database) usingdbca response file in silent mode.
I have a Oracle 12c CDB up and running, listener is also up, $ORACLE_HOME and $ORACLE_SID are also set correctly.
After database install and creating CDB using response files, I am now trying to create a PDB using dbca response file. Contents of dbca.rsp -
[GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createPluggableDatabase"
[CREATEPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "dev"
CREATEPDBFROM = "DEFAULT"
PDBADMINUSERNAME = "oracle"
PDBADMINPASSWORD = "oracle"
CREATEUSERTABLESPACE = "true" 
I tried following commands:
dbca -silent -responseFile /<file path>/dbca.rsp dbca -silent -createPluggableDatabase -responseFile /<file path>/dbca.rsp
Both give same error:
---- Begin output of /u01/app/oracle/product/12c/db_1/bin/dbca -silent -responseFile /<file path>/dbca.rsp
STDOUT:
STDERR: Exception in thread "main" java.lang.NullPointerException
at oracle.sysman.assistants.dbca.backend.CommandLineArguments.processResponseFile(CommandLineArguments.java:6885)
at oracle.sysman.assistants.dbca.backend.CommandLineArguments.process(CommandLineArguments.java:4544)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:110) at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:184)
However when I pass exact same parameters as command line arguments, dbca works absolutely fine and PDB is created: Following command runs succefully.
dbca -silent -createPluggableDatabase -sourceDB orcl -pdbName dev -createPDBFrom default -pdbAdminUserName oracle -pdbAdminPassword oracle -createUserTableSpace true
My environment need installation using response files only. I had used a dbca response file with "createDatabase" option for CDB and it worked fine. Error is observed only when I run it with OPERATION_TYPE as "createPluggableDatabase".
There is an option to create PDBs along with CDB creation when OPERATION_TYPE is "createDatabase". But Oracle does not give flexibility to name PDBs in this option. If I ask Oracle to create 3 PDBs, it will name them itself like PDB01, PDB02, PDB03 and so on. This doesn't work in my deployment because of applications compile time dependencies on specific PDB names.

Answers

Yes, I am pointing to correct response file. I have two of these. One for "createDatabase" and another one for "createPluggableDatabase".
While the first one works absolutely fine, the one which creates PDBs always gives error.
I tried renaming the response file like dbca_dev.rsp for PDB install but same error message. I read in another forum that rename dbca.rsp is not a good idea.
So I kept it as dbca.rsp but built it using PDB template.
When I try after removing -silent, it tries to launch a UI installer. Since I am in Amazon AWS platform, my instance is CentOS based which doesn't support Xwindows display.
I am stuck with -silent install only. When I try with -progressOnly, I get exactly same error.
Also tried removing some parameters but still get exact same error message.
Tried same trick with "createDatabase" response file, now I see parameters missing error message.
It seems like Oracle doesn't like response file install for "createPluggableDatabase".

Read other 3 answers

Tags:

Related Articles

  • Error when creating Oracle12c PDB using DBCA response file in silent modeOctober 11

    I am getting an Oracle dbca NullPointerException when trying to create a PDB (Pluggable Database) usingdbca response file in silent mode. I have a Oracle 12c CDB up and running, listener is also up, $ORACLE_HOME and $ORACLE_SID are also set correctly

  • Best method for silent-auto DBCA : response file OR dbca scripts ?November 30

    As far as I discovered there are 2 alternatives on creating silently a Database 1. Generate scripts from DBCA itself at end and run the batch - even if you have to make some modification to pass dynamically the DB Name or other parameters eachtime 2.

  • DBCA response file problemNovember 30

    When installing oracle RAC 11g using a customized dbca response file, the initialization parameter for the oracle control files location gets parsed but not applied. From my dbca.rsp: INITPARAMS = CLUSTER_DATABASE=TRUE ........... ,CONTROL_FILES=("/o

  • Paraller Query Server Error while creating the database using DBCA on UNIXOctober 11

    Hi All, I am try to create the database on UNIX PLATFORM database 11g R1. At the end of database creation using DBCA i got the errors: ORA-12801:error signaled in parallel query server P077 ORA-00018: maximun number of sessions exceeded ORA-06512:at"

  • ORA-12547 error while creating new database through dbcaOctober 11

    i installed oracle 10g R2 on parallels virtuozzo container. (it is a product similar to openvz and solaris containers) added: oracle version is 10.2.0.1.0 the installation goes off without too much fuss but when i try to create a general purpose data

  • Error when create contract from RFx bid responseNovember 30

    Dear Expert, need your help, i have create rfx, response the rfx and accepted the rfx response. after that i want to create this response rfx to contract, but this error show up. Error application is coming up. 20110425 ABY_AZKI 183553 srmqas http://

  • Error While creating a new template or updating file with an existing templOctober 11

    Hi, I am trying to create a new Tempalte using XML Publisher Administrator resp. I am getting the error pasted below: oracle.apps.fnd.framework.OAException: oracle.apps.xdo.XDOException: String index out of range: -2      at oracle.apps.fnd.framework

  • Error while creating a system from a par fileOctober 11

    Hi all, I am trying to integrate a web app to our portal. When i am trying to create a from a par file (any par file ,even the system defined parfiles), i am getting the following error.     Portal runtime error. An exception occurred while processin

  • DBCA response fileNovember 30

    Hello, I have created a database template and I am trying to create a database from it on another station in dbca silent mode. I would like to set the password for sys, system and other dbas from a file but I would like that password to be encrypted

  • Error -1 creating frame when sharing as "Master File".November 30

    Anyone seen this before? Anything I can do?Did you manage to sort out the unusual render issues you described here? If you didn't, my intial thought is this error messsage and the earlier issues might be related. It would help if you could list any a

Copyright (C) 2017 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 15 q. 1.379 s.