Oracle Database Commands and Practical Examples

Wednesday 23 October 2019

expdp - permission error ORA-31693, ORA-31617

EXPDP ERROR Example :

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

ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write

ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"

ORA-27037: unable to obtain file status

Solution : Check permission and group on expdp directory

SQL> exit
Disconnected from 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
oracle@sgdcplm02:/u04/MasterDB/expdp/expdp_smrrac>

Export: Release 12.1.0.2.0 - Production on Mon Oct 21 10:09:24 2019

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
Starting "SYS"."FULL_EXPDP_SMRRAC1": "sys/********@SM AS SYSDBA" dumpfile=expdp-SMMRAC12019-10-21_10-09-24.dmp directory=EXPDP_SMRRAC logfile=expdpSMRRAC1-2019-10-21_10-09-24.log FULL=Y EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=FULL_EXPDP_SMRRAC1 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: 145.2 MB
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/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
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
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
. . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows
. . exported "SYS"."AUD$" 0 KB 0 rows
. . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows
. . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows
. . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows
. . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows
. . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows
. . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows
. . exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows
. . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows
. . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows
. . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows
. . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows
. . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows
. . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows
. . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows
. . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows
. . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows
. . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows
. . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows
. . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows
. . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows
. . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows
. . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows
. . exported "WMSYS"."WM$HINT_TABLE$" 9.453 KB 75 rows
. . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows
. . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows
. . exported "WMSYS"."WM$REMOVED_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows
. . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows
. . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows
. . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.054 KB 10 rows
. . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows
. . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POL" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows
. . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
. . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 8.671 KB 4 rows
ORA-31693: Table data object "SYS"."KU$_USER_MAPPING_VIEW" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information:
. . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 10.21 KB 22 rows
. . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
. . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows
. . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
. . exported "SYS"."NACL$_ACE_EXP" 9.929 KB 1 rows
. . exported "SYS"."NACL$_HOST_EXP" 6.914 KB 1 rows
. . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows
. . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows
. . exported "INFODBA"."POM_BACKPOINTER" 11.90 MB 277596 rows
. . exported "INFODBA"."PL10N_PROPERTY_NAME" 9.389 MB 112502 rows
. . exported "INFODBA"."PPOM_OBJECT" 10.02 MB 210260 rows
. . exported "INFODBA"."PFND0WORKFLOWAUDIT" 5.835 MB 13871 rows
. . exported "INFODBA"."PDATA" 2.042 MB 3 rows
. . exported "INFODBA"."PL10N_TYPE_NAME" 2.732 MB 30920 rows
. . exported "INFODBA"."PPOM_APPLICATION_OBJECT" 2.827 MB 30747 rows
. . exported "INFODBA"."PDATA_0" 382.1 KB 56 rows
. . exported "INFODBA"."PBUSINESSRULE" 1.993 MB 21736 rows
. . exported "INFODBA"."PFND0GENERALAUDIT" 1.848 MB 8929 rows
. . exported "INFODBA"."PL10N_FND0ENTRY" 2.301 MB 29405 rows
. . exported "INFODBA"."PWORKSPACEOBJECT" 2.216 MB 17615 rows
. . exported "INFODBA"."PARGUMENTS" 1.276 MB 16870 rows
. . exported "INFODBA"."PEPMHANDLER" 992.1 KB 22091 rows
. . exported "INFODBA"."PEPMTASKTEMPLATE" 922.2 KB 6211 rows
. . exported "INFODBA"."PIMANTYPE" 863.7 KB 8222 rows
. . exported "INFODBA"."POPERATION" 870.6 KB 3984 rows
. . exported "INFODBA"."PBODY_TEXT_0" 66.00 KB 13 rows
. . exported "INFODBA"."PFND0PR_SCRIPT" 19.60 KB 7 rows
. . exported "INFODBA"."PEPMTASK" 831.8 KB 4520 rows
. . exported "INFODBA"."PDATATYPEREF" 759.0 KB 18537 rows
. . exported "INFODBA"."PIMANRELATION" 768.5 KB 8154 rows
. . exported "INFODBA"."PACTION_HANDLERS" 674.2 KB 16865 rows
. . exported "INFODBA"."PDATATYPE" 661.8 KB 4398 rows
. . exported "INFODBA"."PEXTENSIONPOINT" 638.0 KB 10691 rows
. . exported "INFODBA"."PPOM_ATTRIBUTE" 608.3 KB 5660 rows
. . exported "INFODBA"."PPROPERTYCONSTANTATTACH" 584.0 KB 9646 rows
. . exported "INFODBA"."PPROPERTYINFO" 574.2 KB 10238 rows
. . exported "INFODBA"."PSTRUCTELEMENT" 590.8 KB 9608 rows
. . exported "INFODBA"."PCONSTANTATTACH" 535.9 KB 16255 rows
. . exported "INFODBA"."POPERATIONTEMPLATE" 535.9 KB 1511 rows
. . exported "INFODBA"."PACTIONS" 433.5 KB 10822 rows
ORA-31693: Table data object "ORDDATA"."ORDDCM_DOCS" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "INFODBA"."PDESCRIPTION" 416.7 KB 3498 rows
. . exported "INFODBA"."PEXTENSIONPOINTS" 431.4 KB 10691 rows
. . exported "INFODBA"."PFND0MESSAGE" 284.5 KB 1208 rows
. . exported "INFODBA"."PIMANFILE" 455.9 KB 2205 rows
. . exported "INFODBA"."PCONTENTS" 125.8 KB 2988 rows
. . exported "INFODBA"."PEPMBRHANDLER" 123.2 KB 5225 rows
. . exported "INFODBA"."PEPMBUSINESSRULE" 132.0 KB 5032 rows
. . exported "INFODBA"."PEXTENSIONDESCRIPTOR" 116.4 KB 1741 rows
. . exported "INFODBA"."PFND0EVENTTYPEMAPPING" 130.8 KB 1044 rows
. . exported "INFODBA"."PFND0FEATURE_KEYS" 13.68 KB 136 rows
. . exported "INFODBA"."PFND0PRIVATEKEY" 8.820 KB 1 rows
. . exported "INFODBA"."PGENERATEDDATATYPE" 136.7 KB 3283 rows
. . exported "INFODBA"."PL10N_CONDITION_DESC" 122.2 KB 254 rows
. . exported "INFODBA"."PL10N_QUERY_NAME" 103.2 KB 1036 rows
. . exported "INFODBA"."PLISTOFRECEIVERS" 100 KB 2345 rows
. . exported "INFODBA"."PLOV_VALUES_3" 130.7 KB 3735 rows
. . exported "INFODBA"."POPERATIONPARAMETER" 140.6 KB 2550 rows
. . exported "INFODBA"."POPPARAMETERDATATYPEREF" 105.9 KB 2550 rows
. . exported "INFODBA"."PPARAMETERINFO" 108.9 KB 2484 rows
. . exported "INFODBA"."PPARAMETERSINFOS" 104.4 KB 2484 rows
. . exported "INFODBA"."PPARAMETERS_1" 107.0 KB 2550 rows
. . exported "INFODBA"."PPROPERTYBMOPERATION" 112.3 KB 2253 rows
. . exported "INFODBA"."PPROPERTYOPERATION" 98.66 KB 2512 rows
. . exported "INFODBA"."PQUERY_CLAUSES" 118.2 KB 580 rows
. . exported "INFODBA"."PREF_NAMES_0" 141.3 KB 3792 rows
. . exported "INFODBA"."PREF_TYPES" 95.29 KB 3792 rows
. . exported "INFODBA"."PVALIDITY" 133.3 KB 1781 rows
. . exported "INFODBA"."PANCHOR" 46.71 KB 1588 rows
. . exported "INFODBA"."PATTACHMENTS" 75.32 KB 1736 rows
. . exported "INFODBA"."PATTACHMENT_TYPES" 47.77 KB 1736 rows
. . exported "INFODBA"."PCONDITION" 44.23 KB 155 rows
. . exported "INFODBA"."PEXT_DESCRIPTORS" 81.87 KB 1931 rows
. . exported "INFODBA"."PFND0AUDITDEFPROPERTY" 91.14 KB 905 rows
. . exported "INFODBA"."PICM0" 155.4 KB 142 rows
. . exported "INFODBA"."PL10N_QUERY_DESC" 97.68 KB 662 rows
. . exported "INFODBA"."PL10N_RD_DESCRIPTION" 88.66 KB 450 rows
. . exported "INFODBA"."PL10N_RD_NAME" 55.40 KB 455 rows
. . exported "INFODBA"."PLISTOFVALUES" 97.25 KB 761 rows
. . exported "INFODBA"."PLOV_VALUE_DESCRIPTIONS_3" 59.66 KB 1858 rows
. . exported "INFODBA"."PMETAINTERFACE" 46.03 KB 1081 rows
. . exported "INFODBA"."POM_KEY" 82.19 KB 1534 rows
. . exported "INFODBA"."POPERATIONINPUTPROPERTY" 67.48 KB 1477 rows
. . exported "INFODBA"."POPERATIONRETURNDATATYPEREF" 65.39 KB 1511 rows
. . exported "INFODBA"."PPROCESS_STAGE_LIST" 66.60 KB 1519 rows
. . exported "INFODBA"."PRELEASESTATUS" 48.85 KB 620 rows
. . exported "INFODBA"."PREVISIONANCHOR" 44.82 KB 1283 rows
. . exported "INFODBA"."PRUNTIMEPROPERTY" 93.42 KB 1845 rows
. . exported "INFODBA"."PS4_SMRPART" 79.30 KB 508 rows
. . exported "INFODBA"."PSTRUCT" 65.82 KB 2808 rows
. . exported "INFODBA"."PVALID_EVENTTYPES" 45.68 KB 984 rows
. . exported "INFODBA"."ACLS" 7.679 KB 7 rows
. . exported "INFODBA"."EIM_UID_GENERATOR_ROOT" 5.554 KB 1 rows
. . exported "INFODBA"."MFK_WORK_KEYS" 5.968 KB 1 rows
. . exported "INFODBA"."MFK_WORK_OBJS" 5.093 KB 1 rows
. . exported "INFODBA"."PACCESSOR_LIST" 7.445 KB 28 rows
. . exported "INFODBA"."PACTION_LIST" 6.390 KB 1 rows
. . exported "INFODBA"."PALLOWABLE_VIEW_TYPES" 7.218 KB 22 rows
. . exported "INFODBA"."PAM_ACE" 30.75 KB 383 rows
. . exported "INFODBA"."PAM_ACL" 12.01 KB 122 rows
. . exported "INFODBA"."PAM_NAMED_TAG" 6.554 KB 29 rows
. . exported "INFODBA"."PAM_PRIVILEGES" 7.046 KB 34 rows
. . exported "INFODBA"."PAM_TREE" 31.84 KB 222 rows
. . exported "INFODBA"."PAPPDATAMODELDEFINITION" 11.21 KB 142 rows
. . exported "INFODBA"."PAPPEXTENSIONPOINT" 7.296 KB 1 rows
. . exported "INFODBA"."PAPPINTERFACETYPE" 10.62 KB 3 rows
. . exported "INFODBA"."PARCWELDREVISIONMASTER" 6.039 KB 1 rows
. . exported "INFODBA"."PARGUMENTKEYS" 6.234 KB 10 rows
. . exported "INFODBA"."PATTR_CLASSES" 5.968 KB 1 rows
. . exported "INFODBA"."PATTR_NAMES" 5.953 KB 1 rows
. . exported "INFODBA"."PAUDITDEFINITION" 18.50 KB 80 rows
. . exported "INFODBA"."PAUDITLOG" 5.5 KB 1 rows
. . exported "INFODBA"."PAUTHORIZATIONRULE" 7.687 KB 28 rows
. . exported "INFODBA"."PBOM_VIEW_TAGS" 8.421 KB 53 rows
. . exported "INFODBA"."PBUSINESSELEMENT" 11.96 KB 169 rows
. . exported "INFODBA"."PBUSINESSOBJECTINTERFACE" 39.37 KB 948 rows
. . exported "INFODBA"."PCALLBACKFUNCTION" 24.88 KB 199 rows
. . exported "INFODBA"."PCFMLATESTENTRY" 5.546 KB 2 rows
. . exported "INFODBA"."PCFMSTATUSENTRY" 6.648 KB 7 rows
. . exported "INFODBA"."PCFMWORKINGENTRY" 8.039 KB 6 rows
. . exported "INFODBA"."PCHANGEITEM" 15.88 KB 97 rows
. . exported "INFODBA"."PCHANGEITEMREVISION" 13.55 KB 100 rows
. . exported "INFODBA"."PCHANGETYPEDATA" 9.210 KB 3 rows
. . exported "INFODBA"."PCHILD_TASK_TAGLIST_0" 6.523 KB 4 rows
. . exported "INFODBA"."PCLAUSES_0" 5.968 KB 1 rows
. . exported "INFODBA"."PCLIENTDATAMASTER" 6.859 KB 1 rows
. . exported "INFODBA"."PCLOSURERULE" 28.25 KB 288 rows
. . exported "INFODBA"."PCMHASIMPACTEDITEM" 7.140 KB 49 rows
. . exported "INFODBA"."PCOMPONENTRELATION" 5.734 KB 11 rows
. . exported "INFODBA"."PCONDITIONPARAMETER" 16.92 KB 309 rows
. . exported "INFODBA"."PCONDITIONSIGNATURE" 5.617 KB 5 rows
. . exported "INFODBA"."PCONDITION_PARAMETERS" 6.718 KB 9 rows
. . exported "INFODBA"."PCONDITION_SIGNATURES" 6.562 KB 5 rows
. . exported "INFODBA"."PCONSTANT" 35.01 KB 163 rows
. . exported "INFODBA"."PCONSTANTCHOICE" 9.929 KB 123 rows
. . exported "INFODBA"."PCONSTANT_CHOICES" 8.226 KB 47 rows
. . exported "INFODBA"."PCOSTVALUE" 5.992 KB 3 rows
. . exported "INFODBA"."PCOUNTER_TAGS_0" 8.625 KB 58 rows
. . exported "INFODBA"."PCRFQUERYSOURCE" 12.14 KB 52 rows
. . exported "INFODBA"."PDATAFILES" 0 KB 0 rows
. . exported "INFODBA"."PDATAFILESKEYS" 0 KB 0 rows
. . exported "INFODBA"."PDATASETTYPE" 19.47 KB 190 rows
. . exported "INFODBA"."PDATUMPOINTREVISIONMASTER" 6.148 KB 2 rows
. . exported "INFODBA"."PDEEPCOPYRULE" 41.47 KB 350 rows
. . exported "INFODBA"."PDEFAULT_VALUES" 6.226 KB 7 rows
. . exported "INFODBA"."PDEPENDENTON" 10.33 KB 100 rows
. . exported "INFODBA"."PDISPATCHERREQUEST" 13.13 KB 2 rows
. . exported "INFODBA"."PDMTEMPLATEFORM" 10.08 KB 5 rows
. . exported "INFODBA"."PDOCUMENTREVISION" 8.804 KB 128 rows
. . exported "INFODBA"."PDRAWINGVERMASTER" 6.078 KB 23 rows
. . exported "INFODBA"."PDRAWING_0_REVISION_ALT" 5.921 KB 23 rows
. . exported "INFODBA"."PEFFECTIVITYMODE" 5.523 KB 1 rows
. . exported "INFODBA"."PENCRYPTIONKEY" 5.984 KB 1 rows
. . exported "INFODBA"."PENTRY_LIST" 7.101 KB 19 rows
. . exported "INFODBA"."PENVELOPE" 23.19 KB 263 rows
. . exported "INFODBA"."PEPMJOB" 41.38 KB 347 rows
. . exported "INFODBA"."PEPMSIGNOFFPROFILE" 8.968 KB 13 rows
. . exported "INFODBA"."PEVENTTYPEMAPPING" 10.20 KB 79 rows
. . exported "INFODBA"."PEVENTTYPE_DESCRIPTORS" 29.88 KB 984 rows
. . exported "INFODBA"."PEXCELTEMPLATE" 5.789 KB 14 rows
. . exported "INFODBA"."PEXCEL_TEMPLATE_RULES" 6 KB 2 rows
. . exported "INFODBA"."PEXPORTTEMPLATE" 5.882 KB 20 rows
. . exported "INFODBA"."PEXTERNALDATATYPE" 6.601 KB 27 rows
. . exported "INFODBA"."PFILTER" 7.671 KB 10 rows
. . exported "INFODBA"."PFND0AUDITDEFINITION" 35.45 KB 218 rows
. . exported "INFODBA"."PFND0BMIDERESOURCE" 16.71 KB 503 rows
. . exported "INFODBA"."PFND0CLIENTSESSIONINFO" 9.953 KB 30 rows
. . exported "INFODBA"."PFND0DEPLOYVERSION" 5.992 KB 2 rows
. . exported "INFODBA"."PFND0DETAILEDMESSAGE" 36.03 KB 1208 rows
. . exported "INFODBA"."PFND0DETAILEDMESSAGES" 14.46 KB 205 rows
. . exported "INFODBA"."PFND0EXTENSIONS" 11.53 KB 118 rows
. . exported "INFODBA"."PFND0FILTER_ATTRIBUTES" 5.953 KB 1 rows
. . exported "INFODBA"."PFND0ICONRESOURCE" 11.25 KB 310 rows
. . exported "INFODBA"."PFND0LICENSEUSAGE" 30.53 KB 136 rows
. . exported "INFODBA"."PFND0LISTOFVALUESDYNAMIC" 7.492 KB 5 rows
. . exported "INFODBA"."PFND0MAX_VALUE_REASON" 8.539 KB 48 rows
. . exported "INFODBA"."PFND0OBJECTSTATUS" 10.13 KB 113 rows
. . exported "INFODBA"."PFND0PRIVATEKEY_0" 6.437 KB 1 rows
. . exported "INFODBA"."PFND0PROPERTYRENDERER" 7.062 KB 7 rows
. . exported "INFODBA"."PFND0PROPERTYRENDERERATTACH" 7.843 KB 7 rows
. . exported "INFODBA"."PFND0QUERY_CLAUSE" 6.375 KB 5 rows
. . exported "INFODBA"."PFND0RESOURCES" 10.76 KB 113 rows
. . exported "INFODBA"."PFOLDER" 29.71 KB 932 rows
. . exported "INFODBA"."PFORMTYPEDEF" 23.39 KB 459 rows
. . exported "INFODBA"."PFORM_TYPES" 6.671 KB 8 rows
. . exported "INFODBA"."PFRI_RANGES" 6.828 KB 12 rows
. . exported "INFODBA"."PFULLTEXT" 8.460 KB 13 rows
. . exported "INFODBA"."PFUNCTIONALITYRULE" 12.49 KB 124 rows
. . exported "INFODBA"."PGDETYPEDEFINITION" 6.507 KB 22 rows
. . exported "INFODBA"."PGLOBALCONSTANT" 7.664 KB 49 rows
. . exported "INFODBA"."PGLOBALCONSTANTATTACH" 6.515 KB 23 rows
. . exported "INFODBA"."PGNCHANGEREQUESTREVISION" 6.187 KB 37 rows
. . exported "INFODBA"."PGROUP" 16.17 KB 128 rows
. . exported "INFODBA"."PGROUPMEMBER" 19.91 KB 319 rows
. . exported "INFODBA"."PGROUPSECURITYNAMEDTAG" 5.546 KB 2 rows
. . exported "INFODBA"."PHASPARTICIPANT" 20.78 KB 775 rows
. . exported "INFODBA"."PHISTORYDATES" 5.945 KB 1 rows
. . exported "INFODBA"."PHISTORYSTATES" 5.945 KB 1 rows
. . exported "INFODBA"."PIMANACTIONHANDLER" 10.48 KB 11 rows
. . exported "INFODBA"."PIMANCOMPOUNDPROPDEF" 20.41 KB 153 rows
. . exported "INFODBA"."PIMANEVENTTYPE" 13.89 KB 138 rows
. . exported "INFODBA"."PIMANGRM" 42.86 KB 380 rows
. . exported "INFODBA"."PIMANIDCREATOR" 7.453 KB 6 rows
. . exported "INFODBA"."PIMANNEXTID" 12.65 KB 193 rows
. . exported "INFODBA"."PIMANPARAMETERS" 6.468 KB 45 rows
. . exported "INFODBA"."PIMANPFF" 8.492 KB 14 rows
. . exported "INFODBA"."PIMANQUERY" 35.39 KB 246 rows
. . exported "INFODBA"."PIMANRESERVATION" 18.00 KB 33 rows
. . exported "INFODBA"."PIMANSUBSCRIPTION" 16.47 KB 6 rows
. . exported "INFODBA"."PIMANVOLUME" 11.34 KB 2 rows
. . exported "INFODBA"."PIMSPROFILE" 6.914 KB 6 rows
. . exported "INFODBA"."PINFO" 21.51 KB 560 rows
. . exported "INFODBA"."PINPUTS" 6.476 KB 3 rows
. . exported "INFODBA"."PINPUT_FORMATS" 7.710 KB 67 rows
. . exported "INFODBA"."PINSTALLEDTEMPLATES" 8.179 KB 9 rows
. . exported "INFODBA"."PIRDC" 19.11 KB 40 rows
. . exported "INFODBA"."PITEMMASTER" 8.109 KB 2 rows
. . exported "INFODBA"."PITEMVERSIONMASTER" 8.320 KB 13 rows
. . exported "INFODBA"."PKEY" 6.140 KB 10 rows
. . exported "INFODBA"."PL10N_ACL_NAME" 17.85 KB 122 rows
. . exported "INFODBA"."PL10N_NAME" 20.63 KB 158 rows
. . exported "INFODBA"."PL10N_NAME_0" 10.42 KB 39 rows
. . exported "INFODBA"."PL10N_NAME_1" 39.75 KB 365 rows
. . exported "INFODBA"."PL10N_NAME_2" 26.90 KB 235 rows
. . exported "INFODBA"."PL10N_NAME_3" 11.88 KB 54 rows
. . exported "INFODBA"."PL10N_ROLE_NAME" 20.17 KB 145 rows
. . exported "INFODBA"."PL10N_TASKTYPE_NAME" 17.59 KB 122 rows
. . exported "INFODBA"."PL10N_TCCAL_NAME" 9.304 KB 21 rows
. . exported "INFODBA"."PLIBRARY" 23.32 KB 122 rows
. . exported "INFODBA"."PLISTOFVALUESCHAR" 6.828 KB 1 rows
. . exported "INFODBA"."PLISTOFVALUESINTEGER" 8.914 KB 85 rows
. . exported "INFODBA"."PLISTOFVALUESSTRING" 23.71 KB 660 rows
. . exported "INFODBA"."PLISTOFVALUESTAG" 7.25 KB 10 rows
. . exported "INFODBA"."PLIST_OF_ROLE" 21.83 KB 389 rows
. . exported "INFODBA"."PLIST_OF_TOOLS" 19.94 KB 344 rows
. . exported "INFODBA"."PLIST_OF_TOOLS_VIEW" 20.03 KB 346 rows
. . exported "INFODBA"."PLOV_ATTACHED_CONDITIONS" 28.26 KB 552 rows
. . exported "INFODBA"."PLOV_ATTACHED_PROPERTIES" 26.15 KB 552 rows
. . exported "INFODBA"."PLOV_ATTACHED_SPECIFIERS" 18.78 KB 552 rows
. . exported "INFODBA"."PLOV_ATTACHED_TYPES" 27.14 KB 552 rows
. . exported "INFODBA"."PLOV_VALUES" 6.054 KB 6 rows
. . exported "INFODBA"."PLOV_VALUES_2" 20.09 KB 579 rows
. . exported "INFODBA"."PLOV_VALUE_DESCRIPTIONS_2" 20.49 KB 469 rows
. . exported "INFODBA"."PLOV_VALUE_INDEXES" 28.46 KB 925 rows
. . exported "INFODBA"."PMANAGED_OBJECTS" 6.875 KB 13 rows
. . exported "INFODBA"."PMEACTIVITY" 17.51 KB 75 rows
. . exported "INFODBA"."PMEOPREVISION" 9.304 KB 75 rows
. . exported "INFODBA"."PMEPROCESS" 0 KB 0 rows
. . exported "INFODBA"."PMEPROCESSMASTER" 8.460 KB 75 rows
. . exported "INFODBA"."PMEPROCESSVERSIONMASTER" 8.476 KB 75 rows
. . exported "INFODBA"."PMETAENUM" 7.343 KB 86 rows
. . exported "INFODBA"."PMETAENUMLITERAL" 23.41 KB 457 rows
. . exported "INFODBA"."PMETAENUMLITERALS" 23.65 KB 434 rows
. . exported "INFODBA"."PMEWORKAREA" 0 KB 0 rows
. . exported "INFODBA"."PMFG0BVRTOOLREQUIREMENT" 0 KB 0 rows
. . exported "INFODBA"."PMFG0MEEQUIPMENTREVISION" 0 KB 0 rows
. . exported "INFODBA"."PMFG0PROCAREATWPLOCATIONREL" 0 KB 0 rows
. . exported "INFODBA"."PMON_RANGES" 6.75 KB 10 rows
. . exported "INFODBA"."PM_PROCESS_LIST" 9.843 KB 57 rows
. . exported "INFODBA"."PNAMECOUNTER" 12.46 KB 58 rows
. . exported "INFODBA"."PNAMEFIELD" 10.13 KB 38 rows
. . exported "INFODBA"."PNAMERULE" 7.460 KB 36 rows
. . exported "INFODBA"."PNAMERULEPATTERN" 10.07 KB 82 rows
. . exported "INFODBA"."PNAME_PATTERNS" 9.601 KB 82 rows
. . exported "INFODBA"."PNOTETYPE" 9.257 KB 42 rows
. . exported "INFODBA"."PNXAGENTREVISION" 6.039 KB 2 rows
. . exported "INFODBA"."POBJECT_HIERARCHY" 20.62 KB 341 rows
. . exported "INFODBA"."POFFICEDOCDATA" 9.875 KB 3 rows
. . exported "INFODBA"."POM_BOOT" 6.843 KB 37 rows
. . exported "INFODBA"."POM_B_LOCK" 0 KB 0 rows
. . exported "INFODBA"."POM_F_LOCK" 8.140 KB 80 rows
. . exported "INFODBA"."POM_INDEXES" 28.22 KB 342 rows
. . exported "INFODBA"."POM_LOCK_LOGGING" 0 KB 0 rows
. . exported "INFODBA"."POM_M_LOCK" 7.968 KB 14 rows
. . exported "INFODBA"."POM_ROOT" 10.41 KB 1 rows
. . exported "INFODBA"."POM_R_LOCK" 9.070 KB 42 rows
. . exported "INFODBA"."POM_TIMESTAMP" 8.234 KB 43 rows
. . exported "INFODBA"."POPERATIONATTACH" 35.76 KB 559 rows
. . exported "INFODBA"."POPTION_DESCRIPTIONS" 19.90 KB 198 rows
. . exported "INFODBA"."POPTION_DISPLAYNAMES" 15.5 KB 198 rows
. . exported "INFODBA"."POPTION_GROUPNAMES" 13.23 KB 198 rows
. . exported "INFODBA"."POPTION_INITIALVALUES" 11.35 KB 198 rows
. . exported "INFODBA"."POPTION_READONLYFLAGS" 10.60 KB 198 rows
. . exported "INFODBA"."POPTION_REALNAMES" 13.33 KB 198 rows
. . exported "INFODBA"."POUTPUTS" 6.390 KB 1 rows
. . exported "INFODBA"."POUTPUT_FORMATS" 7.718 KB 67 rows
. . exported "INFODBA"."POVERRIDE_LOV_ATTACHMENTS" 18.67 KB 552 rows
. . exported "INFODBA"."PPARAMETERS" 19.57 KB 261 rows
. . exported "INFODBA"."PPARAMETERS_0" 18.21 KB 300 rows
. . exported "INFODBA"."PPARENT" 5.937 KB 1 rows
. . exported "INFODBA"."PPARTICIPANT" 9.375 KB 93 rows
. . exported "INFODBA"."PPARTMASTER" 16.40 KB 507 rows
. . exported "INFODBA"."PPARTVERMASTER" 16.27 KB 525 rows
. . exported "INFODBA"."PPERSON" 15.58 KB 74 rows
. . exported "INFODBA"."PPFF_CLAUSES" 13.78 KB 40 rows
. . exported "INFODBA"."PPIEACTIONRULE" 7.773 KB 1 rows
ORA-31693: Table data object "INFODBA"."PDATASET" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PPROJECTOBJECTRELATION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PSTRUCTELEMENTS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PTYPECONSTANTATTACH" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PCLAUSES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PDEPENDENCY_TASK_TEMPLATES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PEPMACTION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PPARAMS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PPROJECT_LIST" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PPROPAGATION_OBJ_LIST" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PPROPERTY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PFND0LOVDICTIONARYENTRY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PFND0SECURITYAUDIT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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_RECIPE_TABLE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PPROJECT_LIST_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PRULES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PRULE_HANDLERS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PDEPENDENCY_TASK_ACTIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PEXTENSION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PFND0DETAIL" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PFORM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PHIDETYPERULE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PITEM" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PITEMREVISION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PL10N_FND0EVENTTYPE_NAME" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PLOV_VALUE_CONDITIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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_CLASS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PREF_LIST_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PREVISIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PARGUMENTDATA" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PBMOPERATION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PCLAUSES_1" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "INFODBA"."PPLMAPPUID" 26.38 KB 177 rows
. . exported "INFODBA"."PPOM_ACCESSOR" 35.00 KB 507 rows
. . exported "INFODBA"."PPOM_APPLICATION" 7.257 KB 9 rows
. . exported "INFODBA"."PPOM_CATIAMODELATTRIBUTES" 15.83 KB 1 rows
. . exported "INFODBA"."PPOM_CATIA_DOC_ATTR_FORM" 6.867 KB 1 rows
. . exported "INFODBA"."PPOM_GROUP" 15.64 KB 128 rows
. . exported "INFODBA"."PPOM_IMC" 9.875 KB 1 rows
. . exported "INFODBA"."PPOM_MEMBER" 27.48 KB 319 rows
. . exported "INFODBA"."PPOM_SESSION" 7.562 KB 14 rows
. . exported "INFODBA"."PPOM_SITE_CONFIG" 6.023 KB 3 rows
. . exported "INFODBA"."PPOM_USER" 22.26 KB 73 rows
. . exported "INFODBA"."PPRIMARYOBJECTS" 6.398 KB 1 rows
. . exported "INFODBA"."PPROCESSES" 6 KB 3 rows
. . exported "INFODBA"."PPROJECTPREFERENCE" 6.859 KB 1 rows
. . exported "INFODBA"."PPROJECTTEAM" 6.617 KB 52 rows
. . exported "INFODBA"."PPROJECT_MEMBERS" 13.47 KB 179 rows
. . exported "INFODBA"."PPROPERTIES" 7.125 KB 38 rows
. . exported "INFODBA"."PPROPERTIES_0" 5.953 KB 1 rows
. . exported "INFODBA"."PPROPERTYCONSTANT" 7.078 KB 18 rows
. . exported "INFODBA"."PPROPERTYSET" 11.89 KB 64 rows
. . exported "INFODBA"."PPSBOMVIEW" 10.83 KB 53 rows
. . exported "INFODBA"."PPSBOMVIEWREVISION" 9.031 KB 17 rows
. . exported "INFODBA"."PPSOCCURRENCE" 50.92 KB 101 rows
. . exported "INFODBA"."PPSOCCURRENCETHREAD" 8.859 KB 101 rows
. . exported "INFODBA"."PPSOCCURRENCETYPE" 6.617 KB 20 rows
. . exported "INFODBA"."PPSVIEWTYPE" 7.007 KB 6 rows
. . exported "INFODBA"."PRANGE" 7.789 KB 71 rows
. . exported "INFODBA"."PRBFEXPRESSION" 5.570 KB 3 rows
. . exported "INFODBA"."PRBFINPUT" 5.992 KB 3 rows
. . exported "INFODBA"."PRBFOUTPUT" 5.523 KB 1 rows
. . exported "INFODBA"."PRBFPARAMDEF" 6.992 KB 4 rows
. . exported "INFODBA"."PRD_PARAMETERS" 13.22 KB 219 rows
. . exported "INFODBA"."PRD_PARAM_VALUES" 13.28 KB 219 rows
. . exported "INFODBA"."PRD_STYLE_SHEETS" 12.25 KB 149 rows
. . exported "INFODBA"."PRELATIONPROPERTY" 35.89 KB 421 rows
. . exported "INFODBA"."PRELATION_TYPE_LIST" 6.601 KB 6 rows
. . exported "INFODBA"."PRELEASE" 11.50 KB 37 rows
. . exported "INFODBA"."PRELEASE_STATUS_LIST" 31.18 KB 635 rows
. . exported "INFODBA"."PREPORTDEFINITION" 32.65 KB 80 rows
. . exported "INFODBA"."PREPORTDESIGN" 11.67 KB 23 rows
. . exported "INFODBA"."PREPORT_FORMATTERS" 8.625 KB 57 rows
. . exported "INFODBA"."PRESOURCEPOOL" 10.18 KB 51 rows
. . exported "INFODBA"."PREVISIONRULE" 10.22 KB 11 rows
. . exported "INFODBA"."PROLE" 10.44 KB 65 rows
. . exported "INFODBA"."PROLEINOWNINGGROUP" 8.343 KB 65 rows
. . exported "INFODBA"."PROLEINPROJECTSOFOBJECT" 8.351 KB 65 rows
. . exported "INFODBA"."PROLEINSCHEDULE" 6.039 KB 3 rows
. . exported "INFODBA"."PS4GBLSTDPRTREQFORMSTORAGE" 13.64 KB 31 rows
. . exported "INFODBA"."PS4PCASPARTNUMBERFORMSTORAGE" 17.45 KB 25 rows
. . exported "INFODBA"."PS4REGLSTDPRTREQFORMSTORAGE" 13.17 KB 3 rows
. . exported "INFODBA"."PS4_ADJECTIVES" 5.968 KB 2 rows
. . exported "INFODBA"."PS4_ADJECTIVES_1" 6.304 KB 13 rows
. . exported "INFODBA"."PS4_ASSEMBLIESLH" 9.5 KB 141 rows
. . exported "INFODBA"."PS4_ASSEMBLIESRH" 7.140 KB 48 rows
. . exported "INFODBA"."PS4_CAEITEM" 8.140 KB 1 rows
. . exported "INFODBA"."PS4_CAEITEMREVISION" 5.523 KB 1 rows
. . exported "INFODBA"."PS4_CHANGENOTICEREVISION" 9.601 KB 34 rows
. . exported "INFODBA"."PS4_CHANGEREQUEST" 6.164 KB 35 rows
. . exported "INFODBA"."PS4_CHANGEREQUESTREVISION" 12.26 KB 37 rows
. . exported "INFODBA"."PS4_CHANGEVERIFYREVISION" 9.398 KB 23 rows
. . exported "INFODBA"."PS4_ELECTRICALCOMPONENTSLH" 6.023 KB 3 rows
. . exported "INFODBA"."PS4_ELECTRICALCOMPONENTSRH" 6.070 KB 5 rows
. . exported "INFODBA"."PS4_ENGGCOSTFORMSTORAGE" 24.11 KB 60 rows
. . exported "INFODBA"."PS4_FEP" 7.953 KB 15 rows
. . exported "INFODBA"."PS4_FEPREVISION" 6.281 KB 15 rows
. . exported "INFODBA"."PS4_GASKETSFOAMSEALSLH" 6.421 KB 19 rows
. . exported "INFODBA"."PS4_GASKETSFOAMSEALSRH" 6.421 KB 19 rows
. . exported "INFODBA"."PS4_GLASSPRODUCTSLH" 5.992 KB 2 rows
. . exported "INFODBA"."PS4_GLASSPRODUCTSRH" 6.039 KB 4 rows
. . exported "INFODBA"."PS4_HOMLOGTIONCHNGFRMSTORAGE" 11.71 KB 51 rows
. . exported "INFODBA"."PS4_INDUSENGGCOSTFORMSTORAGE" 13.05 KB 49 rows
. . exported "INFODBA"."PS4_ISSUEREPORTREVISION" 10.39 KB 6 rows
. . exported "INFODBA"."PS4_LAUNCHMNGRCOSTFRMSTORAGE" 8.601 KB 49 rows
. . exported "INFODBA"."PS4_LHNUMBER" 6.312 KB 15 rows
. . exported "INFODBA"."PS4_MATERIALCOSTFORMSTORAGE" 31.80 KB 51 rows
. . exported "INFODBA"."PS4_METALCOMPONENTSLH" 6.437 KB 20 rows
. . exported "INFODBA"."PS4_METALCOMPONENTSRH" 6.390 KB 18 rows
. . exported "INFODBA"."PS4_MFGENGGCOSTFORMSTORAGE" 15.70 KB 49 rows
. . exported "INFODBA"."PS4_MOTORMECHANISAMLH" 0 KB 0 rows
. . exported "INFODBA"."PS4_OPENLH" 6.914 KB 39 rows
. . exported "INFODBA"."PS4_OPENRH" 6.789 KB 34 rows
. . exported "INFODBA"."PS4_PAINTCOSTFORMSTORAGE" 18.20 KB 52 rows
. . exported "INFODBA"."PS4_PLASTICCOMPONENTSLH" 7.117 KB 47 rows
. . exported "INFODBA"."PS4_PLASTICCOMPONENTSRH" 6.593 KB 26 rows
. . exported "INFODBA"."PS4_PRJMNGRESTMCSTFRMSTORAGE" 19.07 KB 146 rows
. . exported "INFODBA"."PS4_PROJMNGRCOSTFORMSTORAGE" 35.47 KB 92 rows
. . exported "INFODBA"."PS4_PURCHASINGCOSTFRMSTORAGE" 14.89 KB 49 rows
. . exported "INFODBA"."PS4_QUALITYCOSTFORMSTORAGE" 31.82 KB 52 rows
. . exported "INFODBA"."PS4_RFQ" 12.42 KB 37 rows
. . exported "INFODBA"."PS4_RFQREVISION" 7.945 KB 47 rows
. . exported "INFODBA"."PS4_RFQREVMASTERS" 6.765 KB 13 rows
. . exported "INFODBA"."PS4_RHNUMBER" 6.601 KB 27 rows
. . exported "INFODBA"."PS4_SAFETYCOSTFORMSTORAGE" 8.656 KB 49 rows
. . exported "INFODBA"."PS4_SALESCOSTFORMSTORAGE" 18.62 KB 50 rows
. . exported "INFODBA"."PS4_SMRBIDDOCREVISION" 6.75 KB 23 rows
. . exported "INFODBA"."PS4_SMRDESIGN" 28.78 KB 587 rows
. . exported "INFODBA"."PS4_SMRDESIGNREVISION" 21.03 KB 594 rows
. . exported "INFODBA"."PS4_SMRDOCUMENT" 9.437 KB 10 rows
. . exported "INFODBA"."PS4_SMRDOCUMENTREVISION" 5.734 KB 12 rows
. . exported "INFODBA"."PS4_SMRDRAWING" 8.757 KB 20 rows
. . exported "INFODBA"."PS4_SMRDRAWINGREVISION" 6.804 KB 22 rows
. . exported "INFODBA"."PS4_SMRLIBDOC" 6.875 KB 2 rows
. . exported "INFODBA"."PS4_SMRLIBDOCREVISION" 5.546 KB 2 rows
. . exported "INFODBA"."PS4_SMRPARTREVISION" 32.14 KB 524 rows
. . exported "INFODBA"."PS4_SMRRFQDOC" 7.367 KB 53 rows
. . exported "INFODBA"."PS4_SMRRFQDOCREVISION" 6.867 KB 73 rows
. . exported "INFODBA"."PS4_SMRTOOLDESIGN" 9.882 KB 1 rows
. . exported "INFODBA"."PS4_TOOLINGCOSTFORMSTORAGE" 11.33 KB 50 rows
. . exported "INFODBA"."PSAT_RANGES" 6.632 KB 7 rows
. . exported "INFODBA"."PSCHEDULE" 11.86 KB 3 rows
. . exported "INFODBA"."PSCHEDULEMEMBER" 8.382 KB 3 rows
. . exported "INFODBA"."PSCHEDULEMEMBER_TAGLIST_0" 6.484 KB 3 rows
. . exported "INFODBA"."PSCHEDULEREVISION" 19.65 KB 3 rows
. . exported "INFODBA"."PSCHEDULETASK" 9.031 KB 7 rows
. . exported "INFODBA"."PSCHEDULETASKREVISION" 9.976 KB 7 rows
. . exported "INFODBA"."PSCHMGTCOSTFORMSTORAGE" 7.828 KB 7 rows
. . exported "INFODBA"."PSCOPED_PROPERTY_NAME" 6.546 KB 25 rows
. . exported "INFODBA"."PSCOPED_TYPE_NAME" 6.648 KB 25 rows
. . exported "INFODBA"."PSCOPED_TYPE_NAME_0" 9.656 KB 110 rows
. . exported "INFODBA"."PSCTYPEDATA" 6.828 KB 11 rows
. . exported "INFODBA"."PSECONDARYOBJECTS" 6.398 KB 1 rows
. . exported "INFODBA"."PSEQUENCE" 6.132 KB 9 rows
. . exported "INFODBA"."PSIGNOFF" 45.77 KB 280 rows
. . exported "INFODBA"."PSMLB0" 16.88 KB 4 rows
. . exported "INFODBA"."PSMLB1" 17.88 KB 15 rows
. . exported "INFODBA"."PSOURCEOBJ" 10.51 KB 41 rows
. . exported "INFODBA"."PSPECTEMPLATE" 5.546 KB 2 rows
. . exported "INFODBA"."PSRC_DATASET_TYPE_NAMES" 7.976 KB 41 rows
. . exported "INFODBA"."PSTART_VALUE" 6.132 KB 9 rows
. . exported "INFODBA"."PSTRUCTURE_REVISIONS" 7.023 KB 17 rows
. . exported "INFODBA"."PSTXT" 12.50 KB 5 rows
. . exported "INFODBA"."PSUN_RANGES" 6.585 KB 6 rows
. . exported "INFODBA"."PSYSTEM_DATA_STRINGS" 6.148 KB 6 rows
. . exported "INFODBA"."PTASKDEPENDENCY" 5.968 KB 1 rows
. . exported "INFODBA"."PTASKEXECUTIONFORMINFO" 10.39 KB 7 rows
. . exported "INFODBA"."PTASKINBOX" 14.75 KB 219 rows
. . exported "INFODBA"."PTASKSCHEDULINGFORMINFO" 9.914 KB 7 rows
. . exported "INFODBA"."PTASKTYPE" 9.257 KB 26 rows
. . exported "INFODBA"."PTCCALENDAR" 11.85 KB 6 rows
. . exported "INFODBA"."PTC_PREFERENCES" 8.671 KB 56 rows
. . exported "INFODBA"."PTC_PROJECT" 21.78 KB 52 rows
. . exported "INFODBA"."PTC_USERCONTEXT" 8.484 KB 6 rows
. . exported "INFODBA"."PTEMPLATEDATATYPE" 5.578 KB 3 rows
. . exported "INFODBA"."PTHU_RANGES" 6.828 KB 12 rows
. . exported "INFODBA"."PTOOL" 20.47 KB 63 rows
. . exported "INFODBA"."PTRANSFERMODE" 20.54 KB 85 rows
. . exported "INFODBA"."PTRANSFEROPTIONSET" 11.36 KB 20 rows
. . exported "INFODBA"."PTUE_RANGES" 6.828 KB 12 rows
. . exported "INFODBA"."PTYPEBMOPERATION" 30.95 KB 794 rows
. . exported "INFODBA"."PTYPECONSTANT" 10.38 KB 96 rows
. . exported "INFODBA"."PTYPEDEF" 20.36 KB 389 rows
. . exported "INFODBA"."PTYPE_SCOPE" 6.031 KB 3 rows
. . exported "INFODBA"."PUNCT_DICT" 21.67 KB 15 rows
. . exported "INFODBA"."PUNITOFMEASURE" 6.101 KB 7 rows
. . exported "INFODBA"."PUSER" 24.81 KB 73 rows
. . exported "INFODBA"."PUSERS_0" 7.070 KB 18 rows
. . exported "INFODBA"."PUSER_INBOX" 10.32 KB 73 rows
. . exported "INFODBA"."PUSER_PATHS" 6.601 KB 18 rows
. . exported "INFODBA"."PVALIDATIONAGENTREVISION" 6.023 KB 2 rows
. . exported "INFODBA"."PVALIDATIONDATA" 13.42 KB 2 rows
ORA-31693: Table data object "INFODBA"."PVALIDATION_ARGUMENTS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALIDATION_ARGUMENTS_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALTOOLAGENT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALTOOLAGENTREVISION" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALUE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALUES_0" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALUE_FILTERS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALUE_FILTERS_INDEXES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALUE_FILTER_CONDITIONS" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVALUE_TYPE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PVIEWED_BY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PWED_RANGES" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."PWELDPOINTREVISIONMASTER" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."SCRATCH_TABLE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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"."VARIANT_KEY" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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 "SCOTT"."DEPT" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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 "SCOTT"."EMP" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.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 "SCOTT"."SALGRADE" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp" for write
ORA-19505: failed to identify file "/u04/MasterDB/expdp/expdp_smrrac/expdp-SMMRAC12019-10-21_10-09-24.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . exported "INFODBA"."ACCT_TABLE" 0 KB 0 rows
. . exported "INFODBA"."AUDITLOG" 0 KB 0 rows
. . exported "INFODBA"."BOM_ACCT_TABLE" 0 KB 0 rows
. . exported "INFODBA"."BOM_RECIPE_TABLE" 0 KB 0 rows
. . exported "INFODBA"."EXPORT_TO_SITE_TABLE" 0 KB 0 rows
. . exported "INFODBA"."EXP_OBJ_TABLE" 0 KB 0 rows
. . exported "INFODBA"."IMAN_CURVEDATA" 0 KB 0 rows
. . exported "INFODBA"."IMAN_MVLBLOB" 0 KB 0 rows
. . exported "INFODBA"."IMAN_PROXYTEXT" 0 KB 0 rows
. . exported "INFODBA"."MFK_WORK_OBJPIDS" 0 KB 0 rows
. . exported "INFODBA"."MMV_EQUIVALENT_THREADS" 0 KB 0 rows
. . exported "INFODBA"."MMV_SPATIAL_CELL_INDEX" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCARCHREF" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCCHILDITEM" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCDATA" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCDATAQUALIFIER" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCFLAGS" 0 KB 0 rows
. . exported "INFODBA"."PABSOCCGDEOBJECT" 0 KB 0 rows

