memory_target not support on this system(oracle11g)

本文详细阐述了在Oracle11g中遇到memory_max_target和memory_target配置限制时,如何通过调整/dev/shm的大小来解决问题。包括检查现有设备的大小、编辑fstab文件以确保每次系统启动都正确挂载/dev/shm,并最终重新挂载以验证更改是否成功。
author:skate
time:2011/09/27

 

Oracle11g无法修改memory_max_target,memory_target的值,报错如下:

memory_target not support on this system

导致这个错误的原因是memory_max_target值超过了/dev/shm的大小,解决办法是将/dev/shm调大,具体步骤描述如下:

 

查看现有的/dev/shm的大小
[oracle@db01 ~]$ df -hT
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/sda5     ext3     49G  9.2G   37G  20% /
/dev/sda7     ext3    1.3T  795G  421G  66% /oracle
/dev/sda3     ext3     99M   12M   83M  13% /boot
tmpfs        tmpfs     10G   15G  5.6G  73% /dev/shm

 

修改文件 /etc/fstab,使系统每次启动都可以按我们分配的大小mount /dev/shm
[oracle@db01 ~]$ more /etc/fstab
LABEL=/                 /                       ext3    defaults        1 1
LABEL=/oracle           /oracle                 ext3    defaults        1 2
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   defaults,size=20g        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
LABEL=SWAP-sda6         swap                    swap    defaults        0 0
[oracle@db01 ~]$

重新mount文件系统/dev/shm 
[oracle@db01 ~]$ umount /dev/shm
[oracle@db01 ~]$ mount /dev/shm

在查看文件系统/dev/shm 
[oracle@db01 ~]$ df -hT
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/sda5     ext3     49G  9.2G   37G  20% /
/dev/sda7     ext3    1.3T  795G  421G  66% /oracle
/dev/sda3     ext3     99M   12M   83M  13% /boot
tmpfs        tmpfs     20G   15G  5.6G  73% /dev/shm

 

----------end--------
### Oracle 11g OCI Dependencies Requirements For applications that utilize the Oracle Call Interface (OCI) with Oracle Database 11g, ensuring all necessary dependencies are met is crucial to maintain performance and stability. While specific details about OCI dependencies might not be directly covered in the provided references, information regarding general installation prerequisites can offer insight into what may also apply to OCI. The system must meet certain minimum hardware requirements including memory specifications which could indirectly affect OCI operations[^3]. For instance: - **Memory Requirements**: A minimum of 1 GB of RAM is required; however, it's recommended to have at least 2 GB or more. This applies broadly across components interacting with the database server, likely encompassing OCI as well. To verify available RAM on a Linux-based operating system where many Oracle installations occur, one would use this command: ```bash grep MemTotal /proc/meminfo ``` Beyond these basic hardware considerations, OCI typically requires several software libraries present within the environment. These include but aren't limited to standard C library functions (`libc.so`), math routines (`libm.so`), threading support (`libpthread.so`), among others. Additionally, proper versions of these shared objects should match those expected by the version of Oracle being used. Moreover, when deploying an application using OCI against Oracle 11g databases, ensure compatibility between client-side tools like SQL*Plus or any custom-built programs leveraging OCI APIs and the target database release. Configuration files such as `tnsnames.ora`, while primarily serving connection definitions, play a role alongside OCI for establishing connections from clients to servers[^4]. In summary, although explicit documentation concerning only OCI dependencies isn’t provided here, adhering closely to overall Oracle 11g setup guidelines ensures foundational elements supporting successful deployment of OCI-enabled solutions. --related questions-- 1. What steps need to be taken before installing Oracle Database 11g? 2. How does modifying tnsnames.ora impact connectivity through OCI interfaces? 3. Can you explain how to check if your system meets the minimum hardware requirements for running Oracle 11g? 4. Where can I find logs generated during the creation of an Oracle database via dbca?
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值