10/29/2012

ARABSAT

ORACLE EBS 12.1 WITH UPGRADE DATABASE 11G R2

Technical Upgrade |ByAbuzaid Saad abouzaids@arabsat.com

abouzaids@gmail.com

+966508374239

Oracle EBS 12.1 with Upgrade Database 11gR2

Interoperability Notes Oracle EBS R12 with Oracle Database 11gR2 (11.2.0.2) [ID 1367644.1]

2012

Instructions for upgrading an Oracle E-Business Suite Release 12 database server and instance from Oracle 10g Release 2 (10.2.0 to the latest version of Oracle Database 11g Release 2 (11.2.0).

I.

Before Database Installation

Task 1. Verify software versions Steps Check Oracle Apps 12 Check Database 10.2.x a. b. c. d. e. f. g. h. Download patch 6400501 Unzip p6400501_10105_LINUX.zip cd 6400501 $ORACLE_HOME/Opatch opatch apply cd $ORACLE_HOME/forms/lib make -f ins_forms.mk install cd $ORACLE_HOME/reports/lib make -f ins_reports.mk install D. time [Min] 0 Comments Already at the same level of Application version RPM need to install as attached below This patch will apply on APPLTOP

2. Apply patch 6400501

3. Update application tier context file with new database listener port number (conditional)

a. cp $CONTEXT_FILE $CONTEXT_FILE.29Oct12 b. Change the below parameters

s_dbhost s_dbdomain s_db_serv_sid s_dbport s_apps_jdbc_connect_descri ptor New database hostname New database domain name New database SID New database listener port NULL

c. Save file and dont Run AutoConfig now 2|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

Backup database, application d. e. f. g. h. i. j. k. l. m. n. o. p. q. r. s. t. Login to PRODAPPL Server as [appl/pw] $cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME/ $ perl adpreclone.pl appsTier $cd [to home] $jumpstop Wait until all service are down, Ps ef | grep prodappl |wc l $tar -czvf prodappl.tgz /oracle/prodappl $tar -czvf prodcomn.tgz /oracle/prodcomn $tar -czvf prodora.tgz /oracle/prodora This is a backup of appl Login to PRODDB $cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/ $perl adpreclone.pl dbTier Shutdown db immediate , startup , shutdown normal $tar -czvf proddata.tgz /oracle/proddata $tar -czvf proddb.tgz /oracle/proddb This is backup of DB Node. 60

2012
Verify shudown ps ef in prodappl should be less 20

3|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

II. Database Installation
Task Steps Down time [Min] 0 Comments

2012

4.

Prepare to create the 11.2.0 Oracle home

The 11.2.0 Oracle home must be installed on the database server node in a different directory than the current Oracle home. Read Chapters 1 and 2 of the Oracle Database Installation Guide 11g Release 2 (11.2) for your platform. Also read Chapter 1 and the "System Considerations and Requirements" section of Chapter 3 of the Oracle Database Upgrade Guide 11g Release 2 (11.2). Make sure you thoroughly understand the installation and upgrade processes. Perform any step that is relevant for your environment.

5. Install the 11.2.0.2 software

Login oracle for DB Server Prepare environment file export ORACLE_BASE=/oracle/app export ORACLE_HOME=/oracle/app/11.2.0 export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/l ib/site_perl/5.10.0 export ORA_NLS10=/oracle/app/11.2.0/nls/data/9idata export TNS_ADMIN=/oracle/app/11.2.0/network/admin export ORACLE_SID=R12

4|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

5|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

Select Languages

6|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

7|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

8|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

9|P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

6. Install Oracle Database 11g Products from the 11g Examples CD

10 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

7. Create nls/data/9idata directory

On Database Server Node $ORACLE_HOME/nls/data/old/cr9idata.pl

Export ORA_NLS10=$ORACLE_HOME/nls/data/9idata 8. Apply additional 11.2.0.2 RDBMS patches Apply the following patches: For all UNIX/Linux platforms: 4247037 10149223 10160615 30

11 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

10229719 12400751 12942119 13001379 13004894

2012

III.

Database Upgrade:
Task Steps Down time [Min] Comments

9. Shut down Applications server processes and database listener 10. Drop SYS.ENABLED$INDEXES (conditional)

Shutdown application Services (stopall) Shutdown Listner (lsnrctl stop DB)

Start from now Application will be not available Not Applicable

If the SYS.ENABLED$INDEXES table exists, use SQL*Plus to connect to the database as SYSDBA and running the following command to drop it:
SQL> drop table sys.enabled$indexes;

11. Disable Database Vault (conditional) 12. Prepare to upgrade

Verify all custom resp. working fine ..

Not Applicable

Select DBUA Method Determine Location of Oracle home Develop a test plan Prepare backup strategy

Invalid Objects before upgrade See attached below

13. Upgrade the database instance

spool upgrade_info.log SQL> @/R12b/app/oracle/rdbms/admin/utlu112i.sql

240

12 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

SQL> PURGE DBA_RECY CLEB IN ; SQL> E XE CUTE dbms_stats.gather_dictionary _stats; SQL> E XE C DBMS_S TA TS.GA THER_SCHEMA_S TA TS ('SYS ');

2012

$ unset ORA_TZFILE
$ dbua

13 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

14 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

15 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

16 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

17 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

18 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

Start 30-Oct-2012 18:10 End 30-Oct-2012 21:40

14. Modify initialization parameters 15. Perform patch post-install instructions 16. Natively compile PL/SQL code (optional)

Copy jumpstart& Jumpstop scripts Run only the catmgdidcode.sql and utlrp.sql scripts for the post install instructions. The other scripts are run as part of the dbua upgrade You can choose to run Oracle E-Business Suite 12.1 PL/SQL database objects in natively compiled mode with Oracle Database 11g. See the "Compiling PL/SQL Program Units for Native Execution" section of Chapter 12 of Oracle Database PL/SQL Language Reference 11g Release 2 (11.2).

No more custom scripts No Need

No need for time been

19 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

IV. After the Database Upgrade
Task 17. Start the new database listener (conditional) 18. Run adgrants.sql Steps $ netcan Create TNSNAMES and LISTNER D. time [Min] Comments

2012

Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:
$ sqlplus "/ as sysdba" @adgrants.sql (or adgrants_nt.sql) [APPS schema name]

RPM need to install as attached below This patch will apply on APPLTOP

19. Grant create procedure privilege on CTXSYS

copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node. Use SQL*Plus to connect to the database as APPS and run the script using the following command: $ sqlplus apps/[APPS password] @adctxprv.sql [SYSTEM password] CTXSYS

20. Set CTXSYS parameter

Use SQL*Plus to connect to the database as SYSDBA and run the following command:
$ sqlplus "/ as sysdba"

SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');

21. Validate Workflow ruleset

On the administration server node, use SQL*Plus to connect to the database as APPS and run the 20 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

$FND_TOP/patch/115/sql/wfaqupfix.sql script using the following command: $ sqlplus [APPS user]/[APPS password] @wfaqupfix.sql\ [APPLSYS user] [APPS user] 22. Deregister the current database server (conditional) 23. Implement and run AutoConfig
$ sqlplus apps/[APPS password] SQL> exec fnd_conc_clone.setup_clean;

2012

No Need 30

Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 [ID 387859.1] {Section : 3.2} Apply patch Patch 8919489 for 12.1.X customers $sqlplus apps/asat123 @/R12b/R12/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adset mmd.sql ENABLE $ adpatch $sqlplus apps/asat123 @/R12b/R12/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adset mmd.sql DISABLE Copy AutoConfig to the RDBMS ORACLE_HOME Update the RDBMS ORACLE_HOME file system with the new AutoConfig files delivered in the above patch following Step 2 in Section 3.1. Copy AutoConfig to the RDBMS ORACLE_HOME Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps: On the application tier (as the APPLMGR user): Log in to the APPL_TOP environment (source the environment file) Create appsutil.zip file $perl $AD_TOP/bin/admkappsutil.pl This will create appsutil.zip in $INST_TOP/admin/out

21 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

On the database tier (as the ORACLE user): Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME> $scp appsutil.zip to DBNODE@ORACLE_HOME cd <RDBMS ORACLE_HOME> unzip -o appsutil.zip Run AutoConfig Run AutoConfig on the database tier and then on the applications tier as described in sub-sections 2.2 and 2.3 in Section 2.
2.2. Run AutoConfig on the Databa se Tier cd $ORACLE_HOME/appsutil/bin $ [r12orab@r12db1 bin] $

2012

perl adbldxml.pl

Starting context file generati on for db tier.. Using JVM from /R 12b/app/oracle/j dk/jre/bi n/java to execute java programs.. APPS Pass word: xxx The log file for this adbldxml sessi on is loc ated at: /R12b/app/oracle/appsutil/log/adbldxml_10311618.log

AC-00013: Error: File: /R 12b/app/oracle/network/admin/listener.ora is not a valid file as database SID could not be found for connect string: R12b Could not C onnect to the Database with the above parameters, Pl ease answer the Questi ons below Enter H ostname of Database s er ver: r12db1.arabs at.c om.sa Enter Port of Database ser ver: 1522 Enter SID of Database s erver: R12b Enter the value for Display Variable: 0:0

22 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

The context file has been created at: /R12b/app/oracle/appsutil/R12b_r12db1.xml

2012

$ cd $ORACLE_HOME/appsutil/bin $ adconfig.sh contextfile= appspass= Execute the following command to run AutoConfig on the database tier.
sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEX T_NAME>/adautocfg.sh

24. Gather Statistics for SYS schema

Copy $APPL_TOP/admin/adstats.sql from the 10 administration server node to the database server node. Note that adstats.sql has to be run in restricted mode. Use SQL*Plus to connect to the database as SYSDBA and use the following commands to run adstats.sql in restricted mode:
$ scp $APPL_TOP/admin/adstats.sql r12orab@10.1.3.28:/home/r12orab $ sqlplus "/ as sysdba" SQL> alter system enable restricted session; SQL> @adstats.sql $ sqlplus "/ as sysdba" SQL> alter system disable restricted session; SQL> exit;

25. Create Demantra privileges

(conditional)

Not Applicable
$ sqlplus apps/[apps password]

26. Re-create custom database

Only ITSM System 23 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

links (conditional)
SQL> select db_link from all_db_links;

2012

The EDW_APPS_TO_WH and APPS_TO_APPS database links, if they exist, should have been updated with the new port number by AutoConfig in the previous step. If you have custom self-referential database links in the database instance, use the following commands to drop and re-create them:
$ sqlplus apps/[apps password] SQL> drop database link [custom database link]; SQL> create database link [custom database link] connect to [user] identified by [password] using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[hostname]) (PORT=[port number]))(CONNECT_DATA=(SID=[ORACLE_SID])))';

27. Re-create grants and

synonyms

$adadmin 4. Maintain application entities o 2. Recreate grant and synonym o

10

28. Enable Database Vault 29. Restart Applications Server Processes 30. Synchronize Workflow views 10

Not Applicable

Log on to Oracle E-Business Suite with the "System Administrator" responsibility. Click Requests > Run > Single Request and the OK button. Enter the following parameters:

10

Request Name = Workflow Directory Services User/Role Validation p_BatchSize = 10000

24 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

p_Check_Dangling = Yes Add missing user/role assignments = Yes Update WHO columns in WF tables = No

Click "OK" and "Submit".

Be careful when migrating Difference between oracle 10g and 11g

All of DBAs know about new features of Oracle Database 11 g, but here will expose of the possible problems to migrate. This note apply to Oracle Database 11g Release 2. New Features: ASM Fast Mirror Resync, a snapshot standby database is a fully updatable standby, Data Recover Adv isor automatically diagnoses data failures, Improved Block Corruption Detection, Database Replay allows you to test the impact of sy stem change by replay ing real -world workload on the test sy stem before it is ex posed to a production. Possibles issues to m igrate oracle database 10g to 11g : 1. Problems to send m ail or access HTTP/TCP connection. Oracle Error: ORA-24247 : network access denied by access control list (ACL) The 11 g database v ersion only allows access to external functions (UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL, UTL_INADDR, DBMS_LDAP) through one special explicit grant to the owner. Solution: 1.1 . Create de ACL access control list :
BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('acl_list.xml','List of special access', 'SYS', TRUE, 'connect');

