oracle rac for aix 6安装

安装Oracle 10.2.0.5 RA C for A IX6（一）

上一篇/ 下一篇 2011-07-13 23:56:05 / 个人分类：ORACLE

查看( 114 ) / 评论( 0 ) / 评分( 0 / 0 )

简单介绍在AIX6上安装10.2.0.5 RAC的过程。

这一篇描述环境准备工作。

首先检查两个节点的硬件情况：

# /usr/sbin/lsattr -E -l sys0 -a realmem

realmem 65011712 Amount of usable physical memory in Kbytes False

# /usr/sbin/lsps -a

Page Space Physical Volume Volume Group Size %Used Active Auto Type Chksum hd6 hdisk0 rootvg 65536MB 1 yes yes lv 0

# df -k /tmp

Filesystem 1024-blocks Free %Used Iused %Iused Mounted on

/dev/hd3 20971520 20925388 1% 119 1% /tmp

# df -k

Filesystem 1024-blocks Free %Used Iused %Iused Mounted on

/dev/hd4 20971520 20687728 2% 11471 1% /

/dev/hd2 10485760 6753980 36% 53586 4% /usr

/dev/hd9var 52428800 52087248 1% 8409 1% /var

/dev/hd3 20971520 20925388 1% 119 1% /tmp

/dev/hd1 52428800 52420452 1% 5 1% /home

/dev/hd11admin 524288 523848 1% 5 1% /admin

/proc - - - - - /proc

/dev/hd10opt 20971520 19815436 6% 17796 1% /opt

/dev/livedump 524288 523880 1% 4 1% /var/adm/ras/livedump

/dev/odm 0 0 -1% 6 100% /dev/odm

/dev/vx/dsk/ywdbdg/ywdbdg_vol_01 523239424 518611224 1% 5 1% /ywdb01

/dev/vx/dsk/ywdbdg/ywdbdg_vol_02 523239424 518611224 1% 4 1% /ywdb02

/dev/vx/dsk/ywdbdg/ywdbdg_vol_03 523239424 518611224 1% 4 1% /ywdb03

/dev/vx/dsk/ywdbdg/ywdbdg_vol_04 523239424 518611224 1% 4 1% /ywdb04

/dev/vx/dsk/ywdbdg/ywdbdg_vol_05 629145600 623686784 1% 4 1% /ywdb05

# /usr/bin/getconf HARDWARE_BITMODE

64

然后检查两个节点上系统软件版本和包的安装情况：

# oslevel -r

6100-06

# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools rsct.basic.rte

Fileset Level State Description

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

Path: /usr/lib/objrepos

bos.adt.base 6.1.6.0 COMMITTED Base Application Development

Toolkit

bos.adt.lib 6.1.2.0 COMMITTED Base Application Development

Libraries

bos.adt.libm 6.1.6.0 COMMITTED Base Application Development

Math Library

bos.perf.libperfstat 6.1.6.0 COMMITTED Performance Statistics Library

Interface

bos.perf.perfstat 6.1.6.0 COMMITTED Performance Statistics Interface

bos.perf.proctools 6.1.6.0 COMMITTED Proc Filesystem Tools

rsct.basic.rte 3.1.0.0 COMMITTED RSCT Basic Function

Path: /etc/objrepos

bos.adt.base 6.1.6.0 COMMITTED Base Application Development

Toolkit

bos.perf.libperfstat 6.1.6.0 COMMITTED Performance Statistics Library

Interface

bos.perf.perfstat 6.1.6.0 COMMITTED Performance Statistics

Interface

rsct.basic.rte 3.1.0.0 COMMITTED RSCT Basic Function

下面在节点1上创建oinstall和dba组，然后利用smit security建立oracle用户：

# /bin/mkgroup oinstall

# /bin/mkgroup dba

# smit security

在建立oracle用户时指定oinstall和dba组选项。在Primary GROUP处输入oinstall，在Group SET处输入dba。

# id oracle

uid=203(oracle) gid=202(oinstall) groups=203(dba)

