Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

To start the tuning process it is best to get a trace file from the program. The method of getting the trace file for a concurrent program is detailed below. Step 1: Enable trace on the concurrent program Responsibility: System Administrator   Navigation: Concurrent > Program > Define Query for the concurrent program Check the box labeled,  Enable Trace Save the form. Step 2: Execute the concurrent program Go to the responsibility from which you can execute the concurrent program. Click on View > Requests and open the SRS form.  select  Run the concurrent program. Note the request ID. It is 8888888 Step 3: Locate the trace file directory Connect to the database and execute the following SQL, SELECT *   FROM v$parameter  WHERE NAME = 'user_dump_dest' Now get the Oracle process ID for this request. Execute the following script SELECT oracle_process_...

EBS 12.2 uses WebLogic Server from Fusion Middleware 11g in place of OC4J 10g as part of the release’s internal technology stack. Your organization’s security rule may demand changing password for important uerids at regular interval. This document describes the procedure to use if you need to change the password  of the Oracle WebLogic Server Administration user password at some time. 1. Log in to the Oracle WebLogic Server Administration console at http:// <server>.<domain>:<wls_admin_port>/console with the current user name and password. 2. Choose the Lock and Edit button. 3. Select the ‘Domain’ link under the Domain Structure section. 4. Select the Security tab. 5. Select Advanced. 6. Enter the new Node Manager/Weblogic password. 7. Choose the Save button and then the Activate Changes button. 8. Choose the ‘Security Realms’ link on the Oracle E-Business Suite 12.2 domain configuration, and then select the ‘myreal...

Adding New User in Oracle Apps (EBS) from back end Application users in Oracle Apps (EBS) can be created from the front end as well as back end. The back end method for user creation can be used when you don’t have sysadmin access to the applciation or also it can be used to speed up the process when there are many userids to be created. You will require apps access to connect to database  to run the package fnd_user_pkg. OR you need to connect by those database userids having execute permission on fnd_user_pkg. Also if you are using some other user, you need to prefix schema name (i.e. use apps.fnd_user_pkg.createuser) We can create user, disable/enable user, add/delete responsibility to the user through back end using this seeded oracle API. fnd_user_pkg is the seeded generic API provided by Oracle. In this post we will see how to use below two functionality of this API ...

Today development team has reported an issue that when they are trying to compile any package which have apps.<> schema reference thrown an error: Troubleshoot : 1. Package code I have compiled successfully in other instances like dev2, however got the error in dev1 instance. If we remove schema reference (apps) then it’s compiling from dev1 also but as per coding standard it has good practice to use apps.<>. This show that there are some issue on dev1 DB. Error on Dev1: ORA-06550: line 7, column 3: PLS-00905: object APPS.APPS is invalid ORA-06550: line 7, column 3: PL/SQL: Statement ignore.   2. Now we should make sure that we have created the package in the right place. set linesize 90 column owner       format a20 column object_name format a30 column object_type format a20 show user select owner, object_name, object_type   from dba_objects  where object_name='LPW_PO_APPROVAL'  order by 1,2,3;  ...

Script to get the list of sessions for a user currently in the Database select sid,serial#,username,status,module,command, to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON", program,last_call_et from v$session where username like '%&usr%' order by logon_time;  Changes the usr as per your requirement.

RMAN Script to take a Hot Backup of Database using Catalog # This script can be used to take a hot backup using RMAN. # Some of the variables in the initial section of the script need to have valid values # Set the catalog to the catalog database # This script will also mail errors encountered in the backup process # ============================= #!/bin/sh export ORACLE_SID=PROD export ORACLE_HOME=.... export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin DBA="himanshu.apps@gmail.com" INST=`hostname` TODAY=`date +%d%b` BACKUP_DIR=/u01/backup/ LOG_DIR=/u01/backup/logs LOGFILE=$LOG_DIR/rman_backup_${ORACLE_SID}_${TODAY}.log ERRFILE=$LOG_DIR/err_status.log $ORACLE_HOME/bin/rman <<EOF > ${LOG_DIR}/rman_backup_${ORACLE_SID}_${TODAY}.log connect target/ connect catalog rman/rman@rmandb run { allocate channel t1 TYPE DISK; setlimit channel t1 kbytes 2048000; allocate channe...

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Scenario: After cloning, While launching the forms we get the following error Error : FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details. Cause: This is due to ldflags pointing to wrongly to PROD server which should points to (TEST/DEV) respective server. Solution: Source the Apps environment Bring down the application Cd $ORACLE_HOME/lib ls –lrt ldflags  -Would be pointing to production location unlink  ldflags ln -s   /u01/test/apps/tech_st/10.1.2/lib/ldflags ldflags (link to the right path) cd $ORACLE_HOME/forms/lib32/ make -f ins_forms.mk install Now restart the application and check for the same.

Step 1: Create Apps Read only user. Connect as SYS user to create APPSRO user create user appsro identified by appsro default tablespace APPS_TS_TX_DATA; grant connect, resource to appsro; grant create synonym to appsro; exit;  Step 2: Connect to apps user now to get the synonyms and grant details.  Connect as APPS user and run the SQL commands: bash $ sqlplus apps/apps SQL>set head off SQL> set newpage none SQL> set pagesize 9999 SQL> spool  create_synonyms.sql  SQL> select ‘create synonym ‘ || OBJECT_NAME || ‘ for ‘ || OWNER ||’.’ ||OBJECT_NAME || ‘;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’,’PACKAGE’,’PACKAGE BODY’,’PROCEDURE’,’FUNCTION’);  SQL> spool off  SQL> spool  grant_select.sql  SQL> select ‘grant select on ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘ to appsro;’ from all_objects where OWNER not in (‘SYS...