RAC - SSH conectvity setup manually on GRID 12c

Example : Manually setup of passwordless connection between 2 node on grid user.

Hostname:

sgdcplm01,sgdcplm02

Command :
oracle user
./sshUserSetup.sh -user oracle -hosts "sgdcplm01 sgdcplm02" -advanced -exverify –noPromptPassphrase

grid user

./sshUserSetup.sh -user grid -hosts "sgdcplm01 sgdcplm02" -advanced -exverify –noPromptPassphrase

#########################################################################
grid@sgdcplm02:/u04/oracle_grid_software/grid/sshsetup> ./sshUserSetup.sh -user oracle -hosts "sgdcplm01 sgdcplm02" -advanced -exverify –noPromptPassphrase
The output of this script is also logged into /tmp/sshUserSetup_2019-06-04-09-06-49.log
Hosts are sgdcplm01 sgdcplm02
user is oracle
Platform:- Linux
Checking if the remote hosts are reachable
PING sgdcplm01.xxx.com (10.xx.xx.xx) 56(84) bytes of data.
64 bytes from sgdcplm01.xxx.com (10.xx.xx.xx) : icmp_seq=1 ttl=64 time=0.083 ms
64 bytes from sgdcplm01.xxx.com (10.xx.xx.xx) : icmp_seq=2 ttl=64 time=0.083 ms
64 bytes from sgdcplm01.xxx.com (10.xx.xx.xx) : icmp_seq=3 ttl=64 time=0.096 ms
64 bytes from sgdcplm01.xxx.com (10.xx.xx.xx) : icmp_seq=4 ttl=64 time=0.076 ms
64 bytes from sgdcplm01.xxx.com (10.xx.xx.xx) : icmp_seq=5 ttl=64 time=0.088 ms

