Create Oracle RAC 11gR2 database using dbca silent file

How to create a 11g RAC database using dbca silent response file.

dbca -progress_only -responseFile “/home/shaiksameer/dbca_testdb.rsp”

vi dbca_testdb.rsp

RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "TESTDB"
SID = "TESTDB"
NODELIST=machine1,machine2,machine3,machine4
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "syspass12"
SYSTEMPASSWORD = "systempass12"
STORAGETYPE=ASM
DISKGROUPNAME=DATA
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16
SAMPLESCHEMA=FALSE
MEMORYPERCENTAGE = "10"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"

or you can pass the variable values directly.

dbca -silent -nodelist machine1,machine2,machine3,machine4 

 -createDatabase -templateName General_Purpose.dbc 

 -gdbName TESTDB 

 -sid TESTDB 

 -SysPassword syspass12

 -SystemPassword systempass12 

-emConfiguration NONE 

-characterSet WE8ISO8859P15

 -totalMemory 500

The local BEA product registry is corrupted. Please select another Middleware Home or contact Oracle Support

While installing weblogic using silent install file you may get the below error:


Issue:-
=====
java -Xmx5096m -jar weblogic64/wls1036_generic.jar -mode=silent -silent_xml=weblogic_install.xml -logfile=weblogic_install.log
Extracting 0%....................................................................................................100%
The local BEA product registry is corrupted. Please select another Middleware Home or contact Oracle Support


Fix:-
====
Silent file contains incorrect product list, please correct the product list and try again. i.e either a "|" is missed or quotes so on...

Recitfy the silent file and rerun the install.

Ex:-
  <data-value name="COMPONENT_PATHS"
        value="WebLogic Server/Core Application Server|WebLogic Server/Administration Console|WebLogic Server/Configuration Wizard and Upgrade Framework|WebLogic Server/Web 2.0 HTTP Pub-Sub Server|WebLogic Server/WebLogic JDBC Drivers|WebLogic Server/Third Party JDBC Drivers|WebLogic Server/WebLogic Server Clients|WebLogic Server/WebLogic Web Server Plugins|WebLogic Server/UDDI and Xquery Support|Oracle Coherence/Coherence Product Files" />

Create weblogic domain using silent install

Create weblogic domain using silent file.



Create the silent file that you will use for domain creation:-
=====================================

vi /weblogic_path/stage/response_files/wl_create_domain_demo.rsp
************ File starts here ***********
read template from "/weblogic_path/WL_DEMO/wlserver_10.3/common/templates/domains/wls.jar";

set JavaHome "/weblogic_path/java/jdk1.8.0_05"; //Set JDK to use

set ServerStartMode "dev"; //production mode or development mode

//To create a Admin server find it from wls template
find Server "AdminServer" as AdminServer;
set AdminServer.ListenAddress "";
set AdminServer.ListenPort "8001";
set AdminServer.SSL.Enabled "true";
set AdminServer.SSL.ListenPort "8002";

//We can directly create a new managed server.
create Server "ms1" as MS1;
set MS1.ListenAddress "";
set MS1.ListenPort "8003";
//set MS1.SSL.Enabled "true";
//set MS1.SSL.ListenPort "7004″;

//Craeting Cluster
//create Cluster "MyCluster" as MyCl;

//Putting managed servers into the cluster
//assign Server "MS1″ to Cluster "MyCluster";
//assign Server "MS2″ to Cluster "MyCluster";

//Create Machine
create Machine "shaiksameer.com" as Machinename;

//Create JDBC datasource and targeting it to cluster
//create JDBCConnectionPool "demoPool" as mypool;
//set mypool.DriverName "com.pointbase.jdbc.jdbcUniversalDriver";
//set mypool.URL "jdbc:pointbase:server://localhost:9092/demo";
//set mypool.Password "PBPUBLIC";
//set mypool.Properties "user=PBPUBLIC";
//assign JDBCConnectionPool "*" to target "MyCluster";

//Create File Store
//create JMSFileStore "FileStore" as filestore;
//set filestore.Directory "d:\FStore";
//create JMS server
//create JMSServer "JMSServer" as jmsserver;
//set jmsserver.PersistentStore "FileStore"; //Add persistence store to the JMS server
//assign JMSServer "*" to target "MS1″;

//create JMS queue, default subdeployment will be created and targeted. Not sure
//create JMSQueue "Queue" as queue;
//set queue.JNDIName "jms/queue"; //JNDI name for Queue
//set queue.JMSServer "JMSServer"; //Target queue to JMS server

//use templates default weblogic user
find User "weblogic" as u1;
set u1.password "weblogic4u";

//create a new user
create User "shaiksameer" as u2;
set u2.password "weblogic4u";

write domain to "/weblogic_path/WL_DEMO/user_projects/domains/demo_domain"; // The domain name will be "demo-domain"

close template;

********File end here ********


