Oracle EBS 11i,R12.1 and R12.2 Part-2

System Administrator responsibility tasks: 

As a DBA can maintain/monitor/troubleshoot concurrent managers, submit concurrent requests, create users and assign responsibilities. Workflow mailer start/stop and troubleshooting activities etc.,

Concurrent Managers: Login to system administrator responsibility à Concurrent à Managers à Administrator

Concurrent Request Submit: system administrator à Concurrent àRequest àSubmit new request

Create User and assign responsibilities: system administrator à Security à User àDefine

Workflow Mailer: system administrator à Oracle Applications Manager à workflow à site map à Notifications

Also possible to perform printer registrations, applications/functions/menus creation/updations as per the requirement.

Cloning: Either hotbackup or RMAN mechanism use to clone Database. For Applications will copy RUN file system “EBSapps” directory from source to target and reconfigure.

1.      Run adpreclone script on source database and applications respectively.

2.      Clone database using hot backup or RMAN.

3.      Create necessary directories in Target

4.      Copy Source RUN file system “EBSapps” directory to Target (If source RUN file system was fs2 then target RUN file system should be fs2 only)

5.      Run adcfgclone.pl and configure Target RUN file system.

6.      Start Admin server and run adpreclone.pl on Target RUN file system.

7.      Stop Admin server and copy Target RUN file system “EBSapps” directory to Target PATCH file system.

8.      Run adcfgclone.pl and configure Target PATCH file system.

9.      Perform post clone steps.

10.  Start services and perform sanity checks

FNDCPASS: It is the utility to change user passwords.

Modes: SYSTEM: Used to change APPS and APPLSYS users passwords

Syntax: FNDCPASS apps/<apps old password> 0 Y system/<system password> SYSTEM APPLSYS <new password>  for 11i/R12.1 only.

Note: 1.APPLSYS and APPS are having same password. Using above syntax to change both passwords single time.

APPS Password change in R12.2:

FNDCPASS apps/<apps old password> 0 Y system/<system password> SYSTEM APPLSYS <new password> 

 Run Autoconfig in Database Tier and then Application tier

Note:-

Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services

Change the "apps" password in WLS Data source as follows:

Ø  Log in to WLS Administration Console.

Ø  Click Lock & Edit in Change Center.

Ø  In the Domain Structure tree, expand Services, then select Data Sources.

Ø  On the "Summary of JDBC Data Sources" page, select EBSDataSource.

Ø  On the "Settings for EBSDataSource" page, select the Connection Pool tab.

Ø  Enter the new password in the "Password" field.

Ø  Enter the new password in the "Confirm Password" field.

Ø  Click Save.

Ø  Click Activate Changes in Change Center.

ORACLE: Used to change application product schema passwords i.e., AP, AR, GL etc,

Syntax: FNDCPASS apps/<apps password> 0 Y system/<system password> ORACLE GL   <new password> 

USER: Used to change application user passwords i.e., SYSADMIN etc,

Syntax: FNDCPASS apps/<apps password>   0 Y system/<system password> USER SYSADMIN <new password> 

Differences between 11i/R12.1 and R12.2:

11i	R12.1	R12.2
9iAs and 8.0.6 Tech Stack used.8.0.6 is for forms and reports and 9iAS is Apache home	10.1.2 and 10.1.3 (10gAS) Tech stack was used. 10.1.2 is for forms and reports and 10.1.3 is Apache home	10.1.2 for forms and reports and FMW home replaced with Apache home
9.2.0 is the Default Database	10.2.0 is the Default Database	11.2.0 is the Default Database
Socket  mode was a static connection to handle HTTP or HTTPS requests	Servlet mode was introduced and it has more enhanced features like forms server directly communicate to HTTP or HTTPS requests	Weblogic Admin server handles the requests and submitted to forms_server or forms_c4ws_server managed servers
Mod Jserv and mod PL/SQL used to process the requests	OC4J will handle	Weblogic server will handle
Java Jinitiator was used	JRE plugin	JRE plugin
Report Server handle reports	XML publisher handle reports	BI publisher handle reports
Contains APPL_TOP,COMMON_TOP & ORA_TOP (IAS_ORACLE_HOME & ORACLE_HOME)	Contains APPS_TOP and INST_TOP	Contains RUN,PATCH and NE_BASE file systems
adpatch is the utility to apply the patches	adpatch is the utility to apply the patches	adop utility was introduced to apply patches online
FNDCPASS is the utility to change the APPS user password	FNDCPASS is the utility to change the APPS user password	FNDCPASS is the utility to change the APPS user password, also will change it from ADMIN console