Steps to Relink 12c Grid

Relinking the 12c Grid 

In this Practice have have used 2 Nodes with the Hp-ux Itanium as the O/S with the 12c grid and 12c database with The standard cluster .. Before starting the re linking process we need to stop all the cluster services running in all the Nodes ..check the CRS and make sure that the crs had been in all the Nodes

Step 1  Unlock the grid infrastructure 

We need to unlock all the nodes in the grid infrastructure to perform the relink .. the unlocking can be done by the O/S root user ..before unlock the grid make sure that all the services had been  stopped correctly
As the root user navigate to the GRID_HOME/crs/install directory and run the command  perl rootcrs.pl -unlock  In all the nodes
Node1
root @ db01/prod01/oracle/12.1.0/12.1.0/grid/crs/install >perl rootcrs.pl -unlock
Using configuration parameter file: ./crsconfig_params
2014/06/29 11:50:07 CLSRSC-347: Successfully unlock /prod01/oracle/12.1.0/12.1.0/grid
root @ db01./prod01/oracle/12.1.0/12.1.0/grid/crs/install >
Node2
root @ db02/prod01/oracle/12.1.0/12.1.0/grid/crs/install >perl rootcrs.pl -unlock
Using configuration parameter file: ./crsconfig_params
2014/06/29 11:53:39 CLSRSC-347: Successfully unlock /prod01/oracle/12.1.0/12.1.0/grid
root @ db02/prod01/oracle/12.1.0/12.1.0/grid/crs/install >

Step 2 Relink for the grid owner[O/S]
Switch the user to the grid owner and set the environment variable for ORACLE_HOME and path for the grid user and navigate to ORACLE_HOME/bin and execute the command relink all in all the nodes 
Node1
oragrid @ db01/home/oragrid >echo $ORACLE_HOME
/prod01/oracle/12.1.0/12.1.0/grid

oragrid @ db01/prod01/oracle/12.1.0/12.1.0/grid/bin >relink all

writing relink log to: /prod01/oracle/12.1.0/12.1.0/grid/install/relink.log

Node2

oragrid @ db02/prod01/oracle/12.1.0/12.1.0/grid >echo $ORACLE_HOME

/prod01/oracle/12.1.0/12.1.0/grid

oragrid @ db01/prod01/oracle/12.1.0/12.1.0/grid/bin >relink all

writing relink log to: /prod01/oracle/12.1.0/12.1.0/grid/install/relink.log

Once the Re-link is done check the relink.log to find where any discard or any error Messages if there are error or discard messages fix the problem and move to next step .. else Proceed to the next step 

Step 3 Rootadd and rootcrs execution

Once the relink command had been successfully completed then we need to run the rootadd and rootcrs  again from the o/s root user

Run the rootadd_rdbms.sh from the GRID_HOME/rdbms/install as the root user run the command on all the nodes of the grid
Node1

root @ db01/prod01/oracle/12.1.0/12.1.0/grid/rdbms/install >pwd

/prod01/oracle/12.1.0/12.1.0/grid/rdbms/install

root @ db01/prod01/oracle/12.1.0/12.1.0/grid/rdbms/install >./rootadd_rdbms.sh

Node2

root @ db02/prod01/oracle/12.1.0/12.1.0/grid/rdbms/install >pwd

/prod01/oracle/12.1.0/12.1.0/grid/rdbms/install

root @ db02/prod01/oracle/12.1.0/12.1.0/grid/rdbms/install >./rootadd_rdbms.sh

After the execution of the rootadd_rdbms.sh we need to execute the perl rootcrs.pl -patch  it will start the all the Custer services .. we need to execute this command in all the nodes in the cluster
Node1

root @ db01/prod01/oracle/12.1.0/12.1.0/grid/crs/install >perl rootcrs.pl -patch

Using configuration parameter file: ./crsconfig_params

CRS-4123: Starting Oracle High Availability Services-managed resources

CRS-2672: Attempting to start 'ora.mdnsd' on 'db01'

CRS-2672: Attempting to start 'ora.evmd' on 'db01'

CRS-2676: Start of 'ora.mdnsd' on 'db01' succeeded

CRS-2676: Start of 'ora.evmd' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'db01'

CRS-2676: Start of 'ora.gpnpd' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.gipcd' on 'db01'

CRS-2676: Start of 'ora.gipcd' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db01'

CRS-2676: Start of 'ora.cssdmonitor' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'db01'

CRS-2672: Attempting to start 'ora.diskmon' on 'db01'

CRS-2676: Start of 'ora.diskmon' on 'db01' succeeded

CRS-2789: Cannot stop resource 'ora.diskmon' as it is not running on server 'db01'

CRS-2676: Start of 'ora.cssd' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'db01'

CRS-2672: Attempting to start 'ora.ctssd' on 'db01'

CRS-2676: Start of 'ora.ctssd' on 'db01' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'db01'

CRS-2676: Start of 'ora.asm' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'db01'

CRS-2676: Start of 'ora.storage' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'db01'

CRS-2676: Start of 'ora.crsd' on 'db01' succeeded

CRS-6023: Starting Oracle Cluster Ready Services-managed resources

CRS-6017: Processing resource auto-start for servers: db01

CRS-2672: Attempting to start 'ora.scan1.vip' on 'db01'

CRS-2672: Attempting to start 'ora.ons' on 'db01'

CRS-2672: Attempting to start 'ora.db01.vip' on 'db01'

CRS-2672: Attempting to start 'ora.db02.vip' on 'db01'

CRS-2672: Attempting to start 'ora.cvu' on 'db01'

CRS-2676: Start of 'ora.cvu' on 'db01' succeeded

CRS-2676: Start of 'ora.scan1.vip' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'db01'

CRS-2676: Start of 'ora.db02.vip' on 'db01' succeeded

CRS-2676: Start of 'ora.db01.vip' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'db01'

CRS-2672: Attempting to start 'ora.LISTENER_OMPRD.lsnr' on 'db01'

CRS-2676: Start of 'ora.ons' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.scan3.vip' on 'db01'

CRS-2672: Attempting to start 'ora.scan2.vip' on 'db01'

CRS-2676: Start of 'ora.LISTENER_OMPRD.lsnr' on 'db01' succeeded

CRS-2676: Start of 'ora.LISTENER.lsnr' on 'db01' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'db01' succeeded

CRS-2676: Start of 'ora.scan3.vip' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'db01'

CRS-2676: Start of 'ora.scan2.vip' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'db01'

CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'db01' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'db01' succeeded

CRS-2672: Attempting to start 'ora.omprd.db' on 'db01'

CRS-2676: Start of 'ora.omprd.db' on 'db01' succeeded

CRS-6016: Resource auto-start has completed for server db01

CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources

CRS-4123: Oracle High Availability Services has been started.

Oracle Clusterware active version on the cluster is [12.1.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].

Node2

root @ db02.oasiserp.com/prod01/oracle/12.1.0/12.1.0/grid/crs/install >perl rootcrs.pl -patch

Using configuration parameter file: ./crsconfig_params
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'db02'
CRS-2672: Attempting to start 'ora.evmd' on 'db02'
CRS-2676: Start of 'ora.evmd' on 'db02' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'db02'
CRS-2676: Start of 'ora.gpnpd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'db02'
CRS-2676: Start of 'ora.gipcd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db02'
CRS-2676: Start of 'ora.cssdmonitor' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'db02'
CRS-2672: Attempting to start 'ora.diskmon' on 'db02'
CRS-2676: Start of 'ora.diskmon' on 'db02' succeeded
CRS-2789: Cannot stop resource 'ora.diskmon' as it is not running on server 'db02'
CRS-2676: Start of 'ora.cssd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'db02'
CRS-2672: Attempting to start 'ora.ctssd' on 'db02'
CRS-2676: Start of 'ora.ctssd' on 'db02' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'db02'
CRS-2676: Start of 'ora.asm' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'db02'
CRS-2676: Start of 'ora.storage' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'db02'
CRS-2676: Start of 'ora.crsd' on 'db02' succeeded
CRS-6017: Processing resource auto-start for servers: db02
CRS-2672: Attempting to start 'ora.ons' on 'db02'
CRS-2673: Attempting to stop 'ora.db02.vip' on 'db01'
CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'db02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'db01'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'db01'
CRS-2677: Stop of 'ora.db02.vip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.db02.vip' on 'db02'
CRS-2677: Stop of 'ora.scan1.vip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'db02'
CRS-2676: Start of 'ora.db02.vip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'db02'
CRS-2672: Attempting to start 'ora.LISTENER_OMPRD.lsnr' on 'db02'
CRS-2676: Start of 'ora.scan1.vip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'db02'
CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'db02' succeeded
CRS-2676: Start of 'ora.ons' on 'db02' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'db02' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'db02'
CRS-2676: Start of 'ora.LISTENER_OMPRD.lsnr' on 'db02' succeeded
CRS-2676: Start of 'ora.asm' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.omprd.db' on 'db02'
CRS-2676: Start of 'ora.omprd.db' on 'db02' succeeded
CRS-6016: Resource auto-start has completed for server db02
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
Oracle Clusterware active version on the cluster is [12.1.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].
Step 4

check the cluster now all the services should be up automatically
root @ db01/prod01/oracle/12.1.0/12.1.0/grid/bin >./crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host

----------------------------------------------------------------------

ora....SM.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    db01

ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    db01

ora.FLASH.dg   ora....up.type 0/5    0/     ONLINE    ONLINE    db01

ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    db01

ora....RD.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    db01

ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    db02

ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    db01

ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    db01

ora.asm        ora.asm.type   0/5    0/0    ONLINE    ONLINE    db01

ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    db01

ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    db01

ora....01.lsnr application    0/5    0/0    ONLINE    ONLINE    db01

ora....01.lsnr application    0/5    0/0    ONLINE    ONLINE    db01

ora.db01.ons   application    0/3    0/0    ONLINE    ONLINE    db01

ora.db01.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    db01

ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    db02

ora....02.lsnr application    0/5    0/0    ONLINE    ONLINE    db02

ora....02.lsnr application    0/5    0/0    ONLINE    ONLINE    db02

ora.db02.ons   application    0/3    0/0    ONLINE    ONLINE    db02

ora.db02.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    db02

ora.gns        ora.gns.type   0/5    0/0    ONLINE    ONLINE    db01

ora.gns.vip    ora....ip.type 0/0    0/0    ONLINE    ONLINE    db01

ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    db01

ora.oc4j       ora.oc4j.type  0/1    0/2    OFFLINE   OFFLINE

ora.omprd.db   ora....se.type 0/2    0/1    ONLINE    ONLINE    db01

ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    db01

ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    db02

ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    db01

ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    db01

Creating RCU for ADF Development

Creating the Rcu for ADF development 

Once the ADF Development  had  been installed then we can start the RCU  for the database
before start configuration of the domain .. The RCU will create the seeded schema which will be used for the different services of the middleware

We had used 12c database with the Oracle Linux six for this Practice 

Step 1
Navigate to the middle ware home and from the oracle_common and bin and start the rcu

Step 2
Click next to proceed to the next page

Step 3

There are three options which gives more flexibility for a person to run

[1]system load and product load   only run by the user who has the dba privileges

[2]Prepare Scripts for System Load -- it will create the script which contains all the schema  we need to provide the script to the person who has the sysdba privileges and execute the script

once the system load is done by the dba then the non dba can run the product load  

in this practice we are selecting the system Load and Product load

Step 4

Provide the database credentials for

Legends

Host name :Host name of the database Server

Port           :Database Port Number

Service Name: Database Service name

User name   : SYS

Password    :SYS password for the database [while creating the database for the adf create the orapw<instance_name> password for the sys] to connect remotely 

Role             :SYSDBA

Once  the database details are provide the prerequisite check start it process and all the prerequisite check is successful click ok to proceed 

Step 5

Select the necessary components which is need to be installed 

Step 6

Provide the password for sachems which is newly created 

Step 7

Step 8

Click the Create Button to Create the Schema for the Database

Installing Weblogic 12c on Linux 6

Installing Weblogic 12c Server on Linux 6

In this Practice we are going to install the weblogic server 12c in the oracle Linux 6.4 we had gone through the steps which will install the binary and later we need to create the Domain separately --

Prerequisites for installing webogic 12c on linux 6 

[1] Installing the required Java
Download the latest java which is certified to work with the webloigc 12c java 1.7_60 [which is the latest update of java 7 series] is certified to work with the 12c.. . For Linux the java 1.7 is available in the rpm as well as in the tar file .. Download the rpm and install the java
Download the JDK for linux for the oracle website
http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

[root@omoicfin ~]# cd /tmp
[root@omoicfin tmp]# ll jdk*
-rw-r-----. 1 root root 126841508 Jun 24 21:36 jdk-7u60-linux-x64.rpm
[root@omoicfin tmp]# yum install /tmp/jdk-7u60-linux-x64.rpm

