Thursday 27 April 2017

fs_clone Error 1 occurred while Executing txkADOPValidation script

Error:

Lines #(73-77):
    [PROCEDURE] Calling: /u01/app/applmgr/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT]     Log: /u01/app/applmgr/TEST/fs_ne/EBSapps/log/adop/4/fs_clone_20170427_171727/TEST_test
    [UNEXPECTED]Error occurred running "perl /u01/app/applmgr/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/app/applmgr/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -patchctxfile=/u01/app/applmgr/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml -phase=fs_clone -logloc=/u01/app/applmgr/TEST/fs_ne/EBSapps/log/adop/4/fs_clone_20170427_171727/TEST_test -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on test
[PROCEDURE] [START 2017/04/27 17:18:23] Unlocking sessions table

Lines #(74-78):
    [EVENT]     Log: /u01/app/applmgr/TEST/fs_ne/EBSapps/log/adop/4/fs_clone_20170427_171727/TEST_test
    [UNEXPECTED]Error occurred running "perl /u01/app/applmgr/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/app/applmgr/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -patchctxfile=/u01/app/applmgr/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml -phase=fs_clone -logloc=/u01/app/applmgr/TEST/fs_ne/EBSapps/log/adop/4/fs_clone_20170427_171727/TEST_test -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on test
[PROCEDURE] [START 2017/04/27 17:18:23] Unlocking sessions table
[STATEMENT] Unlocking ad_adop_sessions table for test with wait interval of 60 seconds and number of tries 2

Fix:
To fix this issue test the following to upload the missing PATCH context file to the database:

1. Get the value of your patch context file.

    1.1. Source your PATCH file system

    1.2. Echo the value of $CONTEXT_FILE and take note of it. You will use this value in step #3.

2. Source the RUN filesystem

3. Execute the following command on the run filesystem to upload the patch context file to the database.

$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=/u01/app/applmgr/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml \
logfile=/tmp/patchctxupload.log

Note: the context file parameter should point to the physical location of the patch context file in your system

4. Run the following query and it should return one entry for the recently uploaded context file.

select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';

Wednesday 26 April 2017

Oracle Application R12 forms not opening in Linux

When we are trying to access forms in Oracle apps R12.1 in Linux got the below error.

Error:










Fix:

When you done with the plugin installation, issue about:plugins and check whether your installed jre plugin is showing in mozilla. if it does you can access the forms. 

To know the recommended jre plugin version issue the below : 
grep plugin $CONTEXT_FILE 
<!-- JDK plugins --> 
<sun_plugin_ver oa_var="s_sun_plugin_ver">1.6.0_07</sun_plugin_ver> 
<sun_plugin_type oa_var="s_sun_plugin_type">jdk</sun_plugin_type> 

Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.18) Gecko/20110621 Oracle/3.6-1.0.1.el5_6 Firefox/3.6.18 

Download and install the below : (Make sure you os bit version when you download) http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase6-419409.html#jre-6u33-oth-JPR

Install ---> jre-6u33-linux-x64.bin 

Since my operating ssystem were 64 bit we must create soft link to /usr/lib64 folder instead of /usr/lib 
go to /usr/lib64/mozilla/plugins 

Create softlink as below : 
ln -s /home/oracle/jre1.6.0_33/lib/amd64/libnpjp2.so . 

libnpjp2.so -> /oracle/jre1.6.0_33/lib/amd64/libnpjp2.so 

Now you  can able to access the forms in Linux.

error while loading shared libraries: libXtst.so.6: cannot open shared object file: No such file or directory

Error:

Concurrent program error with the following message.

error while loading shared libraries: libXtst.so.6: cannot open shared object file: No such file or directory.

Fix:

Install the following RPM's to resolve the issue.

yum install libXext.x86_64
yum install libXrender.x86_64
yum install libXtst.x86_64

GConf Error: Failed to contact configuration server; some possible causes are that you need to enable TCP/IP networking for ORBi

Error:

GConf Error: Failed to contact configuration server; some possible causes are that you need to enable TCP/IP networking for ORBit, or you have stale NFS locks due to a system crash. See http://projects.gnome.org/gconf/ for information. (Details - 1: Failed to get connection to session: Failed to connect to socket /tmp/dbus-QS6NzEDBEh: Connection refused)
















In the /var/log/messages


gconfd (root-21343): Bad permissions 777 on directory /tmp/gconfd-root
gconfd (root-21343): Failed to get lock for daemon, exiting: Directory /tmp/gconfd-root has a problem, gconfd can't use it

Fix:

1.Change permissions to 700  on directory /tmp/gconfd-root
2. Restart the VNC server.

Sunday 23 April 2017

RC-50004: Fatal: Error occurred in ApplyDatabase:

While installing application R12.1.1, we got the below error.

Error:

RC-50004: Fatal: Error occurred in ApplyDatabase:

Control file creation failed

Cannot execute configure of database using RapidClone

RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running Database Install Driver for TEST instance

Additional errors recorded in the "addlnctl.txt"

lsnrctl: error while loading shared libraries: /u01/DEV/db/tech_st/11.1.0/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

Fix:

Following steps should be followed:

a) Switch SELinux from the default "Enforcing" mode that it is running in, to the "Permissive" mode. Contact Unix/Linux Admin for the same.

b) Clean up the File System (DB Tier, Application Tier & Inventory). Review the Note: How To Locate the Log Files and Troubleshoot Rapid Install for Release 12.0.x and 12.1.x (Doc ID 452120.1) for Cleanup instructions.

c) Run Rapidwiz.

Friday 21 April 2017

IO Error: Got minus one from a read call vendor code 17002

When we are trying to connect database by using Sql developer, we got below error.

Error:

IO Error: Got minus one from a read call vendor code 17002





















Fix:

You can follow these steps to avoid the error:

  1. Go to directory $ORACLE_HOME/network/admin
  2. Make sure you have backup of sqlnet.ora
  3. Modify sqlnet.ora file with the parameter: (tcp.validnode_checking = no)
  4. If you don't want to disable this, you can put the machine names as follows:  tcp.invited_nodes=(machine1, machine2)
  5. Bounce the listener or reload the listner (lsnrctl reload)

Tuesday 4 April 2017

License Manager Showing Asia/Pacific Localizations (JA) as 'Not Licensed'?

License Manager Showing Asia/Pacific Localizations (JA) as 'Not Licensed'.

How to get it Licensed ?

Please do the following:
  • Go to SYSADMIN responsibility / Oracle Application manager / License Manager / Country Specific Localization.
  • Select Singapore
  • Retest your issue.
Below link to know Licensed enable or not.

How to find Asia/Pacific Localizations (JA) Installed or not in Oracle E-Business Suite (R12.1 / R12.2)

Below script to find the Asia/Pacific Localizations (JA) Installed or not in Oracle E-Business Suite instance.

Script:

SELECT SUBSTR(a.application_name, 1,40) product_name
, a.application_id
, SUBSTR(application_short_name, 1,4) short_name,
DECODE(b.status,'I','INSTALLED',
DECODE(b.status,'S','SHARED',
DECODE(b.status,'N','NOTINSTALLED',b.status))) status
FROM fnd_application_vl a, fnd_product_installations b
WHERE a.application_id = b.application_id
and a.application_short_name like Upper('ja')
and upper(a.application_name) like upper('%asia%')
ORDER BY 1;

Output: