安装前检测:
1.内存检测,至少1G,oracle建议2G以上:
# /usr/sbin/lsattr -E -l sys0 -a realmem
realmem 4194304 Amount of usable physical memory in Kbytes False
2.查看swap大小,至少要等于内存的大小:
# /usr/sbin/lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type Chksum
hd6 hdisk0 rootvg 5632MB 1 yes yes lv 0
3.查看系统架构,需要64位的,oracle对AIX不支持32位的:
# /usr/bin/getconf HARDWARE_BITMODE
64
查看系统内核架构:
# bootinfo -K
64
# getconf KERNEL_BITMODE
64
4.查看/tmp目录的可用空间,11g安装要求/tmp至少1G可用空间:
# df -k /tmp
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd3 5242880 4457096 15% 2779 1% /tmp
5.查看操作系统版本,决定检测需要安装的软件包:
# oslevel -s
6100-06-06-1140
6.我们的操作系统时AIX6.1的,需要检测是否安装以下安装包:
lslpp -l bos.adt.base \
bos.adt.lib \
bos.adt.libm \
bos.perf.libperfstat \
bos.perf.perfstat \
bos.perf.proctools \
xlC.aix61.rte \
xlC.rte \
gpfs.base
# lslpp -l bos.adt.base \
bos.adt.lib \
bos.adt.libm \
bos.perf.libperfstat \
bos.perf.perfstat \
bos.perf.proctools \
xlC.aix61.rte \
xlC.rte \
gpfs.base> > > > > > > >
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.adt.base 6.1.6.16 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.16 COMMITTED Performance Statistics Library
Interface
bos.perf.perfstat 6.1.6.16 COMMITTED Performance Statistics
Interface
bos.perf.proctools 6.1.6.16 COMMITTED Proc Filesystem Tools
xlC.aix61.rte 11.1.0.1 COMMITTED XL C/C++ Runtime for AIX 6.1
xlC.rte 11.1.0.1 COMMITTED XL C/C++ Runtime
Path: /etc/objrepos
bos.adt.base 6.1.6.16 COMMITTED Base Application Development
Toolkit
bos.perf.libperfstat 6.1.6.16 COMMITTED Performance Statistics Library
Interface
bos.perf.perfstat 6.1.1.0 COMMITTED Performance Statistics
Interface
lslpp: 0504-132 Fileset gpfs.base not installed.
gpfs可以忽略。
7.检测APAR是否安装(这个可以忽略):
# /usr/sbin/instfix -i -k "IZ42940 IZ49516 IZ52331 IZ41855 IZ52319"
There was no data for IZ42940 in the fix database.
There was no data for IZ49516 in the fix database.
There was no data for IZ52331 in the fix database.
There was no data for IZ41855 in the fix database.
There was no data for IZ52319 in the fix database.
8.检查网络环境-主机名:
# hostname
aix201
9.检查网络环境-/etc/hosts主机名和ip映射关系:
cat /etc/hosts
127.0.0.1 loopback localhost # loopback (lo0) name/address
192.168.1.201 aix201
10.查看系统中是否已经存在oinstall组:
# more /etc/oraInst.loc
inventory_loc=/oracle/app/oracle/oraInventory
inst_group=oinstall
说明已经存在oinstall组。注意,上面这个文件存在的话也需要删除,否在无法安装新的oracle软件。
# grep dba /etc/group
dba:!:2201:oracle1,oracle03,oracle01,oracle2,oracle8,oracle13,oracle
dba组也已经存在。
这两个组都已经存在,如果不存在就需要创建,smitty security创建。
11.创建oracle用户:
查看是否有oracle用户:
# id oracle
uid=3003(oracle) gid=2203(oinstall) groups=2201(dba)
这里已经存在oracle且主组是oinstall,附属组dba。我们再创建一个其他名称的oracle用户oracle02如下:
# id oracle02
uid=4004(oracle02) gid=2203(oinstall) groups=2201(dba)
修改oracle用户密码:
su - oracle02
passwd oracle02
12.配置shell limit和system limit:
a.配置shell limit
smitty chuser (输入oracle用户然后将soft的选项全选成-1)配置完后查看会显示如下:
# ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user) unlimited
b.配置system limit
oracle的建议的最小值:
maxuprocs 16384
ncargs 128
chgsys修改:
Maximum number of PROCESSES allowed per user [16384]
ARG/ENV list size in 4K byte blocks [256]
13.检查异步IO:
AIX 6.1:
# ioo –o aio_maxreqs
aio_maxreqs = 65536
On AIX 5.3:
# lsattr -El aio0 -a maxreqs
maxreqs 65536 Maximum number of REQUESTS True
14.创建相关的目录:
oracle建议目录结构如下:
# mkdir -p /mount_point/app/
# chown -R oracle:oinstall /mount_point/app/
# chmod -R 775 /mount_point/app/
我们这里创建/u02/app目录:
a.创建一个vg,包含两块盘,一块用来安装oracle11g软件,一块用来创建裸设备建库,如下:
# smitty mkvg
# lsvg -p ora11gvg
ora11gvg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk2 active 79 79 16..16..15..16..16
hdisk9 active 79 79 16..16..15..16..16
b.用hdisk2创建lv和文件系统用来安装oracle11g软件:
# smitty mklv
# smitty crsf
# lsvg -l ora11gvg
ora11gvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
ora11glv jfs2 79 79 1 closed/syncd /u02
loglv00 jfs2log 1 1 1 closed/syncd N/A
c.挂载文件系统:
# mount /u02
# mount
node mounted mounted over vfs date options
-------- --------------- --------------- ------ ------------ ---------------
/dev/hd4 / jfs2 Aug 10 09:46 rw,log=/dev/hd8
/dev/hd2 /usr jfs2 Aug 10 09:46 rw,log=/dev/hd8
/dev/aix10glv /u99 jfs2 Aug 10 09:47 rw,log=/dev/loglv03
/dev/ora10glv /oracle jfs2 Aug 10 09:47 rw,log=/dev/loglv05
/dev/lvnfs /lvnfs jfs2 Aug 10 09:47 rw,log=/dev/loglv01
/dev/ora11glv /u02 jfs2 Aug 10 13:39 rw,log=/dev/loglv00
d.创建目录:
mkdir -p /u02/app/oracle/product/11.2.0/db_1
chown -R oracle02:oinstall /u02/app/oracle/product/11.2.0/db_1
chmod -R 755 /u02/app/oracle/product/11.2.0/db_1
15.配置oracle用户环境变量:
su - oracle02
vi .profile
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
. ./.profile生效一下。
$ cd $ORACLE_HOME
$ pwd
/u02/app/oracle/product/11.2.0/db_1
16.上传安装介质并解压:
root上传完11.2.0.1安装介质如下:
# ls -l
total 5434856
-rw-r----- 1 root system 2782640777 Aug 10 14:05 database.tar
# pwd
/soft
这个包当时是root用户打的,先用root用户解包:
# ls -l
total 5435472
-rw-r----- 1 root system 2782955520 Aug 10 14:27 database.tar
# tar -xvf database.tar
解压之后:
# ls -l
total 5435480
drwxr-xr-x 9 oracle1 oinstall 4096 Apr 27 2012 database
-rw-r----- 1 root system 2782955520 Aug 10 14:27 database.tar
然后改变属主和权限:
# chown -R oracle02:oinstall /soft
# chmod -R 755 /soft
17.oracle用户登录图形界面进行安装:
登录图形界面后先修改/home/oracle02/.dtprofile文件成下面这样:
. /etc/profile
DTSOURCEPROFILE=true
然后重新登录图形界面,否则oracle02的.profile文件默认不会被读取,无法获得环境变量。
$ pwd
/soft/database
$ ls -l
total 104
drwxr-xr-x 12 oracle02 oinstall 4096 Apr 27 2012 doc
drwxr-xr-x 4 oracle02 oinstall 4096 Apr 27 2012 install
-rwxr-xr-x 1 oracle02 oinstall 0 Apr 27 2012 nohup.out
drwxr-xr-x 2 oracle02 oinstall 256 Apr 27 2012 response
drwxr-xr-x 3 oracle02 oinstall 256 Apr 27 2012 rootpre
-rwxr-xr-x 1 oracle02 oinstall 22753 Apr 27 2012 rootpre.sh
drwxr-xr-x 2 oracle02 oinstall 256 Apr 27 2012 rpm
-rwxr-xr-x 1 oracle02 oinstall 7046 Apr 27 2012 runInstaller
drwxr-xr-x 2 oracle02 oinstall 256 Apr 27 2012 sshsetup
drwxr-xr-x 14 oracle02 oinstall 4096 Apr 27 2012 stage
-rwxr-xr-x 1 oracle02 oinstall 5406 Apr 27 2012 welcome.html
运行./runInstaller安装。
提示是否运行rootpre.sh,root运行脚本rootpre.sh后继续。
值安装数据库软件。
$ sqlplus -version
SQL*Plus: Release 11.2.0.1.0 Production
至此,oracle11.2.0.1数据库软件已经安装成功,下面进行在裸设备上手动建库。oracle11g已经不支持裸设备,因此只能手动建库。
18.建立需要的目录:
adump 审计信息,放置审计文件
bdump 放置后台进程的trace文件和alert log ,就是说 alert_sid.log也存在这个目录中
cdump core dump 当数据库崩溃的时候,把内存结构生成dump,cdump有文件肯定是大文件。一般是用来日志应用程序的除非数据库出了问题 否则基本上不会有什么信息
dpdump 存放一些登录信息
udump server process出问题的trace文件,前台手动trace的 比如sql trace之后session的trace文件
pfile 是个空文件,只有一句话,是指向spfile的。真正的目录在$ORACLE_HOME/dbs
rm -rf $ORACLE_BASE/admin/$ORACLE_SID
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/bdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/cdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/dpdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/udump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/scripts
chmod -R 750 $ORACLE_BASE/admin
rm -rf $ORACLE_BASE/diag/rdbms/$ORACLE_SID
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/alert
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/cdump
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/hm
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/incident
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/incpkg
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/ir
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/lck
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/metadata
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/stage
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/sweep
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace
chmod -R 750 $ORACLE_BASE/diag/rdbms/$ORACLE_SID
19.创建裸设备(实验环境就不单独创建vg了,这里还是利用了之前的vg):
mklv -y ora11_system01 -T O -w n -t raw -s n -r n ora11gvg 10
mklv -y ora11_sysaux01 -T O -w n -t raw -s n -r n ora11gvg 8
mklv -y ora11_undotbs01 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_temp01 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_users01 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_redo01 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_redo02 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_redo03 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_control01 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_control02 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_control03 -T O -w n -t raw -s n -r n ora11gvg 1
mklv -y ora11_spfile -T O -w n -t raw -s n -r n ora11gvg 1
创建完后如下:
# lsvg -l ora11gvg
ora11gvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
ora11glv jfs2 79 79 1 open/syncd /u02
loglv00 jfs2log 1 1 1 open/syncd N/A
ora11_system01 raw 10 10 1 closed/syncd N/A
ora11_sysaux01 raw 8 8 1 closed/syncd N/A
ora11_undotbs01 raw 1 1 1 closed/syncd N/A
ora11_temp01 raw 1 1 1 closed/syncd N/A
ora11_users01 raw 1 1 1 closed/syncd N/A
ora11_redo01 raw 1 1 1 closed/syncd N/A
ora11_redo02 raw 1 1 1 closed/syncd N/A
ora11_redo03 raw 1 1 1 closed/syncd N/A
ora11_control01 raw 1 1 1 closed/syncd N/A
ora11_control02 raw 1 1 1 closed/syncd N/A
ora11_control03 raw 1 1 1 closed/syncd N/A
ora11_spfile raw 1 1 1 closed/syncd N/A
# lsvg -p ora11gvg
ora11gvg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk2 active 79 0 00..00..00..00..00
hdisk9 active 79 50 03..00..15..16..16
20.改变裸设备对应的属主,组及权限:
chown -R oracle02:oinstall /dev/rora11_*
chmod -R 660 /dev/rora11_*
改后如下:
# ls -l /dev/rora11_*
crw-rw---- 1 oracle02 oinstall 39, 11 Aug 10 15:32 /dev/rora11_control01
crw-rw---- 1 oracle02 oinstall 39, 12 Aug 10 15:32 /dev/rora11_control02
crw-rw---- 1 oracle02 oinstall 39, 13 Aug 10 15:32 /dev/rora11_control03
crw-rw---- 1 oracle02 oinstall 39, 8 Aug 10 15:32 /dev/rora11_redo01
crw-rw---- 1 oracle02 oinstall 39, 9 Aug 10 15:32 /dev/rora11_redo02
crw-rw---- 1 oracle02 oinstall 39, 10 Aug 10 15:32 /dev/rora11_redo03
crw-rw---- 1 oracle02 oinstall 39, 14 Aug 10 15:32 /dev/rora11_spfile
crw-rw---- 1 oracle02 oinstall 39, 4 Aug 10 15:31 /dev/rora11_sysaux01
crw-rw---- 1 oracle02 oinstall 39, 3 Aug 10 15:31 /dev/rora11_system01
crw-rw---- 1 oracle02 oinstall 39, 6 Aug 10 15:32 /dev/rora11_temp01
crw-rw---- 1 oracle02 oinstall 39, 5 Aug 10 15:31 /dev/rora11_undotbs01
crw-rw---- 1 oracle02 oinstall 39, 7 Aug 10 15:32 /dev/rora11_users01
21.创建密码文件:
$ orapwd file=$ORACLE_HOME/dbs/orapworcl2 password=oracle force=y entries=5
22.创建一个文本格式的参数文件:
$ cd $ORACLE_HOME/dbs
$ ls -l
total 8
-rw-r--r-- 1 oracle02 oinstall 2851 May 15 2009 init.ora
$ pwd
/u02/app/oracle/product/11.2.0/db_1/dbs
vi initorcl2.ora写入以下参数:
*.audit_file_dest='/u02/app/oracle/admin/orcl2/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/dev/rora11_control01','/dev/rora11_control02','/dev/rora11_control03'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl2'
*.diagnostic_dest='/u02/app/oracle'
*.memory_target=858783744
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
$ cd $ORACLE_HOME/dbs
$ ls
hc_orcl2.dat init.ora initorcl2.ora lkORCL2 orapworcl2
$ vi initorcl2.ora
spfile=/dev/rora11_spfile
SQL> create spfile='/dev/rora11_spfile' from pfile; --(会自动读取pfile:$ORACLE_HOME/dbs/init$ORACLE_SID.ora)
File created.
SQL>
以下两步可以忽略:
获取trace文件路径:
select c.value || '/' || d.instance_name || '_ora_' || a.spid || '.trc' trace
from v$process a, v$session b, v$parameter c, v$instance d
where a.addr = b.paddr
and b.audsid = userenv('sessionid')
and c.name = 'user_dump_dest';
获取控制文件的trace:
SQL> alter database backup controlfile to trace;
23.跑脚本手工建库:
手工创建:
SQL> create database orcl2 CONTROLFILE REUSE
MAXINSTANCES 8
MAXDATAFILES 2000
MAXLOGHISTORY 1024
MAXLOGFILES 64
MAXLOGMEMBERS 4
character set ZHS16GBK national character set AL16UTF16
logfile group 1 ('/dev/rora11_redo01') size 50M reuse,
group 2 ('/dev/rora11_redo02') size 50M reuse,
group 3 ('/dev/rora11_redo03') size 50M reuse
datafile '/dev/rora11_system01' size 1000M reuse extent management local
sysaux datafile '/dev/rora11_sysaux01' size 800M
default temporary tablespace temp tempfile '/dev/rora11_temp01' size 100M reuse
undo tablespace undotbs1 datafile '/dev/rora11_undotbs01' size 126M reuse
USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle";
24. 运行数据字典脚本,其中catalog和catproc是必需的,其它可选:
SQL> spool /home/oracle02/cat_orcl2.log
SQL> @?/rdbms/admin/catalog.sql ; (建数据字典视图)
SQL> @?/rdbms/admin/catproc.sql ; (建存储过程包)
SQL> @?/rdbms/admin/catblock.sql ; (建锁相关的几个视图)
SQL> @?/rdbms/admin/catoctk.sql ; (建密码工具包dbms_crypto_toolkit)
SQL> @?/rdbms/admin/owminst.plb ; (建工作空间管理相关对象,如dmbs_wm)
SQL> spool off
执行完后检查/orahome/cat.log看看有什么不可接受的错误没有。
25. 新建sqlplus属性和帮助、USERS表空间
SQL> connect system/oracle
SQL> @?/sqlplus/admin/pupbld.sql
SQL> @?/sqlplus/admin/help/hlpbld.sql helpus.sql
SQL> connect /as sysdba
SQL> CREATE TABLESPACE USERS LOGGING DATAFILE '/dev/rora11_users01' SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
SQL> ALTER DATABASE DEFAULT TABLESPACE USERS;
# mklv -y ora11_users02 -T O -w n -t raw -s n -r n ora11gvg 1
# chown oracle02:oinstall /dev/rora11_users02
查看数据库是否正常:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 10 17:07:37 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 855982080 bytes
Fixed Size 2211584 bytes
Variable Size 545259776 bytes
Database Buffers 301989888 bytes
Redo Buffers 6520832 bytes
Database mounted.
Database opened.
SQL>
SQL> !
$ ps -ef | grep smon
oracle02 6750408 7077952 0 17:08:40 pts/1 0:00 grep smon
oracle02 8060946 1 0 17:07:42 - 0:00 ora_smon_orcl2
$ ps -ef | grep orcl2
oracle02 4063366 1 0 17:07:42 - 0:00 ora_lgwr_orcl2
oracle02 4980968 8192034 0 16:04:31 - 0:00 oracleorcl2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle02 5374162 5963810 0 17:07:47 - 0:01 oracleorcl2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle02 5767422 1 0 17:08:00 - 0:00 ora_q001_orcl2
oracle02 6160612 1 0 17:07:41 - 0:00 ora_dbw0_orcl2
oracle02 6291494 7077952 0 17:08:57 pts/1 0:00 grep orcl2
oracle02 6357144 1 0 17:07:52 - 0:00 ora_cjq0_orcl2
oracle02 6946874 1 0 17:08:00 - 0:00 ora_q000_orcl2
oracle02 7012598 1 0 17:07:41 - 0:00 ora_dia0_orcl2
oracle02 7143540 1 0 17:07:41 - 0:00 ora_dbrm_orcl2
oracle02 7536722 1 0 17:07:41 - 0:00 ora_diag_orcl2
oracle02 7602242 1 0 17:07:41 - 0:00 ora_mman_orcl2
oracle02 7667724 1 0 17:07:41 - 0:00 ora_psp0_orcl2
oracle02 7733340 1 0 17:07:41 - 0:00 ora_vktm_orcl2
oracle02 7864444 1 0 17:07:41 - 0:00 ora_pmon_orcl2
oracle02 8060946 1 0 17:07:42 - 0:00 ora_smon_orcl2
oracle02 8126688 1 0 17:07:42 - 0:00 ora_reco_orcl2
oracle02 8388840 1 0 17:07:49 - 0:00 ora_qmnc_orcl2
oracle02 8454268 1 0 17:07:42 - 0:00 ora_mmnl_orcl2
oracle02 8519868 1 0 17:07:42 - 0:00 ora_ckpt_orcl2
oracle02 8781958 1 0 17:07:42 - 0:00 ora_mmon_orcl2
oracle02 8847448 1 0 17:07:41 - 0:00 ora_gen0_orcl2
$ ls -l /dev/rora11_*
crw-rw---- 1 oracle02 oinstall 39, 11 Aug 10 16:13 /dev/rora11_control01
crw-rw---- 1 oracle02 oinstall 39, 12 Aug 10 16:13 /dev/rora11_control02
crw-rw---- 1 oracle02 oinstall 39, 13 Aug 10 16:13 /dev/rora11_control03
crw-rw---- 1 oracle02 oinstall 39, 8 Aug 10 17:07 /dev/rora11_redo01
crw-rw---- 1 oracle02 oinstall 39, 9 Aug 10 17:07 /dev/rora11_redo02
crw-rw---- 1 oracle02 oinstall 39, 10 Aug 10 17:07 /dev/rora11_redo03
crw-rw---- 1 oracle02 oinstall 39, 14 Aug 10 17:07 /dev/rora11_spfile
crw-rw---- 1 oracle02 oinstall 39, 4 Aug 10 16:13 /dev/rora11_sysaux01
crw-rw---- 1 oracle02 oinstall 39, 3 Aug 10 16:13 /dev/rora11_system01
crw-rw---- 1 oracle02 oinstall 39, 6 Aug 10 16:13 /dev/rora11_temp01
crw-rw---- 1 oracle02 oinstall 39, 5 Aug 10 16:13 /dev/rora11_undotbs01
crw-rw---- 1 oracle02 oinstall 39, 7 Aug 10 17:06 /dev/rora11_users01
crw-rw---- 1 oracle02 oinstall 39, 15 Aug 10 17:03 /dev/rora11_users02
$ lsvg -l ora11gvg
ora11gvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
ora11glv jfs2 79 79 1 open/syncd /u02
loglv00 jfs2log 1 1 1 open/syncd N/A
ora11_system01 raw 10 10 1 open/syncd N/A
ora11_sysaux01 raw 8 8 1 open/syncd N/A
ora11_undotbs01 raw 1 1 1 open/syncd N/A
ora11_temp01 raw 1 1 1 open/syncd N/A
ora11_users01 raw 1 1 1 open/syncd N/A
ora11_redo01 raw 1 1 1 open/syncd N/A
ora11_redo02 raw 1 1 1 open/syncd N/A
ora11_redo03 raw 1 1 1 open/syncd N/A
ora11_control01 raw 1 1 1 open/syncd N/A
ora11_control02 raw 1 1 1 open/syncd N/A
ora11_control03 raw 1 1 1 open/syncd N/A
ora11_spfile raw 1 1 1 closed/syncd N/A
ora11_users02 raw 1 1 1 closed/syncd N/A
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------ ---
1 ONLINE /dev/rora11_redo01 NO
2 ONLINE /dev/rora11_redo02 NO
3 ONLINE /dev/rora11_redo03 NO
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /dev/rora11_control01, /dev/ro
ra11_control02, /dev/rora11_co
ntrol03
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/dev/rora11_system01
/dev/rora11_sysaux01
/dev/rora11_undotbs01
/dev/rora11_users01
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
安装完毕。