ravindra: February 2014

Installation log files Location:

DB Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME

APPs Tier

$APPL_TOP/admin/$CONTEXT_NAME/log

Apache Server:-

Apache Server
Configuration File	$IAS_ORACLE_HOME/Apache/Apache/conf httpd.conf ==> main configuration file (to identify port number also) httpd_pls.conf ==> plsql integration in the web server apps.conf ==> used to define aliases in URL access oracle_appache.conf==> used to include other configuration files	$INST_TOP/ora/10.1.3/Apache/Apache/conf httpd.conf apps.conf oracle_appache.conf
Log file	$IAS_ORACLE_HOME/Apache/Apache/logs access_log error_log	$LOG_HOME/ora/10.1.3/Apache
Status check	ps –ef\|grep –i <SID> \|grep –i Apache netstat –a \|grep <webport number> ps –ef\|grep httpd
Version check	$IAS_ORACLE_HOME/Apache/Apache/conf httpd -v ==> to find the version of Apache version
Jserver	$IAS_ORACLE_HOME/Apache/Jserv/etc jserv.conf ==> used to configure jvm’s jserv.properties ==>used to set the properties of oacore jvm jserv_restrict.properties zone.properties $IAS_ORACLE_HOME/Apache/Jserv/conf jserv.secret.key ==> jserv configuration file. $IAS_ORACLE_HOME/Apache/Jserv/logs mod_jserv.log	There is no Jserver replaced by OACORE
Script & log	$COMMON_TOP/admin/scripts/<context name> adapcctl.sh [start/stop/status] $COMMON_TOP/admin/logs/<context name> adapcctl.txt ==> is log file for Apache script
Apps password	$IAS_ORACLE_HOME/Apache/modplsql/cfg wdbsvr.app==> this file contains your dad (database Access descriptor) information like database connection description & apps username and password in text.
plug-in	$IAS_ORACLE_HOME/Apache/jdk/jre/plugin/i386/ns610-gcc32
Plug-in version check	ps –ef\|grep sun_plugin_version $CONTEXT_FILE
Common Problems in Starting Apache	Could not bind port (Port already in Use) Found .pid file (When Apache starts it creates .pid file in logs directory and when you shutdown apache it cleans this .pid file so if this file is already there then Apache will not start. Fix: Simply move this file Mobile is enabled in zone.properties disable it if you are not using it. If there is no error messages in error_log or error_log_pls then there might be issues in starting Jserv component of web server ( which caters Java requests by mod_jserv)

FORM Server
Configuration File	$COMMON_TOP/html/bin apps.cfg appsweb_<context name>.cfg==> main configuration file for form server $FND_TOP/resource/ appsweb_<context name>.cfg
Scripts	COMMON_TOP/admin/scripts/<Context name> adfmctl.sh ==> starts form server listener process adfmsctl.sh ==> starts forms Metrics client adfmcctl.sh ==>
Process identifications	ps -ef\|grep f60 ps –ef\|grep f60srvm ==> forms server ps –ef\|grep f60webmx ==> forms Runtime Client
Application profile names	1. icx: forms launcher 2.Forms Run time parameter
Trouble Shooting	1. Check whether FORMS60_MAPPING in $APPL_TOP/SID.env is set to correct URL or not. 2. Check whether server Port, server Name and domain Name are correctly set in 3.Configuration errors in $COMMON_TOP/html/bin/appsweb_SID_Hostname.cfg file.

Report Server
Configuration file	$ORACLE_HOME report60_server
Log file	$ORACLE_HOME/report60/server REP60_<SID>.log CGIcmd.dat
Scripts	COMMON_TOP/admin/scripts/<context name> adrepctl.sh [start/stop]
Process identification	ps –ef\|grep rwmts60
Trouble shooting	Check password in CGIcmd.dat (ORACLE_HOME/report60/server) & Display variable in ORACLE_HOME/report60_server, DISPLAY variable in Jserv/etc as well

Discover Server
Configuration

Code generator:-

It means form binaries (.fmb) are convert to the form executables (.fmx)

Syntax:

$ f60gen MODULE=<XXX.fmb> USERID=<apps user name>/<apps password>

OUTPUT_FILE=<location of fmx file>

In R12

$frmcmp_batch Module=FNDFMFUN.fmb Module_Type=FORM userid=apps/apps Output_File=/u01/applravi/apps/apps_st/appl/fnd/12.0.0/forms/US/FNDFMFUN.fmx

Concurrent Managers:

These are used to run Reports.

Concurrent Manager is a background process which manages the concurrent Requests.

Types of Concurrent Managers

ICM (Internal Concurrent Managers)

SM (Standard Manager)

CRM (Conflict Resolution Manager)

ICM: This is the master manager because it was monitoring the other concurrent managers.

The main function of the ICM are to startup and shutdown the individual concurrent managers, and reset the other managers.

SM: This was also be a master concurrent manager because it was run any reports and batch jobs that have not been to run in any specific product manager.

CRM: To check concurrent program definition for incompatibility rules. (to resolve incompatibilities)

Tuning the ICM:

The ICM performance is affected by 3 important oracle parameters. They are

PMON cycle: This is the number of sleep cycles that the ICM waits between the time it checks for concurrent managers failures, which defaults 20.
Queue Size: The queue size is the number of PMON cycles that the ICM waits between checking for disabled or new concurrent managers. Default queue size is ‘1’.
Sleep Time: The sleep time parameter indicates the seconds that the ICM should waits between checking for requests that waiting to run. Default sleep time is 60 seconds.

$FND_TOP/sql
afcmstat.sql	Displays all the defined managers, their maximum capacity, pids and their status
afimchk.sql	Display the status of ICM and PMON method in effect, the ICM’s log file, and determines if the concurrent manager monitor is running.
afcmcreq.sql

How to trace concurrent program:-

A. Startup/Shutdown Log files for Application Tier in R12
i) Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt… :

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

