Blogger被墙，访问不太方便，转移到 http://blog.chinaunix.net/uid/28887495.html

Blogger被墙，访问不太方便，转移到 http://blog.chinaunix.net/uid/28887495.html

Power P615升级系统微码

Power P615升级系统微码

首先查看现在的版本

# lsmcode -A

sys0!system:3F040127       |System Firmware:RG031218_d73e02_regatta

ent0!1410ff01.SCU015

sisscsia0!44415255.050A008a

ent1!14106902.GOL002

cd0!IBM-DROM00205.NR38

hdisk0!IC35L03.44543031.53323846

hdisk1!ST37330.53313233.4335304A

#

# lscfg -vp |grep -p Platform

      Platform Firmware:

        ROM Level.(alterable).......3F040127      

        Version.....................RS6K

        Hardware Location Code......U0.1-P1-X1/Y1

      Physical Location: U0.1-P1-X1/Y1

#

可以看到是3F040127的，安装AIX7对应7029-6c3要求firmware最低版本是3F040129，下载相应的版本，7029-6C3对应的最新版是3F080425，下载rpm格式。ftp上传到主机上。

链接

http://www14.software.ibm.com/webapp/set2/firmware/lgjsn?mode=5

# pwd

/

# cd /tmp

#

#

#

# mkdir fwupdate

#

## cd sys

#

#

# ls

3F080425.rpm

#

#

# ls -l

total 8304

-rw-r-----    1 root     system      4250280 Mar 31 15:47 3F080425.rpm

#

# mv * ../fwupdate

# pwd

/tmp/sys

# cd ../fwupdate

# ls -l

total 8304

-rw-r-----    1 root     system      4250280 Mar 31 15:47 3F080425.rpm

#

# rpm -qa

cdrecord-1.9-7

mkisofs-1.13-4

AIX-rpm-6.1.2.0-1

#

#

# rpm -ivh --ignoreos 3F080425.rpm

3F080425                    ##################################################

Verifying checksums for /tmp/fwupdate/3F080425.img against /tmp/fwupdate/3F080425.chksum

Checksum file /tmp/fwupdate/3F080425.chksum: checksum=11741  blocks=4715

Image file /tmp/fwupdate/3F080425.img: checksum=11741  blocks=4715

The checksums and block sizes match!

#

#

下载回来同时会有个readme文件，好的习惯是先读一遍readme。按要求验证一下文件大小。

# pwd

/tmp/fwupdate

#

# ls -l

total 17752

-rw-r--r--    1 root     system           82 Apr 25 2008  3F080425.chksum

-rw-rw-r--    1 root     system      4828143 Apr 25 2008  3F080425.img

-rw-r-----    1 root     system      4250280 Mar 31 15:47 3F080425.rpm

-rwxr-x---    1 root     system         2432 Feb 19 2003  checksum.pl

#

# sum 3F080425.img

11741  4715 3F080425.img

没有问题，下边开始升级微码。

# cd /usr/lpp/diagnostics/bin

# pwd

/usr/lpp/diagnostics/bin

#

# ./update_flash -f /tmp/fwupdate/3F080425.img

***** WARNING: Continuing will reboot the system! *****

Do you wish to continue?

Enter 1=Yes or 2=No

1

SHUTDOWN PROGRAM

Sat Mar 31 16:05:35 CDT 2012

Wait for 'Rebooting...' before stopping.

Error reporting has stopped.

系统会重启，前面板液晶屏会显示99FF和99FD,一定不要断电，否则。。。。。你懂的

等待大概10几分钟以后，机器会重启。重启以后验证升级以后的系统firmware。

可以看到微码已经从3F040127升级到了3F080425.。。。。。。

# lsmcode -A

sys0!system:3F080425       |System Firmware:RG080425_d79e22_regatta

ent0!1410ff01.SCU015

sisscsia0!44415255.050A008a

ent1!14106902.GOL002

cd0!IBM-DROM00205.NR38

hdisk0!IC35L03.44543031.53323846

hdisk1!ST37330.53313233.4335304A

#

#  lscfg -vp |grep -p Platform

      Platform Firmware:

        ROM Level.(alterable).......3F080425      

        Version.....................RS6K

        Hardware Location Code......U0.1-P1-X1/Y1

      Physical Location: U0.1-P1-X1/Y1

#

修改引导顺序，继续测试AIX7.。。。。。。

#

# bootlist -m normal -o

hdisk0 blv=hd5

# bootlist -m normal cd0 hdisk0

# bootlist -m normal -o

cd0

hdisk0 blv=hd5

#

Power P615升级光驱微码

项目需要，得在一台P615上安装AIX 7.1，下载ISO文件刻录以后，发现装的时候要么出现各种拷贝错误，要么不能引导。。。。。。（光驱是没有问题的，用aix 6.1母盘安装aix6.1正常，但是记得用刻录的aix6.1光盘安装也是各种错误），怀疑光驱微码偏低。于是升级一下吧。

首先查看现在的版本

# lsdev -Cc cdrom

cd0 Available 1G-19-00 IDE DVD-ROM Drive

#

# lscfg -vl cd0

  cd0              U0.1-P1-X1/Q6-A0  IDE DVD-ROM Drive

        Manufacturer................IBM    

        Machine Type and Model......DROM00205      

        ROS Level and ID............NR36

        Device Specific.(Z0)........058002028F000010

#

可以看到是NR36，去ibm网站下载相应的微码文件。

http://www14.software.ibm.com/webapp/set2/firmware/lgjsn?mode=5

过程省略，7029-6C3对应的最新版是NR38，下载回来是rpm格式。ftp上传到主机上。下边开始升级微码，

看过程不说话。。。。。。

# pwd

/tmp/microcode/RPM

# ls -l

total 232

-rw-r-----    1 root     system       118035 Mar 30 13:43 dvdrom.slimide.NR38.rpm

# rpm -qa

cdrecord-1.9-7

mkisofs-1.13-4

AIX-rpm-6.1.2.0-1

#

# rpm -ihv --ingoreos  dvdrom.slimide.NR38.rpm

--ingoreos: unknown option

# rpm -ivh --ignoreos dvdrom.slimide.NR38.rpm

dvdrom.slimide.NR38         ##################################################

#

# rpm -qa

cdrecord-1.9-7

mkisofs-1.13-4

AIX-rpm-6.1.2.0-1

dvdrom.slimide.NR38-001-001

#

# rpm -ql dvdrom.slimide.NR38-001-001

/usr/lib/microcode/IBM-DROM00205.NR38

#

#

# ls -l /etc/microcode

lrwxrwxrwx 1 root system 18 Mar 30 09:43 /etc/microcode -> /usr/lib/microcode

#

#

# cd /etc/micro*

# pwd

/etc/microcode

#

#

下载回来同时会有个readme文件，好的习惯是先读一遍readme。按要求验证一下文件大小。

# ls -l

total 13312

-r-xr-xr-x    1 bin      bin          133364 Nov 02 2004  IBM-DROM00205.NR38

-r--r--r--    1 root     system        20176 Jun 30 2007  cx_conc

-r--r--r--    1 root     system        20768 Jun 30 2007  cx_e_conc

-r--r--r--    1 root     system        28672 Oct 03 2007  cxpabios

-r--r--r--    1 root     system        36864 Oct 03 2007  cxpafep

-r-xr-xr-x    1 bin      bin           99995 Jun 30 2007  dgr0871014d.00.00

-r-xr-xr-x    1 bin      bin          197089 Aug 23 2007  dgr0b91014d.00.00

-r-xr-xr-x    1 bin      bin          267973 Aug 23 2007  dgr0c91014d.00.00

-r-xr-xr-x    1 bin      bin          316207 Jun 30 2007  dgr0d31014d.00.00

-r-xr-xr-x    1 bin      bin           99095 Jun 30 2007  dgr0f81014d.00.00

-r--r--r--    1 bin      bin           74920 Aug 23 2007  ec8fd.00.03

-r--r--r--    1 root     system      1296532 Oct 03 2007  ibmsis2780.img

-r--r--r--    1 root     system       894684 Jun 30 2007  ibmsis5702.img

-r--r--r--    1 root     system      1254980 Jun 30 2007  ibmsis5703.img

-r--r--r--    1 root     system      1254980 Jun 30 2007  ibmsis5709.img

-r--r--r--    1 root     system       888368 Jun 30 2007  ibmsis570B.img

-r--r--r--    1 root     system        41472 Jun 30 2007  sxbios

-r--r--r--    1 root     system        31232 Jun 30 2007  sxfep

#

# sum IBM-DROM00205.NR38

40166   131 IBM-DROM00205.NR38

#

没有问题，下边开始升级微码。

# diag

DIAGNOSTIC OPERATING INSTRUCTIONS  VERSION 6.1.2.1                                                   801001

LICENSED MATERIAL and LICENSED INTERNAL CODE - PROPERTY OF IBM

(C) COPYRIGHTS BY IBM AND BY OTHERS 1982, 2008.

ALL RIGHTS RESERVED.

These programs contain diagnostics, service aids, and tasks for

the system.  These procedures should be used whenever problems

with the system occur which have not been corrected by any

software application procedures available.

In general, the procedures will run automatically.  However,

sometimes you will be required to select options, inform the

system when to continue, and do simple tasks.

Several keys are used to control the procedures:

- The Enter key continues the procedure or performs an action.

- The Backspace key allows keying errors to be corrected.