25 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('acl_list.xml','*'); END; / COMMIT;

2012

1.2. Grant the resolve priv ilege for users that need use the special functions: 1.2.1 . Run select to see all of users :
SELECT OWNER, REFERENCED_NAME FROM DBA_DEPENDENCIES WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_INADDR') AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS') order by OWNER;

Return ex ample: JAVAUTIL,UTL_HTTP SY SCLI,UTL_SMTP 1.2.2. Grant to user JAVAUTIL and SY SCLI (re member to commit) :
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE( acl => 'acl_list.xml', principal => 'JAVAUTIL', is_grant => true, privilege => 'connect'); END;

26 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

/ commit;

2012

BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE( acl => 'acl_list.xml', principal => 'SYSCLI', is_grant => true, privilege => 'connect'); END; / commit;

2. Errors using java class in database. Oracle Error: The class is not compiled In 11 g database the JDBC driv er has changed, and classes tha t use JDBC driv er must import the new. Solution: 2.1. Change the import class: From : import oracle.jdbc.driver*; To: import oracle.jdbc.*; 3. Ambiguous column in the query . Oracle Error: ORA -0091 8: column ambiguously defined According to Oracle this is an ex pected behav ior and 11 g from the need to qualify ambiguous names in select list (DOC ID 8357 01.1)

