Monday, 30 October 2017

/usr/lib/gcc/x86_64-redhat-linux/4.4.7/32/libgcc_s.so: undefined reference to `__stack_chk_fail


Error :-
==================

/usr/lib/gcc/x86_64-redhat-linux/4.4.7/32/libgcc_s.so: undefined reference to
`__stack_chk_fail@GLIBC_2.4'
collect2: ld returned 1 exit status
make: *** [/APP/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR] Error 1
Done with link of fnd executable 'FNDLIBR' on Sat Sep 12 16:31:30 EEST 2015

Relink of module "FNDLIBR" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure. Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /APP/apps/apps_st/appl/fnd/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product 'fnd' on Sat Sep 12 16:31:30 EEST 2015


adrelink is exiting with status 1


Solution :-
================================

After installation, users must update the stub libraries in the 10.1.2 and 10.1.3 Oracle Homes using Patch 12415211.  In following the instructions below, please note that Opatch should not be used to install this patch.

Users must specifically copy the files in the patch to the specified directories as follows for the 10.1.2 Oracle Home:

$ cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.2/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so
After this is done and sourcing the APPS<CONTEXT_NAME>.env file, users should relink all 10.1.2 executables by running the $ORACLE_HOME/appsutil/clone/adlnktools.sh script and ensuring that there are now no errors in the make log file output from the script.

The instructions for the 10.1.3 Oracle Home are:

$ cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.3/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so

Tuesday, 25 July 2017

RA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]


Solution:-
========================================================

Do cancel based reocvery, and apply 'current online redolog' manually
------------

SQL>Startup mount ;

SQL>Show parameter control_files

Query 1
------------

SQL> select a.member, a.group#, b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT' ;

Note down the name of the redo log

SQL> Shutdown abort ;

Take a OS Level backup of the controlfile (This is to ensure we have a backup of current state of controlfile)

SQL> Startup mount ;
SQL> recover database using backup controlfile until cancel ;

Enter location of redo log shown as current in Query 1 when prompted for recovery

Hit Enter

SQL> Alter database open resetlogs ;

Sunday, 23 July 2017

Relink of module "adwrknew" failed. while applying patch 9239089

Error:-
=====================
Relinking executables...

An error occurred while relinking application programs.

Continue as if it were successful [No] : No
 Freeing includes hash table
Freeing fixes hash table
 Freeing basedons hash table
Freeing entities hash table

You should check the file
/u02/apps/apps/apps_st/appl/admin/PROD/log/u9239089.log

for errors.

LOG:-
=======================================================
Relink of module "adwrknew" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u02/apps/apps/apps_st/appl/ad/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product 'ad' on Mon Jul 24 08:06:18 IST 2017


adrelink is exiting with status 1

End of adrelink session
Date/time is  Mon Jul 24 08:06:18 IST 2017
**********************************************************
**********************************************************

SOLUTION:-
------------------------------------------------------------

Download the patch  12415211 and do the below following :-
========================================================================

[applmgr@apps120 stubs]$ cd /u02/apps/apps/tech_st/10.1.2
[applmgr@apps120 lib]$ cp -p -R stubs stubsORIG
[applmgr@apps120 lib]$ cd stubs
[applmgr@apps120 stubs]$ pwd
/u02/apps/apps/tech_st/10.1.2/lib/stubs

[applmgr@apps120 stubs]$ cp -rvf /u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
`/u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so' -> `./libgcc_s-2.3.2-stub.so'
[applmgr@apps120 stubs]$  ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@apps120 stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
[applmgr@apps120 stubs]$ pwd
/u02/apps/apps/tech_st/10.1.2/lib/stubs

[applmgr@apps120 stubs]$ cd /u02/apps/apps/tech_st/10.1.3
[applmgr@apps120 10.1.3]$ cd lib/stubs