- The cursor keys are used to select an option.

回车进入

Move cursor to selection, then press Enter.

  Diagnostic Routines

    This selection will test the machine hardware. Wrap plugs and

    other advanced functions will not be used.

  Advanced Diagnostics Routines

    This selection will test the machine hardware. Wrap plugs and

    other advanced functions will be used.

  Task Selection (Diagnostics, Advanced Diagnostics, Service Aids, etc.)

    This selection will list the tasks supported by these procedures.

    Once a task is selected, a resource menu may be presented showing

    all resources supported by the task.

  Resource Selection

    This selection will list the resources in the system that are supported

    by these procedures. Once a resource is selected, a task menu will

  

From the list below, select a task by moving the cursor to

the task and pressing 'Enter'.

To list the resources for the task highlighted, press 'List'.

[TOP]

  Run Diagnostics

  Run Error Log Analysis

  Run Exercisers

  Display or Change Diagnostic Run Time Options

  Add Resource to Resource List

  Automatic Error Log Analysis and Notification

  Backup and Restore Media

  Certify Media

  Change Hardware Vital Product Data

  Configure Reboot Policy

  Configure Remote Maintenance Policy

  Configure Ring Indicate Power On Policy

  Configure Scan Dump Policy

  Configure Surveillance Policy

  Create Customized Configuration Diskette

  Delete Resource from Resource List

  Disk Maintenance

  Display Configuration and Resource List

  Display Firmware Device Node Information

  Display Hardware Error Report

  Display Hardware Vital Product Data

  Display Multipath I/O (MPIO) Device Configuration

  Display Previous Diagnostic Results

  Display Resource Attributes

  Display Service Hints

  Display Software Product Data

  Display Test Patterns

  Display or Change Bootlist

  Format Media

  Gather System Information

  Hot Plug Task

  Identify and Attention Indicators

  Local Area Network Analyzer

  Log Repair Action

  Microcode Tasks

  Periodic Diagnostics

  RAID Array Manager

  Save or Restore Hardware Management Policies

  Update Disk Based Diagnostics

  Update System or Service Processor Flash

  Update Disk Based Diagnostics

  Save or Restore Hardware Management Policies

  RAID Array Manager

  Periodic Diagnostics

  Microcode Tasks

[MORE...12]

Move cursor to desired item and press Enter.

  Display Microcode Level

  Download Latest Available Microcode

  Download Microcode

  Download Microcode

From the list below, select any number of resources by moving

the cursor to the resource and pressing 'Enter'.

To cancel the selection, press 'Enter' again.

To list the supported tasks for the resource highlighted, press 'List'.

Once all selections have been made, press 'Commit'.

To avoid selecting a resource, press 'Previous Menu'.

  All Resources

      This selection will select all the resources currently displayed.

                                        (14106902)

  cd0              U0.1-P1-X1/Q6-A0     IDE DVD-ROM Drive

                                        (1410ff01)

  sisscsia0        U0.1-P1              PCI-X Dual Channel Ultra320 SCSI Adapter

  hdisk0           U0.1-P1/Z1-A5        16 Bit LVD SCSI Disk Drive (36400 MB)

F1=Help                   F4=List                    F7=Commit                  Esc+0=Exit

All Resources

      This selection will select all the resources currently displayed.

  ent1             U0.1-P1/E2           10/100/1000 Base-TX PCI-X Adapter

                                        (14106902)

回车选择，esc+7提交。

From the list below, select any number of resources by moving

the cursor to the resource and pressing 'Enter'.

To cancel the selection, press 'Enter' again.

To list the supported tasks for the resource highlighted, press 'List'.

Once all selections have been made, press 'Commit'.

To avoid selecting a resource, press 'Previous Menu'.

回车确认

Select the source of the microcode image.

Make selection, use Enter to continue.

  file system

      /etc/microcode

  optical media    (ISO 9660 file system format)

INSTALL MICROCODE 802116

cd0    IDE DVD-ROM Drive

若干分钟后提示:

Installation of the microcode has completed

successfully.  The current microcode for cd0

is IBM-DROM00205.NR38.

Please run diagnostics on the device to ensure that it is

functioning properly.

至此升级微码成功完成。

F3退出以后验证一下

# lscfg -vl cd0

  cd0              U0.1-P1-X1/Q6-A0  IDE DVD-ROM Drive

        Manufacturer................IBM    

        Machine Type and Model......DROM00205      

        ROS Level and ID............NR38

        Device Specific.(Z0)........058002028F000010

可以看到微码已经从NR36升级到了NR38.。。。。。。重启机器再次验证。。。。。。。

Oracle Linux 5.7上部署Oracle Enterprise Management Cloud 12C

1. 安装操作系统

使用kickstart静默安装，配置文件如下



# Kickstart file automatically generated by anaconda.

install
url --url ftp://10.101.5.100/pub/rhel5/iso/
lang en_US.UTF-8
keyboard us

#xconfig --startxonboot
network --device eth0 --bootproto static --ip 10.101.5.69 --netmask 255.255.248.0 --gateway 10.101.0.1 --nameserver 10.101.0.19 --ho
stname gridem
#rootpw --iscrypted $1$nPKdqyiD$KkCUPHAeWXhChoQxmjXiI/
rootpw  --iscrypted $6$1CpNtrhue9gKi6cB$Nb8PKValdv/tE9qmDEgLsW..jBLwHakcjWCbWi5v51yi/3/NeOR7XM2wUSJobmgOqlg9c/sVYvYd1FOiJBAuR1

firewall --disabled
firstboot --disable
authconfig --enableshadow --passalgo=sha512
selinux --disabled
timezone Asia/Shanghai
key --skip

bootloader --location=mbr --driveorder=sda --append="rhgb quiet"

clearpart --all --drives=sda
part swap --fstype swap --size=2048 --grow --maxsize=2048  --asprimary --ondisk=sda
part / --fstype ext3 --size=20480 --grow --maxsize=30960 --asprimary --ondisk=sda

reboot --eject
%packages
@admin-tools
@base
@chinese-support
@core
@dialup
@system-tools
@base-x
@X Window System
sgpio
libstdc++44-devel
python-dmidecode
imake
audit
python-dmidecode
sgpio
tcp_wrappers
ksh
elfutils-libelf
elfutils-libelf-devel
gcc
gcc-c++
glibc
glibc-common
glibc-devel*
glibc-headers
libaio
libaio-devel
libgcc
libgomp
libstdc++
libstdc++-devel
make
numactl-devel
sysstat
rng-utils
compat-libstdc++-296
compat-libstdc++-33.x86_64
libXp
libXp-devel
kernel-devel
glibc-utils
rng-utils
libXp
libXp-devel


%post
chvt 3
cd /tmp
wget ftp://10.101.5.100/pub/rhel5/kik/createuser.sh
bash createuser.sh > /root/createuser.log
wget ftp://10.101.5.100/pub/rhel5/kik/bash_profile
cat /tmp/bash_profile >> /home/oracle/.bash_profile
chvt 1
%end


详情不表，参加另外的博文

过程略。。。。。。

2. 下载并解压缩

11年最后两周光做测试鸟，反复安装，反复各种错。。。。一周的时间在1G内存的虚拟机上测试，实在是痛苦不堪，装一次等出错到90%左右，大半天已经过去鸟。。。。。

后来找了个好点的机器，16G内存，database和em各分配4G内存，才算勉强过去，12c的文档里对硬件的要求写的很清楚，如果有富余的机器还是用配置好点的，省的碰到各种莫名其妙的错误，无从下手。浪费感情又耽误时间。

另外，加压缩前一定要通过cksum验证一下，原来的虚拟机是在32位的xp上装的64位的linux，换机器以后，底层宿主机是windows 64bit 2008，通过windows共享拷贝过去以后刚开始也是碰到各种错误，最终发现竟然是文件有损。通过cksum也验证了文件不对的问题。后来通过在linux上架设ftp往linux虚拟机上上传竟然也不对，包括scp也出问题。最终在最早下载em的32位xp上架了个ftp服务器才顺利解决。不知道神马原因，据说是有bug。先不管啦。


过程略，unzip很简单，解压缩前可以用 -t参数测试一下压缩文件。


3. 开始安装

注意/etc/hosts 文件格式

最终如下


# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
10.101.5.68  grid.mytest grid
10.101.5.69  gridem.mytest gridem   #localhost
10.101.5.70  mydb2.mytest mydb2

安装的时候指定ORACLE_HOME=gridem.mytest.


runInstaller ORACLE_HOSTNAME=gridem.mytest


余下过程看图不说话

4. 登陆EM

静默安装Linux+Oracle 10G

操作系统选择oracle linux 5.7

准备工作：


需要一个能提供ftp服务的机器，最好是个linux。

需要的软件

vitrulbox 全部操作通过虚拟机完成

Enterprise-R5-U7-Server-x86_64-dvd.iso
CentOS-5.7-x86_64-netinstall.iso (BS下oracle，竟然公然歧视大陆，反正中国的IP是没法通过oracle下载linux的
                                  网上找的种子里没有netinstall盘，找了个centos的，临时替代一下)

10201_database_linux_x86_64.cpio
p8202632_10205_Linux-x86-64.zip


1.安装源设置
把Enterprise-R5-U7-Server-x86_64-dvd.iso挂载到一个已经在运行的linxu机器上，
拷贝光盘里所有内容到 /var/ftp/pub/ora5/iso/ 目录下，拷贝完成以后目录结构如下：


