Wednesday, May 2, 2012

Silent upgrade of database from 11.2.0.2.0 to 11.2.0.3.0

A few days ago i upgraded a database form version 11.2.0.2 to 11.2.0.3
For the first time i used the silent upgrade methode
After that i've also adjust things for Oracle restart.

First the silent install:.
export ORACLE_HOME=/oracle/home/11.2.0.3.0
export PATH=$ORACLE_HOME/bin:$PATH

ota5013#NGL451T1>>/oracle>dbua -silent -sid NGL451T1
Log files for the upgrade operation are located at: /oracle/home/cfgtoollogs/dbua/NGL451T/upgrade1
Performing Pre Upgrade
1% complete
7% complete
Upgrading Oracle Server
8% complete
9% complete
10% complete
10% complete
11% complete
12% complete
13% complete
13% complete
14% complete
15% complete
16% complete
16% complete
17% complete
18% complete
19% complete
20% complete
20% complete
21% complete
22% complete
Upgrading JServer JAVA Virtual Machine
23% complete
24% complete
25% complete
26% complete
26% complete
Upgrading Oracle XDK for Java
28% complete
Upgrading Oracle Text
30% complete
30% complete
31% complete
Upgrading Oracle XML Database
33% complete
33% complete
34% complete
Upgrading Oracle Java Packages
36% complete
Upgrading Oracle interMedia
37% complete
38% complete
Upgrading EM Repository
40% complete
40% complete
41% complete
42% complete
43% complete
43% complete
44% complete
45% complete
46% complete
46% complete
47% complete
48% complete
49% complete
50% complete
50% complete
51% complete
52% complete
53% complete
53% complete
54% complete
55% complete
56% complete
56% complete
57% complete
58% complete
Upgrading Oracle Text
60% complete
60% complete
61% complete
62% complete
63% complete
63% complete
Upgrading Oracle XML Database
65% complete
66% complete
66% complete
67% complete
Upgrading Oracle Java Packages
69% complete
70% complete
Upgrading Oracle interMedia
71% complete
72% complete
73% complete
73% complete
74% complete
Upgrading Spatial
76% complete
76% complete
77% complete
78% complete
79% complete
80% complete
80% complete
81% complete
82% complete
83% complete
83% complete
84% complete
Upgrading Oracle Workspace Manager
Upgrading Expression Filter
Upgrading Rule Manager
Upgrading Oracle Application Express
Upgrading Oracle OLAP API
Performing Post Upgrade
85% complete
86% complete
92% complete
Generating Summary
Database upgrade has been completed successfully, and the database is ready to use.
100% complete

Now for Oracle restart to work properly for this database do the following

ota5013#NGL451T1>>/oracle>srvctl config database -d NGL451T

Database unique name: NGL451T
Database name: NGL451T1
Oracle home: /oracle/home/11.2.0.2.0
Oracle user: grid
Spfile: +DATA/spfileNGL451T.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,FRA
Services:

Now modify the database
ota5013#NGL451T1>>/oracle> srvctl modify database -d NGL451T -o /oracle/home/11.2.0.3.0

ota5013#NGL451T1>>/oracle> srvctl config database -d NGL451T
Database unique name: NGL451T
Database name: NGL451T1
Oracle home: /oracle/home/11.2.0.3.0
Oracle user: grid
Spfile: +DATA/spfileNGL451T.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,FRA
Services:

change in /etc/oratab the oracle home
NGL451T1:/oracle/home/11.2.0.3.0:N

ota5013#NGL451T1>>/oracle>srvctl upgrade database -d NGL451T -o /oracle/home/11.2.0.3.0
This to prevent the oratab to be overwritten with the old oracle home of this database.

Now your done database is upgraded and oracle restart still works for this database.

No comments:

Post a Comment