Oracle Technologies Blog


Posts Tagged ‘R12’

Do we have mod_plsql,jserv,reports server in R12 ?

Posted by Srikrishna Murthy Annam on October 13, 2009

Do we have mod_plsql,jserv,reports server in R12 ?

mod_plsql :

Mod_plsql is an Apache web server extension that can be used to develop web application pages using Server PL/SQL.
Unlike Oracle E-Business Suite Release 11i, Release 12 does not include mod_plsql as part of its technology stack.
Modplsql component of Apache is removed in R12 .you have to see the alternate for custom developed programs which will be using this.
If you have developed mod_plsql extensions to Oracle E-Business Suite Release 11i, and are considering upgrading to Release 12, you will have to take some action to preserve that functionality.
mod_plsql is replaced by Oracle Application Framework in R12. The reasong for replacing the mod_plsql with Oracle Application Framework in R12 is that , mod_plsql does not provide solutions for a number of important problems that must be solved in a robust and secure web application.

The following components/modules were removed from Release 12
1. mod_plsql
2. Oracle Reports Server
3. Oracle Graphics Integration with Oracle Forms
4. Oracle Applications Framework pages in the AK Repository (AK mode)

JServ :

OC4J replaces the Jserv component which is there in the current release 11i of Oracle Applications. Also as a result the mod_jserv component would be replaced by the mod_oc4j component in release 12 of Oracle Applications. The mod_oc4j is used to communicate between different OC4J instances.

The default installation Release 12 of Oracle Applications creates 3 OC4J instances

— Oacore: This runs the OA Framework -based applications.
— Forms: This runs the Forms-based applications.
— OAFM: This is responsible for running the web services.

The Jserv groups which are there current in Oracle Applications Release 11i are also planned be replaced by OC4J instances.

As mentioned earlier the OC4J properties are controlled using the XML files and file. These files are managed by the standard Oracle Applications Autoconfig.

The Java code deployment in Oracle E-Business suite for OC4J is done at the time of install using rapid install and maintained by ad tools like adadmin and adpatch. New custom code deployment can be done by using the Application Server Control user interface.

The OC4J implementation In Oracle Applications Release 12 includes the following directory structure.

— applications: Contains applications deployed
— applications-deployment: Contains configuration settings for the applications deployed
— config: Contains common configuration setting for the OC4J instance.

Remember there are no or jserv.conf or in R12 (new techstack), Jserv is replaced by Oacore.

Finally …
– Jserv component is removed and it is replaced in R12 by OC4J(oacore)
– mod_plsql is replaced by Oracle Application Framework
– The reports server has been removed in R12 and it runs as a spawned process called rwrun which is spawned by conc manager.

Ref Note : 726711.1


Posted in Oracle Apps R12 | Tagged: , , , , , , , , , | 1 Comment »

R12 – How to enable logging for Apache,Oc4j and Opmn

Posted by Srikrishna Murthy Annam on September 29, 2009

R12 – How to enable logging for Apache,Oc4j and Opmn:

Apache Logging ( Plain Text )

1) Edit the file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf and set
LogLevel warn (s_apache_loglevel in context file)
2) Bounce the apache
3) Try to access the home URL or reproduce the issue.
4) Collect the following logfiles from $LOG_HOME/ora/10.1.3/Apache
access_log.<unique id>
error_log.<unique id>

Values that can be set to LogLevel variable in httpd.conf file
LogLevel = emerg,alert,crit,error,warn,notice,info,debug.

Apache Logging ( ODL Logging)

1) Set the following parameters in file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf
OraLogMode [oracle|odl|apache]
OraLogSeverity <message type>:<message level>

Message level: 1-32 (1 most severe, 32 least)
2) Bounce the apache
3) Try to access the home URL or reproduce the issue.
4) Collect the logfiles from $LOG_HOME/ora/10.1.3/Apache/oracle

OC4J Logging

By default Oracle Applications R12 creates 3 OC4J instances:
*  OACore: runs OA Framework-based applications
* Forms: runs Forms-base applications
* OAFM (Oracle Apps Fusion Middleware): runs web services, mapviewer, ascontrol

Loglevel is set in the file
$ORA_CONFIG_HOME/10.1.3/j2ee/<oacore, forms, oafm>/config

Log file path is specified in the file
$ORA_CONFIG_HOME/10.1.3/j2ee/<oacore, forms, oafm>/application-deployments/<oacore, forms, oafm>/orion-application.xml

