linux下oracle命令 err,郁闷的 Linux Error: 13: Permission denied

之前我也碰过类似情形,去 metalink 查了之后,修改一下 event 这个参数就可以了,给您参考...

Cause

From  Oracle 10G R2 , Oracle checks the options with which a NFS mount is mounted on the filesystem.

and this is done to ensure that no corruption of the database can happen as incorrectly mounted NFS volumes can result in data corruption.

There are no single set of NFS mount options that work across all Oracle platforms

Please ensure that you have the proper mount options specified by the NAS vendor /Vendor user guide

The exact checks used for an NFS mounted disk vary between platforms but in general the basic checks will include the following checks

a) The mount table (eg; /etc/mnttab) can be read to check the mount options

b) The NFS mount is mounted with the "hard" option

c) The mount options include rsize>=32768 and wsize>=32768

d) For RAC environments, where NFS disks are supported, the "noac" mount option is used.

Please refer the section -- NFS Mount Options in OracleR Database Installation Guide10g Release 2 (10.2)

If you have  ensured that the mount  options are appropriate and still getting the errors then you are encountering symptoms as

in Bug 5146667   Fixed In Ver: 11.0. 0.0

And this  issues is  found to be  port specific and reproducable on Solaris

.

Solution

To implement the solution, please execute the following steps:

From the erorrs that we see from the RMAN stack this looks like Bug 5146667

This behaviour has been observed on Solaris and AIX Platform.

WORKAROUND:

As suggested in the bug  the workaround recommended is to use the Event 10298.

1) set the Event 10298 in the init file

event="10298 trace name context forever, level 32"

if you are using the spfile then the following can be done

SQL> alter system set event='10298 trace name context forever, level 32' scope= spfile ;

Once you set the above parameter restart the instance check as follows

SQL> select name, value from v$parameter where name = 'event';

NAME VALUE

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

Event 10298 trace name context forever, level 32

1 row selected.

Then try the backups again

2) PATCH

Check if a  one off patch for 10.2.0.1 for your platform is available

Please follow next steps to download and test it :

1. Login to Metalink

2. Go to Patches and Updates -> Simple Search

3. Enter patch number 5146667 and platform you are on  ( your version of OS )

4. Download the patch

5. Read the README file for installation instructions and test it to see if it fixes your problem

Once the patch is shown as applied - you can do away with the event

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值