Error: Package: oracleasmlib-2.0.12-1.el7.x86_64 (/oracleasmlib-2.0.12-1.el7.x86_64)

Error

[root@oracle-rac-node1 yum]# yum install oracleasm*
Loaded plugins: langpacks, product-id, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Examining oracleasmlib-2.0.12-1.el7.x86_64.rpm: oracleasmlib-2.0.12-1.el7.x86_64
Marking oracleasmlib-2.0.12-1.el7.x86_64.rpm to be installed
Examining oracleasm-support-2.1.8-3.el7.x86_64.rpm: oracleasm-support-2.1.8-3.el7.x86_64
Marking oracleasm-support-2.1.8-3.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracleasm-support.x86_64 0:2.1.8-3.el7 will be installed
---> Package oracleasmlib.x86_64 0:2.0.12-1.el7 will be installed
--> Processing Dependency: oracleasm >= 1.0.4 for package: oracleasmlib-2.0.12-1.el7.x86_64
--> Finished Dependency Resolution
Error: Package: oracleasmlib-2.0.12-1.el7.x86_64 (/oracleasmlib-2.0.12-1.el7.x86_64)
           Requires: oracleasm >= 1.0.4
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Solution

[root@oracle-rac-node1 yum]# rpm -ivh --nodeps --force oracleasmlib-2.0.12-1.el7.x86_64.rpm
warning: oracleasmlib-2.0.12-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasmlib-2.0.12-1.el7        ################################# [100%]
[root@oracle-rac-node1 yum]# rpm -ivh --nodeps --force oracleasm-support-2.1.8-3.el7.x86_64.rpm
warning: oracleasm-support-2.1.8-3.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasm-support-2.1.8-3.el7    ################################# [100%]
Note: Forwarding request to 'systemctl enable oracleasm.service'.
ln -s '/usr/lib/systemd/system/oracleasm.service' '/etc/systemd/system/multi-user.target.wants/oracleasm.service'
[root@oracle-rac-node1 yum]#

Verify the RAC Cluster/Database Configuration Grid User

---Basic Command of Oracle RAC Cluster/Database Configuration Grid User--



1. To Check for crs, asm & rac database availability. grid $ crs_stat -t -v
2. To - Check health of CRS: grid $ crsctl check crs 3. check all the daemons from all nodes belonging to that cluster grid $ crsctl check cluster -all 4. show the running daemons grid $ crsctl stat res -init -t # /u01/app/11.2.0/grid/bin/crsctl stop crs [stops all services on the particular node where you run the command] # /u01/app/11.2.0/grid/bin/crsctl start crs [starts all services on the particular node where you run the command]

SGA parameter value change in Oracle ASM environment

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer 272M
memory_target                        big integer 272M
SQL>


$ export ORACLE_HOME=/u01/app/11.2.0/grid
$ export ORACLE_SID=+ASM1

conn as sysasm or sysdba

ALTER SYSTEM SET memory_max_target = 12G scope=spfile sid='*';
ALTER SYSTEM SET memory_target = 12G scope=spfile sid='*';

create pfile='/tmp/pfile_13122012.ora' from spfile;

Assign specific Job or Schedule to specific RAC instanace

This is very much effective and simple code for segregating resource to specific RAC instance.

BEGIN
sys.dbms_scheduler.set_attribute( name => 'JOB_NAME', attribute => 'instance_id', value =>1);
END;

BEGIN
sys.dbms_scheduler.set_attribute( name => 'PARSING_NV1GEN1_12', attribute => 'instance_id', value =>1);
END;