Friday, 19 July 2019

IMPDP Error ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user SYS ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1616 ORA-39062: error creating master process DM00 ORA-31613: Master process DM00 failed during startup.

######################################################IMPDP table_exists_action=truncate #############################################################

C:\Windows\system32>ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1616
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.impdp schemas=infodba directory=testsmr dumpfile=expdpsmrprodb63-2019-07-19_03-15-01.dmp logfile=testsmr.log table_exists_action=t
runcate

Import: Release 12.1.0.2.0 - Production on Fri Jul 19 08:58:53 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


######################################################################################################################################################
######################################################################################################################################################
######################################################### ALERT LOG ##################################################################################

Fri Jul 19 08:49:49 2019
ORA-00020: maximum number of processes (300) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Fri Jul 19 08:49:51 2019
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Process W01M submission failed with error = 20
Fri Jul 19 08:50:52 2019

######################################################################################################################################################
######################################################################################################################################################


SQL> select count(*) from v$process;

  COUNT(*)
----------
       299

SQL> alter system set processes=800 scope=spfile;

System altered.

SQL> sho parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      D:\APP\PLMADMIN\PRODUCT\12.1.0
                                                 \DBHOME_1\DATABASE\SPFILETEST.
                                                 ORA
SQL> select resource_name, current_utilization/limit_value*100,current_utilization, max_utilization,limit_value from v$resource_limit where resource_n
ame in ('processes','sessions');

RESOURCE_NAME                  CURRENT_UTILIZATION/LIMIT_VALUE*100 CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------------------------ ----------------------------------- ------------------- --------------- ----------------------------------------
processes                                               99.6666667                 299             300        300
sessions                                                 31.640625                 162             164        512

SQL> create pfile from spfile;

File created.

SQL> select name, value from v$spparameter where name in ('processes','sessions');

NAME                                                                             VALUE
-------------------------------------------------------------------------------- ---------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------
processes                                                                        800
sessions

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
TEST      READ WRITE           PRIMARY

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


Warning: You are no longer connected to ORACLE.
SQL> exit

C:\Windows\system32>set ORACLE_SID=TEST

C:\Windows\system32>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 19 09:28:16 2019

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 8.2678E+10 bytes
Fixed Size                  7774968 bytes
Variable Size            1.4764E+10 bytes
Database Buffers         6.7646E+10 bytes
Redo Buffers              260657152 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

C:\Windows\system32>impdp schemas=infodba directory=testsmr dumpfile=expdpsmrprodb63-2019-07-19_03-15-01.dmp logfile=testsmr.log table_exists_action=t
runcate

Import: Release 12.1.0.2.0 - Production on Fri Jul 19 09:29:44 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_01":  /******** AS SYSDBA schemas=infodba directory=testsmr dumpfile=expdpsmrprodb63-2019-07-19_03-15-01.dmp logfile
=testsmr.log table_exists_action=truncate
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-31684: Object type USER:"INFODBA" already exists
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE

No comments:

Post a Comment