SineFlex Solutions Pitch Deck PPT and Video

 

Hi All ,

We already know that recently we got the assignment to prepare Pitchdeck on Sineflex Solutions as a part of business communications. So i have prepared PPT and make very average video, But i want to share my knowledge with all. 

I have prepard my PDF PPT using  canva it is free of cost also  prepared my resume using canva.com . 

I have prepared my video using zoom. we can perform all recoding as well as PPT presentation. After recording video it will automatically convert mp4 to avi conversion.

All Pitch deck template present in canva . This blog is just for reference.

NOTE : Don't do any copy and paste form below reference.  U---  can detect  plagiarism using there tools. 

Video Snapshot (Uploading Only Image 😀😐)

 Web blog Link : Small tutorial for making presentation and video recording using Zoom and Canva

kindly 

IMPDP Error : RAC Environment Fails With Errors ORA-29913 ORA-31640 ORA-19505 ORA-27037

Scenario Preview : 

Recently we faced an error during impdp operation  migration of multiple schema from standalone database to 2 node RAC database. We face some issue on some of the tables of particular schemas but . Same script used for standalone DB were working  fine also other schema of using same expdp dumpfile. 

Reason was instead using TAF services that we have registered. We  were doing impdp on particular instance services level.

Error: ORA-31693 | ORA-31640 | ORA-19505

Scenario Error: 

After troubleshooting we found we were using parallel option  parallel=3 during  import   

ORA-31693: Table data object "INFODBA"."PPOM_OBJECT" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Command used during import 

oracle@01:/u04/MasterDB/expdp/expdp_smrprod> impdp \"sys/xxx@SMRPROD2 as sysdba\" dumpfile=EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp directory=EXPDPPROD logfile=impdpSMRPRODB-$(date +%Y-%m-%d_%H-%M-%S).log schemas=infodba JOB_NAME=FULL_EXPDP_SMRPRODB parallel=3

Import: Release 12.1.0.2.0 - Production on Sun Nov 8 09:34:11 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, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

Master table "SYS"."FULL_EXPDP_SMRPRODB" successfully loaded/unloaded

Starting "SYS"."FULL_EXPDP_SMRPRODB":  "sys/********@SMRPROD2 AS SYSDBA" dumpfile=EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp directory=EXPDPPROD logfile=impdpSMRPRODB-2020-11-08_09-34-11.log schemas=infodba JOB_NAME=FULL_EXPDP_SMRPRODB parallel=3

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

Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA

Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

ORA-31693: Table data object "INFODBA"."PPOM_OBJECT" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-31693: Table data object "INFODBA"."PPOM_APPLICATION_OBJECT" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."POM_BACKPOINTER"                 605.0 MB 14101046 rows

. . imported "INFODBA"."PIMANFILE"                       266.9 MB 1335204 rows

ORA-31693: Table data object "INFODBA"."POM_RECIPE_TABLE" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-31693: Table data object "INFODBA"."POM_LOCK_KEYS" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."PFND0WORKFLOWAUDIT"              855.8 MB 1759632 rows

. . imported "INFODBA"."PPSOCCURRENCE"                   147.2 MB  588268 rows

ORA-31693: Table data object "INFODBA"."PIMANRELATION" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."PWORKSPACEOBJECT"                256.4 MB 1802823 rows

. . imported "INFODBA"."PFND0GENERALAUDIT"               110.8 MB  491362 rows

ORA-31693: Table data object "INFODBA"."PDATASET" failed to load/unload and is being skipped due to error:

ORA-31640: unable to open dump file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp" for read

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrprod/EXPDP-SMRPRODB-2020-11-08_09-02-28.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

. . imported "INFODBA"."PEPMTASK"                        64.87 MB  331746 rows

. . imported "INFODBA"."PFND0SYNC_CHECKSUMS_3"           66.24 MB  887437 rows

. . imported "INFODBA"."PREF_LIST_0"                     30.97 MB  805308 rows

. . imported "INFODBA"."PPROJECT_LIST"                   28.16 MB  736249 rows

. . imported "INFODBA"."PFND0SECURITYAUDIT"              25.59 MB   85555 rows

. . imported "INFODBA"."PPROPAGATION_OBJ_LIST"           28.12 MB  729337 rows

. . imported "INFODBA"."PREVISIONS"                      21.79 MB  562331 rows

. . imported "INFODBA"."PREF_NAMES_0"                    25.36 MB  805308 rows

. . imported "INFODBA"."PREF_TYPES"                      18.68 MB  805308 rows

^C

Import> stop_job

Are you sure you wish to stop this job ([yes]/no): yes

Solution:

DataPump Import With PARALLEL > 1 In RAC Environment Fails With Errors ORA-29913 ORA-31640 ORA-19505 ORA-27037 (Doc ID 1173765.1)

