DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DBCA Template based silent installation fails for 11g R2

  1. #1
    Join Date
    Feb 2012
    Posts
    2

    DBCA Template based silent installation fails for 11g R2

    Hi All,

    I am working on automated installation and creation for Oracle DB. I have installed the base software first (went successfully) then using DBCA to install and create Database from Template. For this I have run DBCA in GUI mode first, created the template for my configuration and installed the DB which is perfectly fine, then used that template to create DB with same configuration silently. In silent mode DBCA behaves differently for the same configuration and template file generated from GUI installation.

    The command I have used:
    Code:
    dbca -silent -createDatabase -template MyTemplate.dbt -gdbName MYDB112 -sid MYDB112 -SystemPassword manager -SysPassword manager -emConfiguration NONE -datafileDestination /u02/oradata -storageType FS characterSet ALF32UTF8
    After installation is done Database behaves like this way:

    STARTUP:
    Code:
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 1.3700E+10 bytes
    Fixed Size 2161112 bytes
    Variable Size 6878660136 bytes
    Database Buffers 6777995264 bytes
    Redo Buffers 41164800 bytes
    ORA-00205: error in identifying control file, check alert log for more info
    SHUTDOWN:
    Code:
    SQL> shutdown normal
    ORA-01507: database not mounted
    
    ORACLE instance shut down.
    OBSERVATION
    1. There is no controlfile/datafile created in the path mentioned in template. I wonder do I have to pass them from command line? because in template already everything was configured and that template was created from a working DB.

    2. In Log file error occurs like ORA-12701: CREATE DATABASE character set is not known howwver I pass it from command line

    3. Please find the log file to provide a quick glimpse to your experienced eye what has happened: (I hav resized removed same errors)

    DBCA LOG FILE
    Code:
    Creating and starting Oracle instance
    DBCA_PROGRESS : 1%
    DBCA_PROGRESS : 2%
    ORA-12701: CREATE DATABASE character set is not known
    
    DBCA_PROGRESS : 6%
    Creating database files
    ORA-01109: database not open
    
    ORA-01507: database not mounted
    
    DBCA_PROGRESS : 7%
    DBCA_PROGRESS : 13%
    Creating data dictionary views
    DBCA_PROGRESS : 15%
    ORA-01109: database not open
    
    ORA-06550: line 2, column 4:
    PLS-00201: identifier 'DBMS_REGISTRY.LOADING' must be declared
    ORA-06550: line 2, column 4:
    PL/SQL: Statement ignored
    
    ORA-06550: line 3, column 15:
    PLS-00201: identifier 'REGISTRY$.VERSION' must be declared
    ORA-06550: line 3, column 15:
    PL/SQL: Item ignored
    ORA-06550: line 4, column 19:
    PLS-00201: identifier 'REGISTRY$.VERSION' must be declared
    ORA-06550: line 4, column 19:
    PL/SQL: Item ignored
    ORA-06550: line 6, column 20:
    PLS-00201: identifier 'DBMS_REGISTRY_SERVER.XDB_PATH' must be declared
    ORA-06550: line 6, column 3:
    PL/SQL: Statement ignored
    ORA-06550: line 12, column 8:
    PLS-00320: the declaration of the type of this expression is incomplete or malformed
    ORA-01109: database not open
    
    ORA-01109: database not open
    .
    .
    .
    ORA-01109: database not open
    
    ORA-01109: database not open
    Completing Database Creation
    DBCA_PROGRESS : 84%
    DBCA_PROGRESS : 86%
    ORA-01219: database not open: queries allowed on fixed tables/views only
    
    DBCA_PROGRESS : 88%
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    
    DBCA_PROGRESS : 94%
    ORA-01507: database not mounted
    
    ORA-00205: error in identifying control file, check alert log for more info
    
    ORA-01507: database not mounted
    
    DBCA_PROGRESS : 95%
    ORA-01507: database not mounted
    
    ORA-01507: database not mounted
    
    ORA-00205: error in identifying control file, check alert log for more info
    
    DBCA_PROGRESS : 100%
    Database creation complete. For details check the logfiles at:
    /u01/app/oracle/cfgtoollogs/dbca/MYDB112.
    Database Information:
    Global Database Name:MYDB112
    System Identifier(SID):MYDB112
    I have tried to search as best in this forum not able to found anything specific to this scenario. Sincere Apologies for any mistake as this is I am doing first time Oracle installation and If I have violated any thread rules.

    Any help/redirection would be a great help. Let me know if you need more information.

    Thanks a advance,
    Bhaskar

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    For starters...

    1- It should be "-characterSet" not "characterSet"
    2- Check "oracle" user - or whatever account you are using to install - has proper privileges on /u02/oradata

    Last but not least - for documentation purposes is not a good practice to feed everything on the command line; much better to do it thru a response file which can be saved for future reference.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2012
    Posts
    2
    Quote Originally Posted by PAVB View Post
    For starters...

    1- It should be "-characterSet" not "characterSet"
    2- Check "oracle" user - or whatever account you are using to install - has proper privileges on /u02/oradata

    Last but not least - for documentation purposes is not a good practice to feed everything on the command line; much better to do it thru a response file which can be saved for future reference.
    Thanks Paul for this reply.

    I conducted a detailed revision. It seems that I had another transcription error on charaterset, it has to be "AL32UTF8", not "ALF32UTF8". It went fine.

    From next time I will induce this practice to use response file.

    Thanks for you time and advise.

    Cheers,
    Bhaskar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width