DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, November 20, 2008

Upgradation of Discoverer from 4i to 10g for Applications 11i CU2 (11.5.10.2)

Upgradation of Discoverer from 4i to 10g for Applications 11i CU2 (11.5.10.2)
Environment Details : Operating system : Solaris Sparc 64 Bit (5.10)
Applications : 11i CU2 (11.5.10.2)
Database : 10.2.0.2.0
Oracle AS (Infra and Disc) Installation in TEST Applications
Infra Structure installation in TEST:
1. login to root
2. xhost +
3. echo set semsys:seminfo_semmni=300 >>/etc/system
4. echo set semsys:seminfo_semmns=1024 >>/etc/system
5. echo set semsys:seminfo_semmsl=256 >>/etc/system
6. echo set shmsys:shminfo_shmmax=4294967295 >>/etc/system
7. echo set shmsys:shminfo_shmmin=1 >>/etc/system
8. echo set shmsys:shminfo_shmmni=512 >>/etc/system
9. echo set shmsys:shminfo_shmseg=150 >>/etc/system
10. cd /testapps01/
11. mkdir –p testdisc
12. mkdir –p testdisc/testinfra
13. mkdir –p testdisc/testdis
14. chown –R apptstmgr:dba ./testdisc
15. Login to OS application owner (apptstmgr).
16. cd /Disk1/
17. DISPLAY=192.168.73.168:0.0;export DISPLAY
18. ./runInstaller
19. click next on welcome screen
20. set ORACLE_HOME as /testapps01/testdisc/testinfra and click next in “Specify file
location” screen.
21. Select “Oracle Application Server Infrastructure 10g” and click next in “Select a product
to Install” Screen.
22. Select “Identity Management and Metadata Repository” and click next in “Select
Application Type” Screen.
23. Select “Root Privileges” and click next in “Confirm Pre-Installation Requirements” Screen.
24. Select “Oracle Internet Directory, Oracle Application Single Sign-on, Oracle Application
Server Delegated Administrator” and click next in “Select configuration Options” screen.
25. select “Suggested Namespace” with default values (dc=dummy,dc=co,dc=in) and click
next in “Specify Namespace in Internet Directory” Screen
26. select “Automatic” and click next in “Specify Port Configuration Options” screen
27. Provide Global Database Name = “testinfr.dummy.co.in” , SID=testinfr , select database
character set as English US7ASCII , specify Database File Location
/testapps01/testdisc/oradata/ and click next in “Specify Database Configuration Options”
Screen
28. Select “Use the same password for all the accounts” and enter the password as tester1
And click next in “specify Database Schema Passwords” Screen.
29. Enter the Instance Name as “testinfr”, ias_admin password as tester1, confirm password
as tester1 and click next on “Specify Instance Name and ias_admin Password” screen.
30. click Install on “Summary Screen”
31. After Setup Completion, Installer request to run /testapps01/testdisc/testinfra/root.sh
from root.
32. login to root through another terminal
33. sh /testapps01/testdisc/testinfra/root.sh
34. Accept all the default values prompted by root.sh scripts
35. click ok on installer screen prompted to run /testapps01/testdisc/testinfra/root.sh script
36. Installer will proceed for configuration of database and As Components.
37. After Installation is completed click exit & yes to exit installer.
Details of TEST AS Infrastructure after completion of Installation and configuration of
AS Components
The following information is available in:
/testapps01/testdisc/testinfra/install/setupinfo.txt
Oracle Application Server 10g (10.1.2.0.2) Usernames and Default password information:
Please refer to Oracle Application Server 10g Administrator Guide for more information.
Install Type: Identity Management and Metadata Repository
Configured Components: Oracle Application Server Metadata Repository Oracle HTTP Server
Oracle Application Server Containers for J2EE Oracle Internet Directory Oracle Application
Server Single Sign-On Oracle Application Server Delegated Administration Service Oracle
Application Server Directory Integration and Provisioning
New Database created with these properties:
Database File Location: /testapps01/testdisc/oradata/
Database Global Name: testinfr.dummy.co.in
Database SID:testinfr
Database Name:testinfr
Character Set: -characterset US7ASCII
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://ebstest01.dummy.co.in:7778
-----------------------------------------
Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://ebstest01.dummy.co.in:1156
Instance Name: testinfr.ebstest01.dummy.co.in
Discoverer Structure installation in TEST:
1. login to root
2. xhost +
3. echo set rlim_fd_max=65536 >>/etc/system
4. Login to OS application owner (apptstmgr).
5. cd /Disk1/
6. DISPLAY=192.168.73.168:0.0;export DISPLAY
7. ./runInstaller
8. click next on welcome screen
9. set ORACLE_HOME as /testapps01/testdisc/testdis and click next in “Specify file location”
screen.
10. Select “Oracle Application Server 10g” and click next in “Select a product to Install”
Screen.
11. Select “Business Intelligence and Forms” and click next in “Select Application Type”
Screen.
12. Select “Root Privileges” and click next in “Confirm Pre-Installation Requirements” Screen.
13. Select “Oracle Application Server 10g Discoverer” and click next in “Select configuration
Options” screen.
14. select “Automatic” and click next in “Specify Port Configuration Options” screen
15. Provide password as tester1 for username: cn=orcladmin in “Specify OID Login” Screen.
16. Click next on “Select Oracle Application Server 10g Metadata Repository” Screen.
17. Click next on “Provide Outgoing Mail Server Information” screen (SMTP can be null).
18. Enter the Instance Name as “testdis”, ias_admin password as tester1, confirm password
as tester1 and click next on “Specify Instance Name and ias_admin Password” screen.
19. click Install on “Summary Screen”
20. After Setup Completion, Installer request to run /testapps01/testdisc/testdis/root.sh from
root.
21. login to root through another terminal
22. sh /testapps01/testdisc/testdis/root.sh
23. Accept all the default values prompted by root.sh scripts
24. click ok on installer screen prompted to run /testapps01/testdisc/testdis/root.sh script
25. Installer will proceed for configuration of database and As Components.
26. After Installation is completed click exit & yes to exit installer.
Details of TEST Discoverer after completion of Installation and Configuration of AS
Components
The following information is available in:
/testapps01/testdisc/testdis/install/setupinfo.txt
Oracle Application Server 10g 10.1.2.0.2 Usernames and Default password information: Please
refer to the Oracle Application Server 10g Administrator Guide for more information.
Install Type: All Services
Configured Components: Oracle HTTP Server, Oracle Application Server 10g Containers for J2EE,
Oracle Application Server 10g Web Cache, Oracle Application Server 10g Discoverer,
Registered with Oracle Internet Directory: ebstest01.dummy.co.in:389
Use only SSL connections with this Oracle Internet Directory:No
Database Connection String:
ebstest01.dummy.co.in:1521:testinfr.dummy.co.in:testinfr.dummy.co.in
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://ebstest01.dummy.co.in:7779
-----------------------------------------
Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://ebstest01.dummy.co.in:1810
Instance Name: testdis.ebstest01.dummy.co.in
/testapps01/testdisc/testdis/discoverer/util/pref.txt
Configuration of TEST Discoverer and integrating Oracle Application 11i with 10g
Discoverer
1. login to apptstmgr ( applications manager )
2. scp –rp /testapps01/testappl/fnd/11.5.0/secure/TEST_ebstest01/test.dbc
/testapps01/testdisc/testdis/discoverer/secure/
3. cd /testapps01/testdisc/testdis/network/admin
4. vi tnsnames.ora
5. add the following tns entry in tnsnames.ora
a. TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ebstest01.dummy.co.in)(PORT=1572))
(CONNECT_DATA=
(SERVICE_NAME=test)
(INSTANCE_NAME=test)
)
)
16. login to apptstmgr in another terminal to ebstest01
17. source applications 11i environment file
18. cd $APPL_TOP/admin
19. backup the xml file : scp –rp TEST_ebstest01.xml
TEST_ebstest01_bkp__.xml
20. vi TEST_ebstest01.xml
21. change the following parameters as below:
a. s_disco_standalone = true
b. s_disco_machine = ebstest01.dummy.co.in
c. s_disco_port = 7779
d. s_disco_protocol = http
e. s_disco_ver_comma = 10,1,2
f. s_disco_eul_prefix = EUL
g. s_discostatus = disabled
22. cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
23. stop application services : sh adstpall.sh apps/apps
24. ensure concurrent managers stop completely : ps –efgrep FNDLIBRgrep –v grepwc –l
25. execute autoconfig : sh adautocfg.sh
26. provide the apps schema password : apps
27. After Autoconfig completed successfully, Startup application services :
sh adstrtal.sh apps/apps
28. Login to sysadmin through front end applications
29. Navigate to system administrator responsibility.
30. In System administrator, Navigate profiles à system form. Query the %Discoverer%
profile options. verify the following ICX profile options in Oracle Applications:
a. ICX_DISCOVERER_LAUNCHER =
http://ebstest01.dummy.co.in:7779/discoverer/plus?Connect=[APPS_SECURE]
b. ICX_DISCOVERER_VIEWER_LAUNCHER =
http://ebstest01.dummy.co.in:7779/discoverer/viewer?Connect=[APPS_SECURE]
c. ICX_DISCOVERER_RELEASE = 10
d. ICX_DISCOVERER_USE_VIEWER = Yes
e. ICX_DEFAULT_EUL = EUL
f. ICX_DISCOVERER_EUL_LANGUAGE = American English
g. ICX_DISCOVERER_PARAMETERS =
exitURL=http://ebstest01.dummy.co.in:8051/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE.