Once the java is installed then it will be available in the
[root@omoicfin java-1.7.0]# pwd
/usr/lib/java-1.7.0

[2]Create the user and groups for the weblogic in O/S

Create the weblogic owner  and the group as we had created the database user name and group previously for the weblogic user use the same primary group which is used for the database

[root@omoicfin ]# useradd -g oinstall -G oinstall , dba oraadf

[root@omoicfin ]# id oraadf
uid=54322(oraadf) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

In O/s we have create the mount point /u02/app/oracle for install the weblogic server

Assign the newly create the weblogic user to own the mount point which the weblogic is going to be installed 

[root@omoicfin ]# chown -R oraadf:oinstall /u02/app/oracle

[root@omoicfin ]# chmod -R g+w /u02/app/oracle

[3]Set the Java Home to the latest Java Installed 

We need to Set the java home to the latest java which is installed  or the defalut java which comes with the OEL will be taken
[root@omoicfin java-1.7.0]# java -version
java version "1.7.0_09-icedtea"
OpenJDK Runtime Environment (rhel-2.3.4.1.0.1.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode)

For setting the correct java for the weblogic add the JAVA_HOME env variable in the adfuser .bash_profile

export JAVA_HOME=/usr/java/jdk1.7.0_60

export PATH=$JAVA_HOME/bin:$PATH

log out and login and check the java version 

[oraadf@omoicfin ~]$ java -version

java version "1.7.0_60"

Java(TM) SE Runtime Environment (build 1.7.0_60-b19)

Java HotSpot(TM) 64-Bit Server VM (build 24.60-b09, mixed mode)

[oraadf@omoicfin ~]$

Step 1 
Start the Weblogic installer in the Linux by using the java which had been installed  according to the weblogic server requirements
login to the weblogic owner [o/s user which is created  for weblogic]and execute the command
java -jar  wls_121200.jar 

Invoke the Weblogic installer in the Linux 

This command will invoke the weblogic installer

Click Next to proceed to the Next Page

Step 2
Provide the Oracle Middle ware location home  where the s binaries will be installed

Step 3

Select the Installation type which we need to install if you want to proceed with the complete installation with the examples then select complete

 Step 4
Check the prerequisite check and make sure the prerequisite check completes successfully

Step 5
If the Server is connected with the internet then provide the metalink details

 Step 6
Check the installation summary and save the configuration file for the reference

Step 7
Check the installation progress and once the installation Process reaches  100% and then click next

 Step 8

Once  the Installation completes then if you want to go the configuration wizard then click the check box and click the finish button it will  take to the configuration screen or you can use the configh .sh  for configuration of the domains

The weblogic Binaries had been installed successfully .. next step is to proceed to the Domain configuration 

Converting 12c ASM to Flex ASM

Converting ASM to 12c FLEX ASM 

Converting the 12c non flex ASM to flex ASM
In this practice we had upgraded the 11gr2 grid to the 12c ..we can do the upgraed from 11g to 12c with the traditional asm and  once the upgrade is complete then we can convert the non flex asm to flex asm.
[Note] Once the ASM converted to flex ASM  then we cant convert back to the traditional ASM
 In 12c Both the asm types of asm are supported
As with out flex asm like the traditional asm we can run one asm instance in each RAC nodes ..  when we use the flex asm  the asm instance will be running in one node [or cordiality  which is set by us]
Here there are two different concepts introduced in the 12c.. Flex cluster's and Flex ASM both are different components  of  12c we can have flex asm with out flex cluster .. but enabling the flex cluster we need to have the flex asm enabled
The advantage of the flex ASM  we can separately have one instance for ASM and then it will communicate with all the RAC nodes and treat them as the client .. not like the traditional ASM that it is mandatory to have one asm instance running in all the RAC nodes
In this practice we have two cluster nodes running with the two asm instance .. once we finish the conversion we have one asm instance communication with the two database instance

Step 1
check the Mode of the ASM in the  12c
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N        1024   4096  4194304    819136   167912                0          167912              0             Y  DATA/
MOUNTED  EXTERN  N        1024   4096  4194304    511968   324560                0          324560              0             N  FLASH/

ASMCMD> showclustermode

ASM cluster : Flex mode disabled

ASMCMD>

oragrid @ db01/home/oragrid >asmcmd showclustermode
ASM cluster : Flex mode disabled

Step 2
Check the current ASM details before starting the conversion 

oragrid @ db01/home/oragrid >srvctl status asm -detail
ASM is running on db02,db01

ASM is enabled.

root @ db02/prod01/oracle/12.1.0/12.1.0/grid/bin >./srvctl status asm -detail
ASM is running on db02,db01

ASM is enabled.

oragrid @ db01/home/oragrid >srvctl config asm

ASM home: /prod01/oracle/12.1.0/12.1.0/grid

Password file:

ASM listener: LISTENER

oragrid @ db02./home/oragrid >srvctl config asm

ASM home: /prod01/oracle/12.1.0/12.1.0/grid

Password file:

ASM listener: LISTENER

Run the below query to find the attached ASM in each Node of the RAC 

SQL> SELECT instance_name, db_name, status FROM V$ASM_CLIENT;

INSTANCE_NAME                                                    DB_NAME  STATUS

---------------------------------------------------------------- -------- ------------

+ASM1                                                              +ASM       CONNECTED

OMPRD1                                                           OMPRD    CONNECTED

OMPRD1                                                           OMPRD    CONNECTED

SQL> SELECT instance_name, db_name, status FROM V$ASM_CLIENT;

INSTANCE_NAME                                                    DB_NAME  STATUS

---------------------------------------------------------------- -------- ------------

+ASM2                                                              +ASM     CONNECTED

OMPRD2                                                           OMPRD    CONNECTED

OMPRD2                                                           OMPRD    CONNECTED

Step 3

Changing compatibility mode of the ASM

Before starting the conversion of the asm to flex asm we need to Change the compatibility mode of the disk group to the 12 to enable the new features of the 12c 

Go to the Disk group tab through the asmca and select the disk group which we need to change the compatibility and select the edit attributes 

we can change the compatibility in two methods by using the asmca and by using the command line 

check the asm compatibility ASM the database compatibility  of the 12 c.. the default value will be displayed in the screen we need to update to the necessary values 

Query also to check the compatibility values of the asm diskgroup

SQL> SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,

     substr(database_compatibility,1,12) AS db_compat FROM V$ASM_DISKGROUP;

DISKGROUP                      ASM_COMPAT   DB_COMPAT

------------------------------ ------------ ------------

FLASH                          11.2.0.0.0   10.1.0.0.0

DATA                           11.2.0.0.0   10.1.0.0.0

Query to check the ASM disk group attributes 

SQL> SELECT SUBSTR(dg.name,1,12) AS diskgroup, SUBSTR(a.name,1,24) AS name,

  2       SUBSTR(a.value,1,24) AS value, read_only FROM V$ASM_DISKGROUP dg,

  3       V$ASM_ATTRIBUTE a WHERE dg.name = 'DATA' AND dg.group_number = a.group_number

  4       AND a.name NOT LIKE '%template%';

DISKGROUP    NAME                     VALUE                    READ_ON

------------ ------------------------ ------------------------ -------

DATA         disk_repair_time                       3.6h                       N

DATA         au_size                                     4194304                Y

DATA         access_control.umask               066                        N

DATA         access_control.enabled             FALSE                   N

DATA         cell.smart_scan_capable            FALSE                   N

DATA         compatible.rdbms                     10.1.0.0.0                N

DATA         compatible.asm                         11.2.0.0.0               N

DATA         sector_size                                1024                       Y

8 rows selected.

SQL>SELECT SUBSTR(dg.name,1,12) AS diskgroup, SUBSTR(a.name,1,24) AS name,   

  2       SUBSTR(a.value,1,24) AS value, read_only FROM V$ASM_DISKGROUP dg,

  3       V$ASM_ATTRIBUTE a WHERE dg.name = 'FLASH' AND dg.group_number = a.group_number

  4       AND a.name NOT LIKE '%template%';

DISKGROUP    NAME                     VALUE                    READ_ON

------------ ------------------------ ------------------------ -------

FLASH        disk_repair_time         3.6h                     N

FLASH        access_control.enabled   FALSE                    N

FLASH        cell.smart_scan_capable  FALSE                    N

FLASH        compatible.rdbms         10.1.0.0.0               N

FLASH        compatible.asm           11.2.0.0.0               N

FLASH        sector_size              1024                     Y

FLASH        au_size                  4194304                  Y

FLASH        access_control.umask     066                      N

8 rows selected.

change the compatibility version to the 12.1.0.0.0 in the asm compatibility column  and click ok to save the new value for the disk group 

once we are changing the compatibility mode in the asm then we can degrade the compatibility mode .. make sure that all the clients which is using the disk group is accessing by the 12.1 asm

In the manual command lime method we can give the below command with the appropriate attribute to change the value  

as we had already change the DATA disk group attribute by using the asmca now for the FLASH we can change by using the command line

SQL> ALTER DISKGROUP FLASH SET ATTRIBUTE 'compatible.asm' = '12.1';

Diskgroup altered.

SQL>  SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,

     substr(database_compatibility,1,12) AS db_compat FROM V$ASM_DISKGROUP;  2

DISKGROUP                      ASM_COMPAT   DB_COMPAT

------------------------------ ------------ ------------

FLASH                          12.1.0.0.0   10.1.0.0.0

DATA                           12.1.0.0.0   10.1.0.0.0

check the spfile is placed in the disk group before starting the conversion 

SQL> show parameter spfile

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      +DATA/ommprod-cluster/asmparam

                                                 eterfile/registry.253.828933955

Step 4

Converting non flex asm to flex asm

start the asmca and check the asm instance page which has the information about the number for asm instance which is currently available in the cluster  

Step 5

clink the convert to oracle flex asm  a new pop up window will display the lan interconnects which can be used  for the  flex asm 

Select appropriate lan interconnect which had been configured as the cluster interconnect ip and verify the asm listener port the default port is 1521 and if needed we can change the port  

Step 6

Create the password file for the ASM  instance .. as the new feature of the 12c now the password files can be kept  in the disk groups in common so the asm clients can access the ASM 

we can create the new password file are we can use the existing password file as the input file and create the new password file in the disk group  which can be accessed by all asm clients 

Step 7

Moving the ASM password file into the Disk group 

orapwd input_file='/prod01/oracle/12.1.0/12.1.0/grid/dbs/orapwASM' file='+DATA/ASM/orapw+ASM' asm=y

oragrid @ db01/prod01/oracle/12.1.0/12.1.0/grid/dbs >0/grid/dbs/orapw+ASM' file='+DATA/ASM/orapw+ASM' asm=y                                      <
/usr/lib/hpux64/dld.so: Unable to find library 'libocrb12.so'.
Killed

Set the  LD_LIBRARY_PATH to access the particular library .. this error is caused due to the environment variable set up

oragrid @ db01/prod01/oracle/12.1.0/12.1.0/grid/lib >ll libocrb12.so

-rw-r--r--   1 root       oinstall   3808144 Dec 18  2013 libocrb12.so

set the LD_LIBRARY_PATH to $ORACLE_HOME/lib  or GRID_HOME/lib according to the home env variable  and try the command

If the compatibility Mode is not set as per Step 3 then this error occurs  .. when we upgrade the asm the default compatibility  of the ASM is set to the version before the upgrade we need to change the version to the 12.1 to enable the flex asm

oragrid @ db01/home/oragrid >orapwd input_file='/prod01/oracle/12.1.0/12.1.0/grid/dbs/orapw+ASM' file='+DATA/ASM/orapwASM' asm=y

OPW-00010: Could not create the password file.

ORA-15056: additional error message

ORA-15221: ASM operation requires compatible.asm of 12.1.0.0.0 or higher

ORA-06512: at line 4

All the ASM disk groups should be set to  the compatible mode to 12.1.0.0.0 the default compatible mode for the ASM is 11.2.0.0 we need to change the compatible mode to 12 as the password file can be store in the disk group was introduced in 12  

follow the previous steps  in Step 3 to change the comparability mode for the disk groups before moving the password file 

Create a new directory named ASM in the disk group which is going to store the password file 

oragrid @ db01/home/oragrid >asmcmd

ASMCMD> cd DATA

ASMCMD> ls

OMPRD/

ommprod-cluster/

spfileomprd.ora

ASMCMD> mkdir ASM

ASMCMD> ls

ASM/

OMPRD/

ommprod-cluster/

spfileomprd.ora

ASMCMD> exit

oragrid @ db01/home/oragrid >orapwd input_file='/prod01/oracle/12.1.0/12.1.0/grid/dbs/orapw+ASM' file='+DATA/ASM/orapwASM' asm=y

