TechExuberance

Above screenshot might click many Apps DBAs who have recently applied - 1. April 2019 CPU Patch 2. Upgraded to Latest AD and TXK level (C.11) Recently I applied Oracle E-Business Suite Technology Stack Delta 11 on an EBS r12.2.7 implementation. After applying patch we went for sanity checks and when trying to open Weblogic Server console I got this - The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2 Below are metalink ids ideally Apps DBAs should refer to for resolving this- Alternative Methods to Allow Access to Oracle WebLogic Server Administration Console from Trusted Hosts for Oracle E-Business Suite Release 12.2 (Doc ID 2542826.1) ORA-12547 While Client Connecting Via SSH Tunnel (Doc ID 454252.1) Oracle Community also has few tips for this- https://community.oracle.com/message/15413970#15413970 Troubleshooting Part - cd $FMW_HOME/user_pr...

Below query can be very handy in finding out current AD and TXK code levels. col ABBREVIATION for a10 set lines 1000 col NAME for a50 col CODELEVEL for a20 SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad'); ABBREVIATI NAME                                                CODELEVEL ---------- -------------------------------------------------- ------------ ad           Oracle Applications DBA                             C.11 txk         Oracle Applications Technology Stack    ...

Job Role Separation (JRS) environment when deploying Oracle Grid Infrastructure is about having 2 different users for GI and DB installation. In our scenario, we will have oracle for database installation and oraasm for Grid Infrastructure installation Checklist for Job Role Separation (JRS) environment- 1. setuid bit - As root, change the file permissions of the oracle executable under the <Grid_Home>/bin and the <db_home>/bin, to 6751 This is basically used on binaries when you would like OS user A to execute binary X which owned by user B preserving privileges of user B. # cd <Grid_Home>/bin # ls -l oracle # chmod 6751 oracle # ls -l oracle -rwsr-s--x 1 grid oinstall 173515905 May 21 17:04 oracle This is the setuid bit, and this must be set in order for users, other than "Grid" user to have it work. (same applies to the db_home) # cd <ORACLE_Home>/bin # ls -l oracle # chmod 6751 oracle # ls -l oracle 2. Both us...

1. Preinstaller rpms are great and your files are backed up under /var/log/oracle-ebs-server-R12-preinstall/backup sysctl.conf resolv.conf grub.cfg 2. orakernel.log often ignored should be reviewed after installing both rpms oracle-rdbms-server-12cR1-preinstall oracle-ebs-server-R12-preinstall 3. applmgr and oracle have oinstall as common primary OS group. applmgr does not have dba as secondary group. 4. Starting from OL7, user limits are not stored in /etc/security/limits.conf. There will be .conf files created under /etc/security/limits.d  that are read by systemd during server startup  5. resolve.conf file will be overridden if you have DNS1/2 directives in your network configuration files - /etc/sysconfig/network-scripts/ifcfg-* You can make resolv.conf immutable to changes or remove directives DNS1/2 in your network configuration files.

When we are facing performance issues with frmweb sessions, below CONTEXT_FILE variables must be considered – FORMS_CATCHTERM – This variable decides enabling/disabling of forms abnormal termination handler(FATH). FATH basically writes diagnostic information into dumpfile or form server log. Default value is '1'. FORMS_RECORD_GROUP_MAX – This is a customized environment variable when using in servlet mode while we can directly set this in socket.env with socket mode. FORMS_MMAP – This is mainly monitored in socket mode. When set to 0 will not put .fmx files in shared memory mapped files resulting in more memory consumption. Recommended value for this variable is 1. Scenario - Common frmweb process issues are with high CPU and memory consumption. This results in slowing down application server where forms services are running. Whenever an end user is working LOVs fetching huge number of records, these records are loaded in memory and result in ...

WHAT ARE .RTI FILES? For the starters, we referred - What Are .RTI And .FLI Files? (Doc ID 470850.1) and summarized as follows - Format-     em_<PID>.rti These files are generated by the forms runtime processes. Used by Oracle Application Manager "OAM" and the Enterprise Manager "EM" for Forms Monitoring services The rti files should automatically be cleaned up/removed when the user logs out of the Oracle Applications in a normal logout fashion. However, if a user does not logout, and just uses the 'X' button to close the form or kills the browser session before logging out of forms, then the rti file may not get cleared. If the files are not automatically being removed, then you can write a Unix shell script to remove them periodically. We opened a forms session from ebs r12.1.3 to simulate - 1. Normal Logout Fashion for forms 2. Forms Abnormal termination We used below environment for our test-case - Normal ...

Thursday morning and we have a cloning request, well Apps DBAs perform cloning periodically, and at times get adhoc requests from functional or development teams. This was an adhoc request and with below environment 1. Single node ebs 12.2.7 2. Oracle database 12.1.0.2 3. Non-RAC and Non-ASM Issue we faced actually compelled me to understand cloning internals. It was a cold backup cloning. We have a cold backup to test server and had to clone it onto another development server. Just to summarize on where we actually faced this error, below is an account of what about steps we followed to achieve this - We decided to go with dbTier because - - Its a cold backup restore. - dbTier will take care of database registration in inventory, relink and configuration of binaries, recreate controlfile, restore and configure database, start database and listener. Lets head on towards the error - Error -----  /     50% completed      ...