Monday, March 16, 2009

R12 OA framework: common questions

1)How to enable log in R12?

Since there is no Jserv as in 11i, there is no more dependency on jserv.properties file for enabling of log.Here are the details how to enable log on R12:

In R12,Goto $ORA_CONFIG_HOME/10.1.3/opmn/conftake the backup of opmn.xmledit opmn.xml for data id="java-options" and add the following:-DAFLOG_ENABLED=true -DAFLOG_LEVEL=statement-DAFLOG_MODULE=fnd%-DAFLOG_FILENAME=/tmp/aflog.txt -Djbo.debugoutput=console

The log message should get written in,

$INST_TOP/logs/ora/10.1.3/opmn/oacore_default_group_1/oacorestd.out

2)How to add custom classpath in OC4J server classpath ?

Add an entry in,
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/orion-application.xml

prepending the existing library path.


4)Steps for Manual compilation of jsp in R12.

> cd $FND_TOP/patch/115/bin
> ojspCompile.pl --compile -s hello.jsp

5)DBC file location in R12:

$INST_TOP/appl/fnd/12.0.0/secure

6)Bouncing OC4J server, for OAF to pick latest class and xml files.

In R12, there are two scripts which need to run to bounce the HTTP server and make OC4J container pick latest class files instead of one as in 11i, we only need to run adapcctl.sh shell script to bounce Apache Jserv.
Since in R12 Jserv is replaces by OC4J container, we need to run two scripts:

1)Script which is responsible for bouncing Oracle HTTP Server (powered by Apache).(adapcctl.sh)

2)Script which responsible for bouncing OC4J container (adoacorectl.sh)
So basically, here is the sequence of steps you need to do :
1)adapcctl.sh stop
2)adoacorectl.sh stop
3)adapcctl.sh start
4)adoacorectl.sh start

All these scripts are in $ADMIN_SCRIPTS_HOME

1 comment:

Unknown said...

oh, have you heard about the service of repair sql the lsn passed to log scan in database restore? it is the fastest way to open not accessible files