Bas Klaassen
(0 comments, 13 posts)
This user hasn't shared any profile information
Posts by Bas Klaassen
Custom sql scripts in OAM
I noticed Oracle Applications Manager has some very handy sql script you can use when monitoring your EBS environment.
When starting up OAM, navigate to Site Map —-> Monitoring —-> SQL Extensions
The following scripts are available…
invalid oraInventory in Oracle e-Business Suite
The oraInventory that was incomplete was the global oraInventory. I noticed that the local oraInventory in the $IAS_HOME was complete, but running the patch with this oraInventory did not work. Something about the oraInventory…
In the file oraInst.loc (usually in the /var/opt/oracle directory), the location of the global oraInventory is shown. In the global oraInventory you find the installed ORACLE_HOMES and in the ORACLE_HOME you find the local oraInventory for that ORACLE_HOME.
I find out n Metalink that the global oraInventory can be restored if the local oraInventory is valid.
The perl script OUIsetup.pl in the $ORACLE_HOME/appsoui/setup (IAS_HOME) directory can be used to recreate the global oraInventory.
After recreating the global oraInventory the http patch was successfully applied.
Autoconfig templates ?
The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files so the EBS can work properly. When you want to add customizations the a template, you place that template in the ‘custom’ directory in the $product_top/template, and autoconfig uses this custom template instead of the default Oracle template…
But how do you know which templates are customized ?
I ran into the following script in the $AD_TOP/bin directory…. adtmplreport.sh
Use the following syntax
./adtmplreport.sh contextfile= ‘path to your contextfile’
And you get a report with all the templates used by autoconfig, the target directory and if there is a custom version of the template. Very nice script…
So for example the adovars.env file and its custom version…
TEMPLATE FILE : /opt/software/applmgr/EBS/appl/ad/11.5.0/admin/template/adovars_ux.env
TARGET FILE : /opt/software/applmgr/EBS/appl/admin/adovars.env
TEMPLATE FILE : /opt/software/applmgr/EBS/appl/ad/11.5.0/admin/template/APPLSYS_ux.env
CUSTOM TEMPLATE : /opt/software/applmgr/EBS/appl/ad/11.5.0/admin/template/custom/APPLSYS_ux.env
TARGET FILE : /opt/software/applmgr/EBS/appl/EBS_ebs-p01.env
Oracle E-Business Suite R12 with OEM10G
After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G.
Before I could configure R12 in OEM10G, I first had to upgrade the Oracle Applications plugin for EM10GR3. I downloaded the patches p5489352_R12_LINUX.zip and installed this patch on the OMS_HOME and in the local AGENT_HOME’s (11i and R12 agent). For R12 also patch p5843357_R12[1].OAM.A_R12_GENERIC.zip was installed…After applying the patch, my first 11.5.10 configuration didn’t work anymore, so I had to rediscover both R12 and 11i again. (more…)
First patch for Oracle E-Business Suite R12
This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of them (patch p5856453_R12[1].AD.A_R12_LINUX.zip). I could not help feeling a little bit excited, because patching is changed in EBS R12.
The manual steps to be taken before patching are removed from the readme and placed into an xml file. Before patching you are supposed to run a new perl script called $AD_TOP/bin/admsi.pl
This script creates an install_{patch_number}.html. After performing the steps in the html file, you have to run $AD_TOP/bin/admsi.pl –done (to let the system know you have performed the manual steps….). The admsi.pl also creates a custom readme which you have to read before patching.
I was a little bit disappointed, because the patch I downloaded is maybe to small. Nothing about admsi.pl in the readme…Tried to run admsi.pl anyway
Installing Oracle E-Business Suite R12
So, I finally installed the new EBS 12i release. I had to install with an empty database, because of disk space limits…
But the important thing is that the installation was successful.
Some first impressions…
- the look and feel changed (we had already seen some previews..)
- some strange options when logging in the application ??
- the database is twice as big (10g vs 9i)
- new technology stack
- new instance top
I also faced a first problem. I could not startup the application in my Microsoft explorer..The java console showed the login was hanging on the appslogo_new.gif ??
I found out that when I deactivated my Oracle Dba Toolbar in the explorer, I could enter the application without any problem. But when activating the toolbar again..the login process was hanging again on the same gif. Strange…the toolbar was downloaded from OTN and is something Oracle brought to my attention… I wonder if this is a known issue….
I also saw the dbc file is now in the instance top directory. Strange, because the path to the dbc file seems the same, /appl/fnd/12.0.0/secure….but this is not in the APPL_TOP, but in the INSTANCE_TOP (inst/apps/PROD_vamisux34).
A simple ls command in the INSTANCE_TOP shows..
[oracle@vamisux34 PROD_vamisux34]$ ls
admin appltmp conf_PROD.txt logs ora pids rgf
appl certs conf_PROD.txt.bac ocm out portal temp
The admin directory contains the scripts directory, where all the start/stop scripts are located.The appl directory shows us
[oracle@vamisux34 appl]$ ls
admin fnd
where fnd holds the dbc file and the admin directory contains the xml file.
More to come….
Sizing Oracle EBS 12i
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area.
From the stage area I started the rapidwiz to check the required disk space. Here is the required disk space for Oracle EBS 12i :
Database ORACLE_HOME = /ebs/db/tech_st/10.2.0
required = 4234.0
Database System File Directory = /ebs/db/apps_st/data
required = 19487.0
Database Log File Directory = /ebs/db/apps_st/data
required = 3165.0
Database Transaction File Directory = /ebs/db/apps_st/data
required = 66244.0
Database Archive File Directory = /ebs/db/apps_st/data
required = 45061.0
APPL_TOP = /ebs/apps/apps_st/appl
required = 5078.0
APPL_TOP mount 2 = /ebs/apps/apps_st/appl
required = 2639.0
APPL_TOP mount 3 = /ebs/apps/apps_st/appl
required = 4167.0
APPL_TOP mount 4 = /ebs/apps/apps_st/appl
required = 2882.0
COMMON_TOP = /ebs/apps/apps_st/comn
required = 2743.0
Apps ORACLE_HOME = /ebs/apps/tech_st/10.1.3
required = 1553.0
Tools ORACLE_HOME = /ebs/apps/tech_st/10.1.2
required = 1138.0
So, you see the database is much bigger then release 11.5.10.2 (10g vs 9i). Also the new APPL_TOP is a little bigger then the old one.
To check for yourself, here is the required disk space for Oracle EBS 11.5.10.2 (more…)
FNDCPASS ALLORACLE
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin).
To change the APPS password use…
FNDCPASS apps/*** 0 Y system/***** SYSTEM APPLSYS [new_password]
(the apps password is also mentioned in some config files, so you have to change those files manually !!!)
To change any other schema…
FNDCPASS apps/**** 0 Y system/***** ORACLE GL [new_password]
To change the password of a application user
FNDCPASS apps/*** 0 Y system/****** USER SYSADMIN [new_password]
When changing the password of all schemas in the database, you have a lot off FNDCPASS to do…there are almost 200 schemas in the EBS database that need to be changed. Default the password is schema name, so gl/gl and ap/ap…
When installing patch 4676589 (11i.ATG_PF.H Rollup 4) a new feature is added to FNDCPASS. Now you can use the ALLORACLE functionality to change all the schema passwords in one FNDCPASS.
To use the new FNDCPASS feature apply the following patches… ….
1. install AD: Patch 11i.AD.I.4 (patch 4712852)
2. install patch 5452096
Purging timing information for prior sessions.
sqlplus -s APPS/***** @/appl/prodappl/ad/11.5.0/admin/sql/adtpurge.sql 10 1000
Spawned Process 17504
Done purging timing information for prior sessions.
AutoPatch is complete.
AutoPatch may have written informational messages to the file/appl/prodappl/admin/prod/log/u5452096.lgi
Errors and warnings are listed in the log file/appl/prodappl/admin/prod/log/u5452096.log
and in other log files in the same directory.
3. run the Technology Stack Validation Utility
[oracle@ebs2 bin]$ ./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
***STDOUT /appl/prodcomn/rgf/prod_ebs2/TXK/txkValidateRollup_Mon_Jan_8_stdout.log
Reportfile /appl/prodcomn/temp/txkValidateRollup.html generated successfully.
4. run autoconfig
5. apply patch 4676589 (11i.ATG_PF.H Rollup 4, Applications Technology Family)
6. After the install
7. apply patch 3865683 (AD: Release 11.5.10 Products Name Patch)
8. apply patch 4583125 (Oracle XML Parser for Java) see note 271148.1
Verify if the upgrade has been successful..
cd $JAVA_TOP
[oracle@ebs2 java]$ unzip -l appsborg.zip grep 9.0.4
0 04-19-03 02:10 .xdkjava_version_9.0.4.0.0_production
[oracle@ebs2 java]$
if there is an xdkjava_version_9.0.4.0.0_production entry, then XML parser is installed.
9. run autoconfig
Now try the new FNDCPASS function..
[oracle@ebs2 prod_ebs2]$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
Log filename : L2726002.log
Report filename : O2726002.out
[oracle@ebs2 prod_ebs2]$
[oracle@ebs2 prod_ebs2]$ sqlplus apps/apps
SQL*Plus: Release 8.0.6.0.0 – Production on Mon Jan 15 08:50:39 2007
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL> conn gl/welcome
Connected.
SQL> conn ap/welcome
Connected.
SQL>
Upgrading EBS 11i database (9.2.0.6) to 10GR2 database
I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I ran into… 1. The first patch is 5478710 (TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O) After applying the patch make a new appsutil.zip file… [oracle@ebs1 5478710]$ $ADPERLPRG $AD_TOP/bin/admkappsutil.pl Starting the generation of appsutil.zip Log file located at /appl/prodappl/admin/log/MakeAppsUtil_12200852.log output located at /appl/prodappl/admin/out/appsutil.zip MakeAppsUtil completed successfully. After creating the appsutil.zip copy the appsutil.zip to the rdbms ORACLE_HOME and unzip it in this directory. The appsutil.zip should be copied to the new 10g ORACLE_HOME!!!! 2. the parameter aq_tm_processes must be set to 0. According to note 263809.1 (manual upgrades to 10gr1)… Comment out the AQ_TM_PROCESSES parameter, put in a new and set this explicitly to zero, during the upgrade 3. When running catupgrd.sql ERROR at line 1: ORA-06553: PLS-213: package STANDARD not accessible adjust the init.ora. Commend out the following lines.. #plsql_optimize_level = 2 #MP #plsql_code_type = native #MP #plsql_native_library_dir = /prod11i/plsql_nativelib #plsql_native_library_subdir_count = 149 4. Re-create grants and synonyms using adadmin Maintain Applications Database Entities ————————————————— 1. Validate APPS schema 2. Re-create grants and synonyms for APPS schema Following error occurs… declare * ERROR at line 1: ORA-04063: package body "SYSTEM.AD_DDL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.AD_DDL" ORA-06512: at line 19 Seems a known problem according to Metalink. Note 387745.1 brings the sollution… Run utlrp.sql …. [oracle@ebs2 admin]$ sqlplus /nolog SQL*Plus: Release 10.2.0.2.0 – Production on Thu Dec 28 15:39:13 2006 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. SQL> conn sys as sysdba Enter password: Connected. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup upgrade ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 1264892 bytes Variable Size 415236868 bytes Database Buffers 645922816 bytes Redo Buffers 11317248 bytes Database mounted. Database opened. SQL> @utlirp.sql SQL>shutdown SQL>startup SQL>@utlrp.sql Problem solved… Again run adadmin
Changing background in Oracle EBS 11i
It would be nice to have your own company logo as background in the Oracle E-business suite. Default the background is white, but the following steps will put your company logo (or any other logo…) in the background. 1. modify the appsweb.cfg in the $OA_HTML/bin directory. Find the ‘background’ parameter and let it point to your own logo…
colorScheme=blaf lookAndFeel=oracle darkLook=true readOnlyBackground=automatic background=oracle/apps/media/logoamis.gif dontTruncateTabs=true imageBase=CodeBase more_form_params=
2. Place your logo in the $OA_JAVA/oracle/apps/media directory 3. restart the webserver And your logo should be in the background…
Recent Comments