[root@resource kik]# ls -l /var/ftp/pub/ora5/iso/
total 380
-rw-r--r-- 1 root root   5165 Jul 29 13:05 blafdoc.css
drwxr-xr-x 3 root root   4096 Jul 29 13:17 Cluster
drwxr-xr-x 3 root root   4096 Jul 29 13:17 ClusterStorage
-rw-r--r-- 1 root root   6830 Jul 29 13:05 EULA
-rw-r--r-- 1 root root   7041 Jul 29 13:05 eula.en_US
-rw-r--r-- 1 root root   3334 Jul 29 13:05 eula.py
-rw-r--r-- 1 root root  18390 Jul 29 13:05 GPL
drwxr-xr-x 4 root root   4096 Jul 29 13:39 images
drwxr-xr-x 2 root root   4096 Jul 29 13:25 isolinux
-rw-r--r-- 1 root root   3547 Jul 29 13:05 README-en
-rw-r--r-- 1 root root   7897 Jul 29 13:05 README-en.html
-rw-r--r-- 1 root root  33470 Jul 29 13:05 RELEASE-NOTES-en
-rw-r--r-- 1 root root  36140 Jul 29 13:05 RELEASE-NOTES-en.html
-rw-r--r-- 1 root root   1397 Jul 29 13:05 RPM-GPG-KEY
-rw-r--r-- 1 root root   1397 Jul 29 13:05 RPM-GPG-KEY-oracle
drwxr-xr-x 4 root root 212992 Jul 29 13:17 Server
-rw-r--r-- 1 root root    105 Jul 29 13:05 supportinfo
-r--r--r-- 1 root root   4436 Jul 29 13:42 TRANS.TBL
drwxr-xr-x 3 root root   4096 Jul 29 13:17 VT
[root@resource kik]#



然后打开vsftpd的匿名登录。过程就省略略，google大把大把的。

kickstart配置文件放在 /var/ftp/pub/ora5/kik/ 下：



# Kickstart file automatically generated by anaconda.

install
url --url ftp://10.101.5.100/pub/ora5/iso/
lang en_US.UTF-8
keyboard us

#xconfig --startxonboot
network --device eth0 --bootproto static --ip 10.101.5.68 --netmask 255.255.248.0 --gateway 10.101.0.1 -
-nameserver 10.101.0.19 --hostname grid
rootpw --iscrypted $1$nPKdqyiD$KkCUPHAeWXhChoQxmjXiI/

firewall --disabled
firstboot --disable
authconfig --enableshadow --passalgo=sha512
selinux --disabled
timezone Asia/Shanghai
key --skip

bootloader --location=mbr --driveorder=sda --append="rhgb quiet"

clearpart --all --drives=sda
part swap --fstype swap --size=2048 --grow --maxsize=2048  --asprimary --ondisk=sda
part / --fstype ext3 --size=20480 --grow --maxsize=40960 --asprimary --ondisk=sda

reboot --eject



%packages
@admin-tools
@base
@chinese-support
@core
@system-tools
@base-x
@Administration Tools
@X Window System
sgpio
libstdc++44-devel
python-dmidecode
imake
audit
python-dmidecode
sgpio
tcp_wrappers
ksh
elfutils-libelf
elfutils-libelf-devel
gcc
gcc-c++
glibc
glibc-common
glibc-devel*
glibc-headers
libaio
libaio-devel
libgcc
libgomp
libstdc++
libstdc++-devel
make
numactl-devel
sysstat
rng-utils
compat-libstdc++-296
compat-libstdc++-33.x86_64
libXp
libXp-devel
kernel-devel
glibc-utils
rng-utils



%post
chvt 3
cd /tmp
wget ftp://10.101.5.100/pub/ora5/kik/createuser.sh
bash createuser.sh > /root/createuser.log
wget ftp://10.101.5.100/pub/ora5/kik/bash_profile
cat /tmp/bash_profile >> /home/oracle/.bash_profile
wget ftp://10.101.5.100/pub/ora5/kik/rlwrap-0.37-1.el5.x86_64.rpm
/bin/rpm -Uhv rlwrap-0.37-1.el5.x86_64.rpm
chvt 1
%end

createuser.sh

#!/bin/bash
/usr/sbin/groupadd -g 1000 oinstall;
/usr/sbin/groupadd -g 1100 dba;
/usr/sbin/groupadd -g 1200 oper;
/usr/sbin/useradd -u 1000 -g oinstall -G dba,oper oracle -p oracle;
/bin/echo "111111" | /usr/bin/passwd  --stdin oracle

/bin/echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
/bin/echo "kernel.shmmax = 2147483648" >> /etc/sysctl.conf
/bin/echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
/bin/echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
/bin/echo "net.core.rmem_default = 4194304" >> /etc/sysctl.conf
/bin/echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
/bin/echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
/bin/echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
/bin/echo "fs.file-max = 6815744" >> /etc/sysctl.conf
/bin/echo "net.core.wmem_max = 1048576" >> /etc/sysctl.conf11/29/2011
/bin/echo "fs.aio-max-nr = 1048576"  >> /etc/sysctl.conf

/bin/echo "inventory_loc=/u01/app/oracle/oraInventory"  >> /etc/oraInst.loc
/bin/echo "inst_group=oinstall"  >> /etc/oraInst.loc

/bin/mkdir -p /u01/app/oracle/product/10.2.0/dbhome_1
/bin/mkdir -p /u01/oradata
/bin/mkdir -p /u01/flash_recovery_area
/bin/mkdir -p /u01/app/oracle/middleware
/bin/chown -R oracle:oinstall /u01;
/bin/chmod -R 775 /u01

/bin/echo "oracle soft nproc 4096"  >> /etc/security/limits.conf
/bin/echo "oracle hard nproc 16384"  >> /etc/security/limits.conf
/bin/echo "oracle soft nofile 4096"  >> /etc/security/limits.conf
/bin/echo "oracle hard nofile 65536"  >> /etc/security/limits.conf


echo "10.101.5.68  grid.mytest grid" >> /etc/hosts






bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=grid.mytest; export ORACLE_HOSTNAME
ORACLE_UNQNAME=mydb1; export ORACLE_UNQNAME
ORACLE_SID=mydb1; export ORACLE_SID
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/dbhome_1; export ORACLE_HOME


PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH


alias sqlplus="rlwrap sqlplus"
alias rman="rlwrap sqlplus"


设置完以后分别用wget测试一下,过程略。


源设置好以后需要修改一下CentOS-5.7-x86_64-netinstall.iso ，用UltraISO打开编辑
isolinux.cfg，找到
label linux
  menu label ^Install or upgrade an existing system
  menu default
  kernel vmlinuz
  append initrd=initrd.img

编辑完如下：

label linux
  menu label ^Install or upgrade an existing system
  menu default
  kernel vmlinuz
  append initrd=initrd.img ks=ftp://10.101.5.100/pub/ora5/kik/ora5.cfg text

然后保存回ISO文件。

这边准备工作就做好了，下边转到虚拟机。



2.
vitrulbox里新建一个虚拟机。内存8G，硬盘40G动态扩展。启动时加载修改后的CentOS-5.7-x86_64-netinstall.iso
没有问题10来分钟以后oracle linux 5.7就安装好啦，确定重启一下就ok。




3.安装Vbox增强功能


[root@grid ~]# mount /dev/cdrom /mnt
mount: block device /dev/cdrom is write-protected, mounting read-only
[root@grid ~]# /mnt/VBoxLinuxAdditions.run
Verifying archive integrity... All good.
Uncompressing VirtualBox 4.1.8 Guest Additions for Linux.........
VirtualBox Guest Additions installer
Removing existing VirtualBox DKMS kernel modules[  OK  ]
Removing existing VirtualBox non-DKMS kernel modules[  OK  ]
Building the VirtualBox Guest Additions kernel modules
Building the main Guest Additions module[  OK  ]
Building the shared folder support module[  OK  ]
Building the OpenGL support module[FAILED]
(Look at /var/log/vboxadd-install.log to find out what went wrong)
Doing non-kernel setup of the Guest Additions[  OK  ]
Installing the Window System drivers
Installing X.Org 7.1 modules[  OK  ]
Setting up the Window System to use the Guest Additions[  OK  ]
You may need to restart the hal service and the Window System (or just restart
the guest system) to enable the Guest Additions.

Installing graphics libraries and desktop services components[  OK  ]
[root@grid ~]#

设置数据空间，设置完以后加载


[root@grid ~]# mount -t vboxsf share /mnt
[root@grid ~]# ls /mnt/
oracle10G  Oracle-5.7-x86_64-netinstall.iso  oracle_em
[root@grid ~]#




4.
安装oracle

加压缩安装文件 cpio -idvm < /mnt/oracle10G/10201_database_linux_x86_64.cpio

创建response文件


enterprise.rsp


RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME="oinstall"
FROM_LOCATION="../stage/products.xml"
NEXT_SESSION_RESPONSE=<Value Unspecified>
ORACLE_HOME="/u01/app/oracle/product/10.2.0/dbhome_1"
ORACLE_HOME_NAME="OraDbHome1"
TOPLEVEL_COMPONENT={"oracle.server","10.2.0.1.0"}
DEINSTALL_LIST={"oracle.server","10.2.0.1.0"}
SHOW_SPLASH_SCREEN=false
SHOW_WELCOME_PAGE=false
SHOW_NODE_SELECTION_PAGE=false
SHOW_SUMMARY_PAGE=false
SHOW_INSTALL_PROGRESS_PAGE=false
SHOW_CONFIG_TOOL_PAGE=false
SHOW_XML_PREREQ_PAGE=false
SHOW_ROOTSH_CONFIRMATION=true
SHOW_END_SESSION_PAGE=false
SHOW_EXIT_CONFIRMATION=false
NEXT_SESSION=false
NEXT_SESSION_ON_FAIL=false
SHOW_DEINSTALL_CONFIRMATION=false
SHOW_DEINSTALL_PROGRESS=false
RESTART_SYSTEM="false"
RESTART_REMOTE_SYSTEM="false"


ORACLE_HOSTNAME="grid"
SHOW_END_OF_INSTALL_MSGS=true
COMPONENT_LANGUAGES={"en,zh_CN"}
INSTALL_TYPE="EE"
s_nameForDBAGrp="dba"
s_nameForOPERGrp="dba"
n_configurationOption=3





[oracle@grid database]$ ./runInstaller  -ignoreSysPrereqs -silent -responsefile /home/oracle/enterprise.rsp
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                      Failed <<<<


>>> Ignoring required pre-requisite failures. Continuing...

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-29_11-21-54AM. Please wait ...[oracle@grid database]$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.

You can find a log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2011-12-29_11-21-54AM.log
.................................................................................................... 100% Done.


Loading Product Information
..................................................................................................................... 100% Done.

Analyzing dependencies 

.........................................................

Starting execution of Prerequisites...

Total No of checks: 11

Performing check for CertifiedVersions

Checking operating system requirements ...

Expected result: One of redhat-3,redhat-4,SuSE-9

Actual Result: redhat-Red Hat Enterprise Linux Server release 5.7 (Tikanga)

Check complete. The overall result of this check is: Failed <<<<

Check complete: Failed <<<<

Problem: Oracle Database 10g is not certified on the current operating system.

Recommendation: Make sure you are installing the software on the correct platform.

=======================================================================

Performing check for Packages

Checking operating system package requirements ...

Check complete. The overall result of this check is: Not executed <<<<

Check complete: Not executed <<<<

OUI-18001: The operating system 'Linux Version redhat-Red Hat Enterprise Linux Server release 5.7 (Tikanga)' is not supported.

Recommendation: Install the required packages before continuing with the installation.

=======================================================================

Performing check for Kernel

Checking kernel parameters

Check complete. The overall result of this check is: Not executed <<<<

Check complete: Not executed <<<<

OUI-18001: The operating system 'Linux Version redhat-Red Hat Enterprise Linux Server release 5.7 (Tikanga)' is not supported.

Recommendation: Perform operating system specific instructions to update the kernel parameters.

=======================================================================

Performing check for GLIBC

Checking Recommended glibc version

Check complete. The overall result of this check is: Not executed <<<<

Check complete: Not executed <<<<

OUI-18001: The operating system 'Linux Version redhat-Red Hat Enterprise Linux Server release 5.7 (Tikanga)' is not supported.

Recommendation: You may actually have installed packages which have obsoleted these, in which case you can successfully continue with the install. If you have not, it is recommended that you do not continue. Refer to the readme to find out how to get the missing packages.

=======================================================================

Performing check for TotalMemory

Checking physical memory requirements ...

Expected result: 922MB

Actual Result: 3956MB

Check complete. The overall result of this check is: Passed

Check complete: Passed

=======================================================================

Performing check for SwapSpace

Checking available swap space requirements ...

Expected result: 3956MB

Actual Result: 2047MB

Check complete. The overall result of this check is: Failed <<<<

Check complete: Failed <<<<

Problem: The system does not have the required swap space.

Recommendation: Make more swap space available to perform the install.

=======================================================================

Performing check for DetectIfDHCPAssignedIP

Checking Network Configuration requirements ...

Check complete. The overall result of this check is: Passed

Check complete: Passed

=======================================================================

Performing check for OracleBase

Validating ORACLE_BASE location (if set) ...

Check complete. The overall result of this check is: Passed

Check complete: Passed

=======================================================================

Performing check for OracleHomeSpace

Checking Oracle Home path for spaces...

Check complete. The overall result of this check is: Passed

Check complete: Passed

=======================================================================

Performing check for DetectAnyInvalidASMHome

Checking for proper system clean-up....

Check complete. The overall result of this check is: Passed

Check complete: Passed

=======================================================================

Performing check for CompatibilityChecks

Checking for Oracle Home incompatibilities ....

Actual Result: NEW_HOME

Check complete. The overall result of this check is: Passed

Check complete: Passed

=======================================================================

PrereqChecks complete

........................................... 100% Done.

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

Summary

Global Settings

    Source: /home/oracle/database/stage/products.xml

    Oracle Home: /u01/app/oracle/product/10.2.0/dbhome_1 (OraDbHome1)

    Installation Type: Enterprise Edition

Product Languages

   English

Space Requirements

   / Required 1.74GB (includes 130MB temporary) : Available 32.05GB

New Installations (109 products)

   Oracle Database 10g 10.2.0.1.0 

   Enterprise Edition Options 10.2.0.1.0 

   Oracle Partitioning 10.2.0.1.0 

   Oracle Spatial 10.2.0.1.0 

   Oracle OLAP 10.2.0.1.0 

   Oracle Enterprise Manager Console DB 10.2.0.1.0 

   Oracle Net Services 10.2.0.1.0 

   Oracle Database 10g 10.2.0.1.0 

   Oracle Net Listener 10.2.0.1.0 

   HAS Files for DB 10.2.0.1.0 

   Oracle Internet Directory Client 10.2.0.1.0 

   Oracle Call Interface (OCI) 10.2.0.1.0 

   Oracle Programmer 10.2.0.1.0 

   Oracle interMedia 10.2.0.1.0 

   Enterprise Manager Agent Core 10.2.0.1.0 

   Oracle JVM 10.2.0.1.0 

   Database Configuration and Upgrade Assistants 10.2.0.1.0 

   Oracle interMedia Locator 10.2.0.1.0 

   Oracle XML Development Kit 10.2.0.1.0 

   Oracle Text 10.2.0.1.0 

   Oracle Database Utilities 10.2.0.1.0 

   Generic Connectivity Common Files 10.2.0.1.0 

   Oracle Advanced Security 10.2.0.1.0 

   Enterprise Manager Repository Core 10.2.0.1.0 

   PL/SQL 10.2.0.1.0 

   Oracle Net 10.2.0.1.0 

   Assistant Common Files 10.2.0.1.0 

   Oracle Notification Service 10.1.0.3.0 

   Enterprise Manager plugin Common Files 10.2.0.1.0 Beta

   Buildtools Common Files 10.2.0.1.0 

   Installation Common Files 10.2.0.1.0 

   Oracle LDAP administration 10.2.0.1.0 

   Oracle Java Client 10.2.0.1.0 

   Oracle Recovery Manager 10.2.0.1.0 

   SQL*Plus 10.2.0.1.0 

   iSQL*Plus 10.2.0.1.0 

   Enterprise Manager plugin Common Files 10.2.0.1.0 

   Oracle Help for the  Web 1.1.10.0.0 

   HAS Common Files 10.2.0.1.0 

   Oracle Clusterware RDBMS Files 10.2.0.1.0 

   Oracle Wallet Manager 10.2.0.1.0 

   Enterprise Manager Minimal Integration 10.2.0.1.0 

   Oracle Database User Interface 2.2.13.0.0 

   Precompiler Common Files 10.2.0.1.0 

   Secure Socket Layer 10.2.0.1.0 

   Oracle ODBC Driver 10.2.0.1.0 

   Database SQL Scripts 10.2.0.1.0 

   OLAP SQL Scripts 10.2.0.1.0 

   PL/SQL Embedded Gateway 10.2.0.1.0 

   Required Support Files 10.2.0.1.0 

   Character Set Migration Utility 10.2.0.1.0 

   LDAP Required Support Files 10.2.0.1.0 

   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0 

   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0 

   Oracle interMedia Client Option 10.2.0.1.0 

   Oracle Required Support Files 32 bit 10.2.0.0.0 

   Oracle Code Editor 1.2.1.0.0I 

   Oracle Globalization Support 10.2.0.1.0 

   JDBC Common Files 10.2.0.1.0 

   Oracle Locale Builder 10.2.0.1.0 

   Oracle Containers for Java 10.2.0.1.0 

   Database Workspace Manager 10.2.0.1.0 

   Oracle Core Required Support Files 10.2.0.1.0 

   Platform Required Support Files 10.2.0.1.0 

   Oracle interMedia Locator RDBMS Files 10.2.0.1.0 

   Oracle JDBC/OCI Instant Client 10.2.0.1.0 

   Oracle interMedia Annotator 10.2.0.1.0 

   SQLJ Runtime 10.2.0.1.0 

   Oracle interMedia Java Advanced Imaging 10.2.0.1.0 

   Oracle Database 10g interMedia Files 10.2.0.1.0 

   Oracle Data Mining RDBMS Files 10.2.0.1.0 

   Enterprise Manager Baseline 10.2.0.1.0 

   Oracle Help For Java 4.2.6.1.0 

   Oracle UIX 2.1.22.0.0 

   XML Parser for Java 10.2.0.1.0 

   Precompiler Required Support Files 10.2.0.1.0 

   XML Parser for Oracle JVM 10.2.0.1.0 

   Oracle Database 10G 32 bit 10.2.0.1.0 

   Oracle Message Gateway Common Files 10.2.0.1.0 

   Oracle Starter Database 10.2.0.1.0 

   Sample Schema Data 10.2.0.1.0 

   Parser Generator Required Support Files 10.2.0.1.0 

   Agent Required Support Files 10.2.0.1.0 

   Oracle RAC Required Support Files-HAS 10.2.0.1.0 

   RDBMS Required Support Files 10.2.0.1.0 

   RDBMS Required Support Files for Instant Client 10.2.0.1.0 

   XDK Required Support Files 10.2.0.1.0 

   Oracle OLAP API 10.2.0.1.0 

   Oracle OLAP RDBMS Files 10.2.0.1.0 

   DBJAVA Required Support Files 10.2.0.1.0 

   SQL*Plus Required Support Files 10.2.0.1.0 

   Oracle JFC Extended Windowing Toolkit 4.2.33.0.0 

   Oracle Ice Browser 5.2.3.6.0 

   regexp 2.1.9.0.0 

   Oracle Extended Windowing Toolkit 3.4.38.0.0 

   Enterprise Manager Common Files 10.2.0.1.0 

   Enterprise Manager Agent DB 10.2.0.1.0 

   Oracle Net Required Support Files 10.2.0.1.0 

   Enterprise Manager Repository DB 10.2.0.1.0 

   Oracle Display Fonts 9.0.2.0.0 

   SSL Required Support Files for InstantClient 10.2.0.1.0 

   Bali Share 1.1.18.0.0 

   Perl Interpreter 5.8.3.0.2 

   Oracle Universal Installer 10.2.0.1.0 

   Oracle One-Off Patch Installer 10.2.0.1.0 

   Installer SDK Component 10.2.0.1.0 

   Java Runtime Environment 1.4.2.0.8 

   Java 2 SDK 1.4.2.0.8 

   Sun JDK extensions 10.1.2.0.0 

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