# passwd oracle

Changing password for "oracle"

oracle's New password:

Enter the new password again:

# id nobody

uid=4294967294(nobody) gid=4294967294(nobody)

确认oracle用户组选项正确，修改oracle密码，并确认nobody用户存在。

修改oracle用户的.profile文件，添加下面的内容：

ORACLE_SID=ywdb1

export ORACLE_SID

ORACLE_BASE=/opt/oracle

export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/10.2/database

export ORACLE_HOME

ORA_CRS_HOME=$ORACLE_BASE/product/10.2/crs

export ORA_CRS_HOME

PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH

export PATH

DISPLAY=10.142.195.119:0.0

export DISPLAY

设置oracle用户和root用户的属性：

# smit chuser

将Soft FILE size、Soft CPU time、Soft DATA segment和Soft STACK size 都设置为没有限制，也就是-1。

# smit chgsys

设置系统参数，将Maximum number of PROCESSES allowed per user参数的值设置超过2048。

# /usr/sbin/no -a | more

# /usr/sbin/lsattr -E -l sys0 -a pre520tune

pre520tune disable Pre-520 tuning compatibility mode True

# /usr/sbin/no -o udp_sendspace=65536

Setting udp_sendspace to 65536

Change to tunable udp_sendspace, will only be effective for future connections

# /usr/sbin/no -o udp_recvspace=655360

Setting udp_recvspace to 655360

Change to tunable udp_recvspace, will only be effective for future connections

# /usr/sbin/no -o tcp_sendspace=65536

Setting tcp_sendspace to 65536

Change to tunable tcp_sendspace, will only be effective for future connections

# /usr/sbin/no -o tcp_recvspace=65536

Setting tcp_recvspace to 65536

Change to tunable tcp_recvspace, will only be effective for future connections

# /usr/sbin/no -o rfc1323=1

Setting rfc1323 to 1

Change to tunable rfc1323, will only be effective for future connections

# /usr/sbin/no -o sb_max=1310720

Setting sb_max to 1310720

# /usr/sbin/no -r -o ipqmaxlen=512

Setting ipqmaxlen to 512 in nextboot file

Warning: changes will take effect only at next reboot

通过no –a，检查系统网络参数配置，其中udp和tcp参数设置应和上面修改的配置保持一致，rfc1323、sb_max以及ipqmaxlen也同样仿照上面的例子进行设置。

在/etc/dd739ddda58da0116c174966中添加下面的内容：

if [ -f /usr/sbin/no ] ; then

/usr/sbin/no -o udp_sendspace=65536

/usr/sbin/no -o udp_recvspace=655360

/usr/sbin/no -o tcp_sendspace=65536

/usr/sbin/no -o tcp_recvspace=65536

/usr/sbin/no -o rfc1323=1

/usr/sbin/no -o sb_max=1310720

/usr/sbin/no -r -o ipqmaxlen=512

fi

检查主机名称、IP地址信息：

# hostname

ywdb1

# ifconfig -a

en0:

flags=5e080863,c0

inet 10.142.195.5 netmask 0xffffff00 broadcast 10.142.195.255

tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0

en12:

flags=5e080863,c0

inet 192.168.195.1 netmask 0xffffff00 broadcast 192.168.195.255

tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0

lo0:

flags=e08084b,c0

inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255

inet6 ::1%1/0

tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1

下面设置两个节点的/etc/hosts文件：

10.142.195.5 ywdb1

10.142.195.6 ywdb2

10.142.195.1 ywdb1-vip

10.142.195.2 ywdb2-vip

192.168.195.1 ywdb1-priv

192.168.195.2 ywdb2-priv

在两个节点的oracle目录下，建立.rhosts文件，添加下列内容：

ywdb1

ywdb2

ywdb1-vip

ywdb2-vip

ywdb1-priv

ywdb2-priv

最后创建cluster和db安装对应的目录，安装准备工作完成。

安装Oracle 10.2.0.5 RA C for A IX6（二）

