- 浏览: 981502 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
AIX平台为
引用
# oslevel -r
5300-06
5300-06
配置CSS进程报错:
引用
# localconfig add
/etc/oracle does not exist. Creating it now.
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol _Getctype__FPCc (number 102) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol _Getnumpunct__FPCc (number 106) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
A file or directory in the path name does not exist.
/etc/init.cssd[911]: /etc/oracle/scls_scr/mcsvr/root/cssrun: 0403-005 Cannot create the specified file.
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol _Getctype__FPCc (number 102) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol _Getnumpunct__FPCc (number 106) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
Giving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started
/etc/oracle does not exist. Creating it now.
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol _Getctype__FPCc (number 102) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol _Getnumpunct__FPCc (number 106) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
A file or directory in the path name does not exist.
/etc/init.cssd[911]: /etc/oracle/scls_scr/mcsvr/root/cssrun: 0403-005 Cannot create the specified file.
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol _Getctype__FPCc (number 102) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol _Getnumpunct__FPCc (number 106) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
Giving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started
详见 metalink ID 334726.1
查看系统xlC.rte进程:
引用
# lslpp -l |grep xlC
xlC.aix50.rte 6.0.0.13 COMMITTED C Set ++ Runtime for AIX 5.0
xlC.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.rte 6.0.0.0 COMMITTED C Set ++ Runtime
xlC.rte 6.0.0.0 COMMITTED C Set ++ Runtime
xlC.aix50.rte 6.0.0.13 COMMITTED C Set ++ Runtime for AIX 5.0
xlC.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.rte 6.0.0.0 COMMITTED C Set ++ Runtime
xlC.rte 6.0.0.0 COMMITTED C Set ++ Runtime
xlC.aix50.rte下载地址为:
ftp://ftp.software.ibm.com/aix/products/ccpp/xlc-rte-aix-v8/
解压xlC.aix50.rte包:
引用
# uncompress xlc.rte.aix50.aug2006a.ptf.tar.Z
# tar -xvf xlc.rte.aix50.aug2006a.ptf.tar
x xlC.aix50.rte.08.00.0000.0000.bff, 21315072 bytes, 41631 media blocks.
x xlC.aix50.rte.08.00.0000.0005.bff, 21453824 bytes, 41902 media blocks.
x xlC.msg.Ja_JP.rte.08.00.0000.0000.bff, 11776 bytes, 23 media blocks.
x xlC.msg.Ja_JP.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlC.msg.en_US.rte.08.00.0000.0000.bff, 10240 bytes, 20 media blocks.
x xlC.msg.en_US.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlC.msg.ja_JP.rte.08.00.0000.0000.bff, 11776 bytes, 23 media blocks.
x xlC.msg.ja_JP.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlC.rte.08.00.0000.0000.bff, 4022272 bytes, 7856 media blocks.
x xlC.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlsmp.aix50.rte.01.06.0000.0000.bff, 215040 bytes, 420 media blocks.
x xlsmp.aix50.rte.01.06.0000.0002.bff, 219136 bytes, 428 media blocks.
x xlsmp.msg.EN_US.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.EN_US.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.JA_JP.rte.01.06.0000.0000.bff, 7168 bytes, 14 media blocks.
x xlsmp.msg.JA_JP.rte.01.06.0000.0002.bff, 8192 bytes, 16 media blocks.
x xlsmp.msg.Ja_JP.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.Ja_JP.rte.01.06.0000.0002.bff, 7168 bytes, 14 media blocks.
x xlsmp.msg.ZH_CN.rte.01.06.0000.0000.bff, 5632 bytes, 11 media blocks.
x xlsmp.msg.ZH_CN.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.Zh_CN.rte.01.06.0000.0000.bff, 5120 bytes, 10 media blocks.
x xlsmp.msg.Zh_CN.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.en_US.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.en_US.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.ja_JP.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.ja_JP.rte.01.06.0000.0002.bff, 7168 bytes, 14 media blocks.
x xlsmp.msg.zh_CN.rte.01.06.0000.0000.bff, 5120 bytes, 10 media blocks.
x xlsmp.msg.zh_CN.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.rte.01.06.0000.0000.bff, 10752 bytes, 21 media blocks.
x xlsmp.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
# tar -xvf xlc.rte.aix50.aug2006a.ptf.tar
x xlC.aix50.rte.08.00.0000.0000.bff, 21315072 bytes, 41631 media blocks.
x xlC.aix50.rte.08.00.0000.0005.bff, 21453824 bytes, 41902 media blocks.
x xlC.msg.Ja_JP.rte.08.00.0000.0000.bff, 11776 bytes, 23 media blocks.
x xlC.msg.Ja_JP.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlC.msg.en_US.rte.08.00.0000.0000.bff, 10240 bytes, 20 media blocks.
x xlC.msg.en_US.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlC.msg.ja_JP.rte.08.00.0000.0000.bff, 11776 bytes, 23 media blocks.
x xlC.msg.ja_JP.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlC.rte.08.00.0000.0000.bff, 4022272 bytes, 7856 media blocks.
x xlC.rte.08.00.0000.0005.bff, 5120 bytes, 10 media blocks.
x xlsmp.aix50.rte.01.06.0000.0000.bff, 215040 bytes, 420 media blocks.
x xlsmp.aix50.rte.01.06.0000.0002.bff, 219136 bytes, 428 media blocks.
x xlsmp.msg.EN_US.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.EN_US.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.JA_JP.rte.01.06.0000.0000.bff, 7168 bytes, 14 media blocks.
x xlsmp.msg.JA_JP.rte.01.06.0000.0002.bff, 8192 bytes, 16 media blocks.
x xlsmp.msg.Ja_JP.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.Ja_JP.rte.01.06.0000.0002.bff, 7168 bytes, 14 media blocks.
x xlsmp.msg.ZH_CN.rte.01.06.0000.0000.bff, 5632 bytes, 11 media blocks.
x xlsmp.msg.ZH_CN.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.Zh_CN.rte.01.06.0000.0000.bff, 5120 bytes, 10 media blocks.
x xlsmp.msg.Zh_CN.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.en_US.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.en_US.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.msg.ja_JP.rte.01.06.0000.0000.bff, 6144 bytes, 12 media blocks.
x xlsmp.msg.ja_JP.rte.01.06.0000.0002.bff, 7168 bytes, 14 media blocks.
x xlsmp.msg.zh_CN.rte.01.06.0000.0000.bff, 5120 bytes, 10 media blocks.
x xlsmp.msg.zh_CN.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
x xlsmp.rte.01.06.0000.0000.bff, 10752 bytes, 21 media blocks.
x xlsmp.rte.01.06.0000.0002.bff, 4096 bytes, 8 media blocks.
升级fileset:
引用
# smitty install_latest
升级后结果显示:
引用
# lslpp -l |grep xlC
xlC.aix50.rte 8.0.0.5 COMMITTED C Set ++ Runtime for AIX 5.0
xlC.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.rte 8.0.0.5 COMMITTED C Set ++ Runtime
xlC.rte 8.0.0.5 COMMITTED C Set ++ Runtime
xlC.aix50.rte 8.0.0.5 COMMITTED C Set ++ Runtime for AIX 5.0
xlC.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.cpp 6.0.0.0 COMMITTED C for AIX Preprocessor
xlC.msg.en_US.rte 8.0.0.5 COMMITTED C Set ++ Runtime
xlC.rte 8.0.0.5 COMMITTED C Set ++ Runtime
重配CSS:
引用
# localconfig reset
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
mcsvr
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
mcsvr
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
其他过程不赘述
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 584BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 495Oracle管理云服务(OMC)的大数据平台,自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 5312019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 835某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1471性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 528从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 2145数据库的启动是一个相当复杂的过程。比如,Oracle在启动之前 ... -
怎么样彻底删除数据库?
2018-09-18 11:10 608Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 871LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1240“一朝被蛇咬,十年怕井绳”。在没被“蛇”咬之前,很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1137在DTCC 2018发表《如何落地智能化运维》演讲,主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 587问题一:ping不通问题 在虚拟机上安装好linux系统后, ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 952即日起,不定期更新《OracleDBA实战攻略》一书电子版,请 ... -
Oracle 12c新特性
2018-05-11 10:33 907查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3990操作系统:RHEL6.5 数据库版本:11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 70211g rac安装在二节点跑脚本一般会报此错误: 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 805故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2654由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1776数据库中的log file sync等待事件指的是,当user ...
相关推荐
AIX配置ASM AIX操作系统是一个基于UNIX的操作系统,由IBM开发和维护。ASM(Automated Storage Management)是Oracle数据库管理系统中的一种自动存储管理机制,用于管理数据库的存储空间。 在AIX平台上配置ASM需要...
AIX_配置ASM[文].pdf
本次安装为AIX6.1平台上使用ORACLE GRID+ASM方式安装ORACLE11gR2 RAC,升级至目前最新补丁11.2.0.3并且创建数据库。本文档主要记录软件安装、数据库创建、补丁升级、数据库实例参数配置的情况。
### AIX6.1 + RAC 11.2.0.1 + ASM 安装指南及要点 #### 一、环境描述 本章节详细介绍了用于安装 Oracle Real Application Clusters (RAC) 11.2.0.1 与 Oracle Automatic Storage Management (ASM) 的环境需求。 #...
总结来说,Oracle 11gR2 RAC和ASM在AIX 6.1上的部署是一项复杂的任务,涉及到多个层面的规划和配置。这份安装指导手册将帮助你理解整个流程,避免常见错误,确保在AIX环境中构建出高可用、高性能的Oracle数据库环境...
综上所述,Oracle 11g 在 AIX 环境下的部署涉及到多个层面的技术细节,包括 Grid Infrastructure 的安装、数据库的安装与配置、ASM 的管理以及集群和备份恢复策略的规划等。通过对这些关键步骤的详细了解和实践,...
### ORACLE 数据库从AIX裸设备到ASM存储的迁移过程 #### 概述 本文主要介绍了Oracle数据库从AIX裸设备迁移到ASM(自动存储管理)存储的过程。这一迁移通常涉及从传统的直接连接存储(DAS)或网络附加存储(NAS)等裸设备...
总结来说,本手册详细阐述了在AIX6.1上安装Oracle RAC 11GR2和ASM的环境准备、网络配置、存储规划及软件安装等关键步骤,是初学者和现场实施工程师的重要参考资料。通过遵循这些指南,可以确保RAC集群的稳定性和高...
Oracle 11gR2 RAC (Real Application Clusters) 和 ASM (Automatic Storage Management) 是在AIX-6.1操作系统上部署企业级数据库环境的关键组件。本安装指南将涵盖预安装检查、规划以及安装过程中的重要步骤。 1. ...
在部署AIX6.1 + Oracle 10g RAC + ASM环境之前,确保硬件配置符合最低要求是非常重要的。这包括检查处理器类型、内存大小、存储设备以及网络配置等。 - **处理器要求**:AIX6.1支持多处理器系统,并且Oracle 10g ...
总的来说,AIX6.1上的Oracle 11gR2安装需要考虑多个层面,包括硬件配置、操作系统补丁、网络设置、存储规划以及安装流程。通过精心规划和执行,可以构建出一个高效、可靠的Oracle数据库集群环境。
配置Oracle ASM通常涉及多个步骤,包括准备存储设备、配置ASM实例和启动数据库。在udev环境下,重点是确保ASM识别的设备文件与预期一致。这可能涉及到在ASM初始化时指定使用udev固定的设备名。 6. 检查ASM磁盘使用...
在IBM AIX操作系统上配置Oracle RAC,可以确保数据的持续可用性,即使单个服务器出现故障,也能保持业务连续性。以下是基于AIX 6.1进行Oracle 11gR2 RAC安装配置的详细步骤和关键知识点: 1. **系统规划**: - **...
随后,我们通过扩展RDBMS与ASM软件、更新监听器配置以及运行DBCA工具来完成新节点的集成。最后,通过验证集群的整体健康状况来确保一切正常。这些步骤有助于确保新节点顺利融入集群,同时最小化对现有服务的影响。
《AIX6.1+RAC 11.2.0.1+ASM安装手册》是针对Oracle数据库在AIX操作系统上实现高可用性集群(RAC)的详细指南,适用于11g R2版本。AIX(Advanced Interactive eXecutive)是由IBM开发的一种强大的UNIX操作系统,尤其...
LSSCLUSTER是AIX的基本集群框架,它提供了一个命令行界面来管理集群配置。而HACMP是AIX上的高级集群管理软件,它扩展了LSSCLUSTER的功能,包括更复杂的故障切换策略和资源组管理。 2. **HA脚本**: 在AIX HA环境...
- 配置ASM磁盘组,用于存储数据库文件。 5. **创建数据库** - 安装后的数据库创建步骤。 6. **补丁安装** - 升级OPATCH工具,它是Oracle补丁管理的工具。 - 配置OCM(Oracle Configuration Manager),用于...