12cR2 Database Installation & Creation (Beta Testing)

Posted On May 31, 2016

Filed under Uncategorized

Comments Dropped leave a response

Run software installation:

# runInstaller

db1db2db3db4db5db6db7db8db9db10db11

Create ASM Diskgroups:

[oracle@pridb1 ~]$ . oraenv
ORACLE_SID = [db12c1] ? +ASM1
The Oracle base has been changed from /oracle/12.1.0.2 to /oracle/gridbase

# asmca

asm1asm2

Create CDB Database:

[oracle@pridb1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ? db12c1
The Oracle base has been changed from /oracle/gridbase to /oracle/12.1.0.2

# dbca

dbca1dbca2dbca3dbca4dbca5dbca6dbca7dbca8dbca9dbca10dbca11dbca12dbca13dbca14dbca15dbca16dbca17dbca18dbca19

Testing 12cR2 new features.

12cR2 – Grid Infrastructure Installation (Beta Testing)

Posted On May 30, 2016

Filed under Uncategorized

Comments Dropped leave a response

These basic steps for Grid Infra setup (beta version), the main release for 12cR2 will be soon on June or July🙂

Run GridSetup.sh and perform  installation

Grid1Grid2Grid3Grid4Grid5Grid6Grid7Grid8Grid9Grid10grid11Grid12Grid13Grid14

Grid15

Run root.sh on both nodes: pridb1 & pridb2

[root@pridb1 oracle]# /oracle/grid12cr2/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /oracle/grid12cr2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/grid12cr2/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/gridbase/crsdata/pridb1/crsconfig/rootcrs_pridb1_2016-05-31_05-50-41AM.log
2016/05/31 05:50:45 CLSRSC-594: Executing installation step 1 of 19: ‘SetupTFA’.
2016/05/31 05:50:45 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 05:51:20 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 05:51:20 CLSRSC-594: Executing installation step 2 of 19: ‘ValidateEnv’.
2016/05/31 05:51:25 CLSRSC-594: Executing installation step 3 of 19: ‘CheckFirstNode’.
2016/05/31 05:51:26 CLSRSC-594: Executing installation step 4 of 19: ‘GenSiteGUIDs’.
2016/05/31 05:51:27 CLSRSC-594: Executing installation step 5 of 19: ‘SaveParamFile’.
2016/05/31 05:51:32 CLSRSC-594: Executing installation step 6 of 19: ‘SetupOSD’.
2016/05/31 05:51:32 CLSRSC-594: Executing installation step 7 of 19: ‘CheckCRSConfig’.
2016/05/31 05:51:33 CLSRSC-594: Executing installation step 8 of 19: ‘SetupLocalGPNP’.
root wallet
Operation is successfully completed.
root wallet cert
Operation is successfully completed.
root cert export
Operation is successfully completed.
peer wallet
Operation is successfully completed.
profile reader wallet
Operation is successfully completed.
pa wallet
Operation is successfully completed.
peer wallet keys
Operation is successfully completed.
pa wallet keys
Operation is successfully completed.
peer cert request
Operation is successfully completed.
pa cert request
Operation is successfully completed.
peer cert
pa cert
peer root cert TP
Operation is successfully completed.
profile reader root cert TP
Operation is successfully completed.
pa root cert TP
Operation is successfully completed.
peer pa cert TP
Operation is successfully completed.
pa peer cert TP
Operation is successfully completed.
profile reader pa cert TP
Operation is successfully completed.
profile reader peer cert TP
Operation is successfully completed.
peer user cert
Operation is successfully completed.
pa user cert
Operation is successfully completed.
2016/05/31 05:51:49 CLSRSC-594: Executing installation step 9 of 19: ‘ConfigOLR’.
OLR initialization – successful
2016/05/31 05:51:55 CLSRSC-594: Executing installation step 10 of 19: ‘ConfigCHMOS’.
2016/05/31 05:51:55 CLSRSC-594: Executing installation step 11 of 19: ‘CreateOHASD’.
2016/05/31 05:51:58 CLSRSC-594: Executing installation step 12 of 19: ‘ConfigOHASD’.
2016/05/31 05:52:13 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.conf’
2016/05/31 05:52:34 CLSRSC-594: Executing installation step 13 of 19: ‘InstallAFD’.
2016/05/31 05:52:38 CLSRSC-594: Executing installation step 14 of 19: ‘InstallACFS’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb1’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 05:53:12 CLSRSC-594: Executing installation step 15 of 19: ‘InstallKA’.
2016/05/31 05:53:16 CLSRSC-594: Executing installation step 16 of 19: ‘InitConfig’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb1’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start ‘ora.evmd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘pridb1’
CRS-2676: Start of ‘ora.mdnsd’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘pridb1’
CRS-2676: Start of ‘ora.gpnpd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘pridb1’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.gipcd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘pridb1’
CRS-2676: Start of ‘ora.diskmon’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘pridb1’ succeeded

[TRIVIAL] [DBT-30001] Disk Groups created successfully. Check /oracle/gridbase/cfgtoollogs/asmca/asmca-160531AM055352.log for details.

2016/05/31 05:54:41 CLSRSC-482: Running command: ‘/oracle/grid12cr2/bin/ocrconfig -upgrade oracle oinstall’
CRS-2672: Attempting to start ‘ora.crf’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.storage’ on ‘pridb1’
CRS-2676: Start of ‘ora.storage’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.crf’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘pridb1’
CRS-2676: Start of ‘ora.crsd’ on ‘pridb1’ succeeded
CRS-4256: Updating the profile
Successful addition of voting disk 52747b0eeba94ff3bf06eb6641974f35.
Successfully replaced voting disk group with +OCR.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
—  —–    —————–                ——— ———
1. ONLINE   52747b0eeba94ff3bf06eb6641974f35 (ORCL:DISK04) [OCR]
Located 1 voting disk(s).
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.crsd’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.crf’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.drivers.acfs’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.drivers.acfs’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.crf’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.gpnpd’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.mdnsd’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘pridb1’
CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.ctssd’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.evmd’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.cssd’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.gipcd’ on ‘pridb1’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
2016/05/31 05:55:30 CLSRSC-594: Executing installation step 17 of 19: ‘StartCluster’.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.evmd’ on ‘pridb1’
CRS-2676: Start of ‘ora.mdnsd’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘pridb1’
CRS-2676: Start of ‘ora.gpnpd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘pridb1’
CRS-2676: Start of ‘ora.gipcd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘pridb1’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘pridb1’
CRS-2676: Start of ‘ora.diskmon’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cluster_interconnect.haip’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.ctssd’ on ‘pridb1’
CRS-2676: Start of ‘ora.ctssd’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.cluster_interconnect.haip’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb1’
CRS-2676: Start of ‘ora.asm’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.storage’ on ‘pridb1’
CRS-2676: Start of ‘ora.storage’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.crf’ on ‘pridb1’
CRS-2676: Start of ‘ora.crf’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘pridb1’
CRS-2676: Start of ‘ora.crsd’ on ‘pridb1’ succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: pridb1
CRS-6016: Resource auto-start has completed for server pridb1
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 05:57:45 CLSRSC-343: Successfully started Oracle Clusterware stack
2016/05/31 05:57:45 CLSRSC-594: Executing installation step 18 of 19: ‘ConfigNode’.
CRS-2672: Attempting to start ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb1’
CRS-2676: Start of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb1’
CRS-2676: Start of ‘ora.asm’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.OCR.dg’ on ‘pridb1’
CRS-2676: Start of ‘ora.OCR.dg’ on ‘pridb1’ succeeded
2016/05/31 05:59:46 CLSRSC-594: Executing installation step 19 of 19: ‘PostConfig’.
2016/05/31 06:00:05 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster … succeeded

[root@pridb2 ~]# /oracle/grid12cr2/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /oracle/grid12cr2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin …
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin …
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/grid12cr2/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/gridbase/crsdata/pridb2/crsconfig/rootcrs_pridb2_2016-05-31_06-00-58AM.log
2016/05/31 06:01:04 CLSRSC-594: Executing installation step 1 of 19: ‘SetupTFA’.
2016/05/31 06:01:04 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 06:01:45 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 06:01:45 CLSRSC-594: Executing installation step 2 of 19: ‘ValidateEnv’.
2016/05/31 06:01:47 CLSRSC-594: Executing installation step 3 of 19: ‘CheckFirstNode’.
2016/05/31 06:01:49 CLSRSC-594: Executing installation step 4 of 19: ‘GenSiteGUIDs’.
2016/05/31 06:01:49 CLSRSC-594: Executing installation step 5 of 19: ‘SaveParamFile’.
2016/05/31 06:01:52 CLSRSC-594: Executing installation step 6 of 19: ‘SetupOSD’.
2016/05/31 06:01:52 CLSRSC-594: Executing installation step 7 of 19: ‘CheckCRSConfig’.
2016/05/31 06:01:53 CLSRSC-594: Executing installation step 8 of 19: ‘SetupLocalGPNP’.
2016/05/31 06:01:56 CLSRSC-594: Executing installation step 9 of 19: ‘ConfigOLR’.
OLR initialization – successful
2016/05/31 06:01:58 CLSRSC-594: Executing installation step 10 of 19: ‘ConfigCHMOS’.
2016/05/31 06:01:58 CLSRSC-594: Executing installation step 11 of 19: ‘CreateOHASD’.
2016/05/31 06:01:58 CLSRSC-594: Executing installation step 12 of 19: ‘ConfigOHASD’.
2016/05/31 06:02:14 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.conf’
2016/05/31 06:02:41 CLSRSC-594: Executing installation step 13 of 19: ‘InstallAFD’.
2016/05/31 06:02:42 CLSRSC-594: Executing installation step 14 of 19: ‘InstallACFS’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb2’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb2’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 06:03:13 CLSRSC-594: Executing installation step 15 of 19: ‘InstallKA’.
2016/05/31 06:03:14 CLSRSC-594: Executing installation step 16 of 19: ‘InitConfig’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb2’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb2’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb2’
CRS-2673: Attempting to stop ‘ora.drivers.acfs’ on ‘pridb2’
CRS-2677: Stop of ‘ora.drivers.acfs’ on ‘pridb2’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb2’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
2016/05/31 06:03:32 CLSRSC-594: Executing installation step 17 of 19: ‘StartCluster’.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.evmd’ on ‘pridb2’
CRS-2676: Start of ‘ora.mdnsd’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘pridb2’
CRS-2676: Start of ‘ora.gpnpd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘pridb2’
CRS-2676: Start of ‘ora.gipcd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘pridb2’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘pridb2’
CRS-2676: Start of ‘ora.diskmon’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.cluster_interconnect.haip’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.ctssd’ on ‘pridb2’
CRS-2676: Start of ‘ora.ctssd’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.cluster_interconnect.haip’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb2’
CRS-2676: Start of ‘ora.asm’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.storage’ on ‘pridb2’
CRS-2676: Start of ‘ora.storage’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.crf’ on ‘pridb2’
CRS-2676: Start of ‘ora.crf’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘pridb2’
CRS-2676: Start of ‘ora.crsd’ on ‘pridb2’ succeeded
CRS-6017: Processing resource auto-start for servers: pridb2
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.net1.network’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb2’
CRS-2677: Stop of ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.net1.network’ on ‘pridb2’ succeeded
CRS-2673: Attempting to stop ‘ora.scan1.vip’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.ons’ on ‘pridb2’
CRS-2677: Stop of ‘ora.scan1.vip’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.scan1.vip’ on ‘pridb2’
CRS-2676: Start of ‘ora.scan1.vip’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb2’
CRS-2676: Start of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb2’
CRS-2676: Start of ‘ora.ons’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.asm’ on ‘pridb2’ succeeded
CRS-6016: Resource auto-start has completed for server pridb2
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 06:05:29 CLSRSC-343: Successfully started Oracle Clusterware stack
2016/05/31 06:05:29 CLSRSC-594: Executing installation step 18 of 19: ‘ConfigNode’.
2016/05/31 06:05:40 CLSRSC-594: Executing installation step 19 of 19: ‘PostConfig’.
2016/05/31 06:05:48 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster … succeeded

 

Grid16

Check cluster components status:

[root@pridb1 oracle]# crsctl stat res -t
——————————————————————————–
Name           Target  State        Server                   State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.ASMNET1LSNR_ASM.lsnr
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.LISTENER.lsnr
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.OCR.dg
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.net1.network
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.ons
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.proxy_advm
OFFLINE OFFLINE      pridb1                   STABLE
OFFLINE OFFLINE      pridb2                   STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
1        ONLINE  ONLINE       pridb2                   STABLE
ora.LISTENER_SCAN2.lsnr
1        ONLINE  ONLINE       pridb1                   STABLE
ora.LISTENER_SCAN3.lsnr
1        ONLINE  ONLINE       pridb1                   STABLE
ora.MGMTLSNR
1        ONLINE  ONLINE       pridb1                   169.254.25.230 172.1
6.1.11,STABLE
ora.asm
1        ONLINE  ONLINE       pridb1                   Started,STABLE
2        ONLINE  ONLINE       pridb2                   Started,STABLE
3        OFFLINE OFFLINE                               STABLE
ora.cvu
1        ONLINE  ONLINE       pridb1                   STABLE
ora.mgmtdb
1        ONLINE  ONLINE       pridb1                   Open,STABLE
ora.pridb1.vip
1        ONLINE  ONLINE       pridb1                   STABLE
ora.pridb2.vip
1        ONLINE  ONLINE       pridb2                   STABLE
ora.qosmserver
1        ONLINE  ONLINE       pridb1                   STABLE
ora.scan1.vip
1        ONLINE  ONLINE       pridb2                   STABLE
ora.scan2.vip
1        ONLINE  ONLINE       pridb1                   STABLE
ora.scan3.vip
1        ONLINE  ONLINE       pridb1                   STABLE
——————————————————————————–

The End🙂

 

 

 

 

 

 

DataGuard’s reaction when FarSync is off ?

Posted On December 28, 2015

Filed under Data Guard

Comments Dropped leave a response

One of the most advantages of Oracle DB 12c is Farsync, like the image below, but what happen when FarSync DB is down? How can DG automatic transport log to DR Site?
Image
All details about what is farsync DB, farsync statistics and how to config it in this link : https://dborasol.wordpress.com/2013/10/09/database-12c-far-sync-standby-database/
Today, I setup a lab to show you how to config for Primary DB automatic transport log to Standby DB when FarSync DB is down. Below config will help us in this case:
Init file in Primary (ServiceName: CHICAGO):
log_archive_config='DG_CONFIG=(CHICAGO,CBFS,BOSTON)'
log_archive_dest_2='SERVICE=CBFS SYNC AFFIRM MAX_FAILURE=5 REOPEN=60 ALTERNATE=LOG_ARCHIVE_DEST_3 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=CBFS'
log_archive_dest_3='SERVICE=BOSTON ASYNC NOAFFIRM ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=BOSTON'
log_archive_dest_state_1='enable';
log_archive_dest_state_2='ENABLE'
log_archive_dest_state_3='ALTERNATE'
Init file in FarSync (ServiceName: CBFS):
log_archive_config='DG_CONFIG=(CHICAGO,CBFS,BOSTON)'
log_archive_dest_1='LOCATION=+CBFS VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CBFS'
log_archive_dest_2='SERVICE=BOSTON ASYNC ALTERNATE =LOG_ARCHIVE_DEST_3 VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=BOSTON'
log_archive_dest_3='SERVICE=CHICAGO ASYNC ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=CHICAGO'
log_archive_dest_state_1='enable';
log_archive_dest_state_2='ENABLE';
log_archive_dest_state_3='ALTERNATE';
Init file in Standby (ServiceName: BOSTON):
log_archive_config='DG_CONFIG=(CHICAGO,CBFS,BOSTON)'
log_archive_dest_1='LOCATION=+BOSTON VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=BOSTON'
log_archive_dest_2='SERVICE=CBFS LGWR ASYNC MAX_FAILURE=2 ALTERNATE=LOG_ARCHIVE_DEST_3 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CBFS'
log_archive_dest_3='SERVICE=CHICAGO LGWR ASYNC ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CHICAGO'
log_archive_dest_state_1='enable';
log_archive_dest_state_2='ENABLE';
log_archive_dest_state_3='ALTERNATE';
Normally, log will be tranport to LOG_ARCHIVE_DEST_2, now let see when I shutdown FarSync DB:

Primary:
Capture
Capture1

FarSync:
Capture2

Standby DB:
Capture3

Primary DB try to transport log to FarSync DB but it cannot, this will happend for time we set with REOPEN and MAX_FAILURE in Primary DB.
After REOPEN time (in seconds) x MAX_FAILURE, log will be transport to Standby DB, now log will be sent to LOG_ARCHIVE_DEST_3, and DataGuard is now back to traditional way:

Capture4

With above configurations, when FarSync DB is up, Primary will automatically transport log back to FarSync and log from FarSync will sent to Standby like before.

Hope this help :)

Integrating OVM to OEM 13c Cloud Control

Posted On December 22, 2015

Filed under Uncategorized

Comments Dropped leave a response

Step 1: Plug in OVM to agent

Plug-ins => Oracle Virtualization => Deploy on => Management Agent
OVM1

OVM Plug in information displayed
OVM2

Choose Agent to deploy OVM Plug-ins
OVM3


Click Deploy
OVM4

Show Status
OVM5


Step 2: Register VM Manager to OEM

Click on Target Declarative
OVM6

Choose Agent monitor and target type Oracle VM Manager
OVM7.png
Provide OVM Connection Info
OVM8


Check the status

OVM9

Now test Cloud Infrastructure screen .
OVM10
Hope this help! :)

OEM 13c Installation

Posted On December 22, 2015

Filed under Uncategorized

Comments Dropped leave a response

Create Database repository for EM

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName emrepos -sid emrepos -createAsContainerDatabase false -SysPassword sysadmin -SystemPassword sysadmin -emConfiguration NONE -redoLogFileSize 600 -storageType FS -datafileDestination /oracle/12.1.0.1/oradata -characterSet AL32UTF8 -memoryPercentage 40 -automaticMemoryManagement true -sampleSchema true -initParams filesystemio_options=setall,job_queue_processes=1000,log_buffer=10485760,processes=600,open_cursors=1000,session_cached_cursors=1000,shared_pool_size=800M,db_securefile=PERMITTED
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
60% complete
61% complete
62% complete
65% complete
Completing Database Creation
69% complete
73% complete
76% complete
88% complete
99% complete
100% complete
Look at the log file "/home/oracle/cfgtoollogs/dbca/emrepos/emrepos.log" for further details.