oragrid @ db01/home/oragrid >

check the newly create  password file by using the asmcmd

ASMCMD> ls -lt

Type      Redund  Striped  Time             Sys  Name

                                            Y    PASSWORD/

PASSWORD  UNPROT  COARSE   JUN 17 16:00:00  N    orapwasm => +DATA/ASM/PASSWORD/pwdasm.362.850494523

Now we can retry the conversion process to convert the asm to the Flex ASM
Once the password file is moved to the Disk group then we can resume the conversion of the ASM 

 

Step 8

Running the converttoFlexASM.sh script 

oragrid @ db01/prod01/oracle/12.1.0/oragrid/cfgtoollogs/asmca/scripts >ll
total 2
-rwxr-xr-x   1 oragrid    oinstall       530 Jun 17 16:39 converttoFlexASM.sh
oragrid @ db01/prod01/oracle/12.1.0/oragrid/cfgtoollogs/asmca/scripts >

Running the converttoFlexASM.sh script 

root @ db01.oasiserp.com/prod01/oracle/12.1.0/12.1.0/grid/bin >cd /prod01/oracle/12.1.0/oragrid/cfgtoollogs/asmca/scripts
root @ db01.oasiserp.com/prod01/oracle/12.1.0/oragrid/cfgtoollogs/asmca/scripts >./converttoFlexASM.sh
CRS-2673: Attempting to stop 'ora.crsd' on 'db01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'db01'
CRS-2673: Attempting to stop 'ora.omprd.db' on 'db01'
CRS-2673: Attempting to stop 'ora.LISTENER_OMPRD.lsnr' on 'db01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'db01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'db01'
CRS-2677: Stop of 'ora.LISTENER_OMPRD.lsnr' on 'db01' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.db01.vip' on 'db01'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'db01'
CRS-2677: Stop of 'ora.omprd.db' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'db01'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'db01'
CRS-2677: Stop of 'ora.DATA.dg' on 'db01' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db01'
CRS-2677: Stop of 'ora.asm' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'db01'
CRS-2677: Stop of 'ora.scan1.vip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'db02'
CRS-2677: Stop of 'ora.db01.vip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.db01.vip' on 'db02'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'db01' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'db02'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'db02' succeeded
CRS-2676: Start of 'ora.db01.vip' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'db01'
CRS-2677: Stop of 'ora.ons' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'db01'
CRS-2677: Stop of 'ora.net1.network' on 'db01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db01' has completed
CRS-2677: Stop of 'ora.crsd' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'db01'
CRS-2673: Attempting to stop 'ora.evmd' on 'db01'
CRS-2673: Attempting to stop 'ora.storage' on 'db01'
CRS-2677: Stop of 'ora.storage' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db01'
CRS-2677: Stop of 'ora.ctssd' on 'db01' succeeded
CRS-2677: Stop of 'ora.asm' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'db01'
CRS-2677: Stop of 'ora.evmd' on 'db01' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'db01'
CRS-2677: Stop of 'ora.cssd' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'db01'
CRS-2676: Start of 'ora.evmd' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db01'
CRS-2676: Start of 'ora.cssdmonitor' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'db01'
CRS-2672: Attempting to start 'ora.diskmon' on 'db01'
CRS-2676: Start of 'ora.diskmon' on 'db01' succeeded
CRS-2676: Start of 'ora.cssd' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'db01'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'db01'
CRS-2676: Start of 'ora.ctssd' on 'db01' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'db01'
CRS-2676: Start of 'ora.asm' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'db01'
CRS-2676: Start of 'ora.storage' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'db01'
CRS-2676: Start of 'ora.crsd' on 'db01' succeeded
Cluster bounced in node db01
CRS-2673: Attempting to stop 'ora.crsd' on 'db02'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'db02'
CRS-2673: Attempting to stop 'ora.LISTENER_OMPRD.lsnr' on 'db02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'db02'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'db02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'db02'
CRS-2673: Attempting to stop 'ora.cvu' on 'db02'
CRS-2677: Stop of 'ora.LISTENER_OMPRD.lsnr' on 'db02' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'db02'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'db02' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'db02'
CRS-2677: Stop of 'ora.scan3.vip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'db01'
CRS-2677: Stop of 'ora.scan2.vip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'db01'
CRS-2676: Start of 'ora.scan3.vip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'db01'
CRS-2676: Start of 'ora.scan2.vip' on 'db01' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'db01'
CRS-2673: Attempting to stop 'ora.omprd.db' on 'db02'
CRS-2673: Attempting to stop 'ora.db02.vip' on 'db02'
CRS-2677: Stop of 'ora.db02.vip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.db02.vip' on 'db01'
CRS-2677: Stop of 'ora.omprd.db' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'db02'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'db02'
CRS-2677: Stop of 'ora.DATA.dg' on 'db02' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'db01' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db02'
CRS-2677: Stop of 'ora.asm' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'db02'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'db01' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'db02' succeeded
CRS-2676: Start of 'ora.db02.vip' on 'db01' succeeded
CRS-2677: Stop of 'ora.cvu' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'db01'
CRS-2676: Start of 'ora.cvu' on 'db01' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'db02'
CRS-2677: Stop of 'ora.ons' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'db02'
CRS-2677: Stop of 'ora.net1.network' on 'db02' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db02' has completed
CRS-2677: Stop of 'ora.crsd' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'db02'
CRS-2673: Attempting to stop 'ora.evmd' on 'db02'
CRS-2673: Attempting to stop 'ora.storage' on 'db02'
CRS-2677: Stop of 'ora.storage' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db02'
CRS-2677: Stop of 'ora.ctssd' on 'db02' succeeded
CRS-2677: Stop of 'ora.asm' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'db02'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'db02' succeeded
CRS-2677: Stop of 'ora.evmd' on 'db02' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'db02'
CRS-2677: Stop of 'ora.cssd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'db02'
CRS-2676: Start of 'ora.evmd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'db02'
CRS-2676: Start of 'ora.cssdmonitor' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'db02'
CRS-2672: Attempting to start 'ora.diskmon' on 'db02'
CRS-2676: Start of 'ora.diskmon' on 'db02' succeeded
CRS-2676: Start of 'ora.cssd' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'db02'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'db02'
CRS-2676: Start of 'ora.ctssd' on 'db02' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'db02'
CRS-2676: Start of 'ora.asm' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'db02'
CRS-2676: Start of 'ora.storage' on 'db02' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'db02'
CRS-2676: Start of 'ora.crsd' on 'db02' succeeded
Cluster bounced in node db02
root @ db01.oasiserp.com/prod01/oracle/12.1.0/oragrid/cfgtoollogs/asmca/scripts >
Once the script is completed  then  once stop the cluster in all the nodes and start the cluster   we need to do this step because some time while bouncing the cluster there may be one or two proces which remains as zombi process .. so once you shutdown all the cluster . and check and conform no process exists from previous session and then start the cluster

