11.2.0.3 asm报ORA-04031

0

Posted on by

数据库11.2.0.3 在ASM instances后台会报 ORA-04031这样的错 

ERROR at line 1:
ORA-04031: unable to allocate 256 bytes of shared memory ("shared
pool","unknown object","PCursor","kglob")
 
原因是：
1) ASM instance was running out of shared pool free memory.
2) The shared pool free memory was close to 0 MB on the affected ASM instances:
 

+ASM1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL> select bytes/1024/1024 MB
2 from v$sgastat
3 where pool = 'shared pool' and name = 'free memory';

 

 

 

MB 
17.8854446 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

+ASM2
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL> select bytes/1024/1024 MB
2 from v$sgastat
3 where pool = 'shared pool' an[......]

查看全文

Configure Direct NFS Client (DNFS) on Linux (11g)

1

Posted on by

在Oracle 11g中有了Direct NFS Client (DNFS)新功能 ，配置好后数据库将可以直接访问NFS服务器上的文件，避免由OS内核NFS造成的额外开销。

DIRECT NFS CLIENT OVERVIEW

      Standard NFS client software, provided by the operating system, is not optimized for Oracle Database file I/O access patterns.  With Oracle Database 11g, you can configure Oracle Database to access NFS V3 NAS devices directly using Oracle Direct NFS Client, rather than using the operating system kernel NFS client.  Oracle Database will access files stored on the NFS server directly through the integrated Direct NFS Client eliminating the overhead imposed by the operating system kernel NFS.  These files are also accessible via the operating system kernel NFS client thereby allowing seamless administration.

 

 

Direct NFS客户机装载点的设置信息可以是以下3个的一个

1. $ORACLE_HOME/dbs/oranfstab

2. /etc/oranfstab

3. /etc/mtab

 

说明： 

Direct NFS Client can use a[......]

查看全文

rac环境在rman备份出现ORA-00245

1

Posted on by

版本： 

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

数据库在rman备份的时候出现如下错误： 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ch1 channel at 04/19/2013 18:04:39
ORA-00245: control file backup failed; target is likely on a local file system

 

错误原因：

快照控制文件必须要被所有节点访问，如果快照控制不是放在共享设备上，那么在RMAN 进行控制文件的快照备份时就会报错。

具体原文： 

From 11gR2 onwards, the controlfile backup happens without holding the controlfile enqueue. For non-RAC database,
 this do[......]

查看全文

oracle在NFS上参数选项

0

Posted on by

在oracle环境使用NFS，用默认mount方式，oracle备份等会报错。

以下是官方文档推荐参数 Mount Options for Oracle files when used with NFS on NAS devices [ID 359515.1]

 

RAC including RACone and single instance RAC

 

In the table below 

  • Binaries is the shared mount points where the Oracle Home and CRS_HOME is installed.
  • Datafiles includes Online Logs, Controlfile and Datafiles
  • nfsvers and vers are identical on those OS platforms that has nfsvers.  The ver option is an alternative to the nfsvers option. It is included for compatibility with other operating systems
  • Please note that the mount options on each of the following cells are applicable only to those type of files listed in the column heading.
  • For RMAN backup sets, image copies, and Data Pump dump files, the "NOAC" mount option should not be specified – that is because RMAN and Data Pump do not check this option and specifying this[……]

查看全文

redhat6 tmpfs调整大小

0

Posted on by

在redhat6之前，修改tmpfs大小只需要修改fstab里面的值就行了。

redhat 6  除了修改fstab外，还需要修改一下参数文件  /etc/rc.d/rc.sysinit

  1. 修改/etc/fstab

查看内存：

[root@oradbca ~]# grep MemTotal /proc/meminfo 
MemTotal:       65951744 kB

默认值

[root@oradbca ~]# grep tmpfs /etc/fstab 
tmpfs                   /dev/shm                tmpfs   defaults        0 0

 

通过 vi 改成

tmpfs                   /dev/shm                tmpfs   size=60g        0 0

 

   2.修改 /etc/rc.d/rc.sysinit

把 

if [ "$READONLY" != "yes" ] ; then
        # Clear mtab
        (> /etc/mtab) &> /dev/null

        # Remove stale backups
        rm -f /etc/mtab~ /etc/m[......]

查看全文

第 12 页，共 12 页« 最新...789101112