Setup OEM13C installation:

13c_113c_213c_313c_413c_513c_613c_713c_813c_913c_1013c_1113c_1213c_1313c_1413c_1513c_1613c_1713c_1813c_19

For new and exciting features of OEM 13c, check link below

https://blogs.oracle.com/oem/entry/oracle_enterprise_manager_13c_new

Ready for Cloud🙂

PDB Hot Clone – 12cR2

Posted On November 27, 2015

Filed under Uncategorized

Comments Dropped leave a response

Oracle Database 12c Release 2 PDB Hot Clone, this will make your database move easier than ever. This is just testing purpose, Oracle Database 12c will be release in 2016.

[oracle@db12c orcl12]$ ls -lart
total 2865720
drwxr-x---. 3 oracle vboxsf       4096 Oct 24 22:08 ..
drwxr-x---. 2 oracle vboxsf       4096 Oct 24 22:08 pdbseed
drwxr-x---. 2 oracle vboxsf       4096 Oct 24 22:08 pdb1
drwxr-x---. 4 oracle vboxsf       4096 Oct 24 22:08 .
-rw-r-----. 1 oracle vboxsf    5251072 Nov 26 22:06 users01.dbf
-rw-r-----. 1 oracle vboxsf   52429312 Nov 26 22:10 redo03.log
-rw-r-----. 1 oracle vboxsf   52429312 Nov 26 22:10 redo01.log
-rw-r-----. 1 oracle vboxsf  117448704 Nov 26 22:11 temp01.dbf
-rw-r-----. 1 oracle vboxsf  162537472 Nov 26 22:14 undotbs01.dbf
-rw-r-----. 1 oracle vboxsf 1646272512 Nov 26 22:14 sysaux01.dbf
-rw-r-----. 1 oracle vboxsf  922755072 Nov 26 22:14 system01.dbf
-rw-r-----. 1 oracle vboxsf   18726912 Nov 26 22:14 control01.ctl
-rw-r-----. 1 oracle vboxsf   18726912 Nov 26 22:14 control02.ctl
-rw-r-----. 1 oracle vboxsf   52429312 Nov 26 22:14 redo02.log