Saturday, August 9, 2008

Issue in Preclone process after upgrading 11i with 10g R2

Dear all,

This post is relating to following issue we face after upgrading 11i with 10g R2 in Preclone process of dbTier.

ERROR: The version of the OUI found in $ORACLE_HOME/appsoui () is too low.Please make sure that you have applied the latest OUI patch required by Rapid Clone.

Please apply patch 4766508 Application manager patch following the below process:

i. Enable Maintainence Mode through adadmin
ii. Apply u4766508 patch through adpatch
iii. Disable Maintainence mode through adadmin
iv. Cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME/
v. Sh adautocfg.sh
vi. Provide apps password
vii. $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
viii. cp $APPL_TOP/admin/out/appsutil.zip $RDBMS_ORACLE_HOME ( 10g )
ix. unzip -o $ORACLE_HOME/appsutil.zip
x. cd $ORACLE_HOME/appsutil/scripts
xi. sh adautocfg.sh
xii. provide apps password
xiii. perl adpreclone.pl dbTier

The Same process was also updated in upgrade process document.... you can also refer the same in that post...

Ref Metalink Doc ID: 370136.1

https://metalink.oracle.com/metalink/plsql/f?p=130:14:6769826403964055797::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,370136.1,1,1,1,helvetica

Thanks & Regards,
Narasimha Rao.K

