[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], [] ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

OPP LOG

[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)

SOLUTION

1. Shut down all services
Verify NO CP processes are running on OS. This includes FNDLIBR, FNDSM, etc.

IMPORTANT: BE SURE TO RUN THESE SCRIPTS AS THE CORRECT USERS SYSTEM and APPLSYS ONLY.

2. Run $FND_TOP/patch/115/sql/afopp001.sql as SYSTEM.

3. Run $FND_TOP/patch/115/sql/afopp002.sql as APPLSYS.  Commit.

4. Restart managers and test again.

DB link Cross platform

DB link Cross platform

Important information user have to provide:
-----------------------------------------------------------------------------------------------------------------------------------
1. Source Server Name.
2. Source DB-Name.
3. Source DB-Link Owner schema name.
4. DB-Link name
5. Target Server name.
6. Target Port number.
7. Target DB-Name.
8. Target Username/password.

Example

-----------------------------------------------------------------------------------------------------------------------------------
1. Source Server Name            -    ora1.svr.us.abc.net
2. Source DB-Name.            -    ABCD
3. Source DB-Link Owner schema name.    -    PUBLIC
4. DB-Link name                -    GLOBAL_MX_DTCC_2
5. Target Server name.            -    TARGET.uk.ABC.com
6. Target Port number.            -    1551
7. Target DB-Name.            -    GLOBAL_MX_DTCC_PHASE2
8. Target Username/password.        -    GLOBAL_MX_DTCC2_USER/"Password".


DB-Link Creation Process:

1. Create pfile as << initdg4DATABASENAME.ora >> under directory location << $ORACLE_HOME/dg4msql/admin >>:
EXAMPLE:
-------------------------
XXXXXXXX: /export/NRD/oracle/product/11.1.0/db_1/dg4msql/admin>
-rw-r--r-- 1 oracle dba   397 Aug 20 09:26 initdg4GLOBAL_MX_DTCC_PHASE2.ora

$ cat initdg4GLOBAL_MX_DTCC_PHASE2.ora
------------------------------------------------------------------------------------------------------------------------------------
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=TARGET.uk.ABC.com:1433
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER


2. Update tnsnames.ora under $ORACLE_HOME?network/admin with ADDRESS/CONNECT_DATA as mentioned below in example:

Tnsnames.ora entry example:
--------------------------------------------------------------------------------------------
dg4DATABASE-Name =
    (DESCRIPTION=
        (ADDRESS=(PROTOCOL=tcp)(HOST= ora1.svr.us.abc.net)(PORT=1551))
        (CONNECT_DATA=(SID=dg4GLOBAL_MX_DTCC_PHASE2))
        (HS=OK)
     )


3. create cross platform DB-Link using below command on sqlplus:

DDL for Cross platform DB-Link:
---------------------------------------------------------------------------------------------
CREATE PUBLIC DATABASE LINK "GLOBAL_MX_DTCC_2" CONNECT TO "GLOBAL_MX_DTCC2_USER" IDENTIFIED BY password USING '(DESCRIPTION= (ADDRESS=PROTOCOL=tcp)(HOST= ora1.svr.us.abc.net)(PORT=1551)) (CONNECT_DATA=(SID=dg4GLOBAL_MX_DTCC_PHASE2)) (HS=OK))';


4. Restart listener associated with Database in which this DB link is created Note: restarting listener is the requirement for creating crossplatform listener.


5. Check status of restarted listener it should show entry like below:
--------------------------------------------------------------------------------------------------
Service "dg4GLOBAL_MX_DTCC_PHASE2" has 1 instance(s).
  Instance "dg4GLOBAL_MX_DTCC_PHASE2", status UNKNOWN, has 1 handler(s) for this service...


6. check if the DB-Link is working fine, using below on sqlplus:
---------------------------------------------------------------------------------------------------
SQL> select sysdate from dual@GLOBAL_MX_DTCC_2;

SYSDATE
---------
20-Aug-15

Explain plan for an Old Query

Explain plan for an Old Query

set pages 9999 lines 300
select SESSION_ID,SESSION_SERIAL#,SQL_ID,SQL_PLAN_HASH_VALUE from DBA_HIST_ACTIVE_SESS_HISTORY where SESSION_ID=<session_id> and SESSION_SERIAL#=<session_serial>;

SELECT * FROM TABLE(dbms_xplan.display_awr('&SQL_ID'));

SELECT * FROM TABLE(dbms_xplan.display_awr('&SQL_ID','&plan_hash_value'));

select * from table(dbms_xplan.display_awr('&sql_id',null,null,'advanced +peeked_binds'));

SELECT * FROM TABLE(dbms_xplan.display_cursor('&SQL_ID'));

SELECT * FROM TABLE(dbms_xplan.display_cursor('&SQL_ID', '&child_number'));

R12: Error "Java Exception in Thread 'Main' java.lang.OutOfMemoryError: Java Heap Space

R12: Error "Java Exception in Thread 'Main' java.lang.OutOfMemoryError: Java Heap Space

Increase the amount of memory available as follows:

a. Login to the instance as system administrator
b. Go to Concurrent -> Program -> Define
c. Search for the following concurrent program
d. In the 'Executable' group, there is a field named 'Options'.
Enter the value '-ms2048m -mx2048m' as the value for this field.
This will set the heap space min and max size to 2GB.
Bounce the concurrent managers.

e. Save the change and retest the issue.

Delete large number of files - LINUX

Delete large number of files - LINUX

Go to the folder location

cd < folder name>

A faster way of deleting files is the -delete flag:
find . -type f -delete

To show the filenames while deleting them:
find . -type f -print -delete

To show how many files will be deleted, then time how long it takes to delete them:
ls -1 | wc -l && time find . -type f -delete

 The above commands will remove all the files in the folder, then you can use rm -rf to remove the folder.