######################################################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
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