1) Open the file to set the following log level $ORA_CONFIG_HOME/10.1.3/j2ee/<oacore, forms, oafm>/config/j2ee-logging.xml
2) Come to the location located as
“<logger name=’oracle’ level=’NOTIFICATION:1‘ …..
3) Set the desired logging using following values
<message type>:<message level>
Message level: 1-32 (1 most severe, 32 least)
4) Locate the log file path from the file
$ORA_CONFIG_HOME/10.1.3/j2ee/<oacore, forms, oafm>/application-deployments/<oacore,forms,oafm>/orion-application.xml
(Will be identified with tag : <log> <file path=…> </log>)
5) Bounce the OC4J instance and reproduce the issue
6) Collect the log files from the following locations .
Plain text -> $LOG_HOME/ora/10.1.3/j2ee/<oacore, forms, oafm>/<oacore,forms,oafm>_<default_group_1>/application.log
ODL Log -> $LOG_HOME/ora/10.1.3/j2ee/<oacore, forms, oafm>/<oacore,forms,oafm>_<default_group_1>/log.xml

OPMN Logging

1) Open the file $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml to set the logging parameter
2) Logging is enabled per component (internal, ons or pm)
3) Levels that can be set are (component codes) as following:
none, fatal, error, warn, notify          (written to .log)
debug1, debug2, debug3, debug4    (written to .dbg)
Ex :
opmnctl set target=log comp=warn
opmnctl set target=debug comp=debug1
4) Bounce opmn services and reproduce the issue
5) Collect the opmn log files generated in $LOG_HOME/ora/10.1.3/opmn
opmn.log , opmn.dbg and opmn.out

NOTE : Logfiles can be enabled for rotation using parameter s_opmn_log_rotation_size, s_opmn_log_rotation_time in opmn.xml

Various Other Logfiles :


Service Logfile Name
TNS Listener Start/Stop log adalnctl.txt
Fulfillment Server Start/Stop log jtffmctl.txt
Oracle HTTP Server start/stop log adapcctl.txt
Concurrent Managers and ICM start/stop log adcmctl.txt
Forms OC4J start/stop log adformsctl.txt
OACore OC4J start/stop log adoacorectl.txtq
OAFM OC4J start/stop log adoafmctl.txt
OPMN start/stop log adopmnctl.txt

Posted in Oracle Apps R12 | Tagged: , , , , | Leave a Comment »

R12 – Changing APPS password

Posted by Srikrishna Murthy Annam on September 24, 2009

Changing APPS password

There are some situations where you may need to change the apps password. Some times you may or may not know the apps password. And some times the password may be reset if it is corrupted.

Action Steps ( when you know the old apps password )
1) Shutdown all the MT services
2) Change apps password using FNDCPASS
FNDCPASS apps/[oldpasswd] 0 Y system/pwd SYSTEM APPLSYS <new_pwd>
3) Run autoconfig
4) Startup all the MT services

Action Steps ( when you forgot/dont know the apps password)
Follow metalink Note 160337.1 to change the apps password and then run autoconfig.

Encrypted Passwords details :

SQL> select oracle_username,encrypted_oracle_password from fnd_oracle_userid where oracle_username IN (‘APPS’, ‘APPLSYS’,’APPLSYSPUB’);
SQL> select encrypted_foundation_password, encrypted_user_password from fnd_user where user_name = ‘SYSADMIN’;

Posted in Oracle Apps R12 | Tagged: , , | 1 Comment »

Application R12 Installation

Posted by Srikrishna Murthy Annam on September 19, 2009

R12 Installation

Ref Note : 402310.1

This slideshow requires JavaScript.

Assuming that i am installing applications on linux machine.

1) Check the system requirements

software requirements -> ar , gcc ,g++ , ld , ksh , make , X Display Server
Memory Requirements  -> 1 GB RAM

Disk Space Requirement -> 200 GB

2) Create OS user accounts ( oracle , applmgr )

# id oracle
uid=1000(oracle) gid=1001(dba) groups=1001(dba)
# id applmgr
uid=1003(applmgr) gid=1001(dba) groups=1001(dba)

3) Setup Stage area and copy the software to the stage area

# pwd
# ls
oraAppDB  oraApps  oraAS  oraDB  startCD

4) Start the Rapid Install ( as root user)

# cd /u01/stage/startCD/Disk1/rapidwiz
# ./rapidwiz

5) Screen shots.

6) Change the ownership of the directories

#chown -R oracle:dba <database base directory>
#chown -R applmgr:dba <applications base directory>

R12Install_1 R12Install_2





Then check the Login URL.

Default username and passwords: sysadmin/sysadmin ; apps/apps