mkdir -p /u01/app/oracle/oradata/orcl12/pdb2

create pluggable database pdb2 from pdb1
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12/pdb1', '/u01/app/oracle/oradata/orcl12/pdb2');

SQL> col totalsize for 9999999 heading "TotalSize(Mb)"
SQL> select inst_id,con_id,dbid,name,open_mode,round(total_size/1024/1024,1) totalsize from GV$PDBS;

   INST_ID     CON_ID       DBID NAME            OPEN_MODE  TotalSize(Mb)
---------- ---------- ---------- --------------- ---------- -------------
         1          2 3543631094 PDB$SEED        READ ONLY            800
         1          3 3929371449 PDB1            READ WRITE          1086

SQL> create pluggable database pdb2 from pdb1
  2  FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12/pdb1', '/u01/app/oracle/oradata/orcl12/pdb1');
create pluggable database pdb2 from pdb1
*
ERROR at line 1:
ORA-44607: Archive logging must be enabled.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1048576000 bytes
Fixed Size                  4590720 bytes
Variable Size             490734464 bytes
Database Buffers          549453824 bytes
Redo Buffers                3796992 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archive' scope=both;

System altered.

SQL> alter database open;

Database altered.

SQL> create pluggable database pdb2 from pdb1
  2  FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12/pdb1', '/u01/app/oracle/oradata/orcl12/pdb2');