27 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

Solution: 3.1. Change the query specifying the columns ambiguous. Ex am ple of query with am biguous column:
SELECT PROJECT_ID , PROJ_VERSION_NO, NAME , DESCRIPTION , LAST_CHANGED_DATE FROM leeh.PW2_PROJECT JOIN (SELECT PROJECT_ID AS MAX_ID, MAX(PROJ_VERSION_NO) AS MAX_VERSION FROM leeh.PW2_PROJECT GROUP BY PROJECT_ID ) T ON PROJECT_ID = MAX_ID AND PROJ_VERSION_NO = MAX_VERSION WHERE PROJ_VERSION_NO > 0;

2012

4. Error in procedure or function when change user password. Oracle Error: ORA -0600 In 11 g database, the password column on view sys.dba_users, no longer contains the users password. Solution: 4.1. Change the queries to use sy s.user$ v iew. 5. Implicit data conversion is no longer allowed in some times Oracle Error: ORA -06502: PL/SQL: numeric or value error Implicit and ex plicit conv ersion for numeric values may also suffer from the analogous problem, as the conversion result may depend on the session parameter NLS_NUMERIC_CHARACTERS. This parameter defines the decimal and group separator characters. If the decimal separator is defined to be the quotation mark or the double quotation mark, some potential for SQL injection emerges. Solution: 5.1. Check NLS_NUMERIC_CHARACTERS or change the queries to use quotes.

28 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

6. User login error, because password case sensitivity Oracle Error: ORA -01017 : inv alid username/password

2012

When you create or modify user accounts, by default, passwords are case sensitive. To control the use of case sensi tivity in passwords, set the SEC_CASE_SENSITIV E_LOGON initialization parameter. Only users who have the ALTER SY STEM priv ilege can set the SEC_CASE_SENSIT IV E_LOGON parameter. Set it to TRUE to enable case sensitivity or FALSE to disable case sensitiv ity. Solution: 6.1. Set init parameter sec_case_sensitive_logon to false : *.sec_case_sensitive_logon=false 7 . Error using cursor with DBMS_SQL Oracle Error: ORA -2947 1: DBMS_SQL access denied In 11g database, oracle has introduced some security changes to the DBM S_SQL package to prevent cursor injection. The better solution is create the cursors using explicitly security level, for ex ample: curs = dbms_sql.open_cursor(lev el); The lev el 1 requires the executing/binding and parsing user IDs to be the same. Lev el 2 i s more strict and requires id and roles are the same for all operations like binds, describes, executes, fetches etc. Workaround to ignore the security cursor: 7 .1. Set init parameter _dbms_sql_security _level to zero: *._dbms_sql_security _level=0