上一篇/ 下一篇 2011-07-14 23:45:27 / 个人分类：ORACLE

查看( 114 ) / 评论( 1 ) / 评分( 5 / 0 )

简单介绍在AIX6上安装10.2.0.5 RAC的过程。

这一篇描述CLUSTER的建立。

安装Oracle 10.2.0.5 RAC for AIX6（一）：

dd739ddda58da0116c174966/post/468/520680

上一篇进行了安装的准备工作，下面开始安装CLUSTER，首先需要执行rootpre.sh：

# cd /home/oracle/software/clusterware/Disk1/

# cd install

# cd rootpre

# ./rootpre.sh

./rootpre.sh output will be logged in /tmp/rootpre.out_11-04-15.00:09:02

Saving the original files in /etc/ora_save_11-04-15.00:09:02....

Copying new kernel extension to /etc....

Loading the kernel extension from /etc

Oracle Kernel Extension Loader for AIX

Copyright (c) 1998,1999 Oracle Corporation

Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x512c3000

Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x512c3000

The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Configuring POSIX Asynchronous I/O....

Posix Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Checking if group services should be configured....

Nothing to configure.

下面运行runInstaller，开始CLUSTER的安装，这个过长和其他平台下的CLUSTER安装没有区别，这里就不详细描述了，基本上图形界面上的说明已经可以帮助顺利完成CLUSTER的安装。

安装完成后，两个节点分别运行orainstRoot.sh：

# /opt/oracle/oraInventory/orainstRoot.sh

Changing permissions of /opt/oracle/oraInventory to 775.

Changing groupname of /opt/oracle/oraInventory to oinstall.

The execution of the script. is complete

在节点1上运行root.sh：

# /opt/oracle/product/10.2/crs/root.sh

WARNING: directory '/opt/oracle/product/10.2' is not owned by root

WARNING: directory '/opt/oracle/product' is not owned by root WARNING: directory '/opt/oracle' is not owned by root

Checking to see if Oracle CRS stack is already configured

/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory

Setting up NS directories

Oracle Cluster Registry configuration upgraded successfully WARNING: directory '/opt/oracle/product/10.2' is not owned by root WARNING: directory '/opt/oracle/product' is not owned by root WARNING: directory '/opt/oracle' is not owned by root

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node : node 1: ywdb1 ywdb1-priv ywdb1

node 2: ywdb2 ywdb2-priv ywdb2

Creating OCR keys for user 'root', privgrp 'system'..

Operation successful.

Now formatting voting device: /ywdb01/rac/vot

Now formatting voting device: /ywdb01/rac/vot1

Now formatting voting device: /ywdb02/rac/vot2

Format of 3 voting devices complete.

Startup will be queued to init within 30 seconds.

Adding daemons to inittab

Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

ywdb1

CSS is inactive on these nodes.

ywdb2

Local node checking complete.

Run root.sh on remaining nodes to start CRS daemons.

在节点2上运行root.sh：

# /opt/oracle/product/10.2/crs/root.sh

WARNING: directory '/opt/oracle/product/10.2' is not owned by root WARNING: directory '/opt/oracle/product' is not owned by root WARNING: directory '/opt/oracle' is not owned by root

Checking to see if Oracle CRS stack is already configured

/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory

Setting up NS directories

Oracle Cluster Registry configuration upgraded successfully WARNING: directory '/opt/oracle/product/10.2' is not owned by root WARNING: directory '/opt/oracle/product' is not owned by root WARNING: directory '/opt/oracle' is not owned by root

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node : node 1: ywdb1 ywdb1-priv ywdb1

node 2: ywdb2 ywdb2-priv ywdb2

clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.

-force is destructive and will destroy any previous cluster configuration.

Oracle Cluster Registry for cluster has already been initialized Startup will be queued to init within 30 seconds.

Adding daemons to inittab

Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

ywdb1

ywdb2

CSS is active on all nodes.

Waiting for the Oracle CRSD and EVMD to start

Oracle CRS stack installed and running under init(1M)

