Shulou(Shulou.com)05/31 Report--

Editor to share with you oracle for windows using NFS remote backup report OS 1326 error how to do, I believe that most people do not understand, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Test windows database server version: windows server 2012R2

Test windows NFS server version: windows server 2008R2

Test oracle database version: oracle 11.2.0.1

Problem description: create a shared folder on the win2008 server, set the sharing permissions so that everyone has full control, and mount the shared folder of win2008R2 on win2012R2

Let the oracle database perform a remote backup, that is, back up from windows2012R2 to the remote machine windows2008R2 machine by NFS. When the windows 2008R2 server and windows

When the windows password of the 2012R2 server is inconsistent (or the password of the administrator of the two servers is different), oracle uses nfs for expdp or rman remote backup:

C:\ Users\ Administrator > rman target /

Recovery Manager: Release 11.2.0.1.0-Production on Tuesday 19 December 22:18:10 2017

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

Connect to the target database: ORCL (DBID=1489232098)

RMAN > backup current controlfile format'\\ 192.168.49.142\ orabak\ orcl.ctrl'

Launch backup from 19-12-17

Use channel ORA_DISK_1

Channel ORA_DISK_1: starting backup set of all data files

Channel ORA_DISK_1: specifying data files in the backup set

The backup set includes the current control files

Channel ORA_DISK_1: starting segment 1 from 19-12-17

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: the backup command (on the ORA_DISK_1 channel, at 22:19:41 on the 12-pound 19-pound) failed

ORA-19504: unable to create file "\\ 192.168.49.142\ ORABAK\ ORCL.CTRL"

ORA-27040: file creation error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 1326) the username or password is incorrect.

RMAN >

Expdp execution error:

C:\ Users\ Administrator > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tuesday 19 December 22:32:03 2017

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

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > create directory zhul as'\\ 192.168.49.142\ orabak'

The directory has been created.

SQL > quit

From Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnect

C:\ Users\ Administrator > expdp\ "/ as sysdba\" directory=zhul schemas=scott dumpfile=expdp_scott.dmp logfile=expdp_soctt.log

Export: Release 11.2.0.1.0-Production on Tuesday 19 December 22:33:27 2017

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

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: unable to open log file.

ORA-29283: invalid file operation

ORA-06512: in "SYS.UTL_FILE", line 536

ORA-29283: invalid file operation

C:\ Users\ Administrator >

However, when the windows password or administrator of the two servers are the same, oracle can make remote expdp or rman backups using nfs smoothly.

C:\ Users\ Administrator > rman target /

Recovery Manager: Release 11.2.0.1.0-Production on Tuesday 19 December 22:40:00 2017

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

Connect to the target database: ORCL (DBID=1489232098)

RMAN > backup current controlfile format'\\ 192.168.49.142\ orabak\ orcl_ctrl.ora'

Launch backup from 19-12-17

Replace the recovery directory with the target database control file

Assigned channel: ORA_DISK_1

Channel ORA_DISK_1: SID=131 device type = DISK

Channel ORA_DISK_1: starting backup set of all data files

Channel ORA_DISK_1: specifying data files in the backup set

The backup set includes the current control files

Channel ORA_DISK_1: starting segment 1 from 19-12-17

Channel ORA_DISK_1: completed segment 1 from 19 to December to 17

Segment handle =\\ 192.168.49.142\ ORABAK\ ORCL_CTRL.ORA tag = TAG20171219T224050 comment = NONE

Channel ORA_DISK_1: backup set completed, elapsed time: 00:00:01

Completion of backup in 19-12-17

RMAN >

C:\ Users\ Administrator > expdp\ "/ as sysdba\" directory=zhul schemas=scott dumpfile=expdp_scott.dmp logfile=expdp_soctt.log

Export: Release 11.2.0.1.0-Production on Tuesday 19 December 22:41:51 2017

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

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Start "SYS". "SYS_EXPORT_SCHEMA_02": "/ * AS SYSDBA" directory=zhul schemas=scott dumpfile=expdp_scott.dmp logfile=expdp_soctt.log

Estimation is being made using the BLOCKS method.

Dealing with object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimate using the BLOCKS method: 192 KB

Dealing with object type SCHEMA_EXPORT/USER

Dealing with object type SCHEMA_EXPORT/SYSTEM_GRANT

Dealing with object type SCHEMA_EXPORT/ROLE_GRANT

Dealing with object type SCHEMA_EXPORT/DEFAULT_ROLE

Dealing with object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Dealing with object type SCHEMA_EXPORT/TABLE/TABLE

Dealing with object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Dealing with object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Dealing with object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Dealing with object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Dealing with object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . Exported "SCOTT". "DEPT" 5.937 KB 4 lines

. . Exported "SCOTT". "EMP" 8.570 KB 14 lines

. . Exported "SCOTT". "SALGRADE" 5.867 KB 5 lines

. . The line "SCOTT". "BONUS" 0 KB 0 is exported

The primary table "SYS". "SYS_EXPORT_SCHEMA_02" has been successfully loaded / unloaded

*

The dump file set for SYS.SYS_EXPORT_SCHEMA_02 is:

\\ 192.168.49.142\ ORABAK\ EXPDP_SCOTT.DMP

Assignment "SYS". "SYS_EXPORT_SCHEMA_02" completed successfully at 22:42:46

C:\ Users\ Administrator >

The above is all the contents of the article "how to report OS 1326 errors when oracle for windows uses NFS remote backup". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.