Pluggable database created.

SQL> select inst_id,con_id,dbid,name,open_mode,round(total_size/1024/1024,1) totalsize from GV$PDBS;

   INST_ID     CON_ID       DBID NAME            OPEN_MODE  TotalSize(Mb)
---------- ---------- ---------- --------------- ---------- -------------
         1          2 3543631094 PDB$SEED        READ ONLY            800
         1          3 3929371449 PDB1            READ WRITE          1086
         1          4 4017322761 PDB2            MOUNTED                0

SQL> alter pluggable database pdb2 open;

Pluggable database altered.

SQL> select inst_id,con_id,dbid,name,open_mode,round(total_size/1024/1024,1) totalsize from GV$PDBS;

   INST_ID     CON_ID       DBID NAME            OPEN_MODE  TotalSize(Mb)
---------- ---------- ---------- --------------- ---------- -------------
         1          2 3543631094 PDB$SEED        READ ONLY            800
         1          3 3929371449 PDB1            READ WRITE          1086
         1          4 4017322761 PDB2            READ WRITE           995

Waiting🙂

Silent install & configure ASM & Database (Non ASMLIB)

Posted On October 29, 2015

Filed under Uncategorized

Comments Dropped leave a response

There 4 disks mapped as linux devices. Using Fdisk to create partition for these raw disks.

[root@pridb dev]# ls -lart sd*
brw-rw—- 1 root disk 8,  0 Oct 29 09:14 sda
brw-rw—- 1 root disk 8,  2 Oct 29 09:14 sda2
brw-rw—- 1 root disk 8,  1 Oct 29 09:14 sda1
brw-rw—- 1 root disk 8, 16 Oct 29 09:14 sdb
brw-rw—- 1 root disk 8, 32 Oct 29 09:14 sdc
brw-rw—- 1 root disk 8, 48 Oct 29 09:14 sdd
brw-rw—- 1 root disk 8, 80 Oct 29 09:14 sdf
brw-rw—- 1 root disk 8, 64 Oct 29 09:14 sde

To manage disks and permission when starting OS you must use UDEV.

