VijOraAppsDBA: 2019

Installation Type	Zip File
Oracle Database (includes Oracle Database and Oracle RAC) Note: you must download both zip files to install Oracle Database.	p13390677_112040_platform_1of7.zip p13390677_112040_platform_2of7.zip
Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart)	p13390677_112040_platform_3of7.zip
Oracle Database Client	p13390677_112040_platform_4of7.zip
Oracle Gateways	p13390677_112040_platform_5of7.zip
Oracle Examples	p13390677_112040_platform_6of7.zip
Deinstall	p13390677_112040_platform_7of7.zip

DATABASE UPGRADE - Download above zip files and unzip in a single folder.

*Shut down Applications server processes and database listener

/dba/job/stop_vij1.sh on applvij108 (application server) as applmgr

lsnrctl stop vij1 as oracle on oravij107 (database server)

*Drop SYS.ENABLED$INDEXES

drop table sys.enabled$indexes;

*Prepare to upgrade

#Add 11.2.0.4 to /etc/oratab

#Run pre-upgrade tool

@/u03/oracle/vij1db/11.2.0.4/rdbms/admin/utlu112i.sql

#copy init.ora and password file to new 11.2.0.4

cp -p /u03/oracle/vij1db/11.2.0.3/dbs/spfilevij1.ora /u03/oracle/vij1db/11.2.0.4/dbs/

cp -p /u03/oracle/vij1db/11.2.0.3/dbs/orapwvij1 /u03/oracle/vij1db/11.2.0.4/dbs/

*Upgrade database

#shutdown instance

srvctl stop listener -l vij1

srvctl stop database -d vij1

#remove from Grid Infrastructure

srvctl remove database -d vij1

Remove the database vij1? (y/[n]) y

oracle:oravij107:srvctl remove listener -l vij1

#Copy TNS_ADMIN directory and update *.ora files

cp -rp /u03/oracle/vij1db/11.2.0.3/network/admin/vij1_oravij107 /u03/oracle/vij1db/11.2.0.4/network/admin/

cd /u03/oracle/vij1db/11.2.0.4/network/admin/vij1_oravij107

update listener.ora, tnsnames.ora and sqlnet.ora and change 11.2.0.3 to 11.2.0.4

#update /etc/oratab to use 11.2.0.4 ORACLE_HOME

#relogin and source vij1

. oraenv

ORACLE_SID = [sqlnet] ? vij1

export TNS_ADMIN=$ORACLE_HOME/network/admin/vij1_oravij107

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

#startup upgrade

SQL> startup upgrade;

#do the upgrade

cd $ORACLE_HOME/rdbms/admin

sqlplus / as sysdba

SQL> spool vij1_upgrade.log

SQL> @catupgrd.sql

SQL> startup

SQL> @utlu112s.sql

SQL> @catuppst.sql

SQL> EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS', 'FND_STATTAB');

*Perform patch post-install instructions

sqlplus / as sysdba

@?/md/admin/catmgdidcode

@?/sqlpatch/17501296/postinstall.sql

AFTER DATABASE UPGRADE

*run adgrants.sql

mkdir -p $ORACLE_HOME/appsutil/admin

cd $ORACLE_HOME/appsutil/admin

scp applmgr@applvij108:/u04/applmgr/vij1/apps/apps_st/appl/admin/adgrants.sql .

sqlplus "/ as sysdba" @adgrants APPS

*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:

scp applmgr@applvij108:/u04/applmgr/vij1/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adctxprv.sql $ORACLE_HOME/appsutil/admin/

$ sqlplus apps @adctxprv.sql [SYSTEM password] CTXSYS

*Compile invalid objects

SQL> exec utl_recomp.recomp_parallel(32);

*Set CTXSYS parameter

sqlplus "/ as sysdba"

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

*start listener

srvctl add listener -l vij1 -o $ORACLE_HOME -p 1544

srvctl setenv listener -l vij1 -T TNS_ADMIN=$TNS_ADMIN

srvctl start listener -l vij1

*Validate Workflow ruleset

On the administration server node, use SQL*Plus to connect to the database as APPS and run the $FND_TOP/patch/115/sql/wfaqupfix.sql script using the following command:

$ sqlplus apps @$FND_TOP/patch/115/sql/wfaqupfix.sql APPLSYS APPS

*Implement and run AutoConfig

on applvij108 as applmgr

perl $AD_TOP/bin/admkappsutil.pl