Installation in progress (Thu Dec 29 11:22:03 CST 2011)

...............................................................  14% Done.

...............................................................  28% Done.

...............................................................  42% Done.

...............................................................  56% Done.

...............................................................  70% Done.

................                                                 74% Done.

Install successful

Linking in progress (Thu Dec 29 11:23:06 CST 2011)

.                                                                74% Done.

Link successful

Setup in progress (Thu Dec 29 11:24:20 CST 2011)

..................                                              100% Done.

Setup successful

End of install phases.(Thu Dec 29 11:24:22 CST 2011)

WARNING:The following configuration scripts 

/u01/app/oracle/product/10.2.0/dbhome_1/root.sh

need to be executed as root for configuring the system. If you skip the execution of the configuration tools, the configuration will not be complete and the product wont function properly. In order to get the product to function properly, you will be required to execute the scripts and the configuration tools after exiting the OUI.

 

The installation of Oracle Database 10g was successful.

Please check '/u01/app/oracle/oraInventory/logs/silentInstall2011-12-29_11-21-54AM.log' for more details.

[oracle@grid database]$ 

[root@grid ~]# /u01/app/oracle/product/10.2.0/dbhome_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/dbhome_1

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

   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.

[root@grid ~]# 

不需要单独去装监听器鸟


[oracle@grid database]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-DEC-2011 11:28:11

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@grid database]$
[oracle@grid database]$
[oracle@grid database]$
[oracle@grid database]$
[oracle@grid database]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-DEC-2011 11:28:18

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/dbhome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=grid)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-DEC-2011 11:28:18
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=grid)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@grid database]$


4.
这次先升级，再建库。


停掉监听器，确定没有oracle进程。用ps 验证一下


[oracle@grid ~]$ ps -eaf|grep ora
root      2376  2345  0 10:46 ?        00:00:00 hald-addon-storage: polling /dev/sr0
root      6930  2475  0 10:59 ?        00:00:00 sshd: oracle [priv]
oracle    6932  6930  0 10:59 ?        00:00:00 sshd: oracle@pts/1
oracle    6933  6932  0 10:59 pts/1    00:00:00 -bash
root      7168  2475  0 11:20 ?        00:00:00 sshd: oracle [priv]
oracle    7170  7168  0 11:20 ?        00:00:00 sshd: oracle@pts/0
oracle    7171  7170  0 11:20 pts/0    00:00:00 -bash
oracle   21331  6933  0 11:30 pts/1    00:00:00 ps -eaf
oracle   21332  6933  0 11:30 pts/1    00:00:00 grep ora
[oracle@grid ~]$

加压缩升级包

[oracle@grid ~]$ unzip /mnt/oracle10G/p8202632_10205_Linux-x86-64.zip -d /home/oracle/upgrade

。。。。。。。。。。。。。。。。

从模板创建response文件，最终如下：

[oracle@grid ~]$ more patchset.rsp

RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME=oinstall
FROM_LOCATION="/home/oracle/upgrade/Disk1/stage/products.xml"
NEXT_SESSION_RESPONSE=
ORACLE_HOME="/u01/app/oracle/product/10.2.0/dbhome_1"
ORACLE_HOME_NAME="OraDbHome1"
TOPLEVEL_COMPONENT={"oracle.patchset.db","10.2.0.5.0"}
SHOW_SPLASH_SCREEN=false
SHOW_WELCOME_PAGE=false
SHOW_COMPONENT_LOCATIONS_PAGE=false
SHOW_CUSTOM_TREE_PAGE=false
SHOW_SUMMARY_PAGE=false
SHOW_INSTALL_PROGRESS_PAGE=true
SHOW_REQUIRED_CONFIG_TOOL_PAGE=false
SHOW_OPTIONAL_CONFIG_TOOL_PAGE=false
SHOW_CONFIG_TOOL_PAGE=false
SHOW_XML_PREREQ_PAGE=false
SHOW_RELEASE_NOTES=false
SHOW_END_OF_INSTALL_MSGS=true
SHOW_ROOTSH_CONFIRMATION=true
SHOW_END_SESSION_PAGE=false
SHOW_EXIT_CONFIRMATION=false
NEXT_SESSION=false
NEXT_SESSION_ON_FAIL=false
SHOW_DEINSTALL_CONFIRMATION=false
SHOW_DEINSTALL_PROGRESS=false
ACCEPT_LICENSE_AGREEMENT=true
RESTART_SYSTEM=false
CLUSTER_NODES=
OUI_HOSTNAME=
REMOVE_HOMES=
COMPONENT_LANGUAGES={"en,zh_CN"}
sl_userNodeList=
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
DECLINE_SECURITY_UPDATES= true
COLLECTOR_UPGRADE=
COLLECTOR_IGNORE_CONFIGURATION=
COLLECTOR_IGNORE_FAILURES=
COLLECTOR_USE_OBFUSCATED_PASSWORDS=
COLLECTOR_RESPONSE_FILE=
COLLECTOR_SUPPORTHUB_URL=

开始升级


./runInstaller -ignoreSysPrereqs -silent -responseFile


[oracle@grid ~]$ cd upgrade/Disk1/
install/        patch_note.htm  response/       runInstaller    stage/        
[oracle@grid ~]$ cd upgrade/Disk1/
[oracle@grid Disk1]$ ./runInstaller -ignoreSysPrereqs -silent -responseFile /home/oracle/patchset.rsp