Start the domain creation:-
==================
/weblogic_path/WL_DEMO/wlserver_10.3/common/bin> ./config.sh -mode=silent -silent_script=/weblogic_path/stage/response_files/wl_create_domain_demo.rsp -logfile=/weblogic_path/WL_DEMO/create_domain.log

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
<< read template from "/weblogic_path/WL_DEMO/wlserver_10.3/common/templates/domains/wls.jar"
>>  succeed: read template from "/weblogic_path/WL_DEMO/wlserver_10.3/common/templates/domains/wls.jar"
<< set config option JavaHome to "/weblogic_path/java/jdk1.8.0_05"
>>  succeed: set config option JavaHome to "/weblogic_path/java/jdk1.8.0_05"
<< set config option ServerStartMode to "dev"
>>  succeed: set config option ServerStartMode to "dev"
<< find Server "AdminServer" as AdminServer
>>  succeed: find Server "AdminServer" as AdminServer
<< set AdminServer attribute ListenAddress to ""
>>  succeed: set AdminServer attribute ListenAddress to ""
<< set AdminServer attribute ListenPort to "8001"
>>  succeed: set AdminServer attribute ListenPort to "8001"
<< set AdminServer attribute SSL!Enabled to "true"
>>  succeed: set AdminServer attribute SSL!Enabled to "true"
<< set AdminServer attribute SSL!ListenPort to "8002"
>>  succeed: set AdminServer attribute SSL!ListenPort to "8002"
<< create Server "ms1" as MS1
>>  succeed: create Server "ms1" as MS1
<< set MS1 attribute ListenAddress to ""
>>  succeed: set MS1 attribute ListenAddress to ""
<< set MS1 attribute ListenPort to "8003"
>>  succeed: set MS1 attribute ListenPort to "8003"
<< create Machine "shaiksameer.com" as Machinename
>>  succeed: create Machine "shaiksameer.com" as Machinename
<< find User "weblogic" as u1
>>  succeed: find User "weblogic" as u1
<< set u1 attribute Password to "********"
>>  succeed: set u1 attribute Password to "********"
<< create User "shaiksameer" as u2
>>  succeed: create User "shaiksameer" as u2
<< set u2 attribute Password to "********"
>>  succeed: set u2 attribute Password to "********"
<< write Domain to "/weblogic_path/WL_DEMO/user_projects/domains/demo_domain"
...............................................................................................
>>  succeed: write Domain to "/weblogic_path/WL_DEMO/user_projects/domains/demo_domain"
<< close template
>>  succeed: close template

Weblogic silent install

Sample xml file to install weblogic in silent mode. I have tested this on weblogic 10.3.6 /Linux OEL6


Create the xml file using the below options, remember to take out the products that you don't need.

vi weblogic_install.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Silent installer option: -mode=silent -silent_xml=/PATH/silent.xml -->
<bea-installer>
  <input-fields>
  <data-value name="BEAHOME" value="/oracle/FMW/WebLogic" />
  <data-value name="COMPONENT_PATHS"
        value="WebLogic Server/Core Application Server|WebLogic Server/Administration Console|WebLogic Server/Configuration Wizard and Upgrade Framework|WebLogic Server/Web 2.0 HTTP Pub-Sub Server|WebLogic Server/WebLogic JDBC Drivers|WebLogic Server/Third Party JDBC Drivers|WebLogic Server/WebLogic Server Clients|WebLogic Server/WebLogic Web Server Plugins|WebLogic Server/UDDI and Xquery Support|Oracle Coherence/Coherence Product Files" />
  <data-value name="USE_EXTERNAL_ECLIPSE" value="false" />
  <data-value name="INSTALL_NODE_MANAGER_SERVICE" value="no" />
  <data-value name="NODEMGR_PORT" value="5559" />
  <data-value name="LOCAL_JVMS" value="/oracle/comn/java/jdk1.7.0_25"/>
  </input-fields>
</bea-installer>

Download weblogic from:-
=================
http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html


Install:-
======
java -Xmx1024m -jar ../weblogic64/wls1036_generic.jar -mode=silent -silent_xml=weblogic_install.xml
Extracting 0%....................................................................................................100%


Reference:-
http://docs.oracle.com/cd/E23943_01/doc.1111/e14142/silent.htm#i1044116

OID Get ORASSO password

Obtaining the Single Sign-On Schema Password

$ORACLE_HOME/bin/ldapsearch -h oidhostname -p portnumber -D "cn=orcladmin" -w orcladminpwd -b "orclReferenceName=, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" -s sub "orclResourceName=ORASSO" orclpasswordattribute


Ex:-

$ORACLE_HOME/bin/ldapsearch -h oidhost01 -p 389 -D "cn=orcladmin" -w mypass -b "orclReferenceName=OIDDB, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" -s sub "orclResourceName=ORASSO" orclpasswordattribute

Result:-
OrclResourceName=ORASSO,orclReferenceName=OIDDB,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext
orclpasswordattribute=PASSWORDHERE


Reference:-
========
http://docs.oracle.com/cd/B14099_19/idmanage.1012/b14078/schema.htm