Saturday, January 3, 2009

Step by Step to Install Oracle Applications R12.0.4 On Solaris 5.10(SPARC)

Environment:
Operating Systems Requirement: Solaris 5.10 (SPARC)
Oracle Applications : e-business Suite R12.0.4
1. Command to check the operating system version: $ uname –r
2. Command to check the maintenance update level: $ cat /etc/release
Required Patches
a. 125100-04 or higher
b. 120473-05 or higher:

Command to retrieve the list of operating system patches already applied:
$ showrev -p sort > patchList
Command to check for a specific patch:
$ /usr/sbin/patchadd -p grep patch_number

Required Packages for R12
Solaris 10 (5.10)
SUNWarc
SUNWbtool
SUNWhea
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt

Command to check for existing packages:$ pkginfo
Required Kernel Settings
Solaris 10 (5.10)
set rlim_fd_max=65536
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
Check the /etc/system file to verify the kernel settings.
Hostname Settings
Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
.
Create Users & Groups
Groupadd dba
Useradd –d /Home/applprod –g dba applprod
Useradd –d /Home/oraprod –g dba oraprod

Start Install:Create the Stage directory and start Rapid Install.
$ cd /dump/StageR12/startCD/Disk1/rapidwiz$ ./rapidwiz

Go through the Welcome Screen & Next

Go through the Wizard Screen & Next


Go through the Oracle Configuration Manager Screen & Next

We are doing fresh ,Single node installationOn Confuguration choice screen

select Create a new configuration & Next

On Global Syatem settings Screen Provide the Port pool

Provide the database node details

Check & verify the Node Paths

Go through the licensing & select required


Select The Country Specific Functionalities


Provide the Applications Node Details

Verify the Node Information

Go through the Pre-Install Checks

Go through review & Next

Start the Installation by go through YES

Verify the Installation Stages




Verify through Post-install Checks & Next

Next Finish



















Export/Import Issue with oracle 8i

While Upgrading the EMS Database to 9.2.0.6, I have faced Some issues while Importing the EMS data Using the Export DMP file that was created with an Oracle 8i (8.1.6) Release Export Utility.

Error Message:
IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(~,~); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"BOE_DTL"','"BED_EXP_BNK_CODE"', NULL ,NULL,NULL,0"
",0,7209,srec,1,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 155:
PLS-00103: Encountered the symbol "~" when expecting one of the following:

IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(~,~); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"BOE_DTL"','"BED_BYR_BNK_CODE"', NULL ,NULL,NULL,0"
",0,7209,srec,1,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 155:
PLS-00103: Encountered the symbol "~" when expecting one of the following:

Solution:
This issue occurs with an Oracle8i, 8.1.7.2 or earlier release export utility Apply the 8.1.7.3 Patch set or Use this Action plan to resolve the Data Migration Issue:
1. Re-run the export without exporting the statistics:

> exp system/password FILE=... STATISTICS=none .... (other parameters)

And re-run the import afterwards.

or:

2. Do not import the statistics that were exported in the export dump file:

a. When importing into an Oracle8i database:
> imp system/password FILE=... ANALYZE=n .... (other parameters)
or:
> imp system/password FILE=... RECALCULATE_STATISTICS=y .... (other p's)

b. When importing into an Oracle9i/Oracle10g database:
> imp system/password FILE=... STATISTICS=none .... (other parameters)
or:
> imp system/password FILE=... STATISTICS=recalculate .... (other params)