[oracle@grid Disk1]$ ./runInstaller -ignoreSysPrereqs -silent -responseFile /home/oracle/patchset.rsp
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
                                      Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-29_02-09-14PM. Please wait ...[oracle@grid Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.

You can find a log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2011-12-29_02-09-14PM.log
.................................................................................................... 100% Done.


Loading Product Information
.................................................................................................................. 100% Done.


Starting execution of Prerequisites...
Total No of checks: 8

Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of redhat-6,redhat-5,redhat-4,redhat-3,SuSE-11,SuSE-10,SuSE-9,asianux-3,asianux-2,asianux-1
Actual Result: redhat-5
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for Packages
Checking operating system package requirements ...
Checking for make-3.81; found make-1:3.81-3.el5.        Passed
Checking for binutils-2.17.50.0.6; found binutils-2.17.50.0.6-14.el5.   Passed
Checking for gcc-4.1.1; found gcc-4.1.2-51.el5. Passed
Checking for libaio-0.3.106; found libaio-0.3.106-5.    Passed
Checking for libstdc++-4.1.1; found libstdc++-4.1.2-51.el5.     Passed
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.      Passed
Checking for semmns=32000; found semmns=32000.  Passed
Checking for semopm=100; found semopm=100.      Passed
Checking for semmni=128; found semmni=128.      Passed
Checking for shmmax=1073741824; found shmmax=2147483648.        Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=2097152.      Passed
Checking for file-max=101365; found file-max=6815744.   Passed
Checking for VERSION=2.6.18; found VERSION=2.6.32-200.13.1.el5uek.      Passed
Checking for ip_local_port_range=9000 - 65500; found ip_local_port_range=9000 - 65500.  Passed
Checking for rmem_default=1048576; found rmem_default=4194304.  Passed
Checking for rmem_max=1048576; found rmem_max=4194304.  Passed
Checking for wmem_default=262144; found wmem_default=262144.    Passed
Checking for wmem_max=262144; found wmem_max=131071.    Failed <<<<
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.

=======================================================================
Performing check for GLIBC
Checking Recommended glibc version
Expected result: ATLEAST=2.5-12 NOT_EQUALS=2.5-18
Actual Result: 2.5-65
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 3956MB
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 3956MB
Actual Result: 2047MB
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.

=======================================================================
Performing check for checkToInstallCCR
Checking the Components installed in Oracle Home
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for CompatibilityChecks
Checking for Oracle Home incompatibilities ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
PrereqChecks complete


Analyzing dependencies
...................................................................................................... 100% Done.


-----------------------------------------------------------------------------
Summary
Global Settings
    Source: /home/oracle/upgrade/Disk1/stage/products.xml
    Oracle Home: /u01/app/oracle/product/10.2.0/dbhome_1 (OraDbHome1)
Product Languages
   English
Space Requirements
   / Required 1.49GB (includes 54MB temporary) : Available 29.21GB
New Installations (86 products)
   Oracle Notification Service Patch 10.2.0.5.0
   Database Configuration and Upgrade Assistants Patch 10.2.0.5.0
   Character Set Migration Utility Patch 10.2.0.5.0
   Oracle Database 10g Patch 10.2.0.5.0
   Oracle JDBC/OCI Instant Client Patch 10.2.0.5.0
   Oracle Database 10g Patch 10.2.0.5.0
   Enterprise Manager plugin Common Files Patch 10.2.0.5.0
   SQL*Plus 10.2.0.5.0
   HAS Common Files Patch 10.2.0.5.0
   HAS Files for DB Patch 10.2.0.5.0
   Oracle Java Client Patch 10.2.0.5.0
   Oracle JVM Patch 10.2.0.5.0
   Oracle Internet Directory Client Patch 10.2.0.5.0
   iSQL*Plus 10.2.0.5.0
   Oracle Advanced Security Patch 10.2.0.5.0
   Oracle Net Patch 10.2.0.5.0
   Oracle Net Listener Patch 10.2.0.5.0
   Oracle Wallet Manager Patch 10.2.0.5.0
   Precompiler Common Files Patch 10.2.0.5.0
   Secure Socket Layer Patch 10.2.0.5.0
   Oracle ODBC Driver Patch 10.2.0.5.0
   Oracle OLAP Patch 10.2.0.5.0
   Oracle OLAP API Patch 10.2.0.5.0
   OLAP SQL Scripts Patch 10.2.0.5.0
   Oracle interMedia Client Option Patch 10.2.0.5.0
   Oracle Database 10g interMedia Files Patch 10.2.0.5.0
   Oracle interMedia Patch 10.2.0.5.0
   PL/SQL Embedded Gateway Patch 10.2.0.5.0
   Oracle XML Development Kit Patch 10.2.0.5.0
   Oracle Text Patch 10.2.0.5.0
   Oracle Clusterware RDBMS Files Patch 10.2.0.5.0
   Database SQL Scripts Patch 10.2.0.5.0
   Oracle Data Mining RDBMS Files Patch 10.2.0.5.0
   Generic Connectivity Common Files Patch 10.2.0.5.0
   Oracle Net Required Support Files Patch 10.2.0.5.0
   Oracle Starter Database Patch 10.2.0.5.0
   Sample Schema Data Patch 10.2.0.5.0
   Oracle interMedia Locator RDBMS Files Patch 10.2.0.5.0
   Oracle Call Interface (OCI) Patch 10.2.0.5.0
   Oracle OLAP RDBMS Files Patch 10.2.0.5.0
   PL/SQL 10.2.0.5.0
   Oracle Recovery Manager Patch 10.2.0.5.0
   Oracle Database Utilities Patch 10.2.0.5.0
   Oracle interMedia Locator Patch 10.2.0.5.0
   XML Parser for Java Patch 10.2.0.5.0
   Assistant Common Files Patch 10.2.0.5.0
   Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.5.0
   Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.5.0
   Oracle interMedia Java Advanced Imaging Patch 10.2.0.5.0
   SQLJ Runtime Patch 10.2.0.5.0
   XML Parser for Oracle JVM Patch 10.2.0.5.0
   Enterprise Manager Agent DB 10.2.0.5.0
   Enterprise Manager Baseline 10.2.0.5.0
   Oracle Enterprise Manager Console DB 10.2.0.5.0
   XDK Required Support Files Patch 10.2.0.5.0
   Agent Required Support Files Patch 10.2.0.5.0
   DBJAVA Required Support Files Patch 10.2.0.5.0
   LDAP Required Support Files Patch 10.2.0.5.0
   Precompiler Required Support Files Patch 10.2.0.5.0
   Oracle RAC Required Support Files-HAS Patch 10.2.0.5.0
   RDBMS Required Support Files for Instant Client Patch 10.2.0.5.0
   RDBMS Required Support Files Patch 10.2.0.5.0
   SQL*Plus Required Support Files Patch 10.2.0.5.0
   SSL Required Support Files for InstantClient Patch 10.2.0.5.0
   Installation Common Files Patch 10.2.0.5.0
   Oracle Globalization Support Patch 10.2.0.5.0
   Oracle Core Required Support Files Patch 10.2.0.5.0
   Platform Required Support Files 10.2.0.5.0
   Oracle Message Gateway Common Files Patch 10.2.0.5.0
   Enterprise Manager Agent Core Patch 10.2.0.5.0a
   Enterprise Manager Common Core Patch 10.2.0.5.0a
   Enterprise Manager Repository Core patch 10.2.0.5.0a
   Oracle Containers for Java 10.2.0.5.0
   Enterprise Manager Repository DB 10.2.0.5.0
   Oracle LDAP administration patch 10.2.0.5.0
   Oracle Required Support Files 32 bit Patch 10.2.0.5.0
   JDBC Common Files 10.2.0.5.0
   Database Workspace Manager 10.2.0.5.0
   Oracle interMedia Annotator 10.2.0.5.0
   Enterprise Manager Minimal Integration 10.2.0.5.0
   Parser Generator Required Support Files 10.2.0.5.0
   Buildtools Common Files 10.2.0.5.0
   Oracle UIX 2.2.24.6.0
   Bali Share 1.1.19.0.0
   Oracle Real Application Testing 10.2.0.5.0
   Oracle Configuration Manager 10.3.2.1.0
Upgrades (5 products)
   Oracle Universal Installer 10.2.0.5.0
   Oracle One-Off Patch Installer 10.2.0.4.2
   Installer SDK Component 10.2.0.5.0
   Java Runtime Environment 1.4.2.14.0
   Sun JDK 1.4.2.14.05
Already Installed (84 products)
   Oracle Notification Service 10.1.0.3.0
   Database Configuration and Upgrade Assistants 10.2.0.1.0
   Character Set Migration Utility 10.2.0.1.0
   Oracle Database 10g 10.2.0.1.0
   Oracle JDBC/OCI Instant Client 10.2.0.1.0
   Oracle Database 10g 10.2.0.1.0
   Enterprise Manager plugin Common Files 10.2.0.1.0
   SQL*Plus 10.2.0.1.0
   HAS Common Files 10.2.0.1.0
   HAS Files for DB 10.2.0.1.0
   Oracle Java Client 10.2.0.1.0
   Oracle JVM 10.2.0.1.0
   Oracle Internet Directory Client 10.2.0.1.0
   iSQL*Plus 10.2.0.1.0
   Oracle Advanced Security 10.2.0.1.0
   Oracle Net 10.2.0.1.0
   Oracle Net Listener 10.2.0.1.0
   Oracle Wallet Manager 10.2.0.1.0
   Precompiler Common Files 10.2.0.1.0
   Secure Socket Layer 10.2.0.1.0
   Oracle ODBC Driver 10.2.0.1.0
   Oracle OLAP 10.2.0.1.0
   Oracle OLAP API 10.2.0.1.0
   OLAP SQL Scripts 10.2.0.1.0
   Oracle interMedia Client Option 10.2.0.1.0
   Oracle Database 10g interMedia Files 10.2.0.1.0
   Oracle interMedia 10.2.0.1.0
   PL/SQL Embedded Gateway 10.2.0.1.0
   Oracle XML Development Kit 10.2.0.1.0
   Oracle Text 10.2.0.1.0
   Oracle Clusterware RDBMS Files 10.2.0.1.0
   Database SQL Scripts 10.2.0.1.0
   Oracle Data Mining RDBMS Files 10.2.0.1.0
   Generic Connectivity Common Files 10.2.0.1.0
   Oracle Net Required Support Files 10.2.0.1.0
   Oracle Starter Database 10.2.0.1.0
   Sample Schema Data 10.2.0.1.0
   Oracle interMedia Locator RDBMS Files 10.2.0.1.0
   Oracle Call Interface (OCI) 10.2.0.1.0
   Oracle OLAP RDBMS Files 10.2.0.1.0
   PL/SQL 10.2.0.1.0
   Oracle Recovery Manager 10.2.0.1.0
   Oracle Database Utilities 10.2.0.1.0
   Oracle interMedia Locator 10.2.0.1.0
   XML Parser for Java 10.2.0.1.0
   Assistant Common Files 10.2.0.1.0
   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0
   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0
   Oracle interMedia Java Advanced Imaging 10.2.0.1.0
   SQLJ Runtime 10.2.0.1.0
   XML Parser for Oracle JVM 10.2.0.1.0
   Enterprise Manager Agent DB 10.2.0.1.0
   Enterprise Manager Baseline 10.2.0.1.0
   Oracle Enterprise Manager Console DB 10.2.0.1.0
   XDK Required Support Files 10.2.0.1.0
   Agent Required Support Files 10.2.0.1.0
   DBJAVA Required Support Files 10.2.0.1.0
   LDAP Required Support Files 10.2.0.1.0
   Precompiler Required Support Files 10.2.0.1.0
   Oracle RAC Required Support Files-HAS 10.2.0.1.0
   RDBMS Required Support Files for Instant Client 10.2.0.1.0
   RDBMS Required Support Files 10.2.0.1.0
   SQL*Plus Required Support Files 10.2.0.1.0
   SSL Required Support Files for InstantClient 10.2.0.1.0
   Installation Common Files 10.2.0.1.0
   Oracle Globalization Support 10.2.0.1.0
   Oracle Core Required Support Files 10.2.0.1.0
   Platform Required Support Files 10.2.0.1.0
   Oracle Message Gateway Common Files 10.2.0.1.0
   Enterprise Manager Agent Core 10.2.0.1.0
   Enterprise Manager Common Files 10.2.0.1.0
   Enterprise Manager Repository Core 10.2.0.1.0
   Oracle Containers for Java 10.2.0.1.0
   Enterprise Manager Repository DB 10.2.0.1.0
   Oracle LDAP administration 10.2.0.1.0
   Oracle Required Support Files 32 bit 10.2.0.0.0
   JDBC Common Files 10.2.0.1.0
   Database Workspace Manager 10.2.0.1.0
   Oracle interMedia Annotator 10.2.0.1.0
   Enterprise Manager Minimal Integration 10.2.0.1.0
   Parser Generator Required Support Files 10.2.0.1.0
   Buildtools Common Files 10.2.0.1.0
   Oracle UIX 2.1.22.0.0
   Bali Share 1.1.18.0.0
-----------------------------------------------------------------------------


Deinstall in progress (Thursday, December 29, 2011 2:09:24 PM CST)
...............................................................   0% Done.
...............................................................  14% Done.
...............................................................  28% Done.
...............................................................  42% Done.
...............................................................  56% Done.
...............................................................  70% Done.
...............................................................  85% Done.
...                                                             100% Done.

Deinstall successful

Installation in progress (Thursday, December 29, 2011 2:09:24 PM CST)
...............................................................  14% Done.
...............................................................  28% Done.
...............................................................  42% Done.
...............................................................  56% Done.
...............................................................  70% Done.
...............................................................  85% Done.
.............                                                    88% Done.
Install successful

Linking in progress (Thursday, December 29, 2011 2:10:38 PM CST)
...                                                              88% Done.
Link successful

Setup in progress (Thursday, December 29, 2011 2:11:02 PM CST)
...........                                                     100% Done.
Setup successful

End of install phases.(Thursday, December 29, 2011 2:11:04 PM CST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/u01/app/oracle/product/10.2.0/dbhome_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts

The installation of Oracle Database 10g Release 2 Patch Set 4 was successful.
Please check '/u01/app/oracle/oraInventory/logs/silentInstall2011-12-29_02-09-14PM.log' for more details.

[oracle@grid Disk1]$


[root@grid Disk1]# /u01/app/oracle/product/10.2.0/dbhome_1/root.sh
Running Oracle 10g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/dbhome_1

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@grid Disk1]#



启动监听器


[oracle@grid Disk1]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 29-DEC-2011 14:13:17

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/dbhome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=grid)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date                29-DEC-2011 14:13:17
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=grid)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@grid Disk1]$


