Oracle Apps DBA

Journal Import Concurrent Request completed with error, the error is OAR-04030 out of process memory and Journal Import has huge amount of records to be processed. If this is the Scenerio, We can split the journal import and delete process into two steps. 1. Run the program from the command line, in NODEL - no delete mode. $GL_TOP/bin/GLLEZL / 0 Y NODEL 2. Run the Journal Import Delete program to delete all processed records, at a later time (when there is no time crunch). To run Journal Import from the operating system follow the steps below: $GL_TOP/bin/GLLEZL username/passwd 0 Y no 1 N "" "" N N 2 where: 0 : request id no : interface_run_id 1 : set of books id N : (Yes or No) Post Errors to Suspense "" : Start and End Date (Note there is no space between the double quote

After Cloning the Oracle Apps 11i we cant start the Apache and Its exiting with status 3 Cause: Apache Web Server Listener is not running. Starting Apache Web Server Listener (dedicated HTTP) ... /oradb/apps/uatora/iAS/Apache/Apache/bin/apachectl start: httpd started Apache Web Server Listener (PLSQL) is not running. Starting Apache Web Server Listener (dedicated PLSQL) ... Syntax error on line 17 of /oradb/apps/uatora/iAS/Apache/modplsql/cfg/plsql_pls.conf: Cannot load /oradb/apps/uatora/iAS/Apache/modplsql/bin/modplsql.so into server: ld.so.1: httpd: fatal: libclntsh.so.8.0: open failed: No such file or directory /oradb/apps/uatora/iAS/Apache/Apache/bin/apachectl start: httpd could not be started Solution : Run the $IAS_ORACLE_HOME/bin/adlnkiAS.sh file and restart the Apache