Running vipca(silent) for configuring nodeapps

The given interface(s), "en0" is not public. Public interfaces should be used to configure virtual IPs.

这个错误以前碰到过多次了，Oracle将PUBLIC的interface认为是private 的，导致无法配置vip。通过手工启动vipca图形界面来进行配置vip，这个过程就不再重复了。Vip配置成功后，CLUSTER环境的安装顺利完成。

./rootpre.sh output will be logged in /tmp/rootpre.out_11-04-15.00:30:55

Saving the original files in /etc/ora_save_11-04-15.00:30:55....

Copying new kernel extension to /etc....

Loading the kernel extension from /etc

Oracle Kernel Extension Loader for AIX

Copyright (c) 1998,1999 Oracle Corporation

Kernel Extension /etc/pw-syscall.64bit_kernel already loaded, unloading it

Unconfigured the kernel extension successfully

Unloaded the kernel extension successfully

Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x5133c000

Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x5133c000

The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Configuring POSIX Asynchronous I/O....

Posix Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Checking if group services should be configured....

Nothing to configure.

随后可以在图形化界面上执行runInstaller开始数据库的安装：

首先进入的是配置安装更新界面：这里可以输入email地址和metalink口令，以便于更方便的接收安全更新和获取在线诊断功能。

安装配置：这里选择仅安装数据库软件，稍后通过dbca来创建数据库；

网格选项：如果cluster配置成功，这里可以选择Real Application Clusters数据库安装，否则这个选项无法选择。如果有部分节点没有被选择，需要手工将节点选中；

产品语言：添加简体中文；

数据库版本：选择企业版，如果有需要可以通过选择选项来选择安装的选件；

安装位置：Oracle基目录为/data/oracle，软件位置为

/data/oracle/product/11.2；

操作系统组：这里默认就是dba和oinstall，不用进行额外设置；

先决条件检查：Oracle会检查安装数据库的条件是否全部满足，对于检查出来不满足的条件可以根据建议进行改正，有的时候Oracle的一些检查项并不正常，比如交互空间等，对于这些可以选择忽略而直接开始安装；

执行完安装，需要再节点1和节点2上分别执行root.sh：

# /opt/oracle/product/10.2/database/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /opt/oracle/product/10.2/database

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Creating /usr/local/bin directory...

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

数据库软件的安装完成。

安装Oracle 10.2.0.5 RA C for A IX6（四）

上一篇/ 下一篇 2011-07-16 23:49:53 / 个人分类：ORACLE

查看( 117 ) / 评论( 0 ) / 评分( 0 / 0 )

简单介绍在AIX6上安装10.2.0.5 RAC的过程。

这一篇描述补丁的安装过程。

安装Oracle 10.2.0.5 RAC for AIX6（一）：

dd739ddda58da0116c174966/post/468/520680安装Oracle 10.2.0.5 RAC for AIX6（二）：

dd739ddda58da0116c174966/post/468/520729安装Oracle 10.2.0.5 RAC for AIX6（三）：

dd739ddda58da0116c174966/post/468/520795

上一篇安装了数据库的软件，下面介绍补丁的安装过程：

# /etc/init.crs stop

Shutting down Oracle Cluster Ready Services (CRS):

Apr 15 01:20:43.345 | INF | daemon shutting down

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

# ps -ef|grep ora

oracle 4522000 5701638 0 01:21:28 pts/6 0:00 /bin/sh ./runInstaller oracle 4784190 2294188 0 00:32:32 pts/7 0:00 -ksh

oracle 5701638 6357160 0 00:05:41 pts/6 0:00 -ksh

oracle 6029528 4981112 0 23:04:37 - 1:53 sshd: oracle@pts/2,pts/3

oracle 6553750 6553984 0 22:58:35 pts/0 0:00 -ksh

root 4981112 4588000 0 23:04:28 - 0:00 sshd: oracle [priv]

oracle 6619514 9109590 0 00:32:51 pts/1 0:00 -ksh