5.
准备建库

5.1 确认 ORACLE_SID ORACLe_BASE ORACLE_HOME 环境变量


[oracle@grid ~]$ env |grep -i oracle
ORACLE_UNQNAME=mydb1
USER=oracle
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/dbhome_1/lib:/lib:/usr/lib
ORACLE_SID=mydb1
ORACLE_BASE=/u01/app/oracle
MAIL=/var/spool/mail/oracle
PATH=/u01/app/oracle/product/10.2.0/dbhome_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
PWD=/home/oracle
HOME=/home/oracle
LOGNAME=oracle
CLASSPATH=/u01/app/oracle/product/10.2.0/dbhome_1/jlib:/u01/app/oracle/product/10.2.0/dbhome_1/rdbms/jlib
ORACLE_HOME=/u01/app/oracle/product/10.2.0/dbhome_1
OLDPWD=/home/oracle/upgrade/Disk1
[oracle@grid ~]$



5.2 创建密码文件


[oracle@grid ~]$ cd $ORACLE_HOME/dbs
[oracle@grid dbs]$ pwd
/u01/app/oracle/product/10.2.0/dbhome_1/dbs
[oracle@grid dbs]$ ls
initdw.ora  init.ora
[oracle@grid dbs]$ orapwd
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
   
  There must be no spaces around the equal-to (=) character.
[oracle@grid dbs]$ orapwd file=orapwmydb1 entries=20

Enter password for SYS:
[oracle@grid dbs]$

5.3 创建pfile


mkdir -p /u01/app/oracle/admin/mydb1/adump
mkdir -p /u01/app/oracle/admin/mydb1/bdump
mkdir -p /u01/app/oracle/admin/mydb1/cdump
mkdir -p /u01/oradata/mydb1/



[oracle@grid dbs]$ ls
initdw.ora  init.ora  orapwmydb1
[oracle@grid dbs]$ cp init.ora initmydb1.ora
[oracle@grid dbs]$


最终如下：



db_files = 800                                                         # SMALL
db_block_size = 8192
db_files = 1000
#shared_pool_size = 3500000                                            # SMALL
log_checkpoint_interval = 10000
processes = 500                                                        # SMALL
open_cursors=500
#parallel_max_servers = 5                                              # SMALL
log_buffer = 32768                                                    # SMALL
max_dump_file_size = 10240      # limit trace file size to 5 Meg each
db_recovery_file_dest='/u01/flash_recovery_area'
db_recovery_file_dest_size=2G
pga_aggregate_target = 200M #SMALL
sga_target = 1024M
db_name = "mydb1"
control_files = (/u01/oradata/mydb1/control01.ctl, /u01/oradata/mydb1/control02.ctl)
undo_management = auto
undo_tablespace='UNDOTBS1'
audit_file_dest='/u01/app/oracle/admin/mydb1/adump'
db_recovery_file_dest='/u01/flash_recovery_area'
db_recovery_file_dest_size=2G
remote_login_passwordfile='EXCLUSIVE'

创建相关目录

mkdir -p /u01/app/oracle/admin/mydb1/adump

mkdir -p /u01/app/oracle/admin/mydb1/bdump

mkdir -p /u01/app/oracle/admin/mydb1/cdump

mkdir -p /u01/oradata/mydb1/

chmod -R 775 /u01/app/oracle/admin

5.4 连接到实例并创建spfile

[oracle@grid dbs]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Dec 29 14:42:23 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> conn / as sysdba

Connected to an idle instance.

SQL> show user;

USER is "SYS"

SQL> 

SQL> create spfile from pfile;

File created.

SQL>

关闭实例以spfile启动到nomount模式

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size                  2101768 bytes

Variable Size             264244728 bytes

Database Buffers          805306368 bytes

Redo Buffers                2088960 bytes

SQL> 

这时候查看后台进程

[oracle@grid dbs]$ ps -eaf|grep oracle

oracle    1343     1  0 14:13 ?        00:00:00 /u01/app/oracle/product/10.2.0/dbhome_1/bin/tnslsnr LISTENER -inheri                                                             t

oracle    1453  7171  0 14:42 pts/0    00:00:00 rlwrap sqlplus /nolog

oracle    1454  1453  0 14:42 pts/2    00:00:00 sqlplus

oracle    1472     1  0 14:46 ?        00:00:00 ora_pmon_mydb1

oracle    1474     1  0 14:46 ?        00:00:00 ora_psp0_mydb1

oracle    1476     1  0 14:46 ?        00:00:00 ora_mman_mydb1

oracle    1478     1  0 14:46 ?        00:00:00 ora_dbw0_mydb1

oracle    1480     1  0 14:46 ?        00:00:00 ora_lgwr_mydb1

oracle    1482     1  0 14:46 ?        00:00:00 ora_ckpt_mydb1

oracle    1484     1  0 14:46 ?        00:00:00 ora_smon_mydb1

oracle    1486     1  0 14:46 ?        00:00:00 ora_reco_mydb1

oracle    1488     1  0 14:46 ?        00:00:00 ora_mmon_mydb1

oracle    1490     1  0 14:46 ?        00:00:00 ora_mmnl_mydb1

oracle    1491  1454  0 14:46 ?        00:00:00 oraclemydb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle    1495  6933  0 14:47 pts/1    00:00:00 ps -eaf

oracle    1496  6933  0 14:47 pts/1    00:00:00 grep oracle

root      6930  2475  0 10:59 ?        00:00:00 sshd: oracle [priv]

oracle    6932  6930  0 10:59 ?        00:00:00 sshd: oracle@pts/1

oracle    6933  6932  0 10:59 pts/1    00:00:00 -bash

root      7168  2475  0 11:20 ?        00:00:00 sshd: oracle [priv]

oracle    7170  7168  0 11:20 ?        00:00:00 sshd: oracle@pts/0

oracle    7171  7170  0 11:20 pts/0    00:00:00 -bash

[oracle@grid dbs]$

可以看到相关的进程都已经起来啦