#copy from oravij107

on oravij107 as oracle

scp applmgr@applvij108:/fluke/inst/apps/vij1_applvij108/admin/out/appsutil.zip $ORACLE_HOME/

cd $ORACLE_HOME

unzip -o appsutil.zip

cp /u03/oracle/vij1db/11.2.0.3/appsutil/vij1_oravij107.xml /u03/oracle/vij1db/11.2.0.4/appsutil/

cd appsutil

vi vij1_oravij107.xml

change references of 11.2.0.3 to 11.2.0.4

$ORACLE_HOME/appsutil/bin/adconfig.sh

/u03/oracle/vij1db/11.2.0.4/appsutil/vij1_oravij107.xml

Resource environment using new file

. /u03/oracle/vij1db/11.2.0.4/vij1_oravij107.env

update /dba/bin/vij1.env to call /u03/oracle/vij1db/11.2.0.4/vij1_oravij107.env

update GI for vij1 database

srvctl add database -d vij1 -o $ORACLE_HOME -a "vij1DATA,REDOA,REDOB,FRA"

srvctl setenv database -d vij1 -T TNS_ADMIN=$TNS_ADMIN

srvctl setenv database -d vij1 -T ORA_NLS10=$ORA_NLS10

*Gather statistics for SYS schema

$ sqlplus "/ as sysdba"

SQL> exec dbms_stats.gather_schema_stats('SYS', method_opt=>'for all columns size 1', degree=>30,estimate_percent=>100,cascade=>true);

*Apply Application Patches

9868229

10163753

11071569

9151516

16365623

13737002

18843706

Also apply these patches

18485835 –Fixes performance issue with Posting program on 11.2.0.4
17551261 – Missing recommended patch for 11.2.0.4 and EBS
18665660 – Missing recommended patch for 11.2.0.4 and EBS

*Restart Applications server processes

start services on applvij108

*Synchronize Workflow views

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:

Request Name = Workflow Directory Services User/Role Validation

Batch Size = 10000

Fix dangling users = Yes

Add missing user/role assignments = Yes

Update WHO columns in WF tables = No

-----------------Extra

11i Posting Performance On Gluddl Process After Database Upgrade to 12.1.0.1 (12c) - Patch 18485835 Applied (Doc ID 2057233.1)

Applies to:
Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
GLPPOS - Posting program
Symptoms

Database (DB) upgraded from 11.2.0.3 to 12.1.0.1 (12c), Posting concurrent shown performance problems afterwards, run time changing from about 30 seconds to 50-80 minutes.

According to Note 1602141.1 'GLPPOS After DB Upgrade to 11.2.0.4.0 or 12.1.0.1 or 12.1.0.2 Posting Program Has Poor Performance Stuck on Glpubr.Concurrency', database Patch 18485835 has been applied. Posting run time improved to 3-5 minutes, still improper considering the volume of data posted.

From Posting log file it is obvious that gluddl() process takes longer.

STEPS
The issue can be reproduced at will with the following steps:
1. GL responsibility
2. Run Posting: Single Ledger Program
Changes

Upgrades DB to 12.1.0.1 (12c) and installed Patch 18485835.
Cause

Database (DB) upgraded from 11.2.0.3 to 12.1.0.1 (12c); this is related also to lower file version of gluddl.lpc: $Header: gluddl.lpc 115.13.115103.1 2005/02/21 06:09:56 appldev noship $
Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 8222887, which will bring the latest file version gluddl.lpc 115.13.115103.3 or you can apply the latest GL Posting Patch 10202576 for 11i instance

2. Ensure that you have taken a backup of your system before applying the recommended patch

3. Apply the patch in a test environment

4. Confirm the following file versions: gluddl.lpc

You can use the commands like the following:
under Unix : cd $GL_TOP/bin
strings -a GLPPOS | grep Head

Or from SQL command:
SELECT fi.file_id, filename, version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename like 'gluddl%'
AND ve.file_id = fi.file_id
order by filename, version;

5. Bounce the server

6. Retest the issue

7. Migrate the solution as appropriate to other environments

VijOraAppsDBA

Thursday, 14 March 2019

unix server info common commands

Tuesday, 5 March 2019

Reset root password RHEL/Fedora/CentOS

Monday, 4 March 2019

11.2.0.3 to 11.2.0.4 upgrade - Linux 64 bit

SQL Shared Area - BIND MISMATCH

Search This Blog