Tablespace & Data files

 Hi I ve presented here collection of Oracle Database quarries for better quarrying in working environment.

Link : http://appsvista.blogspot.com/2011/01/tablespace-files.html

Forms Compilation in R12

1. Log into the forms tier.

2. Set the applications environment

3. Ensure that the $FORMS_PATH

SQL> !echo $FORMS_PATH

/d02/testapps/TEST/apps/apps_st/appl/au/12.0.0/resource:

/d02/testapps/TEST/apps/apps_st/appl/au/12.0.0/resource/stub

4. Customization Forms Compilation:

  frmcmp_batch module=$AU_TOP/forms/US/xxxx.fmb
  userid=apps/****
  output_file=$ONT_TOP/forms/US/xxxx.fmx module_type=form compile_all=special
  batch=yes

Browser Issues

Hi friend 

             I m Using  Internet Explorer Browser and pls find the bellow info if the Browser getting issue to access the Oracle Application.

For Knowing the IE Version

ü  Help Menu->About-> it will provide the IE Version with details.

For Access the oracle Application through URL

Step 1:
            Change the LAN settings in IE

            Tools->InterneOptions->Conections->LAN Settings->Addvanced Settings

             Here u need to enter the home_url like *erp.testorale.com* if it is one more url u can add the url *erp.testoracle.com*;*erp.oracletest.com* in Do not use proxy server for address begin with box

 Step 2:
             Change the IP Address in host file

             Go to this location C:\WINDOWS\system32\drivers\etc\ and open the host file and Change the values

          102.54.94.97    testoracle.com              # source server

          38.25.63.10      oracletest.com              # x client host

           Once u changed then I.E is allowing to the to connect the ur preferred    Server. If it also not connecting check the host file weather it was saved the   the values or not. Sometimes due to the Read only mode the values may not be changed so before to do that u need to be remove the Read only mode and try to do connect. If it s worked then u can put the host file in Read-only Mode.

Step3:

ü                     In your internet Browser select Tool -> internet Option -> Advanced and check "Enable third party extension", make sure the flag is off. Close your browser and start Oracle again, see if it works.

ü      Remove your popup blockers for the Oracle site (under Tool -> Popup Blockers).

ü      Set your browser with 'Medium' Security Setting: Select Tools -> Internet Options -> Security tab and set the 'Security Level for this Zone' to 'Medium' if it is not set already.

ü      Add this site to your trusted site list: Select Tools -> Internet Options -> Security tab -> Trusted Sites icon -> Sites button .

ü     If that does not work, from your "Start" menu, select Setting -> Control panel -> Add or remove Program and de-install jInitiator. It will automatically re-install itself when you start Oracle again.

Step 4:
ü      Tools - Manage Add-ons - Enable or Disable Add-ons

ü      In Show option - "Add-ons that have been used by Internet Explorer

      "Select from the list and check for Name "Windows Live ...." ,Flash9e.ocx & Google Toolbar1.dll

 ü  Select "Disable" option

 ü  Close all the Internet explorer browser sessions. Restart the client machine.

Step 5

ü   Open Internet Explorer --> Tools --> Internet Options --> Security --> Local Intranet --> Custom Level"Initialize and Script ActiveX controls not marked as safe” should be PROMPT

ü     "ActiveX controls and plubg-ins" should be  ENABLE

ü      "Download unsigned ActiveX controls" should be PROMPT

ü      Close All Internet Explorers and Retest the issue.

Step 4
            ü  Disable “Enable third-party browser extensions [requires restart]

       ü  Navigation: Tools à Internet Options à Advanced à Uncheck ‘Enable third-party browserextensions[requires restart]’

Versions Checking In Oracle Apps

Application Version:

Ø  select release_name from fnd_product_groups;

Apache Version:

Ø     $IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

Java Version:

Ø  $ORACLE_HOME/jdk/bin/java –fullversion

Perl Version:

Ø  perl –version

Workflow Version:

Ø  Select wf_core.translate ('WF_VERSION') from dual;

Database Version:

Ø  select version from v$instance;

Forms version:      

Ø  $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

PL/SQL Version:

Ø  $ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

JRE version:

Ø  cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

OPATCH Version:

Ø  opatch –version

OS Version:

Ø  cat /etc/redhat-release

File Version:

Ø  adident Header <file name>

Login URL:

Ø  grep s_login_page TEST_test.xml

Ø  select home_url from icx_parameters;

Platform 32bits/64bits:

Ø  file $ORACLE_HOME/bin/oracle

Language Information:

Ø  select nls_language,language_code,installed_flag from apps.fnd_languages where installed_flag in ('I','B');

Forms communication mode (Servlet or Socket):

Ø  cat $FORMS_WEB_CONFIG_FILE|grep serverURL=

echo ""If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet

Oracle Applications R12 Log Files Locations

Hi  Everybody

           

            Welcome to My Apps Vista Blog. I ve listed the log files which are useful for Troubleshooting the Oracle Applications. Have a look this.

Installation logs:

Database Tier :

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_<MMDDHHMM>.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_<MMDDHHMM>.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_<SID>.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_<MMDDHHMM>.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/adconfig.log

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/NetServiceHandler.log

Application Tier :

$INST_TOP/logs/<MMDDHHMM>.log

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log

$INST_TOP/logs/ora/10.1.2/install/make_<MMDDHHMM>.log

$INST_TOP/logs/ora/10.1.3/install/make_<MMDDHHMM>.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_<MMDDHHMM>.log

$APPL_TOP/admin/$CONTEXT_NAME/log/<MMDDHHMM>/adconfig.log

$APPL_TOP/admin/$CONTEXT_NAME/log/<MMDDHHMM>/NetServiceHandler.log

Inventory Registration :

<Global Inventory_location>/logs/cloneActions<timestamp>.log

<Global Inventory_location>/logs/oraInstall<timestamp>.log

<Global Inventory_location>/logs/silentInstall<timestamp>.log

Startup/Shutdown Log files

Application Tier

Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…

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

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)

Autoconfig log files

Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/adconfig.log

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/NetServiceHandler.log

Application Tier

$INST_TOP/apps/$CONTEXT_NAME/admin/log/<MMDDHHMM>/adconfig.log

Context File Location:

$INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml

Patching log Files:

Application Tier

adpatch log - $APPL_TOP/admin/$SID/log/

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

Web Server (Apache) patch - $IAS_ORACLE_HOME/.patch_storage

Database Tier

opatch log - $ORACLE_HOME/.patch_storage

Cloning Files:

Source Instance Logs

Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

Application Tier

$INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)

Target Instance Logs
Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.log

Application Tier 

$INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_<time>.log

Clone Context Files:

Database Tier:

$ORACLE_HOME/appsutil/clone/bin/CloneContext_MMDDHHMM

Application Tier:

$COMMON_TOP/clone/bin /CloneContext_MMDDHHMM

Other Log Files:

Application Tier

$ORACLE_HOME/j2ee/DevSuite/log
$ORACLE_HOME/opmn/logs
$ORACLE_HOME/network/logs

Tech Stack Patch 10.1.3 (Web/HTTP Server)
$IAS_ORACLE_HOME/j2ee/forms/logs
$IAS_ORACLE_HOME/j2ee/oafm/logs
$IAS_ORACLE_HOME/j2ee/oacore/logs
$IAS_ORACLE_HOME/opmn/logs
$IAS_ORACLE_HOME/network/log
$INST_TOP/logs/ora/10.1.2
$INST_TOP/logs/ora/10.1.3
$INST_TOP/logs/appl/conc/log
$INST_TOP/logs/appl/admin/log