oracle 6750712 6029528 0 23:17:24 pts/3 0:00 -ksh

oracle 6816182 6029528 0 23:04:37 pts/2 0:00 -ksh

oracle 7012660 4784190 0 00:33:32 pts/7 0:00 more rootpre.sh

root 7274796 6291674 0 01:21:38 pts/0 0:00 grep ora

关闭两个节点上的CLUSTER，在补丁的安装之前，仍然需要运行rootpre.sh：

# cd /home/oracle/software/database/Disk1/rootpre

# ./rootpre.sh

./rootpre.sh output will be logged in /tmp/rootpre.out_11-04-15.01:22:22

Saving the original files in /etc/ora_save_11-04-15.01:22:22....

Copying new kernel extension to /etc....

Loading the kernel extension from /etc

Oracle Kernel Extension Loader for AIX

Copyright (c) 1998,1999 Oracle Corporation

Kernel Extension /etc/pw-syscall.64bit_kernel already loaded, unloading it

Unconfigured the kernel extension successfully

Unloaded the kernel extension successfully

Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x513b5000

Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x513b5000

The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Configuring POSIX Asynchronous I/O....

Posix Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Checking if group services should be configured....

Nothing to configure.

下面图形化运行runInstaller命令，开始补丁的安装过程，需要注意的是，首先应该对CLUSTER环境进行生效，然后对数据库软件升级。

# /opt/oracle/product/10.2/crs/install/root102.sh

Error : Please change the CRS_ORACLE_USER id to have the following OS capabilities : < CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH >

by running command then 'crsctl stop crs' and 'crsctl start crs'.

The CSS daemon, ocssd.bin, will not run in realtime without this change

Oracle strongly recommends that the CSS daemon run realtime

Creating pre-patch directory for saving pre-patch clusterware files

Completed patching clusterware files to /opt/oracle/product/10.2/crs

Relinking some shared libraries.

Relinking of patched files is complete.

Copying opriproc to /etc/oracle/bin for AIX

WARNING: directory '/opt/oracle/product/10.2' is not owned by root

WARNING: directory '/opt/oracle/product' is not owned by root

WARNING: directory '/opt/oracle' is not owned by root

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

Starting up the CRS daemons.

Adding daemons to inittab

Waiting for the patched CRS daemons to start.

This may take a while on some systems.

.

10205 patch successfully applied.

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully deleted 1 values from OCR.

Successfully deleted 1 keys from OCR.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node :

node 1: ywdb1 ywdb1-priv ywdb1

Creating OCR keys for user 'root', privgrp 'system'..

Operation successful.

clscfg -upgrade completed successfully

Creating '/opt/oracle/product/10.2/crs/install/paramfile.crs' with data used for CRS configuration

Setting CRS configuration values in /opt/oracle/product/10.2/crs/install/paramfile.crs

节点2上的root102.sh的运行结果基本和节点1上的一致，就不重复了。

在对数据库软件升级之前，rootpre.sh脚本仍然需要运行，这里就不重复记录了。

# /opt/oracle/product/10.2/database/root.sh

Running Oracle 10g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /opt/oracle/product/10.2/database

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y

Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y

Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y

Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

两个节点分别运行root.sh后，10205补丁集安装完成。

整个安装的最后过程，通过dbca进行手工建库即可，这和其他平台的RAC 安装没有什么区别，就不重复描述了。

图形工具来解决这个问题，整个安装过程几乎没有碰到其他任何问题。而这个IP地址的问题由来已久，在我第一次安装RAC的时候就曾经碰到过，而且在以往的安装过程中，由于PUBLIC_IP的设置，碰到这个问题的可能性反而比这个问题不出现的可能性还大。

不过在RAC环境完全安装成功后，利用srvctl尝试重启CLUSTER时，碰到了错误：

$ srvctl start db -d ywdb

PRKP-1001 : Error starting instance ywdb1 on node ywdb1

CRS-0215: Could not start resource 'ora.ywdb.ywdb1.inst'.

PRKP-1001 : Error starting instance ywdb2 on node ywdb2

