Oracle CPU patches for April-2014 released   Leave a comment

Oracle Has released CPU for April-2014 released

Here is the link

http://www.oracle.com/technetwork/topics/security/cpuapr2014-1972952.html

 

 

Posted April 16, 2014 by balaoracledba.com in Oracle DBA

Deploy Application war file on Weblogic Managed Server using python script   Leave a comment

Here i will list out the steps to deploy application using python script.

I am using weblogic version 10.3.6 on OEL5.5 OS

Please download the shoppingcart.war here.

Step1:

Create python script deploy.py

2

Step2:

Run the setDomainEnv.sh

1

Step3: Deploy the Application war as below

3

Once we execute we will see the below output

[oracle@weblogic domains]$ java weblogic.WLST deploy.py
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
*** WEBLOGIC : START ***
connecting to admin server....
Connecting to t3://weblogic.localdomain:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'base_domain'.
Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.
stopping and undeploying ....
deploying....
Deploying application from /tmp/shoppingcart.war to targets managedserv1 (upload=false) ...
<Apr 14, 2014 12:22:13 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating deploy operation for application, shoppingcart [archive: /tmp/shoppingcart.war], to managedserv1 .>
.Completed the deployment of Application with status completed
Current Status of your Deployment:
Deployment command type: deploy
Deployment State : completed
Deployment Message : [Deployer:149194]Operation 'deploy' on application 'shoppingcart' has succeeded on 'managedserv1'
Starting application shoppingcart.
<Apr 14, 2014 12:22:18 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating start operation for application, shoppingcart [archive: null], to managedserv1 .>
.Completed the start of Application with status completed
Current Status of your Deployment:
Deployment command type: start
Deployment State : completed
Deployment Message : [Deployer:149194]Operation 'start' on application 'shoppingcart' has succeeded on 'managedserv1'
disconnecting from admin server....
Disconnected from weblogic server: AdminServer

Exiting WebLogic Scripting Tool.

<Apr 14, 2014 12:22:21 PM IST> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.>
[oracle@weblogic domains]$

We can access the application using url

http://weblogic.localdomain:7003/shoppingcart

As i deployed the application on managed server and the managed server port is 7003.

4

 

Posted April 14, 2014 by balaoracledba.com in Weblogic

Install Weblogic in Silent mode using silent.xml and creating default domain server in Console mode using config.sh   Leave a comment

Hi all,

I am going to list out the steps to install weblogic in silent mode and managed server in console mode.

First install jrocket. I installed Jrocket using console mode. I used PUTTY for the installation of Jrocket and Weblogic

[oracle@weblogic tmp]$ ./jrockit-jdk1.6.0_45-R28.2.7-4.1.0-linux-x64.bin
Extracting 0%....................................................................................................100%
Unable to instantiate GUI, defaulting to console mode.
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Welcome:
--------
This installer will guide you through the installation of Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1. Type "Next" or enter to proceed to the next prompt.
If you want to change data entered previously, type "Previous". You may quit the installer at any time by typing "Exit".
Enter [Exit][Next]>
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Choose Product Installation Directory:
--------------------------------------
"Product Installation Directory" = [Enter new value or use default "/home/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0"]
Enter new Product Installation Directory OR [Exit][Previous][Next]> /d01/jrockit
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Choose Product Installation Directory:
--------------------------------------
"Product Installation Directory" = [/d01/jrockit]
Use above value or select another option:
 1 - Enter new Product Installation Directory
 2 - Change to default [/home/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0]
Enter option number to select OR [Exit][Previous][Next]> 2
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Choose Product Installation Directory:
--------------------------------------
"Product Installation Directory" = [Enter new value or use default "/home/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0"]
Enter new Product Installation Directory OR [Exit][Previous][Next]> /d01/jrockit
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Choose Product Installation Directory:
--------------------------------------
"Product Installation Directory" = [/d01/jrockit]
Use above value or select another option:
 1 - Enter new Product Installation Directory
 2 - Change to default [/home/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0]
Enter option number to select OR [Exit][Previous][Next]>
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Optional Components 1
Do you want to install Demos and Samples?
1 - Yes, install Demos and Samples.
 ->2 - No, do not install.

Enter a number or [Exit][Previous][Next]> 2
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Optional Components 2
Do you want to install Source Code?
1 - Yes, install Source Code.
 ->2 - No, do not install.
Enter a number or [Exit][Previous][Next]> 2
<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Installing JDK to /d01/jrockit...
0% 25% 50% 75% 100%
[------------|------------|------------|------------]
[***************************************************]

