Create Oracle11g Database in existing Oracle12c RAC / ASM Deployment

Article: Create Oracle11g Database in existing Oracle12c RAC / ASM Deployment
#Existing Deployment
Oracle12c v12.1.0.2.0 2-Node RAC / ASM
Oracle12c RAC Database is deployed

#Challenge
Install New 11g v11.2.0.4.0 Database in existing environment

#Silent Software Installation of Oracle 11g v11.2.0.4.0 RAC Database
Silent oracle11g db software installation

–ignoreSysPrereqs is not working when using silent file
./runInstaller -ignoreSysPrereqs -silent -responseFile /home/oracle/database/response/db_install.rsp

-bash-4.2$ ./runInstaller -silent -responseFile /home/oracle/database/response/db_install.rsp
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 120 MB. Actual 8540 MB Passed
Checking swap space: must be greater than 150 MB. Actual 16383 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-06-22_09-46-57AM. Please wait …-bash-4.2$ [FATAL] [INS-13013] Target environment do not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/installActions2016-06-22_09-46-57AM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/installActions2016-06-22_09-46-57AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

–ignoreSysPrereqs is working fine when using in command line

./runInstaller -silent
-ignoreSysPrereqs
-ignorePrereq
-responseFile /home/oracle/database/response/db_install.rsp
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11204/db_2
ORACLE_HOME_NAME=db_2
oracle.install.option=INSTALL_DB_SWONLY
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
DECLINE_SECURITY_UPDATES=true
oracle.install.db.CLUSTER_NODES=csm-clstrnode1,csm-clstrnode2
‘-ignoreInternalDriverError’

-bash-4.2$ ./runInstaller -silent
> -ignoreSysPrereqs
> -ignorePrereq
> -responseFile /home/oracle/database/response/db_install.rsp
> ORACLE_BASE=/u01/app/oracle
> ORACLE_HOME=/u01/app/oracle/product/11204/db_2
> ORACLE_HOME_NAME=db_2
> oracle.install.option=INSTALL_DB_SWONLY
> oracle.install.db.InstallEdition=EE
> oracle.install.db.DBA_GROUP=dba
> oracle.install.db.OPER_GROUP=oper
> DECLINE_SECURITY_UPDATES=true
> oracle.install.db.CLUSTER_NODES=csm-clstrnode1,csm-clstrnode2
> ‘-ignoreInternalDriverError’
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 120 MB. Actual 8537 MB Passed
Checking swap space: must be greater than 150 MB. Actual 16383 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-06-22_10-13-57AM. Please wait …-bash-4.2$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2016-06-22_10-13-57AM.log
SEVERE:Remote ‘AttachHome’ failed on nodes: ‘csm-clstrnode2’. Refer to ‘/u01/app/oraInventory/logs/installActions2016-06-22_10-13-57AM.log’ for details.
It is recommended that the following command needs to be manually run on the failed nodes:
/u01/app/oracle/product/11204/db_2/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=/u01/app/oracle/product/11204/db_2 ORACLE_HOME_NAME=db_2 CLUSTER_NODES=csm-clstrnode1,csm-clstrnode2 “INVENTORY_LOCATION=/u01/app/oraInventory” LOCAL_NODE=.
Please refer ‘AttachHome’ logs under central inventory of remote nodes where failure occurred for more details.
The installation of Oracle Database 11g was successful on the local node but failed on remote nodes.
Please check ‘/u01/app/oraInventory/logs/silentInstall2016-06-22_10-13-57AM.log’ for more details.

As a root user, execute the following script(s):
1. /u01/app/oracle/product/11204/db_2/root.sh

Execute /u01/app/oracle/product/11204/db_2/root.sh on the following nodes:
[csm-clstrnode1, csm-clstrnode2]

Successfully Setup Software.

#Oracle11g v11.2.0.4.0 RAC DB Creation using DBCA Command line options