[applmgr@apps120 lib]$ cp -p -R stubs stubsORIG
[applmgr@apps120 lib]$ cd stubs
[applmgr@apps120 stubs]$ cp -rvf /u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
`/u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so' -> `./libgcc_s-2.3.2-stub.so'
[applmgr@apps120 stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@apps120 stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
[applmgr@apps120 stubs]$ pwd
/u02/apps/apps/tech_st/10.1.3/lib/stubs

Then apply the Patch 9239089


Sunday, 18 June 2017

Expect command steps in bash



EXPECT COMMAND:-
======================================================================================================

[root@tlntatl14 Naveen]# cat patch.sh
Userid=naveen.janjanam@*****.com
Password=**********                      # give the password
echo "Enter the patch number:"
read Pno
expect -c "
spawn sh /u51/ar121/patch/get_MOS_patches.sh patch=$Pno
expect \"Userid:\"
send \"$Userid\r\"
expect \"Password:\"
send \"$Password\r\"
interact
"
ls -ltr *$Pno*

out:-
=============================
[root@tlntatl14 Naveen]# sh patch.sh
Enter the patch number:
24828024
spawn sh /u51/ar121/patch/get_MOS_patches.sh patch=24828024
Oracle Support Userid: naveen.janjanam@tieto.com
Oracle Support Password:

Getting patch 24828024 for "Linux x86-64"
1 - p24828024_R12.AP.C_R12_GENERIC.zip
2 - p24828024_R12.AP.B_R12_GENERIC.zip
Comma-delimited list of files to download: 2
Downloading file p24828024_R12.AP.B_R12_GENERIC.zip ...
p24828024_R12.AP.B_R12_GENERIC.zip completed with status: 0

Getting patch 24828024 for "Norwegian (N)"
no patch available
-rw-r--r-- 1 root root 63375 Oct 14  2016 p24828024_R12.AP.B_R12_GENERIC.zip_old
-rw-r--r-- 1 root root 63375 Oct 14  2016 p24828024_R12.AP.B_R12_GENERIC.zip

Tuesday, 28 March 2017

fnd_conc_clone.setup_clean vs cmclean.sql

fnd_conc_clone.setup_clean
====================
fnd_conc_clone  ===> is package
setup_clean ====> it is procedure name
When we run fnd_conc_clone.setup_clean it deletes the information from the below tables.
Delete from fnd_concurrent_queue_size
Delete from fnd_concurrent_queues_tl
Delete from fnd_concurrent_queuesDelete from fnd_nodes;

We use fnd_conc_clone.setup_clean to cleanup fnd_nodes table in the target to clear source node information as part of cloning.

below syntax to execute:
SQL> sho user
USER is "APPS"
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
First run the autoconfig on DB tier and middle tier this will regiser the nodes in fnd_nodes tables.

cmclean.sql
=========
If we stop conc manager using abort options then concurrent requests will be in running state ,Next when we start concurrent manager the processes will not start properly.
To cleanup running and pending requests we use cmclean.sql this script will update the below tables.
UPDATE fnd_concurrent_processes
UPDATE fnd_concurrent_queues
UPDATE fnd_concurrent_requests
UPDATE fnd_conflicts_domain
UPDATE fnd_concurrent_conflict_sets
Download cmclean.sql: 
=================
Concurrent Processing - cmclean.sql - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
Note: cmclean.sql and fnd_conc_clone.setup_clean touch different set of concurrent request tables.
Its better idea to run both during the clone. 

NOFILENAMECHECK Parameter Causes ?

When NOFILENAMECHECK is used with the DUPLICATE command, RMAN does not validate the filenames during restoration.

If the primary database and the standby database are on the same host, The DUPLICATE NOFILENAMECHECK option should not be used.

What really happens when you enable maintenance mode before applying patches


Maintenance mode provides a clear separation between normal runtime operation of Oracle Applications and system downtime for maintenance. Enabling the maintenance mode feature shuts down the Workflow Business Events System and sets up function security so that no Oracle Applications functions are available to users. Used only during AutoPatch sessions, maintenance mode ensures optimal performance and reduces downtime when applying a patch. For more information, refer to Preparing your System for Patching in Oracle Applications Maintenance Utilities.

You may also refer to Article ID 291901.1, which has more information about Maintenance Mode.

Monday, 27 March 2017

Workflow Notifications - "Override Email address" Functionality

Background :

      Very often on a Oracle Apps Test or Development environment, you would like all the Workflow Email notifications to be sent to one temporary email address instead of the original users to avoid confusion and to avoid filling the users mail box with Test data. Some companies will setup a temporary mail box and give access to the consultants.

Please  find the steps required to assign a temporary email address. This is much needed when testing Oracle Workflows based applications and especially time out reminder notifications.

These steps have been tried and tested on R12 environment.

Note: Please do not try these steps on Production Environment. Hopefully DBA only will have access to it :)
Steps:

Step 1 : Login to  Workflow Administrator > Oracle Applications Manager > Workflow Manager


Step 2 : Ensure that Notification Mailer is running, and then click on icon as below 


            

 Step 3 : Click on the Notification Mailer > View Details

      Step 4 : Click on "Set Override Address




Step 5 : You can enter an email ID to which you want to send all workflow Notifications and submit. (Note: you can also change it any time.)







You will receive a verification code, just enter it here and click on apply.
 You can verify the same Override Address using the below SQL:
select fscpv.parameter_value test_address
from   fnd_svc_comp_params_tl fscpt
,      fnd_svc_comp_param_vals fscpv
,      fnd_svc_components fsc
where  fscpt.parameter_id = fscpv.parameter_id
and    fscpv.component_id = fsc.component_id
and    fscpt.display_name = 'Test Address'
and    fsc.component_name = 'Workflow Notification Mailer';



TEST_ADDRESS
--------------------------------------------------------------------------------
shrikant.aughad@tieto.com

Workflow Notification Mailer Outbound SMTP Server
We can get the Outbound SMTP Server Name using the below SQL:
select fscpv.parameter_value smtp_server_name
from   fnd_svc_comp_params_tl fscpt
,      fnd_svc_comp_param_vals fscpv
,      fnd_svc_components fsc
where  fscpt.parameter_id = fscpv.parameter_id
and    fscpv.component_id = fsc.component_id
and    fscpt.display_name = 'Outbound Server Name'
and    fsc.component_name = 'Workflow Notification Mailer';

Wednesday, 15 March 2017

oracle application table spaces




Tablespace Type
Tablespace Name
Contents
Transaction Tables
APPS_TS_TX_DATA
Tables that contain transactional data.
Transaction Indexes
APPS_TS_TX_IDX
Indexes on transaction tables.
Reference
APPS_TS_SEED
Reference and setup data and indexes.
Interface
APPS_TS_INTERFACE
Interface and temporary data and indexes.
Summary
APPS_TS_SUMMARY
Summary management objects, such as materialized views, and other objects that record summary information.
Nologging
APPS_TS_NOLOGGING
Materialized views not used for summary management and temporary objects.
Advanced Queuing/AQ
APPS_TS_QUEUES
Advanced Queuing and dependent tables and indexes.
Media
APPS_TS_MEDIA
Multimedia objects, such as text, video, sound, graphics, and spatial data.
Archive
APPS_TS_ARCHIVE
Archive-purge-related objects.
Undo
UNDO
Automatic Undo Management (AUM) tablespace. UNDO segments are identical to ROLLBACK segments when AUM is enabled.
Temp
TEMP
Temporary tablespace for global temporary table, sorts, and hash joins.
System
SYSTEM
System tablespace used by the Oracle Database.


Wednesday, 1 March 2017

How to set environment file in Linux for database



[grid@racpub151 u01]$ vi grid.env

export GRID_HOME=/u01/app/12.1.0/grid

export PATH=$PATH:$GRID_HOME/bin

:wq!

Tuesday, 28 February 2017

CLSRSC-184: Configuration of ASM failed


[root@racpub151 app]# /u01/app/12.1.0/grid/root.sh

Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/12.1.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   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.
Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params
2017/02/28 17:27:09 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

2017/02/28 17:27:45 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2017/02/28 17:27:47 CLSRSC-363: User ignored prerequisites during installation

OLR initialization - successful
  root wallet
  root wallet cert
  root cert export
  peer wallet
  profile reader wallet
  pa wallet
  peer wallet keys
  pa wallet keys
  peer cert request
  pa cert request
  peer cert
  pa cert
  peer root cert TP
  profile reader root cert TP
  pa root cert TP
  peer pa cert TP
  pa peer cert TP
  profile reader pa cert TP
  profile reader peer cert TP
  peer user cert
  pa user cert
2017/02/28 17:28:43 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'

CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
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 'racpub151'
CRS-2672: Attempting to start 'ora.mdnsd' on 'racpub151'
CRS-2676: Start of 'ora.evmd' on 'racpub151' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'racpub151'
CRS-2676: Start of 'ora.gpnpd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racpub151'
CRS-2672: Attempting to start 'ora.gipcd' on 'racpub151'
CRS-2676: Start of 'ora.cssdmonitor' on 'racpub151' succeeded
CRS-2676: Start of 'ora.gipcd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racpub151'
CRS-2672: Attempting to start 'ora.diskmon' on 'racpub151'
CRS-2676: Start of 'ora.diskmon' on 'racpub151' succeeded
CRS-2676: Start of 'ora.cssd' on 'racpub151' succeeded

ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-170228PM053122.log for details.

2017/02/28 17:32:08 CLSRSC-184: Configuration of ASM failed

2017/02/28 17:32:09 CLSRSC-258: Failed to configure and start ASM

Died at /u01/app/12.1.0/grid/crs/install/crsinstall.pm line 2017.
The command '/u01/app/12.1.0/grid/perl/bin/perl -I/u01/app/12.1.0/grid/perl/lib -I/u01/app/12.1.0/grid/crs/install /u01/app/12.1.0/grid/crs/install/rootcrs.pl ' execution failed

================================
Solution:-
================================

[root@racpub151 app]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              29G  9.9G   18G  36% /
tmpfs                 751M  260K  751M   1% /dev/shm
/dev/sda2              15G  679M   14G   5% /tmp
/dev/sda5              52G  9.2G   40G  19% /u01
.host:/               466G  280G  186G  61% /mnt/hgfs
/dev/sr0              3.5G  3.5G     0 100% /media/OL6.4 x86_64 Disc 1 20130225


[root@racpub151 app]# umount /dev/shm
umount: /dev/shm: device is busy.
        (In some cases useful info about processes that use
         the device is found by lsof(8) or fuser(1))


[root@racpub151 app]# fuser -km /dev/shm
/dev/shm:             3696m  3714m  3769m  3807m

[root@racpub151 app]# umount /dev/shm

[root@racpub151 app]# vi /etc/fstab
#
# /etc/fstab
# Created by anaconda on Sun Nov  8 16:01:55 2015
#
# Accessible filesystems, by reference, are maintained under ‘/dev/disk’
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
UUID=50921d9d-11bf-46f6-815e-65bf11cd734e /                       ext4    defaults        1 1
UUID=2e531048-7ae9-4c4a-b5b9-228e0420d958 /oracle                 ext4    defaults        1 2
UUID=05fc1c47-9f9f-4525-941a-7a5b54abc261 swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults,size=3G        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0


[root@racpub151 app]# mount /dev/shm

[root@racpub151 app]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              29G  9.9G   18G  36% /
/dev/sda2              15G  679M   14G   5% /tmp
/dev/sda5              52G  9.2G   40G  19% /u01
.host:/               466G  280G  186G  61% /mnt/hgfs
/dev/sr0              3.5G  3.5G     0 100% /media/OL6.4 x86_64 Disc 1 20130225
tmpfs                 3.0G     0  3.0G   0% /dev/shm


RUN The script again:-


[root@racpub151 app]# /u01/app/12.1.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/12.1.0/grid

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.
Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params
2017/02/28 18:09:24 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

2017/02/28 18:09:25 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2017/02/28 18:09:27 CLSRSC-363: User ignored prerequisites during installation

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racpub151'
CRS-2673: Attempting to stop 'ora.ctssd' on 'racpub151'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'racpub151'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'racpub151'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'racpub151'
CRS-2677: Stop of 'ora.drivers.acfs' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'racpub151'
CRS-2677: Stop of 'ora.gpnpd' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.evmd' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racpub151'
CRS-2677: Stop of 'ora.cssd' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racpub151'
CRS-2677: Stop of 'ora.gipcd' on 'racpub151' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racpub151' 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 'racpub151'
CRS-2672: Attempting to start 'ora.mdnsd' on 'racpub151'
CRS-2676: Start of 'ora.mdnsd' on 'racpub151' succeeded
CRS-2676: Start of 'ora.evmd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'racpub151'
CRS-2676: Start of 'ora.gpnpd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racpub151'
CRS-2672: Attempting to start 'ora.gipcd' on 'racpub151'
CRS-2676: Start of 'ora.cssdmonitor' on 'racpub151' succeeded
CRS-2676: Start of 'ora.gipcd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racpub151'
CRS-2672: Attempting to start 'ora.diskmon' on 'racpub151'
CRS-2676: Start of 'ora.diskmon' on 'racpub151' succeeded
CRS-2676: Start of 'ora.cssd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'racpub151'
CRS-2672: Attempting to start 'ora.ctssd' on 'racpub151'
CRS-2676: Start of 'ora.ctssd' on 'racpub151' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racpub151'
CRS-2676: Start of 'ora.asm' on 'racpub151' succeeded

ASM created and started successfully.

Disk Group CRS created successfully.

CRS-2672: Attempting to start 'ora.crf' on 'racpub151'
CRS-2672: Attempting to start 'ora.storage' on 'racpub151'
CRS-2676: Start of 'ora.storage' on 'racpub151' succeeded
CRS-2676: Start of 'ora.crf' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racpub151'
CRS-2676: Start of 'ora.crsd' on 'racpub151' succeeded
CRS-4256: Updating the profile
Successful addition of voting disk 2c8aa82e3bac4f9bbf2802c7ca16e00d.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   2c8aa82e3bac4f9bbf2802c7ca16e00d (ORCL:CRS) [CRS]
Located 1 voting disk(s).
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racpub151'
CRS-2673: Attempting to stop 'ora.crsd' on 'racpub151'
CRS-2677: Stop of 'ora.crsd' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'racpub151'
CRS-2673: Attempting to stop 'ora.evmd' on 'racpub151'
CRS-2673: Attempting to stop 'ora.storage' on 'racpub151'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'racpub151'
CRS-2673: Attempting to stop 'ora.crf' on 'racpub151'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'racpub151'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'racpub151'
CRS-2677: Stop of 'ora.storage' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racpub151'
CRS-2677: Stop of 'ora.drivers.acfs' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.crf' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.evmd' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'racpub151' succeeded
CRS-2677: Stop of 'ora.asm' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racpub151'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racpub151'
CRS-2677: Stop of 'ora.cssd' on 'racpub151' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racpub151'
CRS-2677: Stop of 'ora.gipcd' on 'racpub151' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racpub151' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'racpub151'
CRS-2672: Attempting to start 'ora.evmd' on 'racpub151'
CRS-2676: Start of 'ora.mdnsd' on 'racpub151' succeeded
CRS-2676: Start of 'ora.evmd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'racpub151'
CRS-2676: Start of 'ora.gpnpd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'racpub151'
CRS-2676: Start of 'ora.gipcd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racpub151'
CRS-2676: Start of 'ora.cssdmonitor' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racpub151'
CRS-2672: Attempting to start 'ora.diskmon' on 'racpub151'
CRS-2676: Start of 'ora.diskmon' on 'racpub151' succeeded
CRS-2676: Start of 'ora.cssd' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'racpub151'
CRS-2672: Attempting to start 'ora.ctssd' on 'racpub151'
CRS-2676: Start of 'ora.ctssd' on 'racpub151' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racpub151'
CRS-2676: Start of 'ora.asm' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'racpub151'
CRS-2676: Start of 'ora.storage' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'racpub151'
CRS-2676: Start of 'ora.crf' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racpub151'
CRS-2676: Start of 'ora.crsd' on 'racpub151' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: racpub151
CRS-6016: Resource auto-start has completed for server racpub151
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2017/02/28 18:19:19 CLSRSC-343: Successfully started Oracle Clusterware stack

CRS-2672: Attempting to start 'ora.asm' on 'racpub151'
CRS-2676: Start of 'ora.asm' on 'racpub151' succeeded
CRS-2672: Attempting to start 'ora.CRS.dg' on 'racpub151'
CRS-2676: Start of 'ora.CRS.dg' on 'racpub151' succeeded

2017/02/28 18:23:32 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded





Sunday, 26 February 2017

ASM didk deleting

Notice the existing disk highlighted in green was removed and has become a “FORMER” disk.  You can delete the disk by running the following commands:
Cleanup ASM disk header
[root@mktg04 ~]# /etc/init.d/oracleasm deletedisk DATA

/jdk/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory



Error:-
=======================================

[grid@rac151 grid]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 8744 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4999 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-02-25_10-12-48PM. Please wait ...[grid@rac151 grid]$ Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2017-02-25_10-12-48PM/jdk/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1753)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1649)
at java.lang.Runtime.load0(Runtime.java:769)
at java.lang.System.load(System.java:968)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1753)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1670)
at java.lang.Runtime.loadLibrary0(Runtime.java:822)
at java.lang.System.loadLibrary(System.java:993)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.loadLibraries(Toolkit.java:1509)
at java.awt.Toolkit.<clinit>(Toolkit.java:1530)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)
at com.jgoodies.looks.LookUtils.<clinit>(LookUtils.java:249)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:135)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1779)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:453)
at oracle.install.commons.util.Application.startup(Application.java:780)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:165)



Solution:-
======================================================================

Download and install All Rpms below mentioned.

rpm -ivh openmotif21-2.1.30-11.EL6.i686.rpm --force  --nodeps
rpm -ivh xorg-x11-libs-6.8.2-1.EL.33.0.1.WB1.i386.rpm --force  --nodeps
rpm -ivh binutils-2.20.51.0.2-5.11.el6.i686.rpm --force  --nodeps
rpm -ivh binutils-2.20.51.0.2-5.11.el6.x86_64.rpm --force  --nodeps
rpm -ivh gcc-4.4.4-13.el6.x86_64.rpm --force  --nodeps
rpm -ivh gcc-4.4.5-6.el6.x86_64.rpm --force  --nodeps
rpm -ivh gcc-c++-4.4.4-13.el6.x86_64.rpm --force  --nodeps
rpm -ivh glibc-2.12-1.7.el6_0.5.i686.rpm --force  --nodeps
rpm -ivh glibc-2.12-1.7.el6.x86_64.rpm --force  --nodeps
rpm -ivh glibc-common-2.12-1.7.el6.x86_64.rpm --force  --nodeps
rpm -ivh glibc-devel-2.12-1.7.el6.i686.rpm --force  --nodeps
rpm -ivh glibc-devel-2.12-1.7.el6.x86_64.rpm --force  --nodeps
rpm -ivh libgcc-4.4.4-13.el6.i686.rpm --force  --nodeps
rpm -ivh libgcc-4.4.4-13.el6.x86_64.rpm --force  --nodeps
rpm -ivh libstdc++-devel-4.4.4-13.el6.i686.rpm --force  --nodeps
rpm -ivh libstdc++-devel-4.4.4-13.el6.x86_64.rpm --force  --nodeps
rpm -ivh libstdc++-4.4.4-13.el6.i686.rpm --force  --nodeps
rpm -ivh libstdc++-4.4.4-13.el6.x86_64.rpm --force  --nodeps
rpm -ivh make-3.81-19.el6.x86_64.rpm --force  --nodeps
rpm -ivh libXrender-0.9.5-1.el6.i686.rpm --force  --nodeps
rpm -ivh libXp-1.0.0-15.1.el6.x86_64.rpm --force  --nodeps
rpm -ivh libaio-0.3.107-10.el6.i686.rpm --force  --nodeps
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm --force  --nodeps
rpm -ivh libgomp-4.4.4-13.el6.x86_64.rpm --force  --nodeps
rpm -ivh sysstat-9.0.4-11.el6.x86_64.rpm --force  --nodeps
rpm -ivh util-linux-ng-2.17.2-6.el6.x86_64.rpm --force  --nodeps
rpm -ivh unzip-5.51-10.el5.src.rpm --force  --nodeps
rpm -ivh compat-libstdc++-33-3.2.3-69.el6.i686.rpm --force  --nodeps
rpm -ivh compat-libstdc++-296-2.96-144.el6.i686.rpm --force  --nodeps
rpm -ivh compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm --force  --nodeps
rpm -ivh elfutils-libelf-0.148-1.el6.x86_64.rpm --force  --nodeps
rpm -ivh kernel-uek-2.6.39-400.17.1.el6uek.x86_64.rpm --force  --nodeps
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm --force  --nodeps
rpm -ivh unixODBC-2.2.14-11.el6.i686.rpm --force  --nodeps
rpm -ivh unixODBC-2.2.14-11.el6.x86_64.rpm --force  --nodeps
rpm -ivh unixODBC-devel-2.2.14-11.el6.i686.rpm --force  --nodeps
rpm -ivh unixODBC-devel-2.2.14-11.el6.x86_64.rpm --force  --nodeps
rpm -ivh xorg-x11-utils-7.4-8.el6.x86_64.rpm --force  --nodeps

rpm -ivh un* --force --nodeps

Download and install

jdk-6u45-linux-i586-rpm.bin

#sh jdk-6u45-linux-i586-rpm.bin