Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/export/home/oracle/stfacmas.dmp" for read
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7
Problem:
-bash-4.4$ impdp said/passwd@orcl full=y directory=STLBAS_DIR dumpfile=stfacmas.dmp logfile=stlbas_tab_261219.log
Import: Release 12.2.0.1.0 - Production on Sat Apr 11 20:53:16 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/export/home/oracle/stfacmas.dmp" for read
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7
Solution:
Actually we are trying to import data into Oracle 12c R2 2 nodes RAC Database. After that we just shutdown one instance and try to execute the following command and its working fine!!!!!!!!!!
Login into 2nd Node:
-bash-4.4$ sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 12 06:41:57 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Login into 1st Node:
-bash-4.4$ impdp system/passwd@orcl full=y directory=STLBAS_DIR dumpfile=stlbas_100420.dmp logfile=imp.log
Import: Release 12.2.0.1.0 - Production on Sat Apr 11 07:38:30 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@stlbas full=y directory=STLBAS_DIR dumpfile=stlbas_100420.dmp logfile=imp.log
Processing object type SCHEMA_EXPORT/USER
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/export/home/oracle/stfacmas.dmp" for read
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7
Problem:
-bash-4.4$ impdp said/passwd@orcl full=y directory=STLBAS_DIR dumpfile=stfacmas.dmp logfile=stlbas_tab_261219.log
Import: Release 12.2.0.1.0 - Production on Sat Apr 11 20:53:16 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/export/home/oracle/stfacmas.dmp" for read
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7
Solution:
Actually we are trying to import data into Oracle 12c R2 2 nodes RAC Database. After that we just shutdown one instance and try to execute the following command and its working fine!!!!!!!!!!
Login into 2nd Node:
-bash-4.4$ sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 12 06:41:57 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Login into 1st Node:
-bash-4.4$ impdp system/passwd@orcl full=y directory=STLBAS_DIR dumpfile=stlbas_100420.dmp logfile=imp.log
Import: Release 12.2.0.1.0 - Production on Sat Apr 11 07:38:30 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@stlbas full=y directory=STLBAS_DIR dumpfile=stlbas_100420.dmp logfile=imp.log
Processing object type SCHEMA_EXPORT/USER
No comments:
Post a Comment