Thursday, 15 December 2016

runinstall error 11gr2

[oracle@apps15 database]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 46314 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 7999 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-12-15_05-30-16PM. Please wait ...[oracle@apps15 database]$ #
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x00000039b4c14d70, pid=4124, tid=140279675725584
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_30-b03 mixed mode)
# Problematic frame:
# C  [ld-linux-x86-64.so.2+0x14d70]
#
# An error report file with more information is saved as hs_err_pid4124.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#

solution:-
============================================================

[oracle@apps15 database]$  export LD_BIND_NOW=1
[oracle@apps15 database]$ ./runInstaller 

Wednesday, 14 December 2016

How to create context files in apps R12

Database saide:-
=======================================================================

SQL> select name,status from v$database,v$instance;

NAME  STATUS
--------- ------------
PROD  OPEN


[oracle@apps15 11.1.0]$ lsnrctl status prod

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 14-DEC-2016 15:23:45

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps15.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias                     prod
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                14-DEC-2016 14:19:52
Uptime                    0 days 1 hr. 3 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_apps15/listener.ora
Listener Log File         /u01/oracle/PROD/db/tech_st/11.1.0/log/diag/tnslsnr/apps15/prod/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps15.com)(PORT=1536)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


[oracle@apps15 bin]$ perl adbldxml.pl appsuser=apps appspass=apps


Starting context file generation for db tier..
Using JVM from /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/adbldxml_12141531.log
UnsatisfiedLinkError exception loading native library: njni11

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server: apps15.com

Enter Port of Database server: 1536

Enter SID of Database server: PROD


The context file has been created at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml


                                                            ( OR )

Database context file creation:-
=======================================================================

[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log

Database Host [apps15]:

Database Host Domain [com]:

Database Port [1521]:1536

Database SID:PROD

APPS Schema Name [APPS]:  

APPS Schema Password:apps

The following context files are available:

[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)

Select the context to retrieve [1]:2

Destination file path [/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml]:

Retrieved context file to /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml

Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log


Application Context file creation:-
=================================================================

[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log

Database Host [apps15]:

Database Host Domain [com]:

Database Port [1521]:1536

Database SID:PROD

APPS Schema Name [APPS]:  

APPS Schema Password:apps

The following context files are available:

[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)

Select the context to retrieve [1]:1

Destination file path [/u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml]:

Retrieved context file to /u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml

Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log



How to create DBC file if it is deleted

database and application is running 

[applmgr@apps15 install]$ cd $FND_SECURE

[applmgr@apps15 install]$ pwd

/u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure

[applmgr@apps15 secure]$ ls


[applmgr@apps15 secure]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@apps15 scripts]$ pwd
/u02/Apps/inst/apps/PROD_apps15/admin/scripts

[applmgr@apps15 scripts]$ cd ../install/
[applmgr@apps15 install]$ pwd
/u02/Apps/inst/apps/PROD_apps15/admin/install

[applmgr@apps15 install]$ sh adgendbc.sh

adgendbc.sh started at Wed Dec 14 14:50:46 IST 2016


Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Dec 14 14:50:53 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value  : PROD
Level Name: SITE
INFO       : Updated/created profile option value.
.

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Params=fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false


Unique constraint error (00001) is OK if key already exists
Application server ID already exists for this host - loading..
ADD executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc

Trying to update information ...

Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5 fnd_jdbc_buffer_decay_interval=300
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false fnd_jdbc_context_check=true
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_plsql_reset=false
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc

Updating Server Security Authentication
AUTHENTICATION SECURE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
adgendbc.sh exiting with status 0
ERRORCODE = 0 ERRORCODE_END


[applmgr@apps15 install]$ cd $FND_SECURE

[applmgr@apps15 secure]$ ls
PROD.dbc
[applmgr@apps15 secure]$

Thursday, 10 November 2016

frm-92050 failed to connect to the server /forms/servlet-1

frm-92050 failed to connect to the server /forms/servlet-1:-

If we Disable the XSS filter as below it is working fine.

MSIE 8 --->Tools > Internet Options >
Security Settings -->Custom Level >
Scroll down to entry "Enable XSS Filter" > Select Disable XSS Filter button.

Thursday, 3 November 2016

how check file versions

Two ways to check version of file.
            1. Adident   
            2. Strings
 ADIDENT Utility in ORACLE application is used to find version of any file.
STEP:-1
   Syntax : adident Header filename.
   e.g If you want to find out the version of appvndrb.pls
        $ cd AP_TOP/patch/115/sql
        $ adident Header appvndrb.pls
        o/p :
         appvndrb.pls:
         $Header appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship
STEP-2
 Using Strings:
  Syntax : strings -a Top_name/location of file/filename | grep '$Header'
   e.g $ strings -a $AP_TOP/patch/115/sql/appvndrb.pls | grep '$Header'
   o/p : /* $Header: appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship $ */
                                              OR
      $ cd $AP_TOP/patch/115/sql
      $ strings -a appvndrb.pls | grep '$Header'
OR
grep '$Header' $INV_TOP/patch/115/sql/INVTXGGB.pls

Wednesday, 2 November 2016

how to change maintenance mode



we can run this commands fromo any saide (DB or APPS)
How to know the status of maintenance mode:=
===============================================================================

SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual;

How to enable maintenance mode:=
=================================================================================

SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

How to disable maintenance mode:=
==================================================================================

SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE



or 

run adadmin

A fatal error has been detected by the Java Runtime Environment

[oracle@apps14 12c]$ dbua
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x0000003ac4814d70, pid=6623, tid=139971124459280
#
# JRE version: 6.0_37-b06
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.12-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C  [ld-linux-x86-64.so.2+0x14d70]
#
# An error report file with more information is saved as:
# /u01/database/db/tech_st/12c/hs_err_pid6623.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
Aborted (core dumped)
[oracle@apps14 12c]$ 
TRACE FILE CONTENT
Memory: 4k page, physical 8181084k(5652968k free), swap 16777212k(16777212k free                               )

vm_info: Java HotSpot(TM) 64-Bit Server VM (20.12-b01) for linux-amd64 JRE (1.6.                               0_37-b06), built on Sep 24 2012 11:47:45 by "java_re" with gcc 3.2.2 (SuSE Linux                               )

time: Fri Sep 23 17:23:02 2016
elapsed time: 0 seconds


Solution:=
=================================================================
$ export LD_BIND_NOW=1

Then Run dbca or dbua or any