Oct 24, 2011
How to Enable trace on a session in Oracle
432

How to Enable trace on a session in Oracle

1.  Enable trace at instance level: ALTER SYSTEM SET trace_enabled = TRUE; ALTER SYSTEM SET trace_enabled = FALSE; 2.  Enable trace at session level: EXECUTE dbms_system.set_sql_trace_in_session (SID, SERIAL#, TRUE); EXECUTE dbms_system.set_sql_trace_in_session (SID, SERIAL#, FALSE); 3.  Find out SID and SERIAL# from v$session of that particular user select sid, serial# from...
Oct 20, 2011
How to enable Forms Servlet or Socket Mode
649

How to enable Forms Servlet or Socket Mode

How to enable Forms Servlet or Socket Mode?? Carry out these steps to re-enable Forms Servlet/Socket mode 1.   Source the environment on the application tier. 2.   Stop all the application tier services: $INST_TOP/admin/scripts/adstpall.sh 3.   Run the following script to disable Forms Socket Mode and re-enable Forms Servlet...
Oct 18, 2011
Oracle Data Pump Examples
3.2K

Oracle Data Pump Examples

Oracle Data Pump Examples To work on Datapump, we need to unlock the SCOTT account and create a logical directory to access. The logical directory is a pointer to a physical directory   Oracle Data Pump Unlock Scott Schema =========================== CONN / AS SYSDBA ALTER USER scott IDENTIFIED BY tiger...
Oct 10, 2011
How to compile jsps
782

How to compile jsps

How to compile jsps in Oracle Applications Go to “$JTF_TOP/admin/scripts” and run “perl ojspCompile.pl –compile –flush”