Oracle Application DBA (11i , 12.1 12.2): 2021

Thursday, August 26, 2021

EBS Technology Patch Automation Tool for Application Tier (ETPAT-AT) (Doc ID 2749774.1)

Monday, August 16, 2021

R12.2 WebLogic OACore Server Error 'java.io.FileNotFoundException: 504: Gateway Time-out' Appears in Server Logs When Adding Managed Servers Via adProvisionEBS.pl and txkSetAppsconf.pl (Doc ID 2082124.1) To BottomTo Bottom

Thursday, August 12, 2021

12.2 E-Business Suite Applications Framework Commands To Use The CacheWatchUtil With The Java Object Cache Monitor Tool For Diagnostics And Debug Log Creation (Doc ID 2329601.1)

Wednesday, August 11, 2021

Oracle Identity and Access Management Upgrade Strategies

F33537-04

May 2021

Documentation for installers and system administrators that describes the different strategies you can use to upgrade Oracle Internet Directory, Oracle Unified Directory, and Oracle Identity and Access Management.

Monday, August 9, 2021

CAC Authentication

CAC_diagram

Thursday, July 29, 2021

Oracle Identity and Access Management 12.2.1.3.0 Certifications.

Oracle Identity and Access Management 12.2.1.3.0 Certifications.
Number of Releases / Versions
Operating Systems (6 Items)

HP-UX Itanium
   1 Version(11.31)
IBM AIX on POWER Systems (64-bit)
   2 Versions(7.2,7.1)
Linux x86-64
   7 Versions(SLES 15,SLES 12,SLES 11,Red Hat Enterprise Linux 7,Red Hat Enterprise Linux 6,Oracle Linux 7,Oracle Linux 6)
Microsoft Windows x64 (64-bit)
   4 Versions(2019,2016,2012 R2,2012)
Oracle Solaris on SPARC (64-bit)
   1 Version(11)
Oracle Solaris on x86-64 (64-bit)
   1 Version(11)
Application Servers (1 Item)

Oracle WebLogic Server
   1 Release(12.2.1.3.0)
Databases (3 Items)
Oracle Database (App Data Access)
   6 Releases(19.0.0.0.0,18.0.0.0.0,12.2.0.1.0,12.1.0.2.0,12.1.0.1.0,11.2.0.4.0)
Oracle Database (Target DB for RCU)
   6 Releases(19.0.0.0.0,18.0.0.0.0,12.2.0.1.0,12.1.0.2.0,12.1.0.1.0,11.2.0.4.0)
Oracle Database (WLS Server Features)
   6 Releases(19.0.0.0.0,18.0.0.0.0,12.2.0.1.0,12.1.0.2.0,12.1.0.1.0,11.2.0.4.0)
Desktop Applications, Browsers and Clients (5 Items)

Apple Safari
   2 Releases(10.*,9.*)
Google Chrome
   1 Release(84+)
Microsoft Edge
   1 Release(40.*)
Microsoft Internet Explorer
   1 Release(11.*)
Mozilla Firefox
   1 Release(79+)
Directory/LDAP Services (10 Items)

IBM Security Directory Server
   1 Release(6.4+)
IBM Tivoli Directory Server
   1 Release(6.3)
Microsoft Active Directory
   3 Releases(2016,2012 R2,2012)
Microsoft Active Directory Lightweight Directory Services
   3 Releases(2016,2012 R2,2012)
Novell eDirectory
   1 Release(8.8)
OpenLDAP
   1 Release(2.4)
Oracle Directory Server Enterprise Edition
   1 Release(11.1.1.7.0)
Oracle Internet Directory
   3 Releases(12.2.1.3.0,11.1.1.9.0,11.1.1.7.0)
Oracle Unified Directory
   2 Releases(12.2.1.3.0,11.1.2.3.0)
Oracle Virtual Directory
   2 Releases(11.1.1.9.0,11.1.1.7.0)
Enterprise Applications (2 Items)

Oracle Communications Billing and Revenue Management
   3 Releases(12.0.0.3.0,12.0.0.2.0,12.0.0.1.0)
Oracle Communications Pricing Design Center
   2 Releases(12.0.0.3.0,12.0.0.2.0)
Management and Development Tools (3 Items)

HP JDK
   1 Release(8.0.09+)
IBM JDK
   1 Release(1.8.0 SR4 FP2+)
Oracle JDK
   15 Releases(1.8.0_291,1.8.0_281,1.8.0_271,1.8.0_261,1.8.0_251,1.8.0_241,1.8.0_231,1.8.0_221,1.8.0_212,1.8.0_211)and 5 others
Middleware (9 Items)

Apache HTTP Server
   2 Releases(2.4.2+,2.2.*)
Built-in Reverse Proxy
   1 Release(.)
Microsoft Internet Information Services
   2 Releases(10,8.5)