./dbca -silent
-createDatabase
-templateName General_Purpose.dbc
-gdbName csmqa
-sid csmqa
-SysPassword oracleqa
-SystemPassword oracleqa
-emConfiguration NONE
-redoLogFileSize 100
-recoveryAreaDestination DATA
-storageType ASM
-asmSysPassword oracleqa
-diskGroupName DATA
-characterSet AL32UTF8
-nationalCharacterSet AL16UTF16
-totalMemory 4096
-databaseType MULTIPURPOSE
-nodelist csm-clstrnode1,csm-clstrnode2

-bash-4.2$ ./dbca -silent
> -createDatabase
> -templateName General_Purpose.dbc
> -gdbName csmqa
> -sid csmqa
> -SysPassword oracleqa
> -SystemPassword oracleqa
> -emConfiguration NONE
> -redoLogFileSize 100
> -recoveryAreaDestination DATA
> -storageType ASM
> -asmSysPassword oracleqa
> -diskGroupName DATA
> -characterSet AL32UTF8
> -nationalCharacterSet AL16UTF16
> -totalMemory 4096
> -databaseType MULTIPURPOSE
> -nodelist csm-clstrnode1,csm-clstrnode2
Copying database files
1% complete
3% complete
9% complete
15% complete
21% complete
30% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
44% complete
45% complete
48% complete
50% complete
Creating cluster database views
52% complete
70% complete
Completing Database Creation
73% complete
76% complete
85% complete
94% complete
100% complete
Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/csmqa/csmqa.log” for further details.

#Verify the newly created database deployment
SQL> select name from v$controlfile;

NAME
——————————————————————————–
+DATA/csmqa/controlfile/current.2132.915203609
+DATA/csmqa/controlfile/current.2136.915203609

SQL> show parameter spfile

NAME TYPE VALUE
———————————— ———– ——————————
spfile string +DATA/csmqa/spfilecsmqa.ora
SQL>
SQL> select member from v$logfile;

MEMBER
——————————————————————————–
+DATA/csmqa/onlinelog/group_2.2137.915203613
+DATA/csmqa/onlinelog/group_2.2128.915203613
+DATA/csmqa/onlinelog/group_1.2126.915203613
+DATA/csmqa/onlinelog/group_1.2131.915203613
+DATA/csmqa/onlinelog/group_3.2129.915203695
+DATA/csmqa/onlinelog/group_3.2139.915203695
+DATA/csmqa/onlinelog/group_4.2140.915203695
+DATA/csmqa/onlinelog/group_4.2141.915203695

SQL> show parameter spfile

NAME TYPE VALUE
———————————— ———– ——————————
spfile string +DATA/csmqa/spfilecsmqa.ora

SQL> show parameter memory

NAME TYPE VALUE
———————————— ———– ——————————
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SQL>
SQL> show parameter sga

NAME TYPE VALUE
———————————— ———– ——————————
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3G
sga_target big integer 3G
SQL>
SQL> show parameter pga

NAME TYPE VALUE
———————————— ———– ——————————
pga_aggregate_target big integer 1G

#Data Migration
expdp userid = “‘ / as sysdba'” DIRECTORY=DATA_PUMP_DIR schemas=NV662,DHAVALNV680,DHAVALNV660,DHAVALNV648 dumpfile=exp_QA_220616.dmp logfile=log_QA_220616.log

-bash-4.2$ cat create_schema.sql
CREATE TABLESPACE &&TABLESPACE_NAME DATAFILE ‘+DATA’ size 10m autoextend on;

CREATE USER &&USERNAME IDENTIFIED BY &&USERNAME
DEFAULT TABLESPACE &&TABLESPACE_NAME
QUOTA UNLIMITED ON &&TABLESPACE_NAME;

GRANT READ,WRITE ON DIRECTORY DATA_PUMP_DIR TO &&USERNAME;

GRANT CONNECT,RESOURCE TO &&USERNAME;

impdp userid = “‘ / as sysdba'” DIRECTORY=DATA_PUMP_DIR schemas=NV662,DHAVALNV680,DHAVALNV660,DHAVALNV648 dumpfile=exp_QA_220616.dmp logfile=log_QA_220616.log

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s