Post Installation EBS12.2.0

Run the following post installation steps:
1.3.1 Run Scripts to find out RUN and PATCH File System and Application Environment

1.3.1.1 Create custom application directory.

1.3.2 Changing Default Passwords

1.3.2.1 Create custom application directory.

1.3.3 Apply Mandatory Database Tier Patches using ADOP

1.3.3.1 Apply following database tier patches using ‘oravis’ user:
• Patch 17468141 - PL/SQL COMPILATION THROWS ERROR ORA-4063
• Patch 16924879 - CLEAN UP OBSOLETE ORACLE/QSMA SYNONYMS FROM DB 11.2
• Patch 17047617 - MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 15967134 12657924
• Patch 17184721 - CLEAN UP OBSOLETE ORACLE/QSMA SYNONYMS POST INSTALL SCRIPT

1.3.4 Apply Mandatory Application Tier Patches using ADOP

1.3.4.1 Apply following application tier patches using ‘applvis’ user:
• Patch 16605855 - Consolidated Seed Table Upgrade Patch 16605855:12.2.0

1.3.5 Run utldchk.sql and compile database objects

1.3.5.1 Create custom application directory.
$ sqlplus / as sysdba
sqlplus> @$ORACLE_HOME/rdbms/admin/utldtchk.sql

1.3.6 Setting-up DB Tier Environment

1.3.6.1 Run the following commands from ‘root’ user to setup DB Tier Environment
$ su - oravis
$ cd /u01/oracle/VIS/11.2.0
$ . VIS_ebs122.env run

1.3.7 Starting and Stopping Oracle Enterprise Database and Listener

1.3.7.1 From ‘oravis’ user run the following commands to start the Database
$ cd /u01/oracle/VIS/11.2.0/bin
$ sqlplus '/as sysdba';
$ sqlplus > startup;

1.3.7.2 As an alternate, you can also use the following standard script to start the database:
$ cd $ORACLE_HOME/appsutil/scripts/VIS_ebs122
$ addbctl.sh start

1.3.7.3 From ‘oravis’ user run the following commands to start the Listener
$ lsnrctl start VIS

1.3.7.4 As an alternate, you can also use the following standard script to start the Listener:
$ cd $ORACLE_HOME/appsutil/scripts/VIS_ebs122
$ addlnctl.sh start VIS

1.3.7.5 From ‘oravis’ user run the following commands to stop the Database
$ cd /u01/oracle/VIS/11.2.0/bin
$ sqlplus '/as sysdba';
$ sqlplus > shutdown;

1.3.7.6 From ‘oravis’ user run the following commands to stop the Listener
$ lsnrctl stop VIS

1.3.7.7 As an alternate, you can also use the following standard script to start the Listener:

$ cd $ORACLE_HOME/appsutil/scripts/VIS_ebs122
$ addlnctl.sh stop VIS

1.3.8 Setting up Application Tier Environment

1.3.8.1 Create custom application directory.
$ export ORACLE_SID=VIS
$ cd /u01/oracle/VIS/fs1/EBSapps/appl
$ . VIS_ebs122.env run

1.3.9 Starting and Stopping Application Tier, Weblogic Server and Other Services

1.3.9.1 Use following script to Start Application Tier:

$ su - applvis
$ cd /u01/oracle/VIS/fs1/inst/apps/VIS_ebs122/admin/scripts
$ adstrtal.sh

1.3.9.2 Use following script to Stop Application Tier:
$ cd /u01/oracle/VIS/fs1/inst/apps/VIS_ebs122/admin/scripts
$ adstpall.sh

1.3.10 Starting Weblogic Node Manager

1.3.10.1 Use following script to start weblogic Node Manager from ‘applvis’ user:
$ /u01/oracle/VIS/fs1/FMW_Home/wlserver_10.3/server/bin/startNodeManager.sh

1.3.11 Starting and Stopping Weblogic Admin Server

1.3.11.1 Starting Weblogic Admin Server from ‘applvis’ user:
$ $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
OR
$ /u01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/bin/startWebLogic.sh

1.3.11.2 Stopping Weblogic Admin Server from ‘applvis’ user:
$ $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

1.3.12 Bouncing Apache

1.3.12.1 Create custom application directory.

1.3.13 Installing JRE and Linking it in Browser

1.3.13.1 Create custom application directory.

1.3.14 Launching Oracle E Business Suite in Browser

1.3.14.1 Create custom application directory.

1.3.15 Backup Oracle Applications

1.3.15.1 Create custom application directory.

Upgrading from R12.2.0 to R12.2.2
Hands-On Installation Steps – Standard Installatio...