CRS-0215: Could not start resource 'ora.ywdb.ywdb2.inst'.

检查alert告警文件：

$ tail -100 /opt/oracle/admin/ywdb/bdump/alert_ywdb1.log

DIAG started with pid=3, OS id=13304120

PSP0 started with pid=4, OS id=11337892

LMON started with pid=5, OS id=14549180

LMD0 started with pid=6, OS id=3408122

LMS0 started with pid=7, OS id=12452102

LMS1 started with pid=8, OS id=11534814

MMAN started with pid=9, OS id=15859942

DBW0 started with pid=10, OS id=11403748

LGWR started with pid=11, OS id=13828208

CKPT started with pid=12, OS id=12779546

SMON started with pid=13, OS id=14680228

RECO started with pid=14, OS id=12321000

CJQ0 started with pid=15, OS id=13172782

MMON started with pid=16, OS id=9437552

Fri Apr 15 03:39:58 CDT 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=17, OS id=11403418

Fri Apr 15 03:39:58 CDT 2011

starting up 1 shared server(s) ...

Fri Apr 15 03:40:09 CDT 2011

lmon registered with NM - instance id 1 (internal mem no 0) Fri Apr 15 03:40:09 CDT 2011

Reconfiguration started (old inc 0, new inc 4)

List of nodes:

0 1

Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

Communication channels reestablished

Master broadcasted resource hash value bitmaps

Non-local Process blocks cleaned out

Fri Apr 15 03:40:09 CDT 2011

LMS 1: 0 GCS shadows cancelled, 0 closed

Fri Apr 15 03:40:09 CDT 2011

LMS 0: 0 GCS shadows cancelled, 0 closed

Set master node info

Submitted all remote-enqueue requests

Dwn-cvts replayed, VALBLKs dubious

All grantable enqueues granted

Post SMON to start 1st pass IR

Fri Apr 15 03:40:09 CDT 2011

LMS 1: 0 GCS shadows traversed, 0 replayed

Fri Apr 15 03:40:09 CDT 2011

LMS 0: 0 GCS shadows traversed, 0 replayed

Fri Apr 15 03:40:09 CDT 2011

Submitted all GCS remote-cache requests

Fix write in gcs resources

Reconfiguration complete

LCK0 started with pid=20, OS id=10616844

Fri Apr 15 03:40:10 CDT 2011

ALTER DATABASE MOUNT

Fri Apr 15 03:40:19 CDT 2011

Setting recovery target incarnation to 1

Fri Apr 15 03:40:19 CDT 2011

Successful mount of redo thread 1, with mount id 2807738276

Fri Apr 15 03:40:19 CDT 2011

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)

Completed: ALTER DATABASE MOUNT

Fri Apr 15 03:40:20 CDT 2011

ALTER DATABASE OPEN

This instance was first to open

Fri Apr 15 03:40:20 CDT 2011

Errors in file /opt/oracle/admin/ywdb/bdump/ywdb1_dbw0_11403748.trc: ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/ywdb01/oradata/ywdb/system01.dbf'

ORA-27092: size of file exceeds file size limit of the process Additional information: 131071

Additional information: 262145

Fri Apr 15 03:40:20 CDT 2011

Errors in file /opt/oracle/admin/ywdb/bdump/ywdb1_dbw0_11403748.trc: ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: '/ywdb01/oradata/ywdb/undotbs01.dbf'

ORA-27092: size of file exceeds file size limit of the process Additional information: 131071

Additional information: 1048577

Fri Apr 15 03:40:20 CDT 2011

Errors in file /opt/oracle/admin/ywdb/bdump/ywdb1_dbw0_11403748.trc: ORA-01157: cannot identify/lock data file 3 - see DBWR trace file ORA-01110: data file 3: '/ywdb01/oradata/ywdb/sysaux01.dbf'

ORA-27092: size of file exceeds file size limit of the process Additional information: 131071

Additional information: 524289

本文来源：https://www.bwwdw.com/article/psqq.html