[root@pridb ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules

KERNEL==”sdb1″, NAME=”disk01″, OWNER=”oracle”, GROUP=”dba”, MODE=”0660″
KERNEL==”sdc1″, NAME=”disk02″, OWNER=”oracle”, GROUP=”dba”, MODE=”0660″
KERNEL==”sdd1″, NAME=”disk03″, OWNER=”oracle”, GROUP=”dba”, MODE=”0660″
KERNEL==”sde1″, NAME=”disk04″, OWNER=”oracle”, GROUP=”dba”, MODE=”0660″

Reload rule and start UDEV

[root@pridb ~]# udevadm control –reload-rules
[root@pridb ~]# start_udev
Starting udev:                                             [  OK  ]

Check disks alias created on /dev/

[root@pridb dev]# ls -lart  disk*
brw-rw—- 1 oracle dba  8, 49 Oct 29 09:28 disk03
brw-rw—- 1 oracle dba  8, 33 Oct 29 09:28 disk02
brw-rw—- 1 oracle dba  8, 81 Oct 29 09:34 disk05
brw-rw—- 1 oracle dba  8, 65 Oct 29 09:36 disk04
brw-rw—- 1 oracle dba  8, 17 Oct 29 09:36 disk01

Install GRID Infrastructure in silent mode

./runInstaller -invPtrLoc /etc/oraInst.loc -silent FROM_LOCATION=../stage/products.xml ORACLE_HOSTNAME=PRIDB ORACLE_BASE=/oracle SELECTED_LANGUAGES=en ORACLE_HOME=/oracle/11.2.0.4/grid INVENTORY_LOCATION=/oracle/oraInventory oracle.install.option=HA_CONFIG oracle.install.asm.diskGroup.diskDiscoveryString=’/dev/disk*’ oracle.install.asm.diskGroup.name=DATA oracle.install.asm.diskGroup.disks=’/dev/disk01′ oracle.install.asm.SYSASMPassword=sysadmin oracle.install.asm.monitorPassword=sysadmin oracle.install.asm.OSDBA=dba oracle.install.asm.OSOPER=dba oracle.install.asm.OSASM=dba oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.upgradeASM=false

As a root user, execute the following script(s):
1. /oracle/11.2.0.4/grid/root.sh
As install user, execute the following script to complete the configuration.
1. /oracle/11.2.0.4/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file>
Note:
1. This script must be run on the same host from where installer was run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
Successfully Setup Software.

[root@pridb grid]# /oracle/11.2.0.4/grid/root.sh
Check /oracle/11.2.0.4/grid/install/root_pridb_2015-10-29_01-33-05.log for the output of root script

[root@pridb ~]# tail -f /oracle/11.2.0.4/grid/install/root_pridb_2015-10-29_01-33-05.log
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user ‘oracle’, privgrp ‘oinstall’..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
CRS-4664: Node pridb successfully pinned.
Adding Clusterware entries to upstart
pridb     2015/10/29 01:33:28     /oracle/11.2.0.4/grid/cdata/pridb/backup_20151029_013328.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

Configure ASM & Create Diskgroup

[oracle@pridb bin]$ ./asmca -silent -configureASM -sysAsmPassword sysadmin -asmsnmpPassword sysadmin -diskString ‘/dev/disk*’ -diskGroupName DATA -diskList ‘/dev/disk01’ -redundancy EXTERNAL -au_size 16 -compatible.asm ‘11.2.0.0.0’ -compatible.rdbms ‘11.2.0.0.0’

ASM created and started successfully.
Disk Group DATA created successfully.

Install Oracle Home Software

./runInstaller -silent FROM_LOCATION=../stage/products.xml oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/oracle/oraInventory ORACLE_HOME=/oracle/dbsoft/db_1 ORACLE_HOME_NAME=”OraDb11g_Home1″ ORACLE_BASE=/oracle/dbsoft oracle.install.db.InstallEdition=EE oracle.install.db.isCustomInstall=false oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba DECLINE_SECURITY_UPDATES=true

As a root user, execute the following script(s):
1. /oracle/dbsoft/db_1/root.sh
Successfully Setup Software.

[root@pridb oracle]# /oracle/dbsoft/db_1/root.sh
Check /oracle/dbsoft/db_1/install/root_pridb_2015-10-29_02-36-15.log for the output of root script
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /oracle/dbsoft/db_1
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Finished product-specific root actions.

Create Database

[oracle@pridb ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName DBTEST -sid DBTEST -SysPassword sysadmin -SystemPassword sysadmin -emConfiguration NONE -redoLogFileSize 100 -storageType ASM -asmSysPassword sysadmin -diskGroupName DATA -characterSet AL32UTF8 -memoryPercentage 40 -automaticMemoryManagement true -sampleSchema true -initParams filesystemio_options=setall,job_queue_processes=1000,log_buffer=10485760,processes=500,open_cursors=300,session_cached_cursors=300
5% complete
Copying database files
7% complete
8% complete
38% complete
Creating and starting Oracle instance
39% complete
41% complete
45% complete
46% complete
50% complete
54% complete
55% complete
56% complete
59% complete
61% complete
Registering database with Oracle Restart
66% complete
Completing Database Creation
70% complete
73% complete
76% complete
86% complete
96% complete
100% complete
Look at the log file “/oracle/dbsoft/cfgtoollogs/dbca/DBTEST/DBTEST0.log” for further details.

Check Database status

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
——— ——————–
DBTEST    READ WRITE

Save your time🙂

Upgrade Standalone DB 11gR2 (11.2.0.3) to DB 12c (12.1.0.1)

Posted On June 15, 2015

Filed under Uncategorized

Comments Dropped leave a response

11gto12c_Standalone_S1

11gto12c_Standalone_S2

11gto12c_Standalone_S3

11gto12c_Standalone_S4

Select Apply Action

11gto12c_Standalone_S5

11gto12c_Standalone_S6

11gto12c_Standalone_S7

Change database file path if needed by select Move Database Files.

11gto12c_Standalone_S8

11gto12c_Standalone_S9

11gto12c_Standalone_S10

Backup before Upgrade id needed by Select Use RMAN backup and specify backup location. If not Select I have own backup and restore strategy.

11gto12c_Standalone_S11

Check all again before Upgrade.

11gto12c_Standalone_S12

11gto12c_Standalone_S13

11gto12c_Standalone_S14

11gto12c_Standalone_S15

11gto12c_Standalone_S16

[oracle@rac03 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------------------------------------------
Name               Target     State        Server                   State details       Local Resources
--------------------------------------------------------------------------------------------------------------------
ora.CRS.dg       ONLINE  ONLINE    rac03                    STABLE
ora.DATA.dg      ONLINE  ONLINE   rac03                    STABLE
ora.LISTENER.lsnr  ONLINE  ONLINE       rac03          STABLE
ora.asm              ONLINE  ONLINE      rac03                 Started,STABLE
ora.ons               OFFLINE OFFLINE   rac03                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1        ONLINE  ONLINE       rac03                          STABLE
ora.diskmon
1        OFFLINE OFFLINE                                        STABLE
ora.evmd
1        ONLINE  ONLINE       rac03                           STABLE
ora.test12c.db
1        ONLINE  ONLINE       rac03                           Open,STABLE
--------------------------------------------------------------------------------

Moving the 11R2 RAC database servers to new datacenter with changed IP address and subnet

Posted On May 25, 2015

Filed under Uncategorized

Comments Dropped one response

  • Shutdown the CRS and DISABLE CRS auto start
  • Move the servers to new data center
  • Start the CRS – only on first node(./crsctl start crs)
  • Update the GPGNP profile in 11gR2
  • Modify the IP details on OCR using oifcfg
  • Now bounce CRS on first node and start the CRS on second node           NOW, WE JUST FOCUS ON THE THIRD AND FOURTH STEP.

    Suppose:

                 Inter connect IP: 192.168.95.110

                Subnet: 192.168.95.0

                Virtual IP: 192.168.164.110

                Subnet: 192.168.164.0

    • Start the CRS – only on first node(./crsctl start crs)

    When we Start the CRS – we got below errors when we tried starting the CRS with server running on different subnet with new IP address.
    ” [crsd(21366)]CRS-0804:Cluster Ready Service aborted due to Oracle Cluster Registry error [PROC-44: Error in network address and interface operations Network address and interface operations error [7]]. Details at (:CRSD00111:) in /u01/app2/grid/11.2.0/log/oracledb08/crsd/crsd.log.”

    Case: Change subnet and IP of Private,VIP,SCAN. The CRSD process will not start and any subsequent changes (using oficfg) to the OCR will be impossible NOTE:1094024.1

    Cause: As of 11.2 Grid Infrastructure, the CRS daemon (crsd.bin) now has a dependency on the private network configuration stored in the gpnp profile and OCR.  If the private network is not available or its definition is incorrect.

    Solution: It needs to be taken when making modifications to the configuration of the private network. It is important to perform the changes in the correct order.

    • Update the GPGNP profile in 11gR2 (run all the steps on first node as ROOT unless specified dont run on other nodes)

    STEP1: Start CRS on all the nodes (though CRSD won’t come up we need gpnp deamon running on all the cluster nodes)

    su – root

    # cd $GRID_HOME/bin

    # ./crsctl start crs

    # ps -ef | grep gpnp

    grid 27470   1  0 01:09:08 ?    0:38 u01/app2/11.2.0/grid/bin/gpnpd.bin

    STEP 2: On first node: As the from 11gR2 – CRS startup is based on GPNP profile we need to update profile to reflect new IP address (to view current profile infomation

    su – root

    # cd $GRID_HOME/bin/

    # ./gpnptool get >> we can notice the old ip and interface name

    Warning: some command line parameters were defaulted. Resulting command line:

    ./gpnptool.bin get -o-

    <?xml version=”1.0″ encoding=”UTF-8″?><gpnp:GPnP-Profile Version=”1.0″ xmlns=”http://www.grid-pnp.org/2005/11/gpnp-profile&#8221; xmlns:gpnp=”http://www.grid-pnp.org/2005/11/gpnp-profile&#8221; xmlns:orcl=”http://www.oracle.com/gpnp/2005/11/gpnp-profile&#8221; xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance&#8221; xsi:schemaLocation=”http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd” ProfileSequence=”25″ ClusterUId=”a376122ae0fcffbaffed51fc0c0afee2″ ClusterName=”oraclecrs” PALocation=””><gpnp:Network-Profile><gpnp:HostNetwork id=”gen” HostName=”*”><gpnp:Network id=”net2” IP=”10.10.10.0″ Adapter=”lan900″ Use=”cluster_interconnect”/><gpnp:Network id=”net1” Adapter=”lan0″ IP=”192.168.97.0″ Use=”public”/>

    ………

    Success.

    STEP 3: on first node: Take backup of existing GPNP profile before editing (we are going have temp profile XML file and do our modification there in that file). This profile (will be store in $GRID_HOME/gpnp/hostname/profiles/peer) is the backup of the profile store in OCR, in case of failure CRS will auto re-create this file.

    # mkdir /home/oracle/gpnp

    # export GPNPDIR=/home/oracle/gpnp

    # ./gpnptool get -o=$GPNPDIR/profile.original

    # cp $GPNPDIR/profile.original $GPNPDIR/prf.xml

    STEP 4: on first node: Get current profile sequence number – this is the version of profile, we need to increment it while editing profile i.e current prf_sq +1. If you don’t increase this number you will get Error CLSGPNP_TOO_OLD when trying put profile to OCR.

    su – root

    # cd $GRID_HOME/bin

    # ./gpnptool getpval -p=$GPNPDIR/p.xml -prf_sq -o-

    20

    STEP 5: on first node: Get available network interfaces

    su – root

    # cd $GRID_HOME/bin

    # ./oifcfg iflist

    lan1  169.254.0.0

    lan1  192.168.95.0

    lan0  192.168.97.0

    lan7  192.168.97.0

    lan5  192.168.99.0

    lan900  192.168.164.0

    STEP 6: Get the current NETWORK ID from profile and crosscheck the xml file

    su – root

    # cd $GRID_HOME/bin

    # ./gpnptool getpval -p=$GPNPDIR/p.xml -net -o-

    net1 net2

    STEP 7: Now update the profile which created in previous step with new IP subnet of interconnect and VIP

    su – root

    # cd $GRID_HOME/bin

    # ./gpnptool edit -p=$GPNPDIR/p.xml -o=$GPNPDIR/prf.xml -ovr -prf_sq=21 -net1:net_use=public -net1:net_ip=192.168.164.0 -net1:net_ada=lan900

    # ./gpnptool edit -p=$GPNPDIR/p.xml -o=$GPNPDIR/prf.xml -ovr -prf_sq=21 -net2:net_use=cluster_interconnect -net2:net_ip=192.168.95.0 -net2:net_ada=lan1

    # cat $GPNPDIR/prf_new.xml >> new IP subnet of Interconnect and VIP should be here

    <?xml version=”1.0″ encoding=”UTF-8″?><gpnp:GPnP-Profile Version=”1.0″ xmlns=”http://www.grid-pnp.org/2005/11/gpnp-profile&#8221; xmlns:gpnp=”http://www.grid-pnp.org/2005/11/gpnp-profile&#8221; xmlns:orcl=”http://www.oracle.com/gpnp/2005/11/gpnp-profile&#8221; xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance&#8221; xsi:schemaLocation=”http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd” ProfileSequence=”21″ ClusterUId=”a376122ae0fcffbaffed51fc0c0afee2″ ClusterName=”oraclecrs” PALocation=””><gpnp:Network-Profile><gpnp:HostNetwork id=”gen” HostName=”*”><gpnp:Network id=”net1” IP=”192.168.164.0″ Adapter=”lan900″ Use=”public”/><gpnp:Network id=”net2” IP=”192.168.95.0″ Adapter=”lan1″ Use=”cluster_interconnect”/>

    ………

    Success.

    –> It will deffer with the last time we saw.

    STEP 8: Sign with encrypted wallet and update to OCR

    su – root

    # cd $GRID_HOME/bin

    # ./gpnptool sign -p=$GPNPDIR/prf.xml -o=$GPNPDIR/prf_new.xml -ovr -w=cw-fs:peer

    # ./gpnptool put -p=$GPNPDIR/prf_new.xml

    Success

    # ./gpnptool get >> check again, if content is the same with $GPNPDIR/prf_new.xml then you are done, but crs will not run with this profile until you restart.

    # ./crsctl stop crs –f

    # ./crsctl start crs

    STEP 9: Now we run oifcfg getif — it will be warned/error which ignorable as we edited GPNP profile and its not matching with OCR

    su – root

    # cd $GRID_HOME/bin

    # ./oifcfg getif >> first time system will show below errorPRIF-30: Network information in OCR and GPnP profile differs

    # ./oifcfg delif -global lan1

    # ./oifcfg delif -global lan900

    # ./oifcfg setif -global lan900/192.168.164.0:public

    # ./oifcfg setif -global lan1/192.168.95.0:cluster_interconnect

    # ./oifcfg getif

    lan1  192.168.95.0  global  cluster_interconnect

    lan900  192.168.164.0  global  public

    STEP 10: Config SCAN, VIP and LISTENER_SCAN

    #Config SCAN

    su – root

    # cd $GRID_HOME/bin

    # ./srvctl config scan

    SCAN name: oraclecrs, Network: 1/192.168.164.0/255.255.255.0/lan900

    SCAN VIP name: scan1, IP: /192.168.97.20/192.168.97.20

    # ./srvctl remove scan  -f

    # ./srvctl add scan -n oraclecrs -k 1 -S 192.168.164.0/255.255.255.0/lan900

    #Config VIP

    # ./srvctl config vip -n oracledb08

    VIP exists: /oracledb08-vip/192.168.164.12/192.168.97.0/255.255.255.0/lan0, hosting node oracledb08

    # ./srvct modify nodeapps -n oracledb08 -A 192.168.164.12/255.255.255.0/lan900

    #Config SCAN_LISTENER – make sure LISTENER_SCAN1 is not running

    # ./srvctl status scan_listener

    SCAN Listener LISTENER_SCAN1 is enabled

    SCAN listener LISTENER_SCAN1 is not running

    # ./srvctl modify scan_listener -p TCP:1521

    # ./srvctl start scan_listener

    STEP 11: Clean stop/start CRS again

    # crsctl stop crs –f

    # crsctl start crs

(Read More)

Performance Hub Active Report – Oracle Database 12c

Posted On March 24, 2015

Filed under Uncategorized

Comments Dropped leave a response

Performance Hub feature of EM Express provides an active report with a consolidated view of all performance data for a specified time period. The report is fully interactive; its contents are saved in a HTML file, which you can access offline using a web browser.

Generating a Performance Hub Active Report Using a SQL Script: the script is located $ORACLE_HOME/rdbms/admin/perfhubrpt.sql

@rpthtml/perfhubrpt.sql all 4065805245 1 '03/22/15 23:50:06' '03/23/15 00:00:07' 1_PerfHub_150322_2350_0000.html

Generate reports for PerfHub:

perf0

All real time or historical database performance data can be collected. Below some pics from report:

perf1

perf2

perf3

perf4

perf5

Hope this help!

Next Page »
Follow

Get every new post delivered to your Inbox.