ii) Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web) :

$INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log)
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

B. Log files related to cloning in R12
=======================================
Preclone (adpreclone.pl) log files in source instance

i) Database Tier-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_.log)
ii) Apps Tier – $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_.log)

Post-Clone (Adcfgclone.pl) log files in target instance

i) Database Tier- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
ii) Apps Tier – $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log

If your clone on DB Tier fails while running txkConfigDBOcm.pl ( Check metalink note – 415020.1)
During clone step on DB Tier it prompts for “Target System base directory for source homes” and during this you have to give like /base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0

C. Patching related log files in R12
======================================
i) Application Tier– adpatch log – $APPL_TOP/admin//log/

ii) Developer (Developer/Forms & Reports 10.1.2) Patch – $ORACLE_HOME/.patch_storage

iii) Web Server (Apache) patch – $IAS_ORACLE_HOME/.patch_storage

iv) Database Tier opatch log – $RDBMS_ORACLE_HOME/.patch_storage

D. Autoconfig related log files in R12
========================================
i) Database Tier Autoconfig log :

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

ii) Application Tier Autoconfig log -

$INST_TOP/apps/$CONTEXT_NAME/admin/log//adconfig.log
. R12 Installation Logs
==========================
Database Tier Installation logs:

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Application Tier Installation logs :

$INST_TOP/logs/.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/logs/ora/10.1.2/install/make_.log
$INST_TOP/logs/ora/10.1.3/install/make_.log
$INST_TOP/admin/log/ApplyAppsTechStack.log
$INST_TOP/admin/log/ohclone.log
$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log
$APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log
$APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log

Inventory Registration logs :

/logs/cloneActions.log
/logs/oraInstall.log
/logs/silentInstall.log

F. Other log files in R12
=========================
1) Database Tier

How to find location of Install, Autoconfig, Patching , Clone and other logs in R12 [ID 804603.1]

ADPATCH:

Patch Drivers:

A patch may contain one or more driver files.

A patch contains one single

Put it database in Maintenance Mode:

Applying the ADPATCH:-

Manual Database Creation in 10g:

step 1: create Directory structure.

mkdir -p /apps/prod/oradata
mkdir -p /apps/prod/admin/{arch,scripts,network,bdump,cdump,udump}

step2: Give the permissions.

chown -R oracle:dba /apps/prod
chmod -R 777 /apps/prod

Step3: export variables

export ORACLE_HOME=/apps/oracle/product/10.2.0
export PATH=$ORACLE_HOME/bin:$PATH
export LD_ASSUME_PATH=$ORACLE_HOME/lib:$PATH

export TNS_ADMIN=/apps/prod/admin/network
export ORACLE_SID=prod

Step4: create parameter file

[oracle@ravi ~]$ cd $ORACLE_HOME/dbs
[oracle@ravi dbs]$ vi initprod.ora

prod.__db_cache_size=369098752
prod.__java_pool_size=4194304
prod.__large_pool_size=4194304
prod.__shared_pool_size=142606336
prod.__streams_pool_size=0
*.background_dump_dest='/apps/prod/admin/bdump'
*.compatible='10.2.0'
*.control_files='/apps/prod/oradata/control01.ctl'
*.core_dump_dest='/apps/prod/admin/cdump'
*.db_block_size=4096
*.db_name='prod'
*.log_archive_dest='/apps/prod/admin/arch'
*.log_archive_format='redo_%s_%r_%t.arc'
*.sga_target=500M
*.undo_management='auto'
*.undo_tablespace='undotbs'
*.user_dump_dest='/apps/prod/admin/udump'

Step5: start the database in nomount state.

SQL> STARTUP NOMOUNT

Step6: create database creation script.

create database prod
datafile '/apps/prod/oradata/system01.dbf' size 300M
sysaux datafile '/apps/prod/oradata/sysaux01.dbf' size 200m
undo tablespace undotbs datafile '/apps/prod/oradata/undotbs01.dbf' size 100m
default temporary tablespace temp tempfile '/apps/prod/oradata/temp01.dbf' size 100m
default tablespace userdata datafile '/apps/prod/oradata/userdata01.dbf' size 400m
logfile
group 1 '/apps/prod/oradata/redo1a.log' size 30m,
group 2 '/apps/prod/oradata/redo2a.log' size 30m
character set UTF8;
~

Step6: run the post scripts like

@?/rdbms/admin/catalog.sql ------> create Indexes
@?/rdbms/admin/catproc.sql ------> packages are create
connect system/manager
@?/sqlplus/admin/pupbld.sql

Note: by using OMF (oracle Managed files) doesn't create directories manually automatically create those locations will be write in p-file.

db_create_file_dest ---> to specify the CRD files.

Reasions for DB creation errors:

If physical files are not there.
Database is Inconsistent.

Errors:

ora-01092- signalled during: alter database open...

Sol: check Undo_tablespace prameter and undo tablespace names are same or not.

ravindra

Wednesday 5 February 2014

Application Files Location

Sunday 2 February 2014

Database creation

change logo in Oracle login page