Archive for March 2014

ORA-01408 such column list already indexed 11.2.0.2 to 11.2.0.4 Upgrade error   Leave a comment

During the Upgrade from 11.2.0.2 to 11.2.0.4 on OEL5.5 64-bit for EBS R12.1.3 I faced below issue

upgrade_error

 

Solution:

Ora-01408 Error Upgrading to 11g using Dbua (and manual upgrade) (Doc ID 737400.1)

1. Remove the offending index:

drop index system.REPCAT$_AUDIT_COLUMN_IDX1;

2.

2.1 -If the upgrade has finished without any other error, create the following index:

create index system.repcat$_audit_column_f2_idx
on system.repcat$_audit_column
(base_sname,base_oname,base_conflict_type_id, base_reference_name);

2.2.- If the upgrade was cancelled or more errors were reported, retry the upgrade manually (see Note 429825.1) :

$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus “/ as sysdba”
SQL> startup UPGRADE
SQL> set echo on
SQL> SPOOL upgrade.log
SQL> @catupgrd.sql
SQL> spool off

Posted March 25, 2014 by balaoracledba.com in Upgrade

Relinking phase all application program with adrelink, got failure on MSC product. Relink of module “MSCSLD” failed.   Leave a comment

OS-Linuxx64Bit

Application Version R12.1.1

DB Version 11.2.0.3

During upgrade from R12.1.1 to R12.1.3 . When i was running ATG patch 8919491, during relinking phase in patch sesseionall application program with adrelink, got failure on MSC product.

Relink of module “MSONEW” failed.
…….
Relink of module “FEMCCE” failed.
…….
Relink of module “MSRNEW” failed.
…….
Relink of module “MSCCPP” failed.
…….
Relink of module “MSCMON” failed.
…….
Relink of module “MSCNEW” failed.
…….
Relink of module “MSCNSP” failed.
………
Relink of module “MSCNSPNM” failed.
………
Relink of module “MSCPCL” failed.
………
Relink of module “MSCPDW” failed.
………
Relink of module “MSCPRG” failed.
………
Relink of module “MSCSDW” failed.
………
Relink of module “MSCSLD” failed.
………

Relinking module ‘MSCXGCAL’ in product msc …
/d01/oracle/VIS/apps/apps_st/appl/mso/12.0.0/lib/libmso.a(msopomresourcebkt.o)
collect2: ld returned 1 exit status
make: *** [/d01/oracle/VIS/apps/apps_st/appl/msc/12.0.0/bin/MSCCPP] Error 1
Done with link of msc executable ‘MSCCPP’ on Wed Mar 5 11:44:50 IST 2014

It asks us whether we want to continue patch session as Normal or else Stop

NO-Will stop the patch session and YES will allows us continue patching as if normal.

So to exit patch session type NO and once patch session ends. we have to perform below work around.

To fix this problem, we are required to replace the following line under the Linux section of file ” $AD_TOP/bin/adrelinknew.sh”:

From:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

TO:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

Posted March 5, 2014 by balaoracledba.com in OracleAppsR12, Patching

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory   4 comments

Review the HTTP log file. The error is very clear about the missing soft link. It would show this error:

<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory

cd /d01/oracle/VIS/inst/apps/VIS_r12/logs/ora/10.1.3/opmn

vi HTTP_Server~1.log
--------
14/03/04 00:54:51 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 00:54:53 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 10:22:12 Start process

To implement the solution, please execute the following steps:

1. Shut down all Oracle Application Services.

2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

3. Start up all Oracle Application Services.

Posted March 4, 2014 by balaoracledba.com in Issues