在Oracle Linux 6.1 上安装Oracle 10.2.0.1, 在安装软件的时候就是很曲折的过程,在dbca 建instance的时候,又遇到了:
ORA-27125:unable to create shared memory segment
安装被中断。
rac2:/u02> oerr ora 27125
27125, 00000, "unable to create sharedmemory segment"
// *Cause: shmget() call failed
// *Action: contact Oracle support
解决方法如下:
[root@rac2 ~]# id oracle
uid=500(oracle) gid=501(oinstall)groups=501(oinstall),502(dba),503(asmadmin),504(oper)
[root@rac2 ~]# more/proc/sys/vm/hugetlb_shm_group
0
下面用root执行下面的命令,将dba组添加到系统内核中:
[root@rac2 ~]# echo 502 >/proc/sys/vm/hugetlb_shm_group
--这里的502 是上面的id 命令查看出来的。
[root@rac2 ~]# more /proc/sys/vm/hugetlb_shm_group
502
然后重新DBCA,成功建立实例。 如果遇到实例名以存在的提示,删除/etc/oratab 中对应的记录即可。
hugetlb_shm_group 说明:
hugetlb_shm_group contains group id that isallowed to create SysV shared memory segment using hugetlb page
When a process uses some memory, the CPU ismarking the RAM as used by that process. For efficiency, the CPU allocate RAMby chunks of 4K bytes (it's the default value on many platforms). Those chunksare named pages. Those pages can be swapped to disk, etc.
Since the process address space are virtual, the CPU and the operating systemhave to remember which page belong to which process, and where it is stored.Obviously, the more pages you have, the more time it takes to find where thememory is mapped. When a process uses 1GB of memory, that's 262144 entries to lookup (1GB / 4K). If one Page Table Entry consume 8bytes, that's 2MB (262144 * 8)to look-up.
Most current CPU architectures support bigger pages (so the CPU/OS have lessentries to look-up), those are named Huge pages (on Linux), Super Pages (onBSD) or Large Pages (on Windows), but it all the same thing.
-------------------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
Skype: tianlesoftware
Email: tianlesoftware@gmail.com
Blog: http://www.tianlesoftware.com
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware
-------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----
DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929 DBA5群: 142216823
DBA6 群:158654907 DBA7 群:172855474 DBA总群:104207940
分享到:
相关推荐
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
ORA-32001:write to spfile requested but no spfile is in use请求写入spfile,但没有使用spfile的解决方法 在输入以下语句中报了这样的错误: SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/...
调整参数后引起,ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3 2768M 的解决方案
oracle12c程序连接时异常: ORA-01017: 用户名/口令无效; 登录被拒绝 的解决方案。
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
ORA-12154: TNS: 无法解析指定的连接标识符的解决方法
ORA-01036:非法的变量名/编号 oracle特有的错误
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
ORA-00031:标记要终止的会话解决方案; ORA-00031:标记要终止的会话解决方案;
oracle 12 c ORA-01017: 用户名/口令无效; 登录被拒绝
oracle报错ora-12541:TNS无监听程序
NULL 博文链接:https://3w1h.iteye.com/blog/1211779
最近在工作中遇到了一个问题,错误是Oracle dbca时报错:ORA-12547: TNS:lost contact,通过查找相关的资料终于找到了解决的方法,下面分享给大家,话不多说了,来一起看看详细的介绍吧。 环境: OS:RHEL6.5 x86-...
ORA-12518 TNS:监听程序无法分发客户机连接,在您安装好数据库后配置连接数据库的过程中遇到这类问题应该很头疼吧,不过,当您还是四处查资料来解决您遇到的另你头疼的问题时,如果不经意间看到了这则贴子,那请您升...
-- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... ...
CLOB字段类型报错 ORA-01704:文字字符串过长的解决
解决ORACLE TNS: 无法解析指定的连接标识符; 里面有步骤
BLOG_【故障处理】Oracle_lhr_ORA-01565 告警日志报“ORA-01565 Unable To open Spfile”.pdf
ORA-12541 TNSno listener 的解决方案 ORA-12541 TNSno listener 的解决方案
ORA-00312: online log 1 thread 1: '/oradata/10g/db/instant/redo01.log' SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=4294967296 SCOPE=BOTH; System altered. SQL> shutdown immediate ORA-...