Friday, August 8, 2008

Some ADADMIN Activities Shortcuts

Dear all,


This post is to share some shortcuts for adadmin activities.

To Enable and disable maintainence mode
1. Enable Maintainence mode
sqlplus -s apps/<`apps password`> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

2. Disable Maintainence Mode
sqlplus -s apps/<`apps password`> @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

Will share more in future posts....

Thanks & Regards,
Narasimha Rao.K

Saturday, August 2, 2008

Oracle EBS Apps in MS-Vista

Dear All,

This post is relating to using Vista in EBS.

Info: Vista is certified in Ebs 11i.

Permenant solution : Upgrade Sun Java Plug-in JRE 1.5.0_12

Certified Configurations

Release 11i -- 11.5.10.CU2
Applications 11.5.10 plus Maintenance Pack 11.5.10 CU2 or later
Oracle Developer 6i Patchset 18 (6.0.8.27.x) or later (Metalink Note 125767.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=125767.1)
Oracle Applications Technology 11i.ATG_PF.H Rollup 4 http://blogs.oracle.com/schan/2006/08/latest_ebusiness_suite_technol_1.html (RUP 4) (patch 4676589) or later
Microsoft Vista desktop clients running Internet Explorer 7
Sun Java plug-in (JRE) 1.5.0_12