<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Installing JRE to /d01/jrockit/jre...
0% 25% 50% 75% 100%
[------------|------------|------------|------------]
[***************************************************]

<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Installation Complete
Congratulations! Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 has been successfully installed to /d01/jrockit.
Press [Enter] to continue or type [Exit]>


<----------------------------------------- Oracle JRockit Installer - Oracle JRockit JDK R28.2.7 for Java SE 6 with JRMC 4.1 ----------------------------------------->
Clean up process in progress ...
[oracle@weblogic bin]$ export JAVA_HOME=/d01/jrockit/
Here i am using silent.xml for installation of Weblogic in silent mode.

silent.xml contents as below:
[oracle@weblogic d01]$ cat silent.xml
<?xml version="1.0" encoding="UTF-8"?>
<bea-installer>
 <input-fields>
 <data-value name="BEAHOME" value="/d01/Oracle/middleware" />
 <data-value name="WLS_INSTALL_DIR" value="/d01/Oracle/middleware/wlserver_10.3" />
 </input-fields>
</bea-installer>
[oracle@weblogic d01]$
[oracle@weblogic bin]$ export PATH=/d01/jrockit/bin:$PATH
[oracle@weblogic bin]$
[oracle@weblogic bin]$ which java
/d01/jrockit/bin/java

cd /d01/jrockit/bin/
[oracle@weblogic bin]$ java -jar /tmp/wls1036_generic.jar -mode=silent -silent_xml=/home/oracle/silent.xml
Extracting 0%....................................................................................................100%

Once the Weblogic install is finished i am configuring weblogic using config.sh
[oracle@oel bin]$ ./config.sh mode=console
Unable to instantiate GUI, defaulting to console mode.





<------------------- Fusion Middleware Configuration Wizard ------------------>

Welcome:
--------

Choose between creating and extending a domain. Based on your selection,
the Configuration Wizard guides you through the steps to generate a new or
extend an existing domain.

 ->1|Create a new WebLogic domain
 | Create a WebLogic domain in your projects directory.

 2|Extend an existing WebLogic domain
 | Use this option to add new components to an existing domain and modify |configuration settings.