Use cluster=N to run the import from a single node of the RAC cluster which has file access.

or

Run the Data Pump import job with parallel=1 (default)

OEM 12c - Oracle Physical Standby archive log sync monitoring

 OEM 12c - Oracle Physical Standby archive log sync monitoring

Note: Before Configuring Matric for archive log sync monitoring, Please make sure, there should not have One Matric for one Standby. One Matric should have groups of standby servers.

Step: 1: Enterprise>Monitoring>Metric Extensions

Step: 2: Metric Extensions Page Open

Step: 3  Click on +Create & Click on Metric Extension

 

Step: 4 Page Open: Create New: General Properties

Step: 5 Create New: General Properties: Put same values except Name$ & Displays (Put values according to Standby Group Name) &  then Click on Next.

 Step: 6 Put the below query in SQL Query Column only & Click Next

Query :

select sum(local.sequence#-target.sequence#) Total_gap

from

(select thread#,max(sequence#) sequence# from gv$archived_log where

dest_id=(select dest_id from v$archive_dest where TARGET='STANDBY'

)

and applied='YES' group by thread#) target,

(select thread#,max(sequence#) sequence# from gv$log group by thread#) local

where target.thread#=local.thread#;

Step: 7 Automatically Open Create New: Column

Step: 8  Create New: Column : Click on +Add & Click on New metric column.

Step: 9 Add Column put same value as I have entered & Click on OK.

 Step: 10 Now Create Neww : Columns

Step: 11

Step: 12

Step: 13

Step: 14

Step: 15

Step: 16

Step: 17

Step: 18

 Step: 19

Step: 20

Step: 21

Step: 22

 Step: 23

 Step: 24

Step: 25

Step: 26

Step: 27

Step: 28

 Step: 29

PT - Extracting Session level trace based on sid and serial#

Session level trace example  based on sid and serial#

• Checking the database name 

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

TC12DEV   TC12DEV          TC12DEV                        READ WRITE           PRIMARY          NO                 0

• Command to check sessions details  (describing only particular session only for trace generation)

SQL> @sessions

     INST   SID SERIAL# USERNAME     OSUSER           PROGRAM    LOCKED S hh:mm:ss SQL_ID            SEQ# Current/LastEvent         State (sec)

--------- ----- ------- ------------ ---------------- ---------- ------ - -------- --------------- ------ ------------------------- --------------

MODULE                                                                                               ACTION

---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------

        1   298   33658 INFODBA      varunyadav       SQL Develo        I 00:29:48 cr6axzpwa6byz       62 SQL*Net message from clie WAITING   1788

SQL Developer

 9 rows selected.

• Extracting trace based on sis and session#

SQL> DEFINE v_sid =298

SQL> DEFINE v_serial =33658

SQL> BEGIN

DBMS_MONITOR.SESSION_TRACE_ENABLE( SESSION_ID => &v_sid, SERIAL_NUM =>

&v_serial, WAITS => TRUE, BINDS => FALSE);

END;

/  2    3    4    5

old   2: DBMS_MONITOR.SESSION_TRACE_ENABLE( SESSION_ID => &v_sid, SERIAL_NUM =>

new   2: DBMS_MONITOR.SESSION_TRACE_ENABLE( SESSION_ID => 298, SERIAL_NUM =>

old   3: &v_serial, WAITS => TRUE, BINDS => FALSE);

new   3: 33658, WAITS => TRUE, BINDS => FALSE);

PL/SQL procedure successfully completed.

SQL> SELECT P.TRACEFILE FROM V$SESSION S JOIN V$PROCESS P ON S.PADDR = P.ADDR WHERE S.SID = &V_SID;

old   1: SELECT P.TRACEFILE FROM V$SESSION S JOIN V$PROCESS P ON S.PADDR = P.ADDR WHERE S.SID = &V_SID

new   1: SELECT P.TRACEFILE FROM V$SESSION S JOIN V$PROCESS P ON S.PADDR = P.ADDR WHERE S.SID = 298

TRACEFILE

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/diag/rdbms/tc12dev/TC12DEV/trace/TC12DEV_ora_20976.trc

SQL> BEGIN

DBMS_MONITOR.SESSION_TRACE_DISABLE( SESSION_ID => &v_sid, SERIAL_NUM =>

&v_serial);

END;

/  2    3    4    5

old   2: DBMS_MONITOR.SESSION_TRACE_DISABLE( SESSION_ID => &v_sid, SERIAL_NUM =>

new   2: DBMS_MONITOR.SESSION_TRACE_DISABLE( SESSION_ID => 298, SERIAL_NUM =>

old   3: &v_serial);

new   3: 33658);

PL/SQL procedure successfully completed.

SQL>

Trace output: