Posts

Showing posts from December, 2013

kkjcre1p: unable to spawn jobq slave process,TNS-12514,TNS-12523,TNS-12502,TNS-12520,TNS-12528

This problem occurred due to resource allocation on the db side .

Here is the solution approach :-


1.check the kernel parameter and see if it configured at optimum level. 2.Check the swap space and their usage and re-config them if it is needed . 3.It may be your JOB_QUEUE_PROCESSES is too low comparison to processes parameter , increase it upto     32 and decrease the  processes parameter upto 800 for now . 4.Check the session,transaction and process parameter and tune the session and process parameter. 5.monitor the PROCESSES usage at the database level using the V$RESOURCE_LIMIT view and increase it if is    needed .

oracle export partition wise from one database to another database

[oracle@linux251 ~]$ export ORACLE_SID=dwh02
[oracle@linux251 ~]$ sqlplus sys/sys as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 29 11:27:07 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter tablespace TEST_TABLESPACE_2 read only;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@linux251 ~]$ expdp  transportable=always directory=bkp dumpfile=part_part.dmp tables=SCOTT.PART_PART:P0032,SCOTT.PART_PART:P0033,SCOTT.PART_PART:P0034,SCOTT.PART_PART:P0035,SCOTT.PART_PART:P0036,SCOTT.PART_PART:P0037,SCOTT.PART_PART:P0038,SCOTT.PART_PART:P0039,SCOTT.PART_PART:P0040,SCOTT.PART_PART:P0041,SCOTT.PART_PART:P0042,SCOTT.PART_PART:P0…