Monday 23 March 2020

expdp Master Table error ORA-31633:


ERROR :

ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.FULL_EXPDP_SMRTESTENV"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object

oracle@s08:~> sh /u02/scripts/expdp_SMRTESTENV_full.sh

Export: Release 12.1.0.2.0 - Production on Mon Mar 23 11:48:20 2020

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

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
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.FULL_EXPDP_SMRTESTENV"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object



SQL> SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
ORDER BY 1,2;  2    3    4

OWNER_NAME                               JOB_NAME                                 OPERATION                      JOB_MODE             STATE                          ATTACHED_SESSIONS
---------------------------------------- ---------------------------------------- ------------------------------ -------------------- ------------------------------ -----------------
SYS                                      FULL_EXPDP_SMRTESTENV                    EXPORT                         FULL                 NOT RUNNING                           0



SQL> drop table sys.FULL_EXPDP_SMRTESTENV;

Table dropped.

SQL> SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
ORDER BY 1,2;  2    3    4

no rows selected

SQL>


oracle@s08:/u01/app/oracle/diag/rdbms/smrtestenv/SMRTESTENV/trace> sh /u02/scripts/expdp_SMRTESTENV_full.sh

Export: Release 12.1.0.2.0 - Production on Mon Mar 23 12:09:13 2020

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

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
Starting "SYS"."FULL_EXPDP_SMRTESTENV":  "sys/********@SMRTESTENV AS SYSDBA" dumpfile=expdpSMRTESTENV-2020-03-23_12-09-13.dmp directory=EXP_SMRTESTENV logfile=expdpSMRTESTENV-2020-03-23_12-09-13.log FULL=Y EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=FULL_EXPDP_SMRTESTENV parallel=2
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.858 GB
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
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
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE


Posted by at No comments:
Labels:

Thursday 19 March 2020

Database installation using DBCA Silent installation with custom Template on 12C

oracle@s8:/u01/app/oracle/product/12.1.0/dbhome_1/bin> ./dbca -silent -createDatabase -templateName Teamcenter_Oracle.dbt -gdbName SMRTESTENV -sid SMRTESTENV -sysPassword system123 -systemPassword system123 -emConfiguration NONE -characterSet AL32UTF8
Creating and starting Oracle instance
2% complete
3% complete
4% complete
11% complete
Creating database files
12% complete
13% complete
14% complete
22% complete
Creating data dictionary views
25% complete
32% complete
33% complete
34% complete
35% complete
36% complete
37% complete
38% complete
39% complete
40% complete
41% complete
42% complete
43% complete
44% complete
45% complete
52% complete
55% complete
56% complete
58% complete
Completing Database Creation
62% complete
65% complete
68% complete
69% complete
70% complete
80% complete
90% complete
92% complete
Running Custom Scripts
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/SMRTESTENV/SMRTESTE.log" for further details.
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/SMRTESTENV.
Database Information:
Global Database Name:SMRTESTENV
System Identifier(SID):SMRTESTENV

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/bin>

Check Template Teamcenter_Oracle.dbt on link

Posted by at No comments:
Labels:

Drop Oracle database Manually

oracle@8:~> . oraenv
ORACLE_SID = [] ? zabbixdr
The Oracle base remains unchanged with value /u01/app/oracle

oracle@8:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 19 08:49:16 2020

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                  2932632 bytes
Variable Size             536871016 bytes
Database Buffers         3741319168 bytes
Redo Buffers               13844480 bytes
Database mounted.
Database opened.
SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRKORID  zabbixdr        zabbixdr                      READ WRITE           PRIMARY          NO                 0

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                  2932632 bytes
Variable Size             536871016 bytes
Database Buffers         3741319168 bytes
Redo Buffers               13844480 bytes
Database mounted.

SQL> !cat d.sql
set lines 200
select name, instance_name,db_unique_name, open_mode, database_role, flashback_on  current_scn,to_char(standby_became_primary_scn) failover_scn from v$database,v$instance;

SQL>


SQL>  @d


NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRKORID  zabbixdr        zabbixdr                      MOUNTED              PRIMARY          NO                 0

SQL> drop database;

Database dropped.

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

alert.log file

drop database
Mon Mar 08 16:55:36 2021
Deleted file /u01/app/oracle/oradata/zabbixdr/system01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/sysaux01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/undotbs01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdbseed/system01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/users01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdbseed/sysaux01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/system01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/sysaux01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/pdb1_users01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/redo01.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo02.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo03.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo04.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo05.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo06.log
Deleted file /u01/app/oracle/oradata/zabbixdr/redo07.log
Deleted file /u01/app/oracle/oradata/zabbixdr/temp01.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdbseed/pdbseed_temp012021-02-16_05-38-06-PM.dbf
Deleted file /u01/app/oracle/oradata/zabbixdr/pdb1/temp012021-02-16_05-38-06-PM.dbf
Stopping background process RVWR
Starting background process RSM0
Mon Mar 08 16:55:36 2021
RSM0 started with pid=29, OS id=4553
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2t9qj0p_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2t9qncv_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2tly5jo_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2vh1307_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2w44w63_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2z99v3c_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2z9bsf4_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2z9clx4_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j2zt0wq6_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j31xrxfl_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j33knsy7_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j34oh724_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/ZABBIXDR/flashback/o1_mf_j35ozjhl_.flb
Flashback Database Disabled
Deleted file /u01/app/oracle/product/12.1.0.2/db_1/dbs/snapcf_zabbixdr.f
Shutting down archive processes
Archiving is disabled
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC3: Archival stopped
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC2: Archival stopped
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC1: Archival stopped
Mon Mar 08 16:55:37 2021
ARCH shutting down
ARC0: Archival stopped
ALTER DATABASE MOUNT
ORA-750 signalled during: ALTER DATABASE MOUNT...

------------------- Same as primary single instance database  ------------------------------

oracle@test08:~> . oraenv
ORACLE_SID = [oracle] ? NEWSMRUPGR10
The Oracle base remains unchanged with value /u01/app/oracle
oracle@test08:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 24 08:29:13 2021

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

Connected to an idle instance.

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  3712904 bytes
Variable Size            1426065528 bytes
Database Buffers          704643072 bytes
Redo Buffers               13062144 bytes
Database mounted.
SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
NEWSMRUP  NEWSMRUPGR10     NEWSMRUPGR10                   MOUNTED              PRIMARY          NO                 0

SQL> drop database;

Database dropped.

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

alert.log

Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Tue Aug 24 08:30:56 2021
drop database
Tue Aug 24 08:30:56 2021
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/system01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/sysaux01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/undotbs01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/idata01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/ilog01.dbf
Deleted file /u04/db_backup/Flash_recovery_area/NEWSMRUPGR10/datafile1/u01/app/oracle/oradata/NEWSMRUPGR10/indx01.dbf
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/redo01.log
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/redo02.log
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/redo03.log
Deleted file /u01/app/oracle/oradata/NEWSMRUPGR10/temp01.dbf
Deleted file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_NEWSMRUPGR10.f
Shutting down archive processes
Archiving is disabled

Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)