--- sgdcplm02.xxx.com (10.xx.xx.xx) ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4082ms
rtt min/avg/max/mdev = 0.076/0.085/0.096/0.008 ms
PING sgdcplm02.xxx.com (10.xx.xx.xx) 56(84) bytes of data.
64 bytes from sgdcplm02.xxx.com (10.xx.xx.xx): icmp_seq=1 ttl=64 time=0.011 ms
64 bytes from sgdcplm02.xxx.com (10.xx.xx.xx): icmp_seq=2 ttl=64 time=0.020 ms
64 bytes from sgdcplm02.xxx.com (10.xx.xx.xx): icmp_seq=3 ttl=64 time=0.039 ms
64 bytes from sgdcplm02.xxx.com (10.xx.xx.xx): icmp_seq=4 ttl=64 time=0.030 ms
64 bytes from sgdcplm02.xxx.com (10.xx.xx.xx): icmp_seq=5 ttl=64 time=0.031 ms

--- sgdcplm02.xxx.com (10.xx.xx.xx) ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4094ms
rtt min/avg/max/mdev = 0.011/0.026/0.039/0.010 ms
Remote host reachability check succeeded.
The following hosts are reachable: sgdcplm01 sgdcplm02.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost sgdcplm01
numhosts 2
The script will setup SSH connectivity from the host sgdcplm02 to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host sgdcplm02
and the remote hosts without being prompted for passwords or confirmations.

NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.

NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.

Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes

The user chose yes
Please specify if you want to specify a passphrase for the private key this script will create for the local host. Passphrase is used to encrypt the private key and makes SSH much more secure. Type 'yes' or 'no' and then press enter. In case you press 'yes', you would need to enter the passphrase whenever the script executes ssh or scp.
The estimated number of times the user would be prompted for a passphrase is 4. In addition, if the private-public files are also newly created, the user would have to specify the passphrase on one additional occasion.
Enter 'yes' or 'no'.

The user chose
The files containing the client public and private keys already exist on the local host. The current private key may have a passphrase associated with it. In case you find using passphrase inconvenient(although it is more secure), you can change to it empty through this script. Press 'change' if you want the script to change the passphrase for you. Press 'no' if you want to use your old passphrase, if you had one.
yes
The user chose yes
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/grid/.ssh/config, it would be backed up to /home/grid/.ssh/config.backup.
Removing old private/public keys on local host
Running SSH keygen on local host
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Generating public/private rsa key pair.
Your identification has been saved in /home/grid/.ssh/id_rsa.
Your public key has been saved in /home/grid/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:KS3TTKMYZhi8U8JO51qosZzesQV0ho7zlSUYWk9wcQM grid@sgdcplm02
The key's randomart image is:
+---[RSA 1024]----+
| o.+=Eoo |
| B**+... |
| +=B*.+ o |
|.o==o= * o |
|.++++ = S |
|oo.o . + |
|. . + |
| . o |
| |
+----[SHA256]-----+
Creating .ssh directory and setting permissions on remote host sgdcplm01
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host sgdcplm01. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host sgdcplm01.
Warning: Permanently added 'sgdcplm01,10.33.105.63' (ECDSA) to the list of known hosts.
Password:
Done with creating .ssh directory and setting permissions on remote host sgdcplm01.
Creating .ssh directory and setting permissions on remote host sgdcplm02
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host sgdcplm02. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host sgdcplm02.
Warning: Permanently added 'sgdcplm02,10.xx.xx.xx' (ECDSA) to the list of known hosts.
Password:
Done with creating .ssh directory and setting permissions on remote host sgdcplm02.
Copying local host public key to the remote host sgdcplm01
The user may be prompted for a password or passphrase here since the script would be using SCP for host sgdcplm01.
Password:
Done copying local host public key to the remote host sgdcplm01
Copying local host public key to the remote host sgdcplm02
The user may be prompted for a password or passphrase here since the script would be using SCP for host sgdcplm02.
Password:
Done copying local host public key to the remote host sgdcplm02
Creating keys on remote host sgdcplm01 if they do not exist already. This is required to setup SSH on host sgdcplm01.
Enter passphrase for key '/home/grid/.ssh/id_rsa':

