Finished Control File and SPFILE Autobackup at15-MAY-14
database opened
RMAN> list backup;
RMAN> list copy;
RMAN> alter database open; //开库
RMAN>quit
（6）调整内存及数据文件大小
[oracle@rh55 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on ThuMay 15 17:38:44 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Miningoptions
17:38:45 SYS@ prod>select tablespace_name,sum(bytes/1024/1024)free_M from dba_free_space group by tablespace_name; //查看各表空间剩余量
17:43:37 SYS@ prod>col name for a50
17:40:13 SYS@ prod>select file#,name from v$datafile; //查看数据文件号
17:43:48 SYS@ prod>select file#,name,bytes/1024/1024 fromv$datafile;
//查看数据文件大小，根据上面查询出的表空间剩余空间对其进行相应调整
17:46:04 SYS@ prod>alter database datafile 1 resize 700m; //给system01.dbf扩容
17:47:09 SYS@ prod>alter database datafile 3 resize 400m; //给sysaux01.dbf扩容
17:47:44 SYS@ prod>alter database datafile 4 resize 50m; //给users01.dbf扩容
17:49:28 SYS@ prod>select file#,name,bytes/1024/1024 fromv$datafile;
//再次查看数据文件大小，这里因为undo启动了自动扩展功能，所以未对其进行扩容
17:50:22SYS@ prod>show parameter sga //查看sga设置情况
17:51:54 SYS@ prod>alter system set sga_max_size=600mscope=spfile; //修改sga最大值
17:53:40 SYS@ prod>alter system set sga_target=600m scope=spfile; //修改sga目标值
17:54:55 SYS@ prod>show parameter shared //查看各共享池尺寸
17:55:05 SYS@ prod>alter system set shared_pool_size=200mscope=spfile;//调整共享池尺寸
17:55:41 SYS@ prod>alter system set java_pool_size=300mscope=spfile;
//调整java池尺寸，此操作非必须，这么做是为了之后在执行数据字典升级脚本时加快速度
【补充】：报sga_target太小错误
17:56:14 SYS@prod>startupforce nomount;
//由于刚刚对sga进行了扩展，致使大小已经超出初始化文件中设定的sga大小，所以报此错误
[oracle@rh55 ~]$ cd $ORACLE_HOME/dbs
[oracle@rh55 dbs]$ ls
alert_prod.log c-199802235-20120822-04 init.ora orapwprod
alert_test1.log hc_catdb.dat initprod.ora snapcf_prod.f
c-199802235-20120812-1d hc_prod.dat lkCATDB spfileprod.ora
c-199802235-20120812-20 hc_test1.dat lkPROD
c-199802235-20120812-22 initdw.ora lkTEST1
[oracle@rh55 dbs]$ vi initprod.ora
补充完毕
[oracle@rh55 dbs]$ !sql
18:06:34 SYS@ prod>create spfile from pfile;
18:08:41 SYS@ prod>startup force nomount;
18:08:54 SYS@ prod>show parameter sga;
18:09:21 SYS@ prod>show parameter cache;
18:09:47 SYS@ prod>show parameter disp；
18:11:16 SYS@ prod>alter system set dispatchers='';
18:11:51 SYS@ prod>alter system set shared_servers=0;
18:12:17 SYS@ prod>shutdown;
18:12:47 SYS@ prod>exit
（7）查看监听状态
确保监听处于停止状态
[oracle@rh55 dbs]$ lsnrctl status //查看监听状态
//查看所有相关端口已经关闭
[oracle@rh55 dbs]$ netstat -an |grep 1521
[oracle@rh55 dbs]$ netstat -an |grep 1158
[oracle@rh55 dbs]$ netstat -an |grep 5500
2、 升级oracle软件
运行补丁包中的./runInstaller文件，参考如下图所示：
下面 报错了，如下图：
重启虚拟机，再次执行以上操作，不在弹出错误提示，进入如下界面：
[root@rh55 ~]# /u01/app/oracle/product/10.2.0/db_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/db_1
Enter the full pathname of the local bindirectory: [/usr/local/bin]:
The file "dbhome" already exists in/usr/local/bin. Overwrite it (y/n)
[n]: y
Copyingdbhome to /usr/local/bin ...
The file "oraenv" already exists in/usr