Friday, December 26, 2014

Existing lock /var/run/yum.pid: another copy is running as pid

Issue: Existing lock /var/run/yum.pid: another copy is running as pid

Caused : Yum Session was locked by other user or it was terminated.

[root@rac1 ~]# yum list | grep oracle-
This system is not registered with ULN.
ULN support will be disabled.
Existing lock /var/run/yum.pid: another copy is running as pid 3246.
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: yum-updatesd-he
Memory : 26 M RSS (263 MB VSZ)
Started: Fri Dec 26 19:53:45 2014 - 00:10 ago
State : Running, pid: 3246
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: yum-updatesd-he
Memory : 26 M RSS (263 MB VSZ)
Started: Fri Dec 26 19:53:45 2014 - 00:12 ago
State : Running, pid: 3246
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: yum-updatesd-he
Memory : 26 M RSS (263 MB VSZ)
Started: Fri Dec 26 19:53:45 2014 - 00:14 ago
State : Running, pid: 3246

Exiting on user cancel.

Fixed:
[root@rac1 ~]# ls -l /var/run/yum.pid
-rw-r--r-- 1 root root 4 Dec 26 19:53 /var/run/yum.pid
[root@rac1 ~]# rm /var/run/yum.pid
rm: remove regular file `/var/run/yum.pid'? y

Re-run:
[root@rac1 ~]# yum list | grep oracle-

Thursday, September 25, 2014

How to install telnet to windows 7

Telnet Client is not installed by default on Windows 7. The procedures to install Telnet Client vary based on the operating system you are using.

Here are the steps to Install into the Windows 7 Operating system:

Select 'Control Panel'

Select 'Programs and Features'

Select 'Turn Windows Features on or off'

Wait for 2-4 minutes on this screen

Select 'Telnet Client' and click on 'Ok' button

Open Command Prompt and now you have telnet command.

Thursday, August 28, 2014

Cloning cheat list - EBS 11i / R12.1 / R12.2

Application Cloning

Post clone steps

1. Clean FND_NODES

SQL> select node_name, node_mode, support_cp, support_web, support_admin,support_forms from FND_NODES;

NODE_NAME N S S S S

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

SGERP01 O Y Y Y Y

AUTHENTICATION O N N N N

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

2. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers

EBS R12.2 - Application Cloning

Issue 1:

############################################################

Started ApplyAppsTier at Sun Oct 26 13:38:45 SGT 2014

Version:

ApplyAppsTier.java : 120.11.12020000.6

#############################################################

Found the directory : /r122va/VIS3/fs1/FMW_Home

Exiting cloning as FMW Home already exists..

Fix: Move this folder to some other name

Issue 2:

#########################################################

Started ApplyAppsTier at Sun Oct 26 13:40:13 SGT 2014

Version:

ApplyAppsTier.java : 120.11.12020000.6

#############################################################

Below Oracle Homes are already registered in the global inventory:

/r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1

/r122va/VIS3/fs1/FMW_Home/webtier

/r122va/VIS3/fs1/FMW_Home/oracle_common

/r122va/VIS3/fs1/FMW_Home/Oracle_OAMWebGate1

Exiting Cloning...

Ensure that the above Oracle Homes are unregistered from the global inventory "/r122vd/VIS3/oraInventory//ContentsXML/inventory.xml" and re-run adcfgclone.pl script

Fix :
move inventory.xml file so new file will be created

mv /r122vd/VIS3/oraInventory//ContentsXML/inventory.xml /r122vd/VIS3/oraInventory//ContentsXML/inventory.xml.jm1

Error 3:

END: Executed adupdlobs.pl

ERROR: AutoConfig completed with errors. Check logfile at /r122va/VIS3/fs1/inst/apps/VIS3_sar122vis1/admin/log/clone/ApplyAppsTier_10261341.log for details.

FMW JDK version in use: 1.7.0_25

/r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1/jdk is not a symbolic link, creating it...

Running ln -s /r122va/VIS3/fs1/EBSapps/comn/util/jdk64 /r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1/jdk

-- further errors

Updating s_tnsmode to 'generateTNS'

UpdateContext exited with status: 0

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates

Instantiating Tools tnsnames.ora

Tools tnsnames.ora instantiated

adgentns.pl exiting with status 2

ERRORCODE = 2 ERRORCODE_END

fix: run fnd_node clean and run autoconfig on application and databsae node

applmgr@sar122vis1 bin]$ . /r122va/VIS3/EBSapps.env run

E-Business Suite Environment Information

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

RUN File System : /r122va/VIS3/fs1/EBSapps/appl

PATCH File System : /r122va/VIS3/fs2/EBSapps/appl

Non-Editioned File System : /r122va/VIS3/fs_ne

DB Host: sar122vis1.stone-apple.com Service/SID: VIS3

Sourcing the RUN File System ...

[applmgr@sar122vis1 bin]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@sar122vis1 scripts]$ ./adautocfg.sh

Enter the APPS user password:

Wednesday, August 27, 2014

RPM required for RHEL 6 to run Oracle Database 11gR2

Install following Rpm from the Yum / Installation Media

yum install libSM.i686 libXp.i686 libXp.x86_64 libX11.i686 libXt.i686 libXrender.i686 compat-db43.i686 gcc.x86_64 gcc-c++.x86_64 glibc-devel.i686 libgcc.i686 \
libstdc++-devel.i686 libstdc++-devel.x86_64 libstdc++.i686 libXi.i686 libaio.i686 gdbm.i686 compat-libstdc++-296.i686 compat-libstdc++-33.i686 compat-libcap1.x86_64 \
compat-libstdc++-33.x86_64 elfutils-libelf-devel.x86_64 libaio-devel.x86_64 unixODBC.i686 unixODBC.x86_64 unixODBC-devel.i686 unixODBC-devel.x86_64 xorg-x11-utils.x86_64 \
ksh.x86_64

Download following package from the Oracle website and Install it.

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/openmotif21-2.1.30-11.EL6.i686.rpm

rpm -ivh openmotif21-2.1.30-11.EL6.i686.rpm

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

rpm -ivh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

Thursday, August 21, 2014

How to connect to AWS EC2 Server

Step 1 : Connect to the Jumpin server

From mac Pc

Copy secure key to your mac and run the below command

ssh -i <secure key> <username>@<server IP Address>

from Jump-in server to the actual server

From Putty

Tuesday, August 19, 2014

Oracle EBS R12.1.3 - WebADI with 64bit Office

Issue 1: Users are unable to open WebADI Document in some of the PC with Office 2010.

Error: java.lang.NoSuchMethodError: oracle.apps.bne.utilities.oa.BneDFFStructure.setValType(Ljava/lang/String;)

Solution:
1. Apply Patch - 14209751:R12.BNE.B
2. Bounce Middle-tier

Change:
BneDFFStructure.java 120.1.12010000.2 2009/08/03 16:23:37
to
BneDFFStructure.java 120.1.12010000.4 2012/11/30 19:32:09

Saturday, August 9, 2014

Install AWS Command Line Interface on Oracle Linux 5

1. Download Active Perl from below website
2. Download AWS CLI from the Amazon website

1. Install Active Perl

cd /tmpwget http://downloads.activestate.com/ActivePython/releases/2.7.8.10/ActivePython-2.7.8.10-linux-x86_64.tar.gztar -xzvf ActivePython-2.7.8.10-linux-x86_64.tar.gzcd ActivePython-2.7.8.10-linux-x86_64
[root@bastion ActivePython-2.7.8.10-linux-x86_64]# ./install.shEnter directory in which to install ActivePython. Leave blank andpress 'Enter' to use the default [/opt/ActivePython-2.7].Install directory:()Installing ActivePython to '/opt/ActivePython-2.7'...Relocating dir-dependent files...

2. Install AWS CLI

cd /tmp
export PATH=/opt/ActivePython-2.7/bin:$PATH
wget https://s3.amazonaws.com/aws-cli/awscli-bundle.zip
[root@bastion tmp]# export PATH=/opt/ActivePython-2.7/bin:$PATH
[root@bastion tmp]# ./awscli-bundle/install -i /usr/local/aws -b /usr/local/bin/aws
Running cmd: /opt/ActivePython-2.7/bin/python virtualenv.py --python /opt/ActivePython-2.7/bin/python /usr/local/aws
Running cmd: /usr/local/aws/bin/pip install --no-index --find-links file:///tmp/awscli-bundle/packages awscli-1.4.0.tar.gz
You can now run: /usr/local/bin/aws --version
[root@bastion tmp]# /usr/local/bin/aws --version
aws-cli/1.4.0 Python/2.7.8 Linux/2.6.18-194.0.0.0.3.el5xen
[root@bastion tmp]#

3. Configure AWS

[root@sar12vis tmp]# aws configure

AWS Access Key ID [None]: xxxxxxxxxxxxxxxxxxxxxxAWS

Secret Access Key [None]: xxxxxxxxxxxxxxxxxxxxxx

Default region name [None]: ap-southeast-1

Default output format [None]:

[root@sar12vis tmp]#

4. Ready to use

[xxxx@bastion ~]$ aws ec2 help

Tuesday, June 24, 2014

Gather Schema Statistics

Gather Stats in Oracle E-Business Suite with improved (Auto sampling) features of Oracle Database 11gR2

Schedule Concurrent Request:

Schema Name:
Estimate Percent:
Degree:
Backup Flag:
Restart Request ID:
History Mode: Backup existing statistics prior to gather new statistics
Gather Options: (GATHER_AUTO Option - gather statistics for tables based upon % change)
Modifications Threshold:
Invalidate Dependent Cursors:

Know Issue and fixes

Error 1- ORA-20005: object statistics are locked
**Starts**24-JUN-2014 21:00:54
ORACLE error 20005 in FDPSTP
Cause: FDPSTP failed due to ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "APPS.FND_STATS", line 780
ORA-06512: at line 1
.
The SQL statement being executed at the time of the error was: SELECT R.Con
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag=
stats on table AQ$_WF_CONTROL_P is locked
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
ORA-20005: object statistics are locked (stattype = ALL)
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Solution:

Unlock object statistics:

exec dbms_stats.unlock_table_stats('APPLSYS','AQ$_WF_CONTROL_P');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_CP_GSM_IPC_AQTBL');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_IN');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_OUT');

Error 2- ORA-20005: object statistics are locked

**Starts**24-JUN-2014 21:11:03

ORACLE error 20001 in FDPSTP

Cause: FDPSTP failed due to ORA-20001: SYS_NT8GWEU//JUHJGQKJAFGGSUG== is an invalid identifier

ORA-06512: at "APPS.FND_STATS", line 774

ORA-06512: at line 1

The SQL statement being executed at the time of the error was: SE

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag=

ORA-20001: SYS_NT8GWEU//JUHJGQKJAFGGSUG== is an invalid identifier

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

Solution:

apply patch - 9542112 [ERROR IN R12 FOR GATHER SCHEMA STATS WITH GATHER AUTO OPTION to a non critical environment]

Reference:
When Using Gather Auto Option Errors - Is an Invalid Identifier (Doc ID 1363044.1)

Infra & DevOps gist

Friday, December 26, 2014

Existing lock /var/run/yum.pid: another copy is running as pid

Thursday, September 25, 2014

How to install telnet to windows 7

Thursday, August 28, 2014

Cloning cheat list - EBS 11i / R12.1 / R12.2