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







Friday, 21 October 2016

How to open oracle application in windows from linux

[applmgr@apps14 scripts]$ grep login $CONTEXT_FILE  (for checking the LogIn url)
<login_page oa_var="s_login_page">http://apps14.com:8004/OA_HTML/AppsLogin</login_page>

DISABLE FIRE WALL IN LINUX

STEP:-1
===============================================================
If you want to open this link in windows:
  1     open notepad as Administrator privileges
  2     Ctl+O
  3     Go to this address (C:\Windows\System32\drivers\etc)
  4     Here select “hosts” & open file


  5     Add your machine ip and hostname



STEP:-2
=====================================================================
Start Menu › Control Panel  (keep its view in category) › System and Security › System
Open Advanced system settings
Click Environment Variables
Add a OS Parameter: JAVA_TOOL_OPTIONS, and
parameter value: -Djava.vendor="Sun Microsystems Inc." 
Re-log or reboot your system
STEP:-3
=================================================================
   Open Internet Explorer 
   Go to Tools -> Internet Options -> Security -> Custom Level 
  
       Search for XSS Filter
  
      By Default it is Enabled. Now you Disable it.    
   
   Give yes
   
      Restart Browser.

     STEP:-4
    ==================================================================
  

    Uninstall all java versions.

        Download jre-7u79-windows 64 or 32-bit  And install it. then
       
        open control pannel -> change it to small icons ->open Java -> security -> 
        
        change to Medium ->Edit sait level -> apps login URL -> ok  ->Restart browser.





                                                          








Thursday, 20 October 2016

oracle application user

Application Database Users:-

1.     Apps user
2.     Applsys
3.     Applsyspub
4.     Oracle
5.     Applmgr
6.     Gust user

Apps User is a Application Super User or Universal Schema. Apps User has complete access to EBS Data Module.  & APPS User has privilege to access all Application Objects.

       All runtime Applications connect to Apps Schema,
       Apps User is the owner of all Business Modules.
       Apps is the owner of AOL (Application Object Library) at Database level.
       All Tables Synonym of other Users by default will be granted to Apps User, so that the Apps User can be access the other Users Schema.

Applsys User is a common User created for all Technology Modules.

       Applsys is a owner of All Technology Modules & (Application Data Dictionary). 
       Applsys is the owner of Application at Database Level.

Sysadminis the System Administrator User to perform System Administrative tasks.

Applmgr User is the owner of Application Database Tire at O/S level.

Oracle Useris the owner of Oracle Database Tire at O/S level.

ApplsyspubUser checks the authentications. It will have all the login& logout details of the Users.
Note:- Apps is the default password for both Apps User and Applsys User.
If we change the Password of Apps User then it will automatically change the Password of Applsys User also.

Gust user:-
It is  application user with no responsibilities.

GUEST_USER_PWD=GUEST/ORACLE 

What is DBC File in oracle apps?

.dbc file :-


The .dbc file is actually the database connector descriptor file used to connect to database and this file is by-default located in $FND_TOP/secure directory, this file is quite important as whenever any program likes to connect to database like forms it uses dbc file where there you find the Guest_user_pwd ,when the guest user connect it does not allow it to directly connect to the database but it first connect goes via this file and cross verify the password of the guest which is kept in this file.

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file.

Typical entry in dbc file are:
GUEST_USER_PWDAPPS_JDBC_URLDB_HOST

Tuesday, 18 October 2016

FNDFS Error unable to view Concurrent program LOG and OUT files

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_APPLTOP_ . There may be a network configuration problem, or the TNS listener on node FNDFS_APPLTOP_ may not be running.Please contact your system administrator.

Problem : In R12, After running a Concurrent request, Unable to view LOG and OUT files of the Concurrent request and returns above error message.

Cause : The RRA is Not Enabled in the Profile Option.

Solution :
In the Profile Option –>system –> RRA: Enabled is set as No in Site Level. Make it to Yes.
Save and Logout and Retest the Issue.

EBS Technology Modules

(AOL) Oracle Application Object Library, It is also called as FND Foundation
(AD) Oracle Application Database
(AU) Oracle Application Utilities
(OWF) Oracle Work Flow
(ALR) Oracle Alert
(FWK) AO Frame Work
(XDO)XML publisher
(AK) Common Module
Tech Stack:-     8o6_HOME (11i)    IAS_HOME(R12)
                                                       
 AOL(Oracle Application Object Library):-

AOL is  a Centralized technology module or Key Component of Application. which contains ApplicationData Dictionary and Meta Data of Application. AOL is also called asFND foundation. and all other modules depends on AOL.
       AOL is the Heart of Application Database.
       AOL Controls Access to the Database in Oracle Applications through user sign-on and responsibilities. AOL stores all Application User Information.