Oracle Access Management
   2 Releases(12.2.1.3.0,11.1.2.3.0)
Oracle HTTP Server
   6 Releases(12.2.1.4.0,12.2.1.3.0,12.2.1.2.0,12.2.1.1.0,11.1.1.9.0,11.1.1.7.0)
Oracle Traffic Director
   4 Releases(12.2.1.4.0,12.2.1.3.0,12.2.1.2.0,12.2.1.1.0)
Oracle WebLogic Server Plug-In
   5 Releases(12.2.1.3.0,12.2.1.2.0,12.2.1.1.0,12.1.3.0.0,11g)
Oracle iPlanet Web Server
   4 Releases(7.0.15.0.0,7.0.11.0.0,7.0.9.0.0,7.0.0.0.0)
mod_wl_ohs.so
   2 Releases(12c,11g)

Thursday, May 20, 2021

How restore database from TSM back for DR Test.

Assume your oracle database rman backup files are stored in TSM.

Make sure the mount point is comes up.

dsmc

tsm > restore -inactive /apps/* sudir=yes

All the files will be restore from tsm for your environment. like oracle home, TNS_ADMIN/ ... etc.

tsm > restore - inactive /orafra/$SID subdir=yes

Sames as above all the files will be restored from /orafra/$SID/ Ctl, dbf, redo .. etc..

Restore function invoked.

Assume all the neccessary files are restored from TSM for your environment.

$rman target=/

STARTUP NOMOUNT

RESTORE CONTROL FILE FROM AUTOBACKUP;

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

RESTORE DATABASE;

RECOVER DATABASE;

SQL "ALTER DATBABASE OPEN RESETLOGS";

ALTER DATBASE OPEN RESETLOGS;

Friday, May 14, 2021

ADCGNJAR

Ref Notes: Note 1609939.1

Oracle has introduced adcgnjar utililty for the deployments which helps to create customall.jar file in $JAVA_TOP. This jar file will picked and executed by the application server.

Place required OAF CO/VO/EO files in $JAVA_TOP respective folder.
Run adcgnjar utile package which is available in $AD_TOP.
Add the entry for customall.jar in the ebsProduct Manifest.xml file
Bounce the mid-tier server
{ sleep 1s; echo apps; sleep 1s; echo appspassword;} | adcgnjar

Friday, April 23, 2021

EBS Application and DB Tunning

https://www.oracle.com/technetwork/apps-tech/ebs-performance-tuning-part-1-470542.pdf

How to run adconfig on Patch file system?

1. you must disable trigger ebs_login prior to running autoconfig.

2. Log into sqlplus as SYSTEM

3. SQL> alter trigger ebs_logon_disable; trigger altered. exit;

4.$ehco $FILE_EDITIONS it should show patch file system PATCH

5. adautocfg.sh once completed successfully enable the trigger.

6. log into sqlplus as SYSTEM

7 . SQL> alter trigger ebs_logon_enable; trigger altered. exit;

Monday, January 11, 2021

oafm_server1 status was admin mode

####<Jan 11, 2021 9:58:56 PM EST> <Info> <JDBC> <suthakar.prince> <oaea_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1610420336490> <BEA-001177> <Creating data source connection pool named OAEADatasource, URL = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=suthakar.prince)(PORT=1608)))(CONNECT_DATA=(SERVICE_NAME=DEV))), Properties = user=APPS;.>
####<Jan 11, 2021 9:58:56 PM EST> <Info> <Common> <suthakar.prince> <oaea_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1610420336505> <BEA-000626> <Free resources in pool "OAEADatasource" will be tested every "120" seconds.>
####<Jan 11, 2021 9:58:59 PM EST> <Info> <JDBC> <suthakar.prince> <oaea_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1610420339875> <BEA-001508> <Destroying data source connection pool OAEADatasource.>
####<Jan 11, 2021 9:58:59 PM EST> <Info> <JDBC> <suthakar.prince> <oaea_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1610420339876> <BEA-001155> <The following exception has occurred:

weblogic.common.ResourceException: Unknown Data Source OAEADatasource
        at weblogic.jdbc.common.internal.ConnectionPoolManager.shutdownConnectionPool(ConnectionPoolManager.java:622)
        at weblogic.jdbc.common.internal.ConnectionPoolManager.shutdownAndDestroyPool(ConnectionPoolManager.java:594)
        at weblogic.jdbc.common.internal.ConnectionPoolManager.shutdownAndDestroyPool(ConnectionPoolManager.java:520)
        at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:320)

Solution:

login into EBS weblogic Console Navigate to EBSDATASource and click OAEADataSource - > connectionpool - and update apps password.

admanagedsrvctl.sh stop oaea_server1

admanagedsrvctl.sh start oaea_server1

Oracle Application DBA (11i , 12.1 12.2)