Oracle10201升级到10202

简单记录Solaris平台下Oracle10.2.0.1的升级到10.2.0.2的过程。

首先解开Oracle的PATCH包：

$ unzip p4547817_10202_SOLARIS64.zip

然后停止所有的ORACLE进程：

关闭数据库：

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 12月 7 20:29:09 2006

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

停止LISTENER：

$ lsnrctl stop

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 07-12月-2006 20:30:34

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully

停止Oracle Enterprise Manager:

$ emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://data2:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.

检查进程，确认没有oracle的进程存在：

$ ps -ef|grep ora
oracle 5012 5010 0 20:35:05 pts/1 0:00 -sh
oracle 5016 5012 0 20:35:12 pts/1 0:00 grep ora

下面就可以进入安装目录，开始安装：

$ cd Disk1
$ ./runInstaller

安装过程没有什么值得一提的，点击几个NEXT就一切OK了。

最后使用root身份执行/data/oracle/oracle1020/produt/10.2.0/root.sh。

IXDBA.NET技术社区

下面启动listener，并以sysdba身份登陆数据库：

$ lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 07-12月-2006 21:11:38

Starting /data/oracle/oracle1020/product/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
System parameter file is /data/oracle/oracle1020/product/10.2.0/network/admin/listener.ora
Log messages written to /data/oracle/oracle1020/product/10.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=data2)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
Start Date 07-12月-2006 21:11:38
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data/oracle/oracle1020/product/10.2.0/network/admin/listener.ora
Listener Log File /data/oracle/oracle1020/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=data2)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).