29 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

2012

Attached Note s:Please ta ke a look on the Doc 564174.1. ################################################################### Any insta llat ion of Oracle Application Server 10g Re lease 2 (10.1.2.0.2) on O EL 5.x or R HEL 5.x in which Reports is getting i nstalled will fail with reports re linking errors Example output from installActions log: /usr/lib/libXtst.so.6: undef ined reference to `__stack_chk_fail@GLIBC_2.4' /usr/lib/libXtst.so.6: undef ined reference to `__fprintf_chk@GLIBC_2.3.4' /usr/lib/libXtst.so.6: undef ined reference to `__sprintf_chk@GLIBC_2.3.4' collect2: ld returne d 1 exit status ma ke: *** [rwrun] Error 1 End output from spawned process. Exception thrown from a ction: ma ke Exception Na me: Ma kefileException Exception String: Error in invoking target 'proxy_insta ll runm_insta ll server_install cgi_insta ll cli_install conv_install qv_install' of makef ile '/opt/oracle /Forms10gR2/reports/lib/ins_re ports. mk'

In order to prevent this, download and apply the required RPM listed be low: [http://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm] As root, you ca n insta ll this RPM package by issuing the following command # rpm -i xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm After the RPM, is installed, you will a lso need to override the /usr/lib/libXtst.so.6 with the one from /usr/X11R6/lib/libXtst.so.6. As r oot, issue the commands: # mv /usr/lib/libXtst.so.6 /usr/lib/libXtst.so.6.ORG # ln -s /usr/X11R6/lib/libXtst.so.6 /usr/lib/libXtst.so.6

30 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

################################################################### Hope it helps

2012

Invalid Objects Before Upgrade:SQL> select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type From dba_objects where status='INV ALID' order by owner,object_type; 2

OBJECT_NAME AQ$_WF_CONTROL_F AQ$WF_CONTROL XX_GENERATE_CONTRACT_FATH FV_FACTS_TBAL_TRX FV_FACTS_TRX_REGISTER OE_HEADER_P AYMENT_UTIL OKS_CCENCRYPTION_P KG

OWNER APPLSYS APPLSYS APPS APPS APPS APPS APPS

OBJECT_TYP E VIEW VIEW FUNCTION PACKAGE BODY PACKAGE BODY PACKAGE BODY PACKAGE BODY

31 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

FV_SLA_PROCESSING_PKG FV_FACTS_TRANS ACTIONS FV_FACTS_TBAL_TRANS ACTIONS IBY_FNDCPT_TRXN_PUB APPS APPS APPS APPS PACKAGE BODY PACKAGE BODY PACKAGE BODY PACKAGE BODY

2012

OBJECT_NAME IBY_AR_UTILS XX_ARABSAT_SR_PKG_27Jul12 DT_S ETP ROP ERTYBYID XX_PROCESS_ITEMS FV_FACTS_TRX_V FV_BUDGET_DISTRI BUTION_HDR_V FV_FACTS_TB_V IBY_XML_FNDCPT_DOC_LINE_V IBY_XML_FNDCPT_DOC_LINES _V IBY_XML_FNDCPT_DOC_HEADER_V IBY_XML_FNDCPT_DOC_HEADERS_V CS_KB_F_CTX_P KG

OWNER APPS APPS APPS APPS APPS APPS APPS APPS APPS APPS APPS CTXSYS

OBJECT_TYP E PACKAGE BODY PACKAGE BODY PROCEDURE PROCEDURE VIEW VIEW VIEW VIEW VIEW VIEW VIEW PACKAGE BODY

32 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

WWCTX_API_VPD WWSSO_API WWSSO_PSTORE_EX WWSSO_API_PRIVATE ORDIMGEXTCODEC_P KG ORDIMG_P KG DEBUG_CARTX OWA_UTIL OWA_OPT_LOCK DEBUG_CARTX XXARABS AT_US ER_HOOKS XXARABS AT_REGIONS PER_APP RAISALS_DFV PER_COMP ETENCE_ELEMENTS_DFV PER_GRADES_DFV PER_OBJECTIVES _DFV DBMS _SUMADV GLWAND JUNK_PS JUNK_PS JUNK_PS JUNK_PS ORDSYS ORDSYS OWAPUB OWAPUB OWAPUB PUBLI C PUBLI C PUBLI C PUBLI C PUBLI C PUBLI C PUBLI C SYS SYNONYM SYNONYM SYNONYM SYNONYM PACKAGE BODY PACKAGE BODY PACKAGE BODY PACKAGE BODY PACKAGE BODY SYNONYM SYNONYM SYNONYM SYNONYM SYNONYM SYNONYM SYNONYM PACKAGE BODY PACKAGE BODY

2012

XXARABS AT

33 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

XXEVENTS _EV ENT_I D_T RG 42 row s selected. SQL> SQL> select owner,object_type,count(*) from dba_objects where status= 'INVALID' group by XXEVENT TRIGGER

2012

owner,object_type order by owner,object_type ; 2 OWNER APPLSYS APPS APPS APPS APPS CTXSYS JUNK_PS ORDSYS OWAPUB PUBLI C SYS XXARABS AT OBJECT _TYP E VIEW FUNCTION PACKAGE BODY PROCEDURE VIEW PACKAGE BODY SYNONYM PACKAGE BODY PACKAGE BODY SYNONYM PACKAGE BODY PACKAGE BODY COUNT(*) 2 1 10 2 7 1 4 2 3 7 1 1

34 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

XXEVENT 13 row s selected. TRIGGER 1

2012

--------------- Upgrade Util -------------SQL> @/R12b/app/oracle/rdbms/admin/utlu112i.sql Oracle Database 11.2 Pre-Upgrade Information Tool 10-30-2012 15:00:05 Script Version: 11. 2.0.2.0 Build: 001 . ********************************************************************** Database: ********************************************************************** --> name: R12B --> version: 10.2.0.5.0 --> compatible: 10.2.0 --> blocksize: 8192 --> platform: Linux IA (32-bit) --> timezone file: V4 . ********************************************************************** Tablespaces: [make adjustments in the current environment] ********************************************************************** --> SYSTEM tablespace is adequate for the upgrade. .... minimum required size: 10034 MB --> APPS_UNDOTS1 tablespace is adequate for the upgrade. .... minimum required size: 3395 MB --> TEMP tablespace is adequate for the upgrade. .... minimum required size: 61 MB --> APPS_TS _QUEUES tablespace is adequate for the upgrade. .... minimum required size: 238 MB --> APPS_TS _TX_DATA tablespace is adequate for the upgrade. .... minimum required size: 17890 MB --> CTX D tablespace is adequate for the upgrade. .... minimum required size: 43 MB --> ODM tablespace is adequate for the upgrade. .... minimum required size: 15 MB

35 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

--> OLAP tablespace is adequate for the upgrade. .... minimum required size: 32 MB --> SYS AUX tablespace is adequate for the upgrade. .... minimum required size: 1139 MB . ********************************************************************** Flashback: OFF ********************************************************************** ********************************************************************** Update Parameters: [Update Oracle Database 11.2 init.ora or spfile] Note: Pre-upgrade tool was run on a lower version 32-bit database. ********************************************************************** --> If Target Oracle is 32-Bit, refer here for Update Parameters: -- No update parameter changes are required. . --> If Target Oracle is 64-Bit, refer here for Update Parameters: -- No update parameter changes are required. . ********************************************************************** Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** -- No renamed parameters found. No changes are required. . ********************************************************************** Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** --> background_dump_de st 11.1 DEPRECATED replaced by "diagnostic_de st" --> user_dump_de st 11.1 DEPRECATED replaced by "diagnostic_de st" --> pl sql_native_library_dir 11.2 OBSOLETE --> pl sql_native_library_subdir_ 11.2 OBSOLETE . ********************************************************************** Components: [The following database components will be upgraded or installed] ********************************************************************** --> Oracle Catalog Views [upgrade] VALID --> Oracle Packages and Types [upgrade] VALID --> JServer JAV A Virtual Machine [upgrade] VALID --> Oracle XDK for Java [upgrade] VALID

2012

36 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

--> Real Application Clusters [upgrade] INVALID --> OLAP Analytic Workspace [upgrade] VALID --> OLAP Catalog [upgrade ] VALID --> Oracle Text [upgrade] VALID --> Oracle XML Database [upgrade] VALID --> Oracle Java Packages [upgrade] VALID --> Oracle interMedia [upgrade] VALID --> Spatial [upgrade] VALID --> Oracle OLAP API [upgrade] VALID . ********************************************************************** Miscellaneous Warnings ********************************************************************** WARNI NG: --> Databa se is using a timezone file older than version 14. .... After the release migration, it is recommended that DBMS_DST package .... be used to upgrade the 10.2.0.5.0 database timezone version .... to the latest version which comes with the new release. WARNI NG: --> Databa se contains INVALI D objects prior to upgrade. .... The list of invalid SYS/SYSTEM objects was written to .... registry$sys_inv_obj s. .... The list of non-S YS/SYSTEM objects wa s written to .... registry$nonsys_inv_obj s. .... Use utluiobj.sql after the upgrade to identify any new invalid .... objects due to the upgrade. .... USER APPLS YS has 2 INV ALID objects. .... USER OWAPUB ha s 3 INVALID objects. .... USER JUNK_PS ha s 4 INVALI D objects. .... USER PUBLIC ha s 7 INVALI D objects. .... USER CTXS YS has 1 I NVALI D objects. .... USER XXEV ENT has 1 INV ALID objects. .... USER ORDS YS has 2 INV ALI D objects. .... USER APPS has 20 INVALID objects. .... USER SYS ha s 1 INVALID objects. .... USER XXARABSAT ha s 1 INV ALID objects. WARNI NG: --> Your recycle bin contains 1610 object(s). .... It is REQUIRED that the recycle bin is empty prior to upgrading .... your database. The command: PURGE DBA_RECYCLEBI N .... must be executed immediately prior to executing your upgrade. WARNI NG: --> Databa se contains schemas with objects dependent on DBMS _LDAP package.

2012

37 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs. .... USER APPS has dependent objects. .... USER XXETICKET ha s dependent objects. . ********************************************************************** Recommendations ********************************************************************** Oracle recommends gathering dictionary stati stics prior to upgrading the database. To gather dictionary stati stics execute the following command while connected as SYSDBA: EXECUTE dbm s_stats. gather_dictionary_stats; ********************************************************************** Oracle recommends removing all hidden parameters prior to upgrading. To view existing hidden parameters execute the following command while connected AS SYSDBA: SELECT name,description from SYS.V$P ARAMETER WHERE name LIKE '\_%' ESCAP E '\' Changes will need to be made in the init.ora or spfile. ********************************************************************** Oracle recommends reviewing any defined events prior to upgrading. To view existing non -default events execute the following commands while connected AS SYSDBA: Events: SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys. v$parameter2 WHERE UPP ER(name) ='EVENT' AND isdefault='FALS E' Trace Events: SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2 WHERE UPP ER(name) = '_TRACE_EV ENTS' AND isdefault='FALS E' Changes will need to be made in the init.ora or spfile.

2012

38 | P a g e

Oracle EBS 12.1 with Upgrade Database 11gR2

********************************************************************** SQL> spool off

2012

39 | P a g e