建库

CREATE DATABASE "mydb1"

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

DATAFILE '/u01/oradata/mydb1/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/oradata/mydb1/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED

SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/mydb1/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED

SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/oradata/mydb1/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE 5G

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

LOGFILE 

GROUP 1 ('/u01/oradata/mydb1/redo01a.log') SIZE 400M,

GROUP 2 ('/u01/oradata/mydb1/redo02a.log') SIZE 400M,

GROUP 3 ('/u01/oradata/mydb1/redo03a.log') SIZE 400M

USER SYS IDENTIFIED BY "234561" USER SYSTEM IDENTIFIED BY "234561";

SQL> set timing on

SQL> 

SQL> CREATE DATABASE "mydb1"

  2  MAXINSTANCES 8

  3  MAXLOGHISTORY 1

  4  MAXLOGFILES 16

  5  MAXLOGMEMBERS 3

  6  MAXDATAFILES 100

  7  DATAFILE '/u01/oradata/mydb1/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL

  8  SYSAUX DATAFILE '/u01/oradata/mydb1/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED

  9  SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/mydb1/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED

 10  SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/oradata/mydb1/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE 5G

 11  CHARACTER SET ZHS16GBK

 12  NATIONAL CHARACTER SET AL16UTF16

 13  LOGFILE 

 14  GROUP 1 ('/u01/oradata/mydb1/redo01a.log') SIZE 400M,

 15  GROUP 2 ('/u01/oradata/mydb1/redo02a.log') SIZE 400M,

 16  GROUP 3 ('/u01/oradata/mydb1/redo03a.log') SIZE 400M

 17  USER SYS IDENTIFIED BY "234561" USER SYSTEM IDENTIFIED BY "234561";

Database created.

Elapsed: 00:01:20.71

SQL> 

运行脚本构造数据字典视图

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

@?/sqlplus/admin/pupbld.sql

@?/rdbms/admin/catalog.sql         

@?/rdbms/admin/catproc.sql          

@?/rdbms/admin/catblock.sql      

@?/rdbms/admin/dbmspool.sql    

SQL> select open_mode from v$database;

OPEN_MODE

----------

READ WRITE

1 row selected.

Elapsed: 00:00:00.00

SQL> 

查看有没有失效对象

SQL> select distinct status from dba_objects;

STATUS

-------

INVALID

VALID

2 rows selected.

Elapsed: 00:00:00.01

SQL> 

编译失效对象

SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP

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

COMP_TIMESTAMP UTLRP_BGN  2011-12-29 16:14:51

1 row selected.

Elapsed: 00:00:00.01

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid

DOC>   objects in the database. Recompilation time is proportional to the

DOC>   number of invalid objects in the database, so this command may take

DOC>   a long time to execute on a database with a large number of invalid

DOC>   objects.

DOC>

DOC>   Use the following queries to track recompilation progress:

DOC>

DOC>   1. Query returning the number of invalid objects remaining. This

DOC>      number should decrease with time.

DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

DOC>

DOC>   2. Query returning the number of objects compiled so far. This number

DOC>      should increase with time.

DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;

DOC>

DOC>   This script automatically chooses serial or parallel recompilation

DOC>   based on the number of CPUs available (parameter cpu_count) multiplied

DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).

DOC>   On RAC, this number is added across all RAC nodes.

DOC>

DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel

DOC>   recompilation. Jobs are created without instance affinity so that they

DOC>   can migrate across RAC nodes. Use the following queries to verify

DOC>   whether UTL_RECOMP jobs are being created and run correctly:

DOC>

DOC>   1. Query showing jobs created by UTL_RECOMP

DOC>         SELECT job_name FROM dba_scheduler_jobs

DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>

DOC>   2. Query showing UTL_RECOMP jobs that are running

DOC>         SELECT job_name FROM dba_scheduler_running_jobs

DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>#

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.91

TIMESTAMP

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

COMP_TIMESTAMP UTLRP_END  2011-12-29 16:14:52

1 row selected.

Elapsed: 00:00:00.00

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00

DOC> The following query reports the number of objects that have compiled

DOC> with errors (objects that compile with errors have status set to 3 in

DOC> obj$). If the number is higher than expected, please examine the error

DOC> messages reported with each object (using SHOW ERRORS) to see if they

DOC> point to system misconfiguration or resource constraints that must be

DOC> fixed before attempting to recompile these objects.

DOC>#

OBJECTS WITH ERRORS

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

                  0

1 row selected.

Elapsed: 00:00:00.01

DOC> The following query reports the number of errors caught during

DOC> recompilation. If this number is non-zero, please query the error

DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors

DOC> are due to misconfiguration or resource constraints that must be

DOC> fixed before objects can compile successfully.

DOC>#

ERRORS DURING RECOMPILATION

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

                          0

1 row selected.

Elapsed: 00:00:00.00

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

SQL> select distinct status from dba_objects;

STATUS

-------

VALID

1 row selected.

Elapsed: 00:00:00.01

SQL> 

SQL> select USERNAME,DEFAULT_TABLESPACE,to_char(CREATED,'yyyy-mm-dd hh24:mi:ss') time,ACCOUNT_STATUS from dba_users order by time;

USERNAME                       DEFAULT_TABLESPACE             TIME                ACCOUNT_STATUS

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

SYS                            SYSTEM                         2011-12-29 15:52:45 OPEN

SYSTEM                         SYSTEM                         2011-12-29 15:52:45 OPEN

OUTLN                          SYSTEM                         2011-12-29 15:52:47 OPEN

DIP                            SYSTEM                         2011-12-29 15:55:18 EXPIRED & LOCKED

TSMSYS                         SYSTEM                         2011-12-29 15:56:44 EXPIRED & LOCKED

DBSNMP                         SYSAUX                         2011-12-29 15:57:12 EXPIRED & LOCKED

ORACLE_OCM                     SYSTEM                         2011-12-29 15:57:14 EXPIRED & LOCKED

7 rows selected.

Elapsed: 00:00:00.01

SQL> 

SQL> select USERNAME,DEFAULT_TABLESPACE dt,to_char(CREATED,'yyyy-mm-dd hh24:mi:ss') time,ACCOUNT_STATUS from dba_users order by time;

USERNAME   DT         TIME                ACCOUNT_STATUS

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

SYS        SYSTEM     2011-12-29 15:52:45 OPEN

SYSTEM     SYSTEM     2011-12-29 15:52:45 OPEN

OUTLN      SYSTEM     2011-12-29 15:52:47 OPEN

DIP        SYSTEM     2011-12-29 15:55:18 EXPIRED & LOCKED

TSMSYS     SYSTEM     2011-12-29 15:56:44 EXPIRED & LOCKED

DBSNMP     SYSAUX     2011-12-29 15:57:12 EXPIRED & LOCKED

ORACLE_OCM SYSTEM     2011-12-29 15:57:14 EXPIRED & LOCKED

7 rows selected.

Elapsed: 00:00:00.00

SQL> 

做个全备，预防安装EM 12c中间又出错。

CONFIGURE RETENTION POLICY TO recovery window of 3 days;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rmanbk/cf-%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE to compressed backupset;
CONFIGURE channel 1 device type disk format '/u01/rmanbk/DB-%U';
CONFIGURE channel 2 device type disk format '/u01/rmanbk/DB-%U';



RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rmanbk/cf-%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/u01/rmanbk/DB-%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/u01/rmanbk/DB-%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/dbhome_1/dbs/snapcf_mydb1.f'; # default

RMAN> list backup;


RMAN> backup database include current controlfile tag "Before-full-bk";

数据库是非归档模式，重启到mount模式下备份全库。
backup database include current controlfile tag "Before-full-bk";



RMAN> backup database include current controlfile tag "Before-full-bk";

Starting backup at 29-DEC-11
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00003 name=/u01/oradata/mydb1/sysaux01.dbf
input datafile fno=00002 name=/u01/oradata/mydb1/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 29-DEC-11
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oradata/mydb1/system01.dbf
channel ORA_DISK_2: starting piece 1 at 29-DEC-11
channel ORA_DISK_2: finished piece 1 at 29-DEC-11
piece handle=/u01/rmanbk/DB-05mvehja_1_1 tag=BEFORE-FULL-BK comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 29-DEC-11
channel ORA_DISK_2: finished piece 1 at 29-DEC-11
piece handle=/u01/rmanbk/DB-06mvehjh_1_1 tag=BEFORE-FULL-BK comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 29-DEC-11
piece handle=/u01/rmanbk/DB-04mvehja_1_1 tag=BEFORE-FULL-BK comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:10
Finished backup at 29-DEC-11

Starting Control File and SPFILE Autobackup at 29-DEC-11
piece handle=/u01/rmanbk/cf-c-3845730394-20111229-00 comment=NONE
Finished Control File and SPFILE Autobackup at 29-DEC-11

RMAN>


RMAN> crosscheck backup;

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rmanbk/DB-05mvehja_1_1 recid=2 stamp=771180138
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rmanbk/DB-06mvehjh_1_1 recid=3 stamp=771180146
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rmanbk/DB-04mvehja_1_1 recid=4 stamp=771180138
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rmanbk/cf-c-3845730394-20111229-00 recid=5 stamp=771180148
Crosschecked 4 objects


RMAN>

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 3 days
Report of files that must be backed up to satisfy 3 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN>

RMAN> alter database open;

database opened

RMAN>






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

THE END......