(AD) Application Database Module:-

AD is a Technology Module which  provide all AD Utilities for performing different maintenance activities  for Application Database like:- Patching, Cloning, General Maintenance,& Administration etc.AD Table contains information about bugs, Patching etc.

(AU) Application Utilities:- 

AU contain all form Files (.fmb) and Reportsor Running Reports invoked by the Report Server from a Standard Shared Location.

(OWF) Oracle Work Flow:-

It is a Technology Module. The Work Flow   help the Business to transfer the business Documents from one user to another user in the form of E-Notification.

(AK) Common Module:- 

AK is a active directory that enables us to define Oracle Application components for HTML based Applications. It is used to develop inquiry HTML based Application.

(ALR) Alerts:- 

ALR allows us to Email system notifications to User when an Exception or Event has occurred.

Ex:- We can send a Email to Key Database Administrator when a Tablespace in Application Database go field up.

(XDO) XML Publisher:- 

XML Publisher is a Java based product based on the World Wide Web Consortium (W3C). XML Publisher use Data  definition and templates to produce output Report in the desired


(FWK) Application Frame Work:-

FWK is the Oracle Application  development and deployment platform for fast & highly Scalable HTML

oracle application concurrent managers

How to check the running concurrent managers?
$ ps -ef|grep FNDLIBR

ICM (internal concurrent manager):-
The master manager is called the Internal Concurrent Manager (ICM) because it controls the behavior of all of the other managers, and because the ICM is the boss, it must be running before any other managers can be activated. The main functions of the ICM are to start up and shutdown the individual concurrent managers, and reset the other managers after one them has a failure.
It is a FNDLIBR process
It is used to communicate the service manager (GSM).

Located at:- $APPLCSF/$APPLLOG 


Standard Manager:
 Another important master Concurrent Manager is called the Standard Manager (SM). The SM functions to run any reports and batch jobs that have not been defined to run in any specific product manager. Examples of specific concurrent managers include the Inventory Manager, CRP Inquiry Manager, and the Receivables Tax Manager.
used to perform the single client request processing. & used to execute the all all the concurrent managers.
If any request is not defined to run the standard manager will take care of that request.

Conflict Resolution Manager — The Conflict Resolution Manager (CRM) functions to check concurrent program definitions for incompatibility rules. However, the ICM can be configured to take over the CRM's job to resolve incompatibilities.

FNDSM:-
It is service manager. FNDSM is executable and core component in GSM ( Generic Service Management Framework discussed above). You start FNDSM services via application listener on all Nodes in Application Tier in E-Business Suite.

APPS listener:-
Combination of FNDFS & FNDSM.

FNDFS:-
FNDFS or the Report Review Agent (RRA) is the default text viewer within Oracle Applications, which allows users to view report output and log files. Report Review Agent is also referred to by the executable FNDFS. The default viewer must be configured correctly before external editors or browsers are used for viewing requests.

GSM:-  (generic service manager)
GSM stands for Generic Service Management Framework. Oracle E-Business Suite consist of various compoennts like Forms, Reports, Web Server, Workflow, Concurrent Manager ..

Service Management is an extension of Concurrent Processing, which provides a powerful framework for managing processes on multiple host machines.   Today, services such as the Oracle Forms Listener, Oracle Reports Server, Apache Web listener, and Oracle Workflow Mailer can be run under Service Management.

 With Service Management, the Internal Concurrent Manager (ICM) manages the various service processes across multiple hosts. On each host, a Service Manager acts on behalf of the ICM, allowing the ICM to monitor and control service processes on that host. System administrators can then configure, monitor, and control services though a management console which communicates with the ICM.


Service Management provides a fault tolerant system. If a service process exits unexpectedly, the ICM will automatically attempt to restart the process.  If a host fails, the ICM may start the affected service processes on a secondary host.  The ICM itself is monitored and kept alive by Internal Monitor processes located on various hosts.


OPP:- (output post processer)
OPP is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the OPP to apply the XML Publisher template and create the final output.
Thread Vs Process :You can either increase process (or) threads. It depends on the load .
Reseting and altering can be done via these navigation
Concurrent -> Manager -> Define > Output Post Processor

Locating OPP log file?
whenever XML issues or other publishing problems occurs, first thing you will do is to trace the OPP logfile.Locating such logs is not a big things, just follow the steps below:
1.     logon with System Administrator
2.     Function: Concurrent --> Manager --> Administration and select the Output Post Processor
3.     Click on the Processes button
4.     Select the Concurrent Process which was active during the time that the request ran
5.     Click on the Manager Log button to open the Output Post Processor log file