Release 11i -- 11.5.9.CU2
Applications 11.5.9 plus Maintenance Pack 11.5.9 CU2 or later
Oracle Developer 6i patchset 18 (6.0.8.27.x) or later (Metalink Note 125767.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=125767.1 )
Oracle Applications Technology 11i.ATG_PF.H Rollup 4 http://blogs.oracle.com/schan/2006/08/latest_ebusiness_suite_technol_1.html (RUP 4) (patch 4676589) or later
Microsoft Vista desktop clients running Internet Explorer 7
Sun Java plug-in (JRE) 1.5.0_12

Release 12
Oracle Applications Release 12 with R12.ATG_PF.A.DELTA.3 http://blogs.oracle.com/schan/2007/10/apps_technology_1203_update_no.html (patch 6077669) or later
Microsoft Vista desktop clients running Internet Explorer 7
Sun Java plug-in (JRE) 1.5.0_12.

Temporary solution:
1 - Install JAVA jdk1.6.0_02 - http://java.sun.com/javase/downloads/index.jsp
2 - Put first on PATH variable: C:\Program Files\Java\jre1.6.0_02\bin;
Now a little problem...
In my machine just this not solved the problem, but in another machine was enought.
Then I proceeded the step 3:
Copy the jvm.dll file under C:\Program Files\Java\jre1.6.0_02\jre\bin\client to C:\Program Files\Oracle\Jinitiator\bin\hotspot, where is the jinit version.
The directory bin\client is hidden but exists... :)* Don't forget to backup the original file.
It worked for me.
IMP:** The Above informations are consolidated information from Internet. and Temporary solution has been displayed after testing.**
Thanks & Regards,Narasimha Rao.K

Wednesday, July 30, 2008

Sending Mails through Os( Unix ) with Mailx

Dear All,

This Post is relating to Useful Operating system techniques
to send mails using command : Mailx


1. To send mails with body and without attachments
syntax : cat <`file's full path and name`> mailx -s “<`Subject`>” <`Recipient`>
Example:
cat /home/myname/logs/mylog1.log mailx -s “Test Alert 1” xyz@gmail.com

2. To Send Mails without body and with attachments
syntax :
uuencode <`file's full path and name`> <`file's alias name`> mailx -s “<`Subject`>” <`Recipient`>
Example :
uuencode /home/myname/logs/mylog1.log alert1.log mailx -s “Test Alert 2” xyz@gmail.com

3. To Send Mails with body and attachments
syntax :
( cat <`file's full path and name`> ; uuencode <`file's full path and name`> <`file's alias name`> )
mailx -s “<`Subject`>” <`Recipient`>
Example :
( cat /home/myname/logs/mylog1.log ; uuencode /home/myname/logs/mylog1.log alert1.log )
mailx -s “Test Alert 3” xyz@gmail.com

Thanks & Regards,
Narasimha Rao.K

Monday, June 16, 2008

R12 New Features

Hi,

Please find the Release 12 New features
through the below link.

http://beginapps.blogspot.com/2008/06/release-content-document-release-12.html

Thanks & Regards,
Narasimha Rao.K

Thursday, June 5, 2008

Complete Guide for upgrading oracle applications 11i with 10g R2

Dear All,

Sub: Upgrading oracle applications 11i with 10g R2.
( This ll be the complete guide for upgradation )

1. Complete the Installation of Oracle Apps EBS 11.5.10 ( with 9.2.0.6.0 ) (Production Source).

2. Upgrade AD from Ad.I to AD.I.6 (Apply 6502082 (AD.I.6)).
(a) Cd $JAVA_TOP
(b) unzip -o apps.zip
(c) Convert to multi org
(d) enable Maintainence mode through adadmin
(e) apply the u6502082.drv patch through adpatch
(f) disable Maintainence mode
(g) cp $APPL_TOP/admin/adgrants.sql to $ORACLE_HOME/appsutil/admin/
(h) switch to oracle user
(i) sqlplus '/as sysdba' @$ORACLE_HOME/appsutil/admin/adgrants.sql applsys

3. Upgrade Developer Suite 6i Patchset from Patchset 17 to 18
(document id :125767.1 )