Creating keys on remote host sgdcplm02 if they do not exist already. This is required to setup SSH on host sgdcplm02.
Enter passphrase for key '/home/grid/.ssh/id_rsa':

Enter passphrase for key '/home/grid/.ssh/id_rsa':
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Updating authorized_keys file on remote host sgdcplm01
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Updating known_hosts file on remote host sgdcplm01
Enter passphrase for key '/home/grid/.ssh/id_rsa':
./sshUserSetup.sh: line 540: [: =: unary operator expected
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Updating authorized_keys file on remote host sgdcplm02
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Updating known_hosts file on remote host sgdcplm02
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Enter passphrase for key '/home/grid/.ssh/id_rsa':
./sshUserSetup.sh: line 540: [: =: unary operator expected
Enter passphrase for key '/home/grid/.ssh/id_rsa':
SSH setup is complete.

------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oracle.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--sgdcplm01:--
Running /usr/bin/ssh -x -l oracle sgdcplm01 date to verify SSH connectivity has been setup from local host to sgdcplm01.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
./sshUserSetup.sh: line 587: [: =: unary operator expected
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Tue Jun 4 09:07:51 CEST 2019
------------------------------------------------------------------------
--sgdcplm02:--
Running /usr/bin/ssh -x -l oracle sgdcplm02 date to verify SSH connectivity has been setup from local host to sgdcplm02.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
./sshUserSetup.sh: line 587: [: =: unary operator expected
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Tue Jun 4 09:07:52 CEST 2019
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from sgdcplm01 to sgdcplm01
------------------------------------------------------------------------
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Tue Jun 4 09:07:55 CEST 2019
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from sgdcplm01 to sgdcplm02
------------------------------------------------------------------------
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Tue Jun 4 09:07:57 CEST 2019
------------------------------------------------------------------------
-Verification from sgdcplm01 complete-
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from sgdcplm02 to sgdcplm01
------------------------------------------------------------------------
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Tue Jun 4 09:08:00 CEST 2019
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from sgdcplm02 to sgdcplm02
------------------------------------------------------------------------
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Enter passphrase for key '/home/grid/.ssh/id_rsa':
Tue Jun 4 09:08:01 CEST 2019
------------------------------------------------------------------------
-Verification from sgdcplm02 complete-
SSH verification complete.
grid@sgdcplm02:/u04/MasterDB/oracle_grid_software/grid/sshsetup>

grid patch --- Patch 24412235 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.161018 (Oct2016)

Scenario Preview:

We found bug at OS level during installation of SLES 12 SP4 , Cluster verification utility tools were not showing outputs , As per oracle support , This is due to OS kernel issue.

So we have to start installation process using grid user before running ./roost.sh. apply patch at local level on both machine one by one.

Set Grid home environment.

[grid@srv1 24412235]$ export ORACLE_HOME=/u01/app/12.1.0/grid/
[grid@srv1 24412235]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[grid@srv1 24412235]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

Grid patch command:

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24007012

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24006101

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/23854735

[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/21436941

###############################################################################
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24007012
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-30-17PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 24007012

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/12.1.0/grid')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Applying interim patch '24007012' to OH '/u01/app/12.1.0/grid'

Patching component oracle.usm, 12.1.0.2.0...
Patch 24007012 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-30-17PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/24006101
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-35-18PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/12.1.0/grid')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.xdk, 12.1.0.2.0 ] , [ oracle.oraolap, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/u01/app/12.1.0/grid'

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.has.crs, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/u01/app/12.1.0/grid'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/u01/app/12.1.0/grid'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.xdk, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.oraolap, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Applying sub-patch '23054246' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.rdbms.dv, 12.1.0.2.0 ] , [ oracle.ctx, 12.1.0.2.0 ] , [ oracle.xdk, 12.1.0.2.0 ] , [ oracle.ctx.atg, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.install.deinstalltool, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Applying sub-patch '24006101' to OH '/u01/app/12.1.0/grid'
ApplySession: Optional component(s) [ oracle.rdbms.dv, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Composite patch 24006101 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-35-18PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/23854735
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-39-38PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-40-06PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 23854735

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/12.1.0/grid')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...

Applying interim patch '23854735' to OH '/u01/app/12.1.0/grid'

Patching component oracle.crs, 12.1.0.2.0...

Patching component oracle.has.db, 12.1.0.2.0...

Patching component oracle.has.common, 12.1.0.2.0...
Patch 23854735 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-40-06PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$
[grid@srv1 OPatch]$ /u01/app/12.1.0/grid/OPatch/opatch apply -oh /u01/app/12.1.0/grid -local /u01/24412235/21436941
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.16
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-46-41PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 21436941

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/12.1.0/grid')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21436941' to OH '/u01/app/12.1.0/grid'

Patching component oracle.wlm.dbwlm, 12.1.0.2.0...
Patch 21436941 successfully applied.
Log file location: /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2019-09-18_19-46-41PM_1.log

OPatch succeeded.
[grid@srv1 OPatch]$