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.