(a) download the latest developer 6i patch (4948577) and interoperability patch (4888294
(b) download the additional developer 6i patches ( 5713544,4261542,5216496,5753922,6195758,5928515)
(c) cd $APPLCSF/scripts/$CONTEXT_NAME/
(d) sh adstpall.sh apps/
(e) apply the 4948577 patch through adpatch.

4. apply the additional developer 6i patches (Cont. Upgrade Developer 6i Process )
I. application of 5713544 patch.
(a) Cd to patch directory
(b) cp genshlib to $ORACLE_HOME/bin
(c) sh patch.sh
(d) adrelink.sh force=y “fnd f60webmx”

II. application of 4261542 patch

(a) unzip the patch in $ORACLE_HOME
(b) cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
(c) cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
$ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542
(d)cd $ORACLE_HOME/4261542/oracle/forms/engine
(e)cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
(f) cd $ORACLE_HOME/4261542/oracle/forms/handler
(g) cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
(h) Generate Jar Files through adadmin [adadmin - Generate Applications Files - Generate product JAR files ].

III. application of 5216496 Patch.

(a) cd $ORACLE_HOME
(b) unzip the 5216496 patch
(c) cd 5216496
(d) cp genshlib $ORACLE_HOME/bin
(e) cd $ORACLE_HOME/lib
(f) cp libiff.a libiff.a.ORG
(g) cp libiff.so.0 libiff.so.0.ORG
(h) cp libiffw.a libiffw.a.ORG
(i) cp libiffw.so.0 libiffw.so.0.ORG
(j) cd $ORACLE_HOME/5216496/opt
(k) ar -rv $ORACLE_HOME/lib/libiff.a ifzprs.o
(l) cd $ORACLE_HOME/5216496/optweb
(m) ar -rv $ORACLE_HOME/lib/libiffw.a ifzprs.o
(n) cd $ORACLE_HOME/lib
(o) $ORACLE_HOME/bin/genshlib iffw 0
(p) $ORACLE_HOME/bin/genshlib iff 0
(q) cd $ORACLE_HOME/forms60/lib
(r) make -f cus_forms60w.mk install

IV. application of 5753922 patch.

(a) Cd 5753922
(b) sh patch.sh
V. application of 6195758 Patch.
(a). cd $ORACLE_HOME
(b). unzip -o p6195758_600_GENERIC.zip
(c). cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG6195758
(d). cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG6195758
(e). cd $ORACLE_HOME/6195758/oracle/forms/handler
(f). cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
(g). cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
(h). Generate Jar Files [ adadmin à Generate Application Files à Generate Product Jar Files ]

Vi. application of 5938515 patch.

(a) cd 5938515
(b) sh patch.sh
(c) adrelink.sh force=y “fnd f60webmx”

5. Relink Application Executables.

(a). adadmin - Maintain Application Files Menu - Relink Application Program

(b). Enter list of products to link ('all' for all products)[all] : fnd
(c). Generate specific executables for each selected product [No] ? y
(d). Relink with debug information [No] ? n
(e). Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund

6. Apply Oracle Applications 11i Developer Interoperability patch

a. Enable the Maintainence Mode through adadmin
b. Apply the u4888294.drv through adpatch
c. Disable the Maintainence Mode

7. Application of Patches for known issues.

(a) cd $ORACLE_HOME
(b) unzip p3182153_600_GENERIC.zip
(c) cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class.PRE_BUG3182153
(d) cd $ORACLE_HOME/3182153/oracle/forms/handler.

(e) cp TextComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class

(f) Generate Jar Files
[adadmin → Maintain Application File Menu → Generate Product Jar Files ]

8. Application of 6372396 ( TXK AUTOCONFIG AND TEMPLATES ROLLUP PATCH S (APRIL/MAY 2008).

(a) source the appplications environment file
(b) cd $XPATCH_TOP/patches/6372396/fnd/patch/115/bin
(c) ./txkprepatchcheck.pl -script=ValidateRollup
-outfile=$APPLTMP/txkValidateRollup.html
-appspass=apps
(d) Review the txkValidateRollup.html
(e) cd $XPATCH_TOP/patches/6372396
(f) enable maintainence mode
(g) apply u6372396.drv patch with adpatch
(h) cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME/
(i) sh adautocfg.sh
(j) $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
(k) cp $APPL_TOP/admin/out/appsutil.zip $RDBMS_ORACLE_HOME
(l) vi $OA_HTML/bin/appsweb.cfg ,and copy the content from “BEGIN CUSTOMIZATION” AND “END CUSTOMIZATION”
(m) vi appsweb_
.cfg and paste the copied content.
(n) 'mv $IAS_ORACLE_HOME/Apache/Apache/logs/sec_audit.log $IAS_ORACLE_HOME/Apache/Apache/logs/sec_audit_
.log
(o) sh adstpall.sh apps/

(p) sh adstrtal.sh apps/


9. 11.5.10 INTEROP PATCH FOR 10GR2 (Application of 4653225 )
(a) enable Maintainence mode through adadmin
(b) apply the u4653225.drv through adpatch
(c) disable Maintainence Mode through adadmin
Installation of 10GR2 Base and Companion binaries

10. Pre Checks for 10GR2 Installation

(1) Set the environment variable ORACLE_HOME=

(2) execute : export PATH=$PATH;$ORACLE_HOME/bin <
>
(3) xhosts +


10G R2 Software Installation

11. Start 10G Base (10.2.0.1) Software Installation

(1) cd database/Disk1
(2) ./runinstaller

(a) Provide the Oracle home Path that distinct from 9i Oracle home.
(b) Install only software ( No New Database Creation Required).
(c) Dont Upgrade database at the time of software installation.



10G R2 Companion CD Installation

12. Install the 10g Database Products by installing 10G R2 (10.2.0.1)

(1) cd database/Disk1
(2) ./runinstaller

Upgrade Oracle 10G database base software to latest oracle 10G database Software
10G R2 (10.2.0.3 )

13. Mandatory Pre Installation Tasks

Set PATH=$PATH:$ORACLE_HOME/bin;$ORACLE_HOME/perl/bin
set LD_LIBRARY_PATH=$ORACLE_HOME/lib
set PERL5LIB=$ORACLE_HOME/perl/lib/
;$ORACLE_HOME/perl/lib/site_perl/


14. Installation of Latest Oracle Database Software

(a). Unzip the 10.2.0.3 Software
(b). cd database/Disk1
(c). ./runinstaller

15. Create nls/data/9idata Directory

(a). perl $ORACLE_HOME/nls/data/old/cr9idata.pl
(b). export $ORA_NLS10=$ORACLE_HOME/nls/data/9idata

16. Additional 10.2.0.3 RDBMS Patches

i.Apply 5257698 Patch
ii.Apply 5892355 Patch
iii.Apply 5871314 Patch
iv.Apply 5755471 Patch


17. Pre Database Upgrade Steps – Database (Perspective )

1.Export ORACLE_HOME=<10g>.
2.Export ORACLE_SID=

3.cp $ORACLE_HOME/rdbms/admin/utlu102i.sql /tmp
4.cd /tmp
5.sqlplus “/as sysdba”
6.startup db
7.spool info.log
8.run $utlu102i.sql
9.spool off
10.Check info.log for any errors and recover the same


18. Pre Database Upgrade steps -- Applications 11i ( Perspective )
appsutil creationcheck whether 9i database is up in running else startup the database
a. login to applmgr
b. $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
c. cp $APPL_TOP/admin/out/appsutil.zip $RDBMS_ORACLE_HOME ( 10g )
d. unzip -o $ORACLE_HOME/appsutil.zip

Listener and tnsnames ( Network ) Resolution

a. login to oracle user
b. cp the tnsnames.ora and listener.ora from 9i TNS_ADMIN to 10g TNS_ADMIN
c. Change the database home in the tnsnames.ora and listener.ora

19. Upgrade 9i Database to 10gR2

Shutdown the database listener if it is up in running

a. cd $ORACLE_HOME/bin
b. ./dbua
c. specify the 9i Database ( to be upgraded )
d. Specify the datafile path for creating sysaux tablespace
e. Remove check box for compiling PL/SQL Objects
f. Give the Enterprise Manager Options
g. Check whether the database information and components details
h. Proceed for upgrade
i. Finish the upgrade process
j. Modify the initialization parameters

I. vi $ORACLE_HOME/dbs/init<$ORACLE_SID>.ora
II. compatible = 10.2.0
III. sga_target = 1G
IV. shared_pool_size = 400M
V. shared_pool_reserved_size = 40M
VI. nls_length_semantics = BYTE
VII.undo_management = AUTO
VIII. undo_tablespace = APPS_UNDOTS1
IX. pga_aggregate_target = 1G
X. workarea_size_policy = AUTO
XI. olap_page_pool_size = 4194304
XII.open_cursors = 600
XIII. session_cached_cursors = 500
XIV. plsql_optimize_level = 2
XV. plsql_code_type = INTERPRETED
XVI. _b_tree_bitmap_plans = FALSE
XVII. optimizer_secure_view_merging = FALSE
XVIII. _kks_use_mutex_pin=TRUE

Remove the Following Parameters

i. _always_anti_join
ii. _always_semi_join
iii. _complex_view_merging
iv. _index_join_enabled
v. _new_initial_join_orders
vi. _optimizer_cost_based_transformations
vii. _optimizer_cost_model
viii. _optimizer_mode_force
ix. _optimizer_undo_changes
x. _or_expand_nvl_predicate
xi. _ordered_nested_loop
xii. _push_join_predicate
xiii. _push_join_union_view
xiv. _shared_pool_reserved_min_alloc
xv. _sortmerge_inequality_join_off
xvi. _table_scan_cost_plus_one
xvii. _unnest_subquery
xviii. _use_column_stats_for_function
xix. always_anti_join
xx. always_semi_join
xxi. db_block_buffers
xxii. db_cache_size
xxiii. enqueue_resources
xxiv. event="10932 trace name context level 32768"
xxv. event="10933 trace name context level 512"
xxvi. event="10943 trace name context forever, level 2"
xxvii. event="10943 trace name context level 16384"
xxviii. event="38004 trace name context forever, level 1"
xxix. hash_area_size
xxx. java_pool_size
xxxi. job_queue_interval
xxxii. large_pool_size
xxxiii. max_enabled_roles
xxxiv. optimizer_dynamic_sampling
xxxv. optimizer_features_enable
xxxvi. optimizer_index_caching
xxxvii. optimizer_index_cost_adj
xxxviii. optimizer_max_permutations
xxxix. optimizer_mode
xl. optimizer_percent_parallel
xli. plsql_compiler_flags
xlii. query_rewrite_enabled
xliii.row_locking
xliv. sort_area_size
xlv. undo_retention
xlvi. undo_suppress_errors

k. Compile Invalid objects through $ORACLE_HOME/rdbms/admin/utlrcmp.sql
command : sqlplus '/as sysdba' @$ORACLE_HOME/rdbms/admin/utrlcmp.sql

20. Post Upgrade steps

1. Fix Korean Lexers
i. Apply the 5005469 Patch
ii. sqlplus "/ as sysdba" @$ORACLE_HOME/ctx/sample/script/drkorean.sql

2. Startup the listener of upgraded database name
i. lsnrctl start


3. Run adgrants.sql

i. cp $APPL_TOP/admin/adgrants.sql $ORACLE_HOME/ <<10g>>
ii. sqlplus "/ as sysdba" @adgrants.sql APPLSYS

4. Grant create procedure privilege on CTXSYS

i. Login to applmgr
ii. sqlplus apps/
@$AD_TOP/patch/115/sql/adctxprv.sql CTXSYS

5. Gather statistics for SYS schema

i. cp $APPL_TOP/admin/adstats.sql $ORACLE_HOME
ii. login TO Oracle user
iii. cd $ORACLE_HOME
iv. $ sqlplus "/ as sysdba"
v. SQL> shutdown normal;
vi. SQL> startup restrict;
vii. SQL> @adstats.sql
viii. SQL> shutdown normal;
ix. SQL> startup;
x. SQL> exit;

21. Implement and Execute Autoconfig in Database Tier

Notes : Ensure no environment variables has been set either manually or in .profile
and database is up in running.if environment variable revoke such variables.

i. Export ORACLE_HOME =<10g>
ii.Export LD_LIBRARY_PATH = <10g>
iii.Export ORACLE_SID = instance name running on this database node.
iv. Export PATH=$PATH;$ORACLE_HOME/bin;
v. Export TNS_ADMIN = $ORACLE_HOME/network/admin/$CONTEXT_NAME
vi. sqlplus '/as sysdba'
vii. create pfile from spfile;
viii. shu immediate
ix. startup pfile=$ORACLE_HOME/dbs/init<$ORACLE_SID>.ora
x. exit
xi. lsnrctl start $ORACLE_SID
xii. cd $ORACLE_HOME/appsutil/bin
xiii. perl adbldxml.pl tier=db appsuser=apps appspasswd=
xiv. cp $ORACLE_HOME/dbs/init<$ORACLE_SID>.ora
xv. $ORACLE_HOME/dbs/init<$ORACLE_SID>_.ora
xvi. cd $ORACLE_HOME/appsutil/bin
xvii. perl adconfig.pl
xviii. Provide the created context file name as input for adconfig.pl script and check $ORACLE_HOME/appsutil/log after completion
xix. shutdown and startup database using addbctl.sh

22. Execute Autoconfig on Application Tier

i. cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
ii. sh adautocfg.sh

Notes: Ensure Applications is locating to 10g database

23. Startup Applications

i. cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME/
ii. sh adstrtal.sh apps/

24. Apply Oracle Receivables 5753621 Patch

i. Enable Maintainence Mode through adadmin
ii. apply u5753621 patch through adpatch
iii. disable Maintainence Mode through adadmin

25. Apply Application Manager 4766508 Patch [ For issue in preclone process in dbtier ]

i. Enable Maintainence Mode through adadmin
ii. Apply u4766508 patch through adpatch
iii. Disable Maintainence mode through adadmin
iv. Cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME/
v. Sh adautocfg.sh
vi. Provide apps password
vii. $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
viii. cp $APPL_TOP/admin/out/appsutil.zip $RDBMS_ORACLE_HOME ( 10g )
ix. unzip -o $ORACLE_HOME/appsutil.zip
x. cd $ORACLE_HOME/appsutil/scripts
xi. sh adautocfg.sh
xii. provide apps password
xiii. perl adpreclone.pl dbTier

Thanks & Regards,
Narasimha Rao.K

How to configure "Forgot your password" link

Dear All,

After a very long time,im updating this blog. Sorry for that.
Subject :How to enable the “Forgot Your Password” in oracle applications login page :
1. Login to the system administrator responsibility
2. navigate to profile à system
3. In the profile text box : enter “ Local Login Mask”
4. If you need to enable only Forgot your password Link in login page
then enter value = 8 ;
if you want to enable password hint and forgot your password link
then enter value = 10.
( Suggested to have password hint + forgot your password link)
5. save the profile option
6. logout & login again and test the option

Thanks & Regards,
Narasimha Rao.K

Wednesday, January 16, 2008

Registering a Shell Script in Oracle Applications 11i

Hi all,

This post is to discuss : How to register a Host concurrent program or Shell Script in Oracle Applications 11i.

Follow Document Id : 156636.1

https://metalink.oracle.com/metalink/plsql/f?p=130:14:546696868847448757::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,156636.1,1,1,1,helvetica

Questions ( if any ) can be raised through comments.

Thanks & Regards,
Narasimha Rao.K

Monday, January 14, 2008

Create a new custom application in Oracle Application 11i

Hi All,

This Post is to : Create a new custom application in Oracle Application 11i :

For Creating a new Custom Application

Please follow Document Id : 216589.1

https://metalink.oracle.com/metalink/plsql/f?p=130:14:192254477538037712::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,216589.1,1,1,1,helvetica


Questions ( if any ) can be raised through comments.

Thanks & Regards,
Narasimha Rao.K

OCFS Space Management

Another useful website for Oracle technologists:
http://oss.oracle.com/

OCFS: Oracle Cluster File System
> What is OCFS?
http://oss.oracle.com/projects/ocfs/
> How do you extend datafiles on an OCFS?
Check the available extend sizes using ocfsextfinder and allocate the datafile size appropriately.
Click here to download the user guide for using OCFS

Thursday, January 10, 2008

Tools for Oracle Apps DBA

Hi ,

This is to share basic tools for Oracle Apps DBA s.

Thanks & Regards,
Allappsdba Blog Team

1. Free Tool for telnet / ssh client [ name : putty ]

http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe

2. Free Tool for FTP / SFTP Client [ name : winscp]

http://downloads.sourceforge.net/winscp/winscp406.exe