DhanaDBA: 2013

Tuesday 3 December 2013

dhanaappsdba.blogspot.in

Monday 2 December 2013

Create Virtual Mapping for Forms 11g | Deploy Images and Icons in Forms 11g

This article explains virtual Directory Mapping for Forms 11g version 11.1.1.1.0. This mapped virtual directory can be used to deploy icons, images, HTML and other files. First part explains how to create virtual mapping to deploy an HTML file and second part explains how to deploy icons and images in Forms 11g.
Create a directory as C:\myapp
Now create an HTML file named “MY.HTML” and place it in C:\myapp directory.
Now locate the file weblogic.xml in following directory
$DOMAIN_HOME\servers\WLS_FORMS\stage\formsapp\11.1.1\formsapp\formsweb.war\WEB-INF\
Now add following line to weblogic.xml file
<virtual-directory-mapping>
<local-path>C:\myapp</local-path>
<url-pattern>myapp/*</url-pattern>
</virtual-directory-mapping>
Now open Forms.conf file which can be located at following location
$ORACLE_INSTANCE\config\OHS\ohs1\moduleconf
Add following two line in this file
AliasMatch ^/forms/myapp/(..*) “C:\myapp/$1″
WLExcludePathOrMimeType /forms/mypp/
Now Restart HTTP server and open following URL
Http://localhost:8090/forms/myapp/my.html
If page is displayed, virtual mapping is successful.
Note that virtual mapping for Forms 11.1.1.2 is not supported in this way.
Deploy Images and Icons in Forms 11g
Similarly mapped virtual directory can be used to deploy icons and images. To deploy icons or images do following.
Add icons/images to a JAR file using following command
<Oracle Home>\jdk\bin\jar –cvf myAppIcons.jar *.gif
Now place this myAppIcons.jar file to c:\myapp directory .
Now modify formsweb.cfg file by adding following bold face words,
archive=frmall.jar,/forms/myapp/myAppIcons.jar
imageBase=codebase
This JAR file can also be places in a pre-mapped directory like $ORACLE_HOME\forms\java.
If you do not want to create JAR files of icons, you can directly place your icons in $ORACLE_HOME\forms\java directory
Reference: Support.oracle.com (document id. 981095.1)

Unix for the DBA

How to kill all similar processes with single command (in this case opmn)

ps -ef | grep opmn |grep -v grep | awk ‘{print $2}’ |xargs -i kill -9 {}

Locating Files under a particular directory

find . -print |grep -i test.sql

Using AWK in UNIX

To remove a specific column of output from a UNIX command – for example to determine the UNIX process Ids for all Oracle processes on server (second column)

ps -ef |grep -i oracle |awk '{ print $2 }'

Changing the standard prompt for Oracle Users

Edit the .profile for the oracle user

PS1="`hostname`*$ORACLE_SID:$PWD>"

Display top 10 CPU consumers using the ps command

/usr/ucb/ps auxgw | head -11

Show number of active Oracle dedicated connection users for a particular ORACLE_SID

ps -ef | grep $ORACLE_SID|grep -v grep|grep -v ora_|wc -l

Display the number of CPU’s in Solaris

psrinfo -v | grep "Status of processor"|wc -l

Display the number of CPU’s in AIX

lsdev -C | grep Process|wc -l

Display RAM Memory size on Solaris

prtconf |grep -i mem

Display RAM memory size on AIX

First determine name of memory device

lsdev -C |grep mem

then assuming the name of the memory device is ‘mem0’

lsattr -El mem0

Swap space allocation and usage

Solaris : swap -s or swap -lAix : lsps -a

Total number of semaphores held by all instances on server

ipcs -as | awk '{sum += $9} END {print sum}'

View allocated RAM memory segments

ipcs -pmb

Manually deallocate shared memeory segments

ipcrm -m '<ID>'

Show mount points for a disk in AIX

lspv -l hdisk13

Display amount of occupied space (in KB) for a file or collection of files in a directory or sub-directory

du -ks * | sort -n| tail

Display total file space in a directory

du -ks .

Cleanup any unwanted trace files more than seven days old

find . *.trc -mtime +7 -exec rm {} \;

Locate Oracle files that contain certain strings

find . -print | xargs grep rollback

Locate recently created UNIX files (in the past one day)

find . -mtime -1 -print

Finding large files on the server (more than 100MB in size)

find . -size +102400 -print

Crontab :

To submit a task every Tuesday (day 2) at 2:45PM
45 14 2 * * /opt/oracle/scripts/tr_listener.sh > /dev/null 2>&1
To submit a task to run every 15 minutes on weekdays (days 1-5)
15,30,45 * 1-5 * * /opt/oracle/scripts/tr_listener.sh > /dev/null 2>&1
To submit a task to run every hour at 15 minutes past the hour on weekends (days 6 and 0)
15 * 0,6 * * opt/oracle/scripts/tr_listener.sh > /dev/null 2>&1

To change the Web Listener Port number in Oracle E-Business Suite Release 12

Goal

Goal:
      To change the Web Listener Port number in Oracle E-Business Suite Release 12

This will be illustrated with a practical example using the following Hostname,Domain, Port numbers:
     -Host Name: myhost
     -Domain Name: oracle.com
     -Port Number that we want to change: 8001
     -Port Number that we wish to be changed to: 8002
     -Protocol : HTTP

Solution

1- Open your Context XML file for edit through OAM
2- Change the value from 8001 to be 8002 on the following lines:
      <web_port oa_var="s_webport" oa_type="PORT" base="8000" step="1" range="-1" label="Web Listener Port">8001</web_port>

      <activewebport oa_var="s_active_webport" oa_type="DUP_PORT" base="8000" step="1" range="-1" label="Active Web Port">8001</activewebport>

   <login_page oa_var="s_login_page">http://myhost.oracle.com:8001/OA_HTML/AppsLogin</login_page>

    <chronosURL oa_var="s_chronosURL">http://myhost.oracle.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</chronosURL>

    <oa_var="s_endUserMonitoringURL">http://myhost.oracle.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</EndUserMonitoringURL>

   <externURL oa_var="s_external_url">http://myhost.oracle.com:8001</externURL>

<httplistenparameter oa_var="s_http_listen_parameter">8001</httplistenparameter>

3- Save your settings

4- Run Autoconfig for changes to take place

5- Try to login again through:
      http://myhost.oracle.com:8002
    The URL should be displayed successfully

FRM-92102 : A network error has occured on iAS

FRM-92102 : A network error has occured

FRM-92102 is Gerneric Error maybe occur for more than one reasons :

1-Network
2-Proxy
3-http
4-Session Time

But today i will discuss the problem On oracle Application server 10g .
Description for the problem like the following when you try to connect on your deploy application On OAS 10g it's gives the above error from 1-5 minutes.

I will give you more than one solution maybe it will be related to the above problem and you try them separately to see which one will be valid for you :

1-Netowrk Parameters :

You will find it $ORACLE_HOME/forms/server/default.env
Just increase the value .

2-do the following change in opmn.xml (under $ORACLE_HOME/opmn/conf/):

3-SET Inbound_connection_timeout In sqlnet.ora to ZERO .

Sqlnet.Inbound_connection_timeout = 0

Note : if your can't find this parameter in the SQLNET.ORA you cant add it .

5- Change the following $ORACLE_HOME/opmn/conf/opmn.xml

How to change the Oracle EBusiness Suite url

Normally while you install oracle R12 it takes the hostname as url name. So, you can access the oracle apps instance as http://:/OA_HTML/AppsLogin

An example is http://machinename.domainname:8000/OA_HTML/AppsLogin

The following article will explain you how you can change the url to other name instead of hostname of the machine.

Here I am assuming the hostname of the server is HOSTNAME and currently the instance is accesible from http://HOSTNAME.domainname:8000/OA_HTML/AppsLogin
and we'll change the url to
http://URLNAME.domainname:8000/OA_HTML/AppsLogin

Set the apps environment file.
Check the CONTEXT_FILE name
Take a backup of the context file

Now change the following parameter in context file.

1. s_webentryhost

This is the name of the host that receives the first HTTP request from the desktop client. Previously it was set as hostname of the server [HOSTNAME]. Change this value to URLNAME.

2. s_webentrydomain

This is domain name of the host that receives the first HTTP request from the desktop client
Change the domain name if required.

3. s_login_page

This is the URL used to access the Applications logon page.
Change it from the old value http://HOSTNAME.domainname:8000/OA_HTML/AppsLogin to new value http://URLNAME.domainname:8000/OA_HTML/AppsLogin .

4. s_external_url

This is URL that third party tools use to connect to the E-Business Suite System.
old value = http://HOSTNAME.domainname:8000/
new value = http://URLNAME.domainname:8000/

After changing the values, do the following.

Run the AutoConfig utility on all the application tier Servers
Restart application server processes
Test sign on from the web entry point

OBIEE startup/shutdown

First, let's go over the manual start up process for Weblogic & OBIEE 11g in Solaris & Linux:

Start Administration Server

located in your Weblogic Server Domain user_projects folder
/user_projects/domains/bifoundation/bin/startWebLogic.sh
example: ./startWebLogic.sh

Start Node Manager

located in your Weblogic Server Home Directory
/wlserver_10.3/server/bin/startNodeManager.sh
example: ./startNodeManager.sh

Start Managed Server

located in your Weblogic Server Domain user_projects folder
/user_projects/domains/bifoundation/bin/startManagedWebLogic.sh
example: ./startManagedWebLogic.sh bi_server1 t3://HOSTNAME:7001

Start BI Services using Oracle Process Manager and Notification Server (opmnctl)

located in your Orcle Instance folder
/instances/instance1/bin/opmnctl
example: opmnctl startall

Second, let's go over the manual shut down process of Weblogic & OBIEE 11g in Solaris & Linux:

Stop BI Services using Oracle Process Manager and Notification Server (opmnctl)

located in your Orcle Instance folder
/instances/instance1/bin/opmnctl
example: opmnctl stopall

Start Managed Server

located in your Weblogic Server Domain user_projects folder
/user_projects/domains/bifoundation/bin/stopManagedWebLogic.sh
example: ./stopManagedWebLogic.sh bi_server1 t3://HOSTNAME:7001

Stop Node Manager

There is no 'stopNodeManager', must kill associated proccesses
example: pkill -TERM -u USERNAME -f "/startNodeManager.sh"
example: pkill -TERM -u USERNAME -f "/java"

Stop Admin Server

located in your Weblogic Server Domain user_projects folder
/user_projects/domains/bifoundation/bin/stopWebLogic.sh
example: ./stopWebLogic.sh

find Components version in R12

How to find Components version in R12

Apache Version

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Go to reports path Then type: -

string -a APXAPRVL.rdf|grep Header

Perl Version

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Java Version

sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"

Jre version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

Forms Version

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

Plsql Version

$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

Forms Communication mode

cat $FORMS_WEB_CONFIG_FILE|grep serverURL=

echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"

How to find Apps Version
select release_name from apps.fnd_product_groups;

Web Server/Apache or Application Server in Apps 11i/R12
Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

Forms & Report version in R12/12i
Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release

Oracle Jinitiator in 11i/R12/12i
Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE

(Default is Java Plug-In for R12/12i )

Oracle Java Plug-in in 11i/R12/12i
A. Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE.

File Version on file system
adident Header
or
strings | grep Header
Here adident is AD Utility (Oracle Apps) and strings is Unix utility.

Version of pld file
*.pld are source code of *.pll which are inturn source of *.plx. *.pll is in $AU_TOP/resource and to find its version check

adident Header $AU_TOP/resource/.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $
or
strings $AU_TOP/resource/.pll | grep -i header
FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);

Workflow Version with Apps
select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;

Identity Management component Version/Release Number

Oracle Single Sign On
select version from orasso.wwc_version$;

Oracle Internet Directory
There are two component in OID (Software/binaries & Schema/database)

To find software/binary version
$ORACLE_HOME/bin/oidldapd -version

To find Schema Version/ database use
ldapsearch -h -p -D “cn=orcladmin” -w “” -b “” \ -s base “objectclass=*” orcldirectoryversion

select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

Application Server
Oracle Application Server 10g Rel 3 (10.1.3.X)
cat $ORACLE_HOME/config/ias.properties | grep Version
Version=10.1.3.0.0

For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database

select * from ias_versions;
or
select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;

AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version

Oracle Portal
select version from portal.wwc_version$;

Database Component

To find database version
select * from v$version;
or
All component version in database
$ORACLE_HOME/OPatch/opatch lsinventory -detail

Unix Operating System

Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-releasecat /proc/meminfo
cat /proc/cpuinfo
less /proc/cpuinfolsb_release -a

Error! FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher

Brought a couple new PCs up recently and ran into the subject nasty error when attempting to access EBS. We’ve run into this before and we usually get it worked out one way or another. This time proved to be a bit challenging for some reason… Thought I would post the solution that we used and seems to work consistently. I’ve found other posts out there as well that reference some combination of these steps. For now, this will be my reference moving forward.

Uninstall all existing Java installations on machine
Uninstall all existing J2SE Runtime Environment installations on machine
Restart the machine
Install JRE 6u45
Open the Control Panel
Search for Java; clicking the link will open the Java Control Panel
Select the “Java” tab
Click “View…”
Double click the field under “Runtime Parameters”
Enter this line: -Djava.vendor=”Sun Microsystems Inc.”
Click OK
Click OK
Open IE and go to Oracle EBS and invoke a form to come up
It will ask to install J2SE Runtime Environment 5.0 Update 13
Install J2SE Runtime Environment 5.0 Update 13
Restart the machine
Open IE and you should now be able to open Oracle EBS

This has been tested on x64 flavors of Win7 and Win8 using the x64 installer for JRE.
Note: Disable the automatic updater within the Java Control Panel after all the steps listed above

Sunday 1 December 2013

Undo tablespace resize

To check your undo tablespace info issue the following statement:
SQL> SELECT name,value FROM v$parameter WHERE name IN (‘undo_management’,'undo_tablespace’);

NAME VALUE
------------------------
undo_management AUTO
undo_tablespace UNDOTBS01

SQL>
SQL> CREATE UNDO TABLESPACE undotbs02
DATAFILE ‘/u01/app/oracle/oradata/mydb/undotbs02.dbf’ SIZE 1024M
REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 10240M;

SQL> ALTER SYSTEM SET undo_tablespace = ‘UNDOTBS02′;
SQL> ALTER TABLESPACE undotbs01 OFFLINE;
SQL> DROP TABLESPACE undotbs01 INCLUDING CONTENTS AND DATAFILES;
SQL>
With these steps we created a new undo tablespace, set it as the system default undo tablespace and drop the old tablespace including the datafiles.

failed to start a managed process because a dependency check failed

After applying Oct2008 CPU patch for a client on Oracle application server 10gR2, OC4J_Security on Infra structure tier failed to startup. No much information in logs, the only thing that was shown after couple minutes was :

ias-component/process-type/process-set:
OC4J/OC4J_SECURITY/default_island

Error
--> Process (pid=0)
oid dependency failed
OID
failed to start a managed process because a dependency check failed
Log:
none

It was interesting that OID started without any issue.
Above issue could occur when OID run on port lower than 1024 and $ORACLE_HOME/bin/oidldapd has not the right permission.
This file should own by root.To fix permission issue, $ORACLE_HOME/root.sh from Infra structure home should be run.

How to access Oracle Apps 11i Forms from Vista on Internet Explorer

Steps mentioned in this post is workaround to access Oracle Applications (E-Business Suite 11i) from Windows Vista , permanent solution is to migrate Application Tier to use Sun JRE (Native Plug-in) as mentioned in Metalink Note 290807.1
To Access Oracle Application 11i from Vista, please perform following tasks:
Step 1)Go to program files => java ==> jre1.6.0_07 (or recent jre min 1.6, you can download from java.sun.com)
Path : C:\ Program Files\ Java\ jre1.6.0_07\ bin\ client (default location)

Step 2)Copy the jvm.dll file

Step 3) Go to C:\ Program Files\ Oracle\ JInitiator 1.3.1.21\ bin\ hotspot

Step 4)Take backup of current jvm.dll file present in \Oracle\ JInitiator 1.3.1.21\ bin\ hotspot directory

Step 5) Paste the jvm.dll file which you have copied (in step 2) to hotspot directory.
STEP 6) Close all the browsers and restart.
You can access the forms now
Make sure you add your_machine_name> in trusted sites under Tools ==> Internet options ==> Security and popups should not be blocked.
.
References/Related

553348.1 Unable To Connect To E-Business Suite On Vista with Jinitiator
285218.1 Recommended Browsers for Oracle E-Business Suite 11i
290807.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i

RENAME TEMPFILE ORACLE 10G

RENAME TEMPFILE ORACLE 10G
If the file is the default temporary tablespace then you need perform the below from step 1,
Else if you want to move a datafile of a normal temporary tablespace then perform the below from step 2.
1]. First of all you have to create another default temporary tablespace.
2]. Take the tablespace in offline position
3]. Use os command to move or copy the files.
4]. Then perform:

SQL> alter database rename file '\' to '\';
5]. Bring the tablespace online.
EXAMPLE:
STEP 1:
------
SQL> alter database default temporary tablespace pr_temp;
Database altered.

SQL> select PROPERTY_NAME,PROPERTY_VALUE from database_properties
where PROPERTY_NAME like '%DEFAULT%';
PROPERTY_NAME PROPERTY_VALUE
-----------------------------------------------
DEFAULT_TEMP_TABLESPACE PR_TEMP

STEP 2:
-----
SQL> alter database tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEMP1.DBF' offline;
Database altered.

STEP 3:
------
SQL> select file_name from dba_temp_files where tablespace_name='TEMP';
FILE_NAME
-------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TEMP01.DBF

+++ Use os command to move or copy the files.

STEP 4:
------
SQL> alter database rename file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TEMP01.dbf'
to 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEMP1.dbf';
Database altered.

Now we can check if the file is move and renamed as below,

SQL> select file_name from dba_temp_files where tablespace_name='TEMP';
FILE_NAME
------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEMP1.DBF

STEP 5:
------
SQL> alter database tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEMP1.DBF' online;
Database altered.

Formsbuilder Crashes With Segmentation Fault

Subject:	Formsbuilder Crashes With Segmentation Fault
	Doc ID:	363976.1	Type:	PROBLEM
	Modified Date :	10-JAN-2008	Status:	PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Forms - Version: 9.0.4 to 10.1.2.0.2
Linux x86
Checked relevance 10-Jan-2008

Symptoms

When attempting to launch frmbld.sh, forms builder crashes with segmentation fault.

Error Details:
Segmentation fault with no core dump.
Doing an strace will have these lines at the end of tail
10934 sigaltstack({ss_sp=0xbfe04000, ss_flags=0, ss_size=40960}, NULL) = 0
10934 rt_sigaction(SIGHUP, NULL, {SIG_DFL}, 8) = 0
10934 rt_sigaction(SIGINT, NULL, {SIG_DFL}, 8) = 0
10934 rt_sigaction(SIGTERM, NULL, {SIG_DFL}, 8) = 0
10934 rt_sigprocmask(SIG_UNBLOCK, [HUP INT QUIT USR2 TERM CHLD], NULL, 8) = 0
10934 --- SIGSEGV (Segmentation fault) @ 0 (0) ---
10934 --- SIGSEGV (Segmentation fault) @ 0 (0) ---
10934 +++ killed by SIGSEGV +++

Cause

Problem with SUN Java version running on Xeon or AMD64 64-bit CPU running on Linux RH. The updated
kernel added "non executable stack" feature. This is a new security enhancement.

This is explained in the following internal Bug: 4175691 - OUI QUITS WITH NO ERROR
According to Sun, this problem is fixed in Sun JRE 1.4.2_08(b02)
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6178600

Solution

Objective: Boot with kernel option 'noexec=off'
Steps to follow:
1. Login as root

2. Backup /boot/grub/grub.conf

3. Modify /boot/grub/grub.conf and add new kernel menu with "noexec=off" flag.

Example:

jdefault=0
timeout=10
splashimage=(hd0,0)/grub/splash.xpm.gz
title Red Hat Enterprise Linux AS (2.4.21-15.EL)
root (hd0,0)
kernel /vmlinuz-2.4.21-15.EL ro root=LABEL=/
initrd /initrd-2.4.21-15.EL.img
title Red Hat Enterprise Linux AS (2.4.21-15.EL) noexec=off
root (hd0,0)
kernel /vmlinuz-2.4.21-15.EL ro root=LABEL=/ noexec=off
initrd /initrd-2.4.21-15.EL.img

4. Reboot the machine
5.Verify if system booted with noexec=off:

# cat /proc/cmdline
ro root=/dev/sda5 console=ttyS0,115200 console=tty0 noexec=off

6. Start forms builder now: ./frmbld.sh
Remark: This problem has also been related to Oracle Report server and Oracle Universal Installer
Note 276802.1 - Runinstaller Crash Immediatly When Run
Note 331919.1 - Rwserver.Sh Is Generating Segmentation Fault but not Core Dump File

Error When Starting the Naming Service on iAS 10g

Subject:	Error When Starting the Naming Service
	Doc ID:	334774.1	Type:	PROBLEM
	Modified Date :	29-JAN-2009	Status:	PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Reports Developer - Version: 10.1.2.0.2
This problem can occur on any platform.
"Checked for relevance on 28-Jan-2009."

Symptoms

Attempting to start the Naming Service gives error :
org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 201 completed : no
naming server is not responding. Restarting ...

namingservice 14021
naming service started successfully
org.omg.CORBA.COMM_FAILURE: 
vmcid: SUN minor code: 201 completed : no
naming server is not responding. Restarting ...
naming service started successfully
org.omg.CORBA.COMM_FAILURE: 
vmcid: SUN minor code: 201 completed : no
naming server is not responding. Restarting ...
naming service started successfully
etc.

Cause

The port passed in parameter to namingservice is busy

namingservice <port number>
To check if a port is used :

on Windows
netstat -a
on UNIX
lsof -i:PORT

Solution

Use another port number
or
Free the port (stop the application using this port)
or
In some cases, it may be necessary to restart the platform

UNZIP Check with code value

unzip <file_name.zip>;rc=$?;echo $rc; Its return "0" (Zero) means unzip is good Its return "1" (One) means unzip is corrupted.

How to change Hostname on Oracle Solaris and Linux

Step # 1: Change Hostname

You need to update two files:

Linux Distribution specific file. Edit appropriate file as per your distribution as follows.
/etc/hosts

Redhat / CentOS / Fedora: Change Hostname

Edit /etc/sysconfig/network, enter:

vi /etc/sysconfig/network

Set HOSTNAME=newhost.example.com, enter:

HOSTNAME=server2.nixcraft.com

Save and close the file. Type the following command:

hostname server2.nixcraft.com
hostname

Now, proceed to step # 2.

Debian / Ubuntu: Change Hostname

Edit, /etc/hostname file, enter:

vi /etc/hostname

Delete old name and add new name:

server2.nixcraft.com

Save and close the file. Type the following command:

hostname server2.nixcraft.com
hostname

Now, proceed to step # 2.

Slackware: Change Hostname

Edit /etc/HOSTNAME, enter:

vi /etc/HOSTNAME

Delete old name and add new one:

server2.nixcraft.com

Save and close the file. Type the following command:

hostname server2.nixcraft.com
hostname

Now, proceed to step # 2.

Suse / OpenSuse: Change Hostname

Edit /etc/HOSTNAME, enter:
Delete old name and add new one:

server2.nixcraft.com

Save and close the file. Type the following command:

hostname server2.nixcraft.com
hostname

Now, proceed to step # 2.

Step #2: Update /etc/hosts

Now, you need to edit /etc/hosts file, enteR:

vi /etc/hosts

Change all old hostname with newer one.

Error! FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher

Uninstall all existing Java installations on machine
Uninstall all existing J2SE Runtime Environment installations on machine
Restart the machine
Install JRE 6u45
Open the Control Panel
Search for Java; clicking the link will open the Java Control Panel
Select the “Java” tab
Click “View…”
Double click the field under “Runtime Parameters”
Enter this line: -Djava.vendor=”Sun Microsystems Inc.”
Click OK
Click OK
Open IE and go to Oracle EBS and invoke a form to come up
It will ask to install J2SE Runtime Environment 5.0 Update 13
Install J2SE Runtime Environment 5.0 Update 13
Restart the machine
Open IE and you should now be able to open Oracle EBS

This has been tested on x64 flavors of Win7 and Win8 using the x64 installer for JRE.
Note: Disable the automatic updater within the Java Control Panel after all the steps listed above

How to Install new language [French] on R12.1.1 Oracle EBusiness Suite

The documents I followed ->

How to resolve NLS translation issues in an Ebusiness Suite 11i and R12 environment [ID 394112.1]

How To Get The Guidelines To Install or Add the new NLS Language on E-Business Suite 11i or R12 [ID 1254325.1]

Oracle Applications NLS Release Notes Release 12 [ID 405294.1]

Requesting Translation Synchronization Patches [ID 252422.1]

Step 1. Activate new language using OAM License Manager
If your database does not have unicode character set [like UTF8] this option will be disable. Then follow the following page to convert the database character set first.

http://www.oracle-latest-technology.com/2011/02/how-to-convert-character-set-of-oracle.html

Step 2. Run adadmin to maintain multilingual tables

Go to adadmin > Maintain multi-lingual tables >

Step 3. Follow Oracle Applications NLS Release Notes, Release 12.1 [ID 788053.1] .

If needed apply patch 8576725. download language patch [6678700 for R12.1] from http://edelivery.oracle.com/ and install it.

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

Issue faced ->

During application of the NLS patch 6678700 for french language, I am getting the following error ->

The current description will not be changed.

Patch 6678700:F is a NLS patch.

You must first apply the corresponding US patch

for the NLS patch(es) listed above.

AutoPatch error:

--------

A fatal error related to codelines or codelevels has occurred.

I have done the following things before applying this patch ->

1. Activate new language using OAM License Manager
2. Run adadmin to maintain multilingual tables

3. Followed all the prerequisites mentioned in the doc Oracle Applications NLS Release Notes, Release 12.1 [ID 788053.1] . Applied patch 8576725.

Solution ->

We don't need to apply 6678700 as the language is already active.

check it using the following command ->

Select NLS_LANGUAGE from FND_LANGUAGES where INSTALLED_FLAG in ('B','I');

See the following discussion if you want to know more details->

http://forums.oracle.com/forums/message.jspa?messageID=9389446#9389446

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

Step 4. Follow this document Requesting Translation Synchronization Patches [ID 252422.1].

Create Manifest file. Upload it to oracle site. They will provide the patch set 11803377.

Apply patch set 11803377.

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

Isuue faced ->

Failed worker ->

1 Run AutoPatch R120 bomprg.ldt FAILED

2 Run AutoPatch R120 payzzcncprg00514.ldt FAILED

3 Run AutoPatch R120 jg12acp.ldt FAILED

4 Run AutoPatch R120 amscitem.ldt FAILED

Checked the worker log file. The error is coming due to following error.

ORA-24816: Donnees bind non LONG developpees fournies apres colonne LONG ou LOB

English translation -> ORA-24816: Data not bind LONG developed provide after LONG or LOB column

Solution ->

Check metalik doc ID 452095.1.

Basically need to change Solaris env variable $NLS_LANG as in database.

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

Step 5. After adding the patch 11803377 restart the application tier using ./adstpal.sh and ./adstrtal.sh.

You can select your new language in the login screen.

Pages

Tuesday 3 December 2013

Monday 2 December 2013

Create Virtual Mapping for Forms 11g | Deploy Images and Icons in Forms 11g

Unix for the DBA

How to kill all similar processes with single command (in this case opmn)

Locating Files under a particular directory

Using AWK in UNIX

Changing the standard prompt for Oracle Users

Display top 10 CPU consumers using the ps command

Show number of active Oracle dedicated connection users for a particular ORACLE_SID

Display the number of CPU’s in Solaris

Display the number of CPU’s in AIX

Display RAM Memory size on Solaris

Display RAM memory size on AIX

Swap space allocation and usage

Total number of semaphores held by all instances on server

View allocated RAM memory segments

Manually deallocate shared memeory segments

Show mount points for a disk in AIX

Display amount of occupied space (in KB) for a file or collection of files in a directory or sub-directory

Display total file space in a directory

Cleanup any unwanted trace files more than seven days old

Locate Oracle files that contain certain strings

Locate recently created UNIX files (in the past one day)

Finding large files on the server (more than 100MB in size)

Crontab :

Goal

Solution

FRM-92102 : A network error has occured

How to change the Oracle EBusiness Suite url

How to find Components version in R12

Sunday 1 December 2013

Applies to:

Symptoms

Cause

Solution

Applies to:

Symptoms

Cause

Solution

Step # 1: Change Hostname

Redhat / CentOS / Fedora: Change Hostname

Debian / Ubuntu: Change Hostname

Slackware: Change Hostname

Suse / OpenSuse: Change Hostname

Step #2: Update /etc/hosts

How to Install new language [French] on R12.1.1 Oracle EBusiness Suite