Disk space requirement for 11i and R12

For 11i

Applications node file system (includes iAS/8.0.6 ORACLE_HOME, COMMON_TOP, and APPL_TOP) 26 GB
Database tier file system (fresh install with a production database)  OR

Database tier file system (fresh install with a Vision Demo database)31 GB

65 GBTotal space for a single node system, not including stage area57 GB for a fresh Install with a production database
91 GB for a fresh install with a Vision Demo

For R12

Applications node file system (includes OracleAS 10.1.2 ORACLE_HOME, OracleAS 10.1.3 ORACLE_HOME, COMMON_TOP, APPL_TOP, and INST_TOP) 28 GB (40 GB on HP-UX Itanium)
Database node file system (Fresh install) 45 GB
Database node file system (Vision Demo database) 133 GB (145 GB on HP-UX Itanium)

Posted in Oracle Apps R12 | Tagged: , , | Leave a Comment »

R12 FileSystem Architecture

Posted by Srikrishna Murthy Annam on September 19, 2009

R12 FileSystem Architecture

The new file system enables Oracle Applications files to be placed into one of the following categories, and located accordingly:
1) Data
2) Code
3) Configuration

Configuration files are typically modified more frequently than code and data files, so keeping them separate from these other types of file simplifies maintenance


R11i Location

R12 Location

APPL_TOP $HOME/appl $HOME/apps/apps_st/appl
COMMON_TOP $HOME/comn $HOME/apps/apps_st/comn
ORACLE_HOME $HOME/ora/8.0.6 $HOME/apps/tech_st/10.1.2
IAS_ORACLE_HOME $HOME/ora/iAS $HOME/apps/tech_st/10.1.3
ORACLE_HOME $HOME/db/10.2.0 $HOME/db/tech_st/10.2.0
ORADATA $HOME/data $HOME/db/apps_st/data
INST_TOP N/A $HOME/inst/apps/context_name

Imp PATHS Comparision

File or Variable R11i R12

Source File

APPSORA.env APPS.env, which executes:



Context File $APPL_TOP/admin/$TWO_TASK.xml $APPL_CONFIG_HOME/admin/$TWO_TASK.xml
OA_HTML $COMMON_TOP/html $COMMON_TOP/webapps/oacore/html
FND_SECURE $FND_TOP/secure/<SID>/ $INST_TOP/apps/fnd/12.0.0/secure/
ADMIN_SCRIPTS_HOME $COMMON_TOP/admin/scripts// $INST_TOP/admin/scripts/
LOG_HOME $APPL_TOP/admin//logs/ $INST_TOP/logs
FORMS_WEB_CONFIG_FILE N/A $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg

R12 File system architecture_1
Scripts :

Script Function Run AutoConfig Stop all services Start all services Start/stop/status Apache Start/stop/status OC4J Forms Start/stop/status OC4J oacore Start/stop/status OPMN Start/stop RPC listeners (FNDFS/FNDSM) Start/stop Concurrent Manager Start/stop FNDSM Start/stop Fulfillment Server Cloning preparation script Start/stop/status of OC4J Execute SQL scripts that update profiles in AutoConfig run Used to call Java with additional arguments (OPMN, CM)

LogFiles and Loc :

Log File Name Log File Location
AD script log files (e.g.from $INST_TOP/logs/appl/admin/log
CM Log Files ($APPLCSF/$APPLLOG) $INST_TOP/logs/appl/conc/log
AD tools log files (e.g. ADPATCH) $APPL_CONFIG_HOME/admin/$TWO_TASK/log
OPMN Log Files (text and ODL) $ORA_CONFIG_HOME/10.1.3/opmn/logs (may move to  $INST_TOP/logs/10.1.3/opmn)
Apache Log Files (text and ODL) $INST_TOP/logs/10.1.3/Apache/
OC4J Log Files (text) $INST_TOP/logs/10.1.3/j2ee/oacore/
OC4J Log Files (ODL) $INST_TOP/logs/10.1.3/j2ee/oacore/log/oacore_default_group_1/oc4j

Important configuration files :

Opmn.xml — > Details of all OC4J instances deployed and also log location.

Server.xml — > Details of all applications deployed under OC4J.
Paths to J2EE logging , RMI config files , JMS config files.

orion-applications.xml — > Details of all web modules deployed under that application.

orion-web.xml — > Details of all servlets aliases and their mapping to servlets classes.

Appsweb.cfg — > $ORA_CONFIG_HOME/10.1.2/forms/server

Posted in Oracle Apps R12 | Tagged: , , , , , , , | Leave a Comment »