Step 8 

Changing the cardinality of the FLEX ASM

we can set the cardinality of the asm according to the number of nodes
For two nodes  we  set the cardinality as one so asm will be running in one instance  and all the database instance will be communications with this asm instance
oragrid @ db01/home/oragrid >srvctl modify asm -count 1

oragrid @ db01home/oragrid >srvctl config asm
ASM home: /prod01/oracle/12.1.0/12.1.0/grid
Password file: +DATA/ASM/orapwasm
ASM listener: LISTENER
ASM instance count: 1
Cluster ASM listener: ASMNET1LSNR_ASM
oragrid @ db01.oasiserp.com/home/oragrid >

Query's to check the client connections in the FLEX ASM





SQL> SELECT instance_name, db_name, status FROM V$ASM_CLIENT;

INSTANCE_NAME                                                    DB_NAME  STATUS
---------------------------------------------------------------- -------- ------------
+ASM1                                                            +ASM     CONNECTED
OMPRD1                                                           OMPRD    CONNECTED
OMPRD1                                                           OMPRD    CONNECTED
OMPRD2                                                           OMPRD    CONNECTED
OMPRD2                                                           OMPRD    CONNECTED

SQL>

SQL>  select group_number,instance_name,status from gv$asm_client where DB_NAME='+ASM';

GROUP_NUMBER INSTANCE_NAME                                                    STATUS
------------ ---------------------------------------------------------------- ------------
           1 +ASM1                                                            CONNECTED


SQL> select distinct i.instance_name asm_instance_name, c.instance_name client_instance_name, c.db_name, c.status from gv$instance i, gv$asm_client c where i.inst_id=c.inst_id;

ASM_INSTANCE_NAM CLIENT_INSTANCE_NAME                                             DB_NAME  STATUS
---------------- ---------------------------------------------------------------- -------- ------------
+ASM1            +ASM1                                                            +ASM     CONNECTED
+ASM1            OMPRD1                                                           OMPRD    CONNECTED
+ASM1            OMPRD2                                                           OMPRD    CONNECTED


oragrid @ db01/home/oragrid >asmcmd lsct data
DB_Name  Status     Software_Version  Compatible_version  Instance_Name  Disk_Group
+ASM     CONNECTED        12.1.0.1.0          12.1.0.1.0  +ASM1          DATA
OMPRD    CONNECTED        12.1.0.1.0          11.2.0.0.0  OMPRD1         DATA
OMPRD    CONNECTED        12.1.0.1.0          11.2.0.0.0  OMPRD2         DATA


oragrid @ db01/home/oragrid >asmcmd lsct flash
DB_Name  Status     Software_Version  Compatible_version  Instance_Name  Disk_Group
OMPRD    CONNECTED        12.1.0.1.0          11.2.0.0.0  OMPRD1         FLASH
OMPRD    CONNECTED        12.1.0.1.0          11.2.0.0.0  OMPRD2         FLASH

SQL> select INST_ID,GROUP_NUMBER, INSTANCE_NAME, DB_NAME, INSTANCE_NAME||':'||DB_NAME client_id,
STATUS from gv$asm_client where DB_NAME = 'OMPRD';  2

   INST_ID GROUP_NUMBER INSTANCE_NAME        DB_NAME  CLIENT_ID                                                                 STATUS
---------- ------------ -------------------- -------- ------------------------------------------------------------------------- ------------
         1            1 OMPRD1               OMPRD    OMPRD1:OMPRD                                                              CONNECTED
         1            2 OMPRD1               OMPRD    OMPRD1:OMPRD                                                              CONNECTED
         1            1 OMPRD2               OMPRD    OMPRD2:OMPRD                                                              CONNECTED
         1            2 OMPRD2               OMPRD    OMPRD2:OMPRD                                                              CONNECTED

SQL> select INSTANCE_NUMBER,INSTANCE_NAME,STATUS, HOST_NAME from v$instance;

INSTANCE_NUMBER INSTANCE_NAME        STATUS       HOST_NAME
--------------- -------------------- ------------ ----------------------------------------------------------------
              1 +ASM1                STARTED      db01<domain>.com


IN this Above Practice we have converted  the flex ASM with out flex Cluster ..

FLEX ASM with out Flex Cluster

It is not mandatory to change the cluster to flex cluster  for converting the asm to flex asm with the standard cluster  oracle Flex asm can be used 

Note:-once you have converted the non flex asm to flex asm then you cant go back normal asm
          For enabling the flex cluster it is mandatory that ASM should be in FLEX ASM
          we can run the Flex ASM with out flex cluster

Installing 12c Enterprise manager

Installation of 11g database with EM 

Step 1: Install the 11g database with software-only installation mode 

The the 11.2.3.3 database as the software only installation and later we can configure the database with the Seeded Template  

Step 2: Prepare the EM and DBCA  templates. 

oracle @ tstapps/u04/seaded_templete >cd /u02/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates

oracle @ tstapps/u02/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates >unzip /u04/seaded_templete/11.2.0.3_Database_Template_for_EM12_1_0_4_HPI.zip

Archive:  /u04/seaded_templete/11.2.0.3_Database_Template_for_EM12_1_0_4_HPI.zip

  inflating: set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Large_deployment.sql

  inflating: set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Medium_deployment.sql

  inflating: set_repo_param_11.2.0.3_Database_SQL_for_EM12_1_0_4_Small_deployment.sql

  inflating: shpool_11.2.0.3_Database_SQL_for_EM12_1_0_4.sql

  inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4_Large_deployment.dbc

  inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4_Medium_deployment.dbc

  inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4_Small_deployment.dbc

  inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4.dfb

  inflating: 11.2.0.3_Database_Template_for_EM12_1_0_4.ctl

oracle @ tstapps/u02/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates >

Step 3: Configure the database with the Dbca according to the number of users accessing the system

Once the database is create Configure  the Listener and tns to connect the database from the weblogic ..

Step 4
Install the Enterprise Manager 12c

oraem @ tstapps/u04/apps/oracle/fmw/oms/sysman/jlib >/opt/java6/bin/java -jar emclikit.jar client -install_dir=/u04/apps/oracle/fmw/EMCLI

Oracle Enterprise Manager 12c Release 4.
Copyright (c) 2012, 2014 Oracle Corporation.  All rights reserved.

EM CLI client-side install completed successfully.
Execute "emcli help setup" from the EM CLI home (the directory where you have installed EM CLI) for further instructions.
oraem @ tstapps/u04/apps/oracle/fmw/oms/sysman/jlib >

oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >./emcli setup -dir=/u04/apps/oracle/fmw/EMCLI/SETUP -url=https://tstapps.domainname.com:7799/em -user=SYSMAN

Oracle Enterprise Manager 12c Release 4.
Copyright (c) 1996, 2014 Oracle Corporation and/or its affiliates. All rights reserved.

Enter password


Warning: This certificate has not been identified as trusted in the local trust store
--------------------------------------
[
[
  Version: V3
  Subject: CN=tstapps.domainname.com, C=US, ST=CA, L=EnterpriseManager on tstapps.domainname.com, OU=EnterpriseManager on tstapps.domainname.com, O=EnterpriseManager on tstapps.domainname.com
  Signature Algorithm: SHA512withRSA, OID = 1.2.840.113549.1.1.13

  Key:  Sun RSA public key, 1024 bits
  modulus: 109579966219704234110006406303733236725844884000059127340771572209689250936242719174746658790668592916154609818754483288673373654068813162099912669553589493650410550312841319456077872040205850853782240467090618733039915186700707052779146344294681460898430439738694891938108047902037454938505342793782908565921
  public exponent: 65537
  Validity: [From: Mon Nov 24 08:56:43 GMT+04:00 2014,
               To: Fri Nov 22 08:56:43 GMT+04:00 2024]
  Issuer: CN=tstapps.domainname.com, C=US, ST=CA, L=EnterpriseManager on tstapps.domainname.com, OU=EnterpriseManager on tstapps.domainname.com, O=EnterpriseManager on tstapps.domainname.com
  SerialNumber: [    936b5864 7a18983c]

Certificate Extensions: 2
[1]: ObjectId: 2.5.29.19 Criticality=true
BasicConstraints:[
  CA:true
  PathLen:2147483647
]

[2]: ObjectId: 2.5.29.15 Criticality=true
KeyUsage [
  DigitalSignature
  Non_repudiation
  Key_CertSign
  Crl_Sign
]

]
  Algorithm: [SHA512withRSA]
  Signature:
0000: 73 99 D2 88 AD 47 31 E9   BE EB 04 96 D7 44 79 83  s....G1......Dy.
0010: B5 E9 B0 54 3F 5E 28 72   99 31 89 0B 73 F6 FD C8  ...T?^(r.1..s...
0020: 9E 0E 8A EB 66 3A EC 72   C0 81 62 BE B6 03 4F 6A  ....f:.r..b...Oj
0030: 6B FA 6F 66 8F 6A 0E E8   B6 52 F0 90 F0 EF 6F 08  k.of.j...R....o.
0040: 52 59 D3 83 CA 7D E8 86   50 95 01 D0 67 20 D4 B1  RY......P...g ..
0050: C9 97 DC B0 FF 83 AE 44   BA 3A 0D 7E 7F 70 C9 AB  .......D.:...p..
0060: FF 9C 03 63 AE F4 55 9B   4C 74 47 60 33 1D E5 70  ...c..U.LtG`3..p
0070: 36 EC 76 F7 6B 77 17 58   6D 43 AD F2 30 EB 90 2C  6.v.kw.XmC..0..,

]
--------------------------------------
Warning: This certificate could be compromised

Warning: This certificate has not been identified as trusted in the local trust store
--------------------------------------
[
[
  Version: V3
  Subject: CN=tstapps.domainname.com
  Signature Algorithm: SHA512withRSA, OID = 1.2.840.113549.1.1.13

  Key:  Sun RSA public key, 1024 bits
  modulus: 137689552006624453421122670544003500177504583070199134715720091582560289275088846286198018337654831494888584462232334122475147426368056079752899280438831425191191457179881748757493880109752494876436285796851033866050328702804665382129465012052946985008470596755143921734083083037764194411990517826273700443501
  public exponent: 65537
  Validity: [From: Mon Nov 24 08:56:47 GMT+04:00 2014,
               To: Fri Nov 22 08:56:47 GMT+04:00 2024]
  Issuer: CN=tstapps.domainname.com, C=US, ST=CA, L=EnterpriseManager on tstapps.domainname.com, OU=EnterpriseManager on tstapps.domainname.com, O=EnterpriseManager on tstapps.domainname.com
  SerialNumber: [    0422a727 c484b252 94]

Certificate Extensions: 3
[1]: ObjectId: 2.5.29.19 Criticality=true
BasicConstraints:[
  CA:false
  PathLen: undefined
]

[2]: ObjectId: 2.5.29.15 Criticality=true
KeyUsage [
  DigitalSignature
  Non_repudiation
  Key_Encipherment
  Key_Agreement
]

[3]: ObjectId: 2.5.29.14 Criticality=false
SubjectKeyIdentifier [
KeyIdentifier [
0000: 8F FE 14 0B DB 9C 83 39   3D 17 C1 1D 05 83 BB 68  .......9=......h
0010: 46 D4 38 05                                        F.8.
]
]

]
  Algorithm: [SHA512withRSA]
  Signature:
0000: 83 0F 28 16 57 92 08 2C   C2 19 DD 4C 07 C3 28 ED  ..(.W..,...L..(.
0010: 9A 3C 78 A8 57 55 CA 26   FC EF 35 53 21 6E FF 7F  .<x.WU.&..5S!n..
0020: AC A2 74 F6 AB 29 C5 92   8B 9F 04 65 17 B9 BB A9  ..t..).....e....
0030: 50 85 9A 7D 2D 38 8C 36   E9 53 58 EA A5 FE A2 3C  P...-8.6.SX....<
0040: AF A9 6B 7A 9A 65 0D 26   4A 45 1B 43 E9 66 E4 8C  ..kz.e.&JE.C.f..
0050: 67 9B 49 73 38 B1 63 7E   6A 81 5D DB F3 78 5A 9E  g.Is8.c.j.]..xZ.
0060: 5B 1B 5B F5 C2 82 7A 39   F1 80 21 BD 06 AD C5 94  [.[...z9..!.....
0070: 5B E1 0F 15 24 5F 6A 0B   75 3B 67 6B 1E CD B2 DE  [...$_j.u;gk....

]
--------------------------------------
Do you trust the certificate chain? [yes/no] yes
Emcli setup successful
oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >
 

oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >./emcli import_update_catalog -file=/u04/apps/p9348486_112000_Generic.zip -omslocal
Processing catalog for Middleware Profiles and Gold Images
Processing update: Middleware Profiles and Gold Images - Three Fusion Middleware Provisioning Profiles with different heap size configuration
Processing catalog for Agent Software
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX Itanium
Processing catalog for Management Connector
Processing update: Management Connector -
             IBM TEC Connector - 12.1.0.3.0

Processing update: Management Connector -
             IBM TEC Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM R2 Connector - 12.1.0.3.0

Processing update: Management Connector -
             Microsoft SCOM R2 Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM preR2 Connector - 12.1.0.3.0

Processing update: Management Connector -
             Microsoft SCOM preR2 Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM 2012 Connector - 12.1.0.1.0

Processing update: Management Connector - BMC Remedy 7.6, 8.0, 8.1 Service Desk Connector - 12.1.0.3.0
Processing update: Management Connector - BMC Remedy 7.6.04 Service Desk Connector - 12.1.0.2.0
Processing update: Management Connector - BMC Remedy Change Management Connector - 12.1.0.1.0
Processing update: Management Connector -
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.3.0

Processing update: Management Connector -
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Service Manager 9 Connector - 12.1.0.1.0

Processing update: Management Connector -
             HP Service Manager 7.1 Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Service Manager 7.0 Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Operations Manager UNIX Connector - 12.1.0.3.0

Processing update: Management Connector -
             HP Operations Manager UNIX Connector - 12.1.0.2.0

Processing update: Management Connector -
             CA Service Desk Connector - 12.1.0.3.0

Processing update: Management Connector -
             CA Service Desk Connector - 12.1.0.2.0

Processing catalog for Extensibility Development Kit
Processing catalog for Plug-in
Processing update: Plug-in - Enterprise Manager for Oracle Virtual Desktop Infrastructure
Processing update: Plug-in - Enterprise Manager for Oracle Virtual Desktop Infrastructure
Processing update: Plug-in - Enterprise Manager for Oracle Utilities provides management and monitoring for the Oracle Utilities area.
Processing update: Plug-in - Application Management Pack for Oracle Utilities provides management and monitoring for the Oracle Utilities area
Processing update: Plug-in - Application Management Pack for Oracle Utilities provides management and monitoring for the Oracle Utilities area
Processing update: Plug-in - Enterprise Manager for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area.
Processing update: Plug-in - Application Management Pack for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area
Processing update: Plug-in - Application Management Pack for Oracle Enterprise Taxation and Policy Management provides management and monitoring for the Oracle Enterprise Taxation and Policy Management area
Processing update: Plug-in - Enables management capabilities for Oracle VM in Enterprise Manager.
Processing update: Plug-in - Enterprise Manager for Zero Data Loss Recovery Appliance provides comprehensive management functionality for Zero Data Loss Recovery Appliance.
Processing update: Plug-in - Enterprise Manager for Sun Ray Software
Processing update: Plug-in - Enterprise Manager for Oracle ZFS Storage Appliances
Processing update: Plug-in - Enterprise Management Plug-in for Oracle ZFS Storage Appliances
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Enterprise Manager for OUD
Processing update: Plug-in - Enterprise Manager for Oracle Key Manager
Processing update: Plug-in - Enterprise Manager for Oracle Flash Storage System
Processing update: Plug-in - Enterprise Manager for Oracle Instant Messaging Server is used for monitoring/managing the Oracle Instant Messaging Server
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Management Pack for Oracle Tuxedo 12.1.0.1.0
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Sybase ASE. Plugin provides comprehensive monitoring Sybase ASE Environments.
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Enterprise Manager for Microsoft SQL Server
Processing update: Plug-in - Enterprise Manager for DB2. Plugin provides comprehensive monitoring of DB2 environments.
Processing update: Plug-in - Enterprise Manager for Oracle TimesTen In-Memory Database
Processing update: Plug-in - Enterprise Manager for Oracle Communications enables management of Oracle Communications products
Processing update: Plug-in -
                Enterprise Manager for Pillar Axiom

Processing update: Plug-in - Enterprise Manager for PeopleSoft
Processing update: Plug-in - Enterprise Manager for PeopleSoft
Processing update: Plug-in -
    Enterprise Manager for Jdedwards EnterpriseOne consists of monitoring and management for Oracle Jdedwards EnterpriseOne system.

Processing update: Plug-in - Oracle Jdedwards EnterpriseOne Plugin consists of monitoring and management for Oracle Jdedwards EnterpriseOne system.
Processing update: Plug-in - Enterprise Manager for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing update: Plug-in - Oracle Application Management Pack for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing update: Plug-in - Oracle Application Management Pack for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing catalog for Test Data Management templates
Processing update: Test Data Management templates - Mask template Fusion Rel v1.x Combined All Family
Processing update: Test Data Management templates - Data Masking template for Oracle E-Business suite 12.1.3 (Standard Model)
Processing update: Test Data Management templates - Data Masking template for Oracle E-Business suite 12.1.3 (JG model)
Processing update: Test Data Management templates - Preparation script required for Oracle E-Business Suite masking process
Processing update: Test Data Management templates - ADM template Fusion Rel v1.x Combined All Family
Processing update: Test Data Management templates - Application Data Model Template for Oracle E-Business Suite 12.1.3(Standard Model)
Processing update: Test Data Management templates - Application Data Model Template for Oracle E-Business Suite 12.1.3(JG Model)
Processing catalog for Informational
Processing update: Informational - Announcing New and Updated Cloud Management Capabilites for Database, Infrastructure, and Testing
Processing update: Informational - Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (12.1.0.2) now available on OTN
Processing update: Informational - Enterprise Manager Cloud Control 12C white papers available now on Oracle Technology Network
Processing update: Informational - Integration of Oracle Business Intelligence (BI) Publisher 11.1.1.5.0 with Enterprise Manager Cloud Control 12.1.0.1
Processing update: Informational - Management of Oracle VM 3.1.1 now available with Oracle Enterprise Manager 12c
Processing update: Informational - Oracle Enterprise Manager Cloud Control Mobile now available for Apple iPhone
Processing catalog for Provisioning Bundle

Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.
oraem @ tstapps/u04/apps/oracle/fmw/EMCLI >