Apps DBA Workshop

Error encountered while trying to extract emcli utility from EM 12c cloud control OMS Home: [ora11g@monitorerp EMCLI]$ java -jar emclikit.jar client -install_dir=/u01/12c_Agent/EMCLI Exception in thread "main" java.lang.ClassFormatError: oracle.sysman.emCLI.CLIInstallLaunch (unrecognized class file version) at java.lang.VMClassLoader.defineClass(libgcj.so.7rh) at java.lang.ClassLoader.defineClass(libgcj.so.7rh) at java.security.SecureClassLoader.defineClass(libgcj.so.7rh) at java.net.URLClassLoader.findClass(libgcj.so.7rh) at java.lang.ClassLoader.loadClass(libgcj.so.7rh) at java.lang.ClassLoader.loadClass(libgcj.so.7rh) at gnu.java.lang.MainThread.run(libgcj.so.7rh)   Cause: Expected version of java executable is not exists in PATH variable.   Solution: => Set JDK 1.6_u30 in PATH vriable and rerun the command it should execute without any errors => If java 1.6_uxx is not preset in your OS then please download and install it. ...

After configuring new clone in R12.1.3 when i was trying to run adautoconfig.sh script on dbTier then it completing with errors. In autoconfig logfile error stack: Connected. Checking for existence of the ACL .... DECLARE * ERROR at line 1: ORA-04031: unable to allocate 2032 bytes of shared memory ("shared pool","XDbD/PLZ01TcHgNAgAIIegtw==","qmxlu subheap","qmichdlArrayImg") ORA-06512: at line 16 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options txkcreateACL.sh: exiting with status 1   Cause: The configured shared_pool size in initialization parameter file is only 400 MB. Solution: => Increase shared_pool size 1000 MB => Bounce database => Re-run autoconfig This time it should complete successfully. bash-3.00$ adautocfg.sh Enter the APPS user password: The log file for this ses...

Hi, Error occured while running adcfgclone on dbTier  on R12.1.3 Sun Solrais 10 sparc 64-bit with the following error: RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635) at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473) at oracle.apps.ad.clone.ApplyDatabase. (ApplyDatabase.java:366) at oracle.apps.ad.clone.ApplyDBTier. (ApplyDBTier.java:110) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67) at java....

Hi, When  i was trying to start one of of TEST R12.1.1 applicaiton script "adoacorectl.sh" is exiting with error "adoacorectl.sh: exiting with status 204" and when trying to stop its exiting with error "adoacorectl.sh: exiting with status 204" Error Stack when trying to start: Executing service control script: /u01/applR12/inst/apps/TEST_linuxerp1/admin/scripts/adoacorectl.sh start script returned: **************************************************** You are running adoacorectl.sh version 120.13 Starting OPMN managed OACORE OC4J instance  ... adoacorectl.sh: exiting with status 204 adoacorectl.sh: check the logfile /u01/applR12/inst/apps/TEST_linuxerp1/logs/appl/admin/log/adoacorectl.txt for more information ... [applerp@linuxerp1 scripts]$ adopmnctl.sh status You are running adopmnctl.sh version 120.6 Checking status of OPMN managed processes... Processes in Instance: TEST_linuxerp1.linuxerp1.orasol.com ----------------------...

This article illustrates how to run "Purge Inactive Sessions" concurrent program in Oracle E-Business suite R12.1 This program will purge all session which are not active. "Purge Inactive Sessions" concurrent program is not included in request group of  system administrator responsibility. So first we need to add this request to system administrator responsibility request group. Navigation: login as sysadmin >  System Administrator > Security > Responsibility > Request - Here search for Group "System Administrator" - Add concurrent program "Purge Inactive Sessions" - save  - Submit new request "Purge Inactive Sessions""   - After successful completion of this request then check no. of records in table icx_sessions.  Hope helps :) Thanks for reading. regards, X A H E E R

This posts illustrates steps for cloning a 11gR2 RAC database to a single Instance database.  There are many ways to perform a RAC database to NON-RAC database clone, but the below illustrated seems to be the easiest approach for me compare to all other methods. In this demonstration oelrac1 & oelrac2 are OEL 5.6 Linux hosts running 11.2.0.1 GI and 11.2.0.1 database. - erpnode3 running OEL 5.6 configured with all database OS pre-requisites, but does not contain any oracle product installed on it. Steps: 1) perform  full database backup from any of the RAC Instance RMAN> connect target connected to target database: PROD (DBID=208065887) RMAN> RUN 2> { 3> allocate channel ch1 type 4> disk format '/u01/11g_db/rman_db_backups/%d_DB_%u_%s_%p'; 5> backup database plus archivelog; 6> release channel ch1; 7> } released channel: ORA_DISK_1 allocated channel: ch1 channel ch1: SID=67 instance=prod1 device type=DISK Startin...