Enter index number to select OR [Exit][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Select Domain Source:
---------------------

Select the source from which the domain will be created. You can create the
domain by selecting from the required components or by selecting from a
list of existing domain templates.

 ->1|Choose Weblogic Platform components
 | You can choose the Weblogic component(s) that you want supported in
 |your domain.

 2|Choose custom template
 | Choose this option if you want to use an existing template. This
 |could be a custom created template using the Template Builder.





Enter index number to select OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Application Template Selection:
-------------------------------



 Available Templates
 |_____Basic WebLogic Server Domain - 10.3.6.0 [wlserver_10.3]x
 |_____Basic WebLogic SIP Server Domain - 10.3.6.0 [wlserver_10.3] [2]
 |_____WebLogic Advanced Web Services for JAX-RPC Extension - 10.3.6.0 [wlserver_10.3] [3]
 |_____WebLogic Advanced Web Services for JAX-WS Extension - 10.3.6.0 [wlserver_10.3] [4]



Enter number exactly as it appears in brackets to toggle selection OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Edit Domain Information:
------------------------

 | Name | Value |
 _|________|_____________|
 1| *Name: | base_domain |




Enter value for "Name" OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Select the target domain directory for this domain:
---------------------------------------------------

 "Target Location" = [Enter new value or use default
"/d01/Oracle/middleware/user_projects/domains"]




Enter new Target Location OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Configure Administrator User Name and Password:
-----------------------------------------------

Create a user to be assigned to the Administrator role. This user is the
default administrator used to start development mode servers.

 | Name | Value |
 _|_________________________|_________________________________________|
 1| *Name: | weblogic |
 2| *User password: | |
 3| *Confirm user password: | |
 4| Description: | This user is the default administrator. |

Use above value or select another option:
 1 - Modify "Name"
 2 - Modify "User password"
 3 - Modify "Confirm user password"
 4 - Modify "Description"




Enter option number to select OR [Exit][Previous][Next]> 2





<------------------- Fusion Middleware Configuration Wizard ------------------>

Configure Administrator User Name and Password:
-----------------------------------------------

Create a user to be assigned to the Administrator role. This user is the
default administrator used to start development mode servers.

 "*User password:" = []




Enter new *User password: OR [Exit][Reset][Accept]> weblogic1





<------------------- Fusion Middleware Configuration Wizard ------------------>

Configure Administrator User Name and Password:
-----------------------------------------------

Create a user to be assigned to the Administrator role. This user is the
default administrator used to start development mode servers.

 | Name | Value |
 _|_________________________|_________________________________________|
 1| *Name: | weblogic |
 2| *User password: | ********* |
 3| *Confirm user password: | |
 4| Description: | This user is the default administrator. |

Use above value or select another option:
 1 - Modify "Name"
 2 - Modify "User password"
 3 - Modify "Confirm user password"
 4 - Modify "Description"
 5 - Discard Changes




Enter option number to select OR [Exit][Previous][Next]> 3





<------------------- Fusion Middleware Configuration Wizard ------------------>

Configure Administrator User Name and Password:
-----------------------------------------------

Create a user to be assigned to the Administrator role. This user is the
default administrator used to start development mode servers.

 "*Confirm user password:" = []




Enter new *Confirm user password: OR [Exit][Reset][Accept]> weblogic1





<------------------- Fusion Middleware Configuration Wizard ------------------>

Configure Administrator User Name and Password:
-----------------------------------------------

Create a user to be assigned to the Administrator role. This user is the
default administrator used to start development mode servers.

 | Name | Value |
 _|_________________________|_________________________________________|
 1| *Name: | weblogic |
 2| *User password: | ********* |
 3| *Confirm user password: | ********* |
 4| Description: | This user is the default administrator. |

Use above value or select another option:
 1 - Modify "Name"
 2 - Modify "User password"
 3 - Modify "Confirm user password"
 4 - Modify "Description"
 5 - Discard Changes




Enter option number to select OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Domain Mode Configuration:
--------------------------

Enable Development or Production Mode for this domain.

 ->1|Development Mode

 2|Production Mode




Enter index number to select OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Java SDK Selection:
-------------------

 ->1|N/A SDK 1.7.0_45 @ /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.45.x86_64
 2|Other Java SDK




Enter index number to select OR [Exit][Previous][Next]> 2





<------------------- Fusion Middleware Configuration Wizard ------------------>

Java SDK Selection:
-------------------

 "JVM Directory" = []




Enter new JVM Directory OR [Exit][Previous][Next]> /d01/jrockit





<------------------- Fusion Middleware Configuration Wizard ------------------>

Java SDK Selection:
-------------------

 "JVM Directory" = [/d01/jrockit]




Enter new JVM Directory OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Select Optional Configuration:
------------------------------

 1|Administration Server [ ]
 2|Managed Servers, Clusters and Machines [ ]
 3|RDBMS Security Store [ ]



Enter index number to select OR [Exit][Previous][Next]> 1





<------------------- Fusion Middleware Configuration Wizard ------------------>

Select Optional Configuration:
------------------------------

 1|Administration Server [x]
 2|Managed Servers, Clusters and Machines [ ]
 3|RDBMS Security Store [ ]



Enter index number to select OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Configure the Administration Server:
------------------------------------

Each WebLogic Server domain must have one Administration Server. The
Administration Server is used to perform administrative tasks.

 | Name | Value |
 _|__________________|_____________________|
 1| *Name: | AdminServer |
 2| *Listen address: | All Local Addresses |
 3| Listen port: | 7001 |
 4| SSL listen port: | N/A |
 5| SSL enabled: | false |

Use above value or select another option:
 1 - Modify "Name"
 2 - Modify "Listen address"
 3 - Modify "Listen port"
 4 - Modify "SSL enabled"




Enter option number to select OR [Exit][Previous][Next]>





<------------------- Fusion Middleware Configuration Wizard ------------------>

Creating Domain...

0% 25% 50% 75% 100%
[------------|------------|------------|------------]
[***************************************************]


**** Domain Created Successfully! ****


[oracle@oel bin]$

now start the weblogic.........
[oracle@oel base_domain]$ pwd
/d01/Oracle/middleware/user_projects/domains/base_domain
[oracle@oel base_domain]$ ls
autodeploy bin config console-ext fileRealm.properties init-info lib security servers startWebLogic.sh
[oracle@oel base_domain]$ ./startWebLogic.sh
.
.
JAVA Memory arguments: -Xms512m -Xmx512m
.
WLS Start Mode=Development
.
CLASSPATH=/d01/Oracle/middleware/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/d01/Oracle/middleware/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/d01/jrockit/lib/tools.jar:/d01/Oracle/middleware/wlserver_10.3/server/lib/weblogic_sp.jar:/d01/Oracle/middleware/wlserver_10.3/server/lib/weblogic.jar:/d01/Oracle/middleware/modules/features/weblogic.server.modules_10.3.6.0.jar:/d01/Oracle/middleware/wlserver_10.3/server/lib/webservices.jar:/d01/Oracle/middleware/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/d01/Oracle/middleware/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:/d01/Oracle/middleware/wlserver_10.3/common/derby/lib/derbyclient.jar:/d01/Oracle/middleware/wlserver_10.3/server/lib/xqrl.jar
.
PATH=/d01/Oracle/middleware/wlserver_10.3/server/bin:/d01/Oracle/middleware/modules/org.apache.ant_1.7.1/bin:/d01/jrockit/jre/bin:/d01/jrockit/bin:/d01/jrockit/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
.
***************************************************
* To start WebLogic Server, use a username and *
* password assigned to an admin-level user. For *
* server administration, use the WebLogic Server *
* console at http://hostname:port/console *
***************************************************
starting weblogic with Java version:
java version "1.6.0_45"
Java(TM) SE Runtime Environment (build 1.6.0_45-b06)
Oracle JRockit(R) (build R28.2.7-7-155314-1.6.0_45-20130329-0641-linux-x86_64, compiled mode)
Starting WLS with line:
/d01/jrockit/bin/java -jrockit -Xms512m -Xmx512m -Dweblogic.Name=AdminServer -Djava.security.policy=/d01/Oracle/middleware/wlserver_10.3/server/lib/weblogic.policy -Xverify:none -da -Dplatform.home=/d01/Oracle/middleware/wlserver_10.3 -Dwls.home=/d01/Oracle/middleware/wlserver_10.3/server -Dweblogic.home=/d01/Oracle/middleware/wlserver_10.3/server -Dweblogic.management.discover=true -Dwlw.iterativeDev= -Dwlw.testConsole= -Dwlw.logErrorsToConsole= -Dweblogic.ext.dirs=/d01/Oracle/middleware/patch_wls1036/profiles/default/sysext_manifest_classpath:/d01/Oracle/middleware/patch_ocp371/profiles/default/sysext_manifest_classpath weblogic.Server
<Apr 11, 2014 10:30:31 PM IST> <Info> <Security> <BEA-090905> <Disabling CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true>
<Apr 11, 2014 10:30:32 PM IST> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG to FIPS186PRNG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true>
<Apr 11, 2014 10:30:33 PM IST> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with Oracle JRockit(R) Version R28.2.7-7-155314-1.6.0_45-20130329-0641-linux-x86_64 from Oracle Corporation>
<Apr 11, 2014 10:30:34 PM IST> <Info> <Management> <BEA-141107> <Version: WebLogic Server 10.3.6.0 Tue Nov 15 08:52:36 PST 2011 1441050 >
<Apr 11, 2014 10:30:39 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
<Apr 11, 2014 10:30:39 PM IST> <Info> <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>
<Apr 11, 2014 10:30:42 PM IST> <Notice> <Log Management> <BEA-170019> <The server log file /d01/Oracle/middleware/user_projects/domains/base_domain/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.>
<Apr 11, 2014 10:30:51 PM IST> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
<Apr 11, 2014 10:31:03 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STANDBY>
<Apr 11, 2014 10:31:03 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
<Apr 11, 2014 10:31:04 PM IST> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Service successfully.>
<Apr 11, 2014 10:31:05 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
<Apr 11, 2014 10:31:05 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
<Apr 11, 2014 10:31:06 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
<Apr 11, 2014 10:31:06 PM IST> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>

weblogic

Posted April 10, 2014 by balaoracledba.com in Weblogic

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   Leave a comment

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

R12.2 adop phase=cleanup failed with ORA-20001: Error while calling ad_zd.cleanupORA-01555: snapshot too old:   Leave a comment

Below is an excerpt when i was running adop session.

When i was running adop phase=cleanup i was hit with the below error

[applmgr@r122 ~]$ adop phase=cleanup
Enter the APPS password: 
Enter the SYSTEM password: 
Enter the WLSADMIN password:
Please wait. Validating credentials...

RUN file system context file: /u01/oracle/PROD/fs2/inst/apps/PROD_r122/appl/admin/PROD_r122.xml
PATCH file system context file: /u01/oracle/PROD/fs1/inst/apps/PROD_r122/appl/admin/PROD_r122.xml
************* Start of session *************
 version: 12.2.0
 started at: Wed Jul 24 2013 03:34:53
APPL_TOP is set to /u01/oracle/PROD/fs2/EBSapps/appl
[STATEMENT] Using 4 workers (Default: 4, Recommended maximum limit: 62)
 Cleanup is not done in earlier session
 [START 2013/07/24 03:35:27] adzdoptl.pl run
 ADOP Session ID: 4
 Phase: cleanup
 Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20130724_033421.log
 [START 2013/07/24 03:35:48] cleanup phase
 [EVENT] [START 2013/07/24 03:35:52] Performing Cleanup steps 
 [EVENT] [START 2013/07/24 03:35:57] Running CLEANUP ddls in ddl handler table 
 Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
 ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20130724_033421/PROD_r122/log
 [EVENT] [END 2013/07/24 03:39:43] Running CLEANUP ddls in ddl handler table 
 [EVENT] Cleaning up ABORT DDL from DDL Handler Table
 [START 2013/07/24 03:39:54] Generating All DDL Report
 [EVENT] Report: /u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql
[EVENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20130724_033421/PROD_r122/adzdallddls_20130724_033957.out
[END 2013/07/24 03:39:58] Generating All DDL Report
[EVENT] Calling cleanup in QUICK mode
 [WARNING] Cleanup may take a while. Please wait.
[ERROR] Failed to execute sql statement :
 declare
 result varchar2(10);
 begin
 ad_zd.cleanup('QUICK');
 exception
 when others then
 raise_application_error(-20001,'Error while calling ad_zd.cleanup' || sqlerrm);
 end;
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 24 03:40:01 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> declare
ERROR at line 1:
ORA-20001: Error while calling ad_zd.cleanupORA-01555: snapshot too old:
rollback segment number 2 with name "_SYSSMU2_735814084$" too small
ORA-06512: at line 7
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[UNEXPECTED]Error occurred while calling cleanup plsql API
 [UNEXPECTED]Cleanup phase completed with errors/warnings. Please check logfiles
 Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20130724_033421.log
adop exiting with status = 1 (Fail)
[applmgr@r122 ~]$

To overcome this issue.I have extended the undotablespace using below:

SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME like 'APPS_UNDOTS1';
TABLESPACE_NAME    FILE_NAME       
--------------------------------------------------------------------------------------------------------------
APPS_UNDOTS1    /u01/oracle/PROD/data/undo01.dbf

SQL> ALTER DATABASE DATAFILE '/u01/oracle/PROD/data/undo01.dbf' RESIZE 10240M;
Database altered.
SQL>

Then again i executed the adop phase=cleanup
[applmgr@r122 ~]$ adop phase=cleanup
Enter the APPS password: 
Enter the SYSTEM password: 
Enter the WLSADMIN password:
Please wait. Validating credentials...

RUN file system context file: /u01/oracle/PROD/fs2/inst/apps/PROD_r122/appl/admi
n/PROD_r122.xml
PATCH file system context file: /u01/oracle/PROD/fs1/inst/apps/PROD_r122/appl/ad
min/PROD_r122.xml
************* Start of session *************
 version: 12.2.0
 started at: Fri Feb 28 2014 04:11:18
APPL_TOP is set to /u01/oracle/PROD/fs2/EBSapps/appl
[STATEMENT] Using 4 workers (Default: 4, Recommended maximum limit: 59)
 Cleanup is not done in earlier session
 [START 2014/02/28 04:11:45] adzdoptl.pl run
 ADOP Session ID: 4
 Phase: cleanup
 Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20140228_041049.log
 [START 2014/02/28 04:12:03] cleanup phase
 [EVENT] [START 2014/02/28 04:12:06] Performing Cleanup steps 
 [EVENT] [START 2014/02/28 04:12:11] Running CLEANUP ddls in ddl handler table 
 Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
 ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20140228_041049/PROD_r122/log
 [EVENT] [END 2014/02/28 04:13:26] Running CLEANUP ddls in ddl handler table 
 [EVENT] Cleaning up ABORT DDL from DDL Handler Table
 [START 2014/02/28 04:13:32] Generating All DDL Report
 [EVENT] Report: /u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql
[EVENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20140228_041049/PROD_r122/adzdallddls_20140228_041335.out
[END 2014/02/28 04:13:36] Generating All DDL Report
 [EVENT] Calling cleanup in QUICK mode
[WARNING] Cleanup may take a while. Please wait.
 [EVENT] [END 2014/02/28 04:57:56] Performing Cleanup steps 
 [END 2014/02/28 04:58:05] cleanup phase 
 [START 2014/02/28 04:58:11] Generating AD_ZD_LOGS Report
 [EVENT] Report: /u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
[EVENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20140228_041049/PROD_r122/adzdshowlog.out
[END 2014/02/28 04:58:24] Generating AD_ZD_LOGS Report
 [END 2014/02/28 04:58:25] adzdoptl.pl run
 adop phase=cleanup - Completed Successfully
Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20140228_041049.log
adop exiting with status = 0 (Success)

 

Posted February 28, 2014 by balaoracledba.com in R12.2

Follow

Get every new post delivered to your Inbox.

Join 359 other followers