Wednesday, August 31, 2011

Upgrade database 11.2.0.1.0 to 11.2.0.2.0 : dbua -silent

Nothing today - just need to tested "dbua -silent" - Upgrading Oracle Database from 11.2.0.1.0 to 11.2.0.2.0 -)
/u01/app/oracle/11.2.0/dbhome_old Home for 11.2.0.1.0
/u01/app/oracle/11.2.0/dbhome_1 Home for 11.2.0.2.0
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 Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

$ cat /etc/oratab
+ASM:/u01/app/oracle/11.2.0/grid:N # line added by Agent
orcl:/u01/app/oracle/11.2.0/dbhome_old:N

$ export ORACLE_HOME=/u01/app/oracle/11.2.0/dbhome_1
$ export PATH=$ORACLE_HOME/bin:$PATH
$ type dbua
dbua is /u01/app/oracle/11.2.0/dbhome_1/bin/dbua
$ dbua -silent -sid orcl
Log files for the upgrade operation are located at: /u01/app/oracle/cfgtoollogs/dbua/ORCL/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
23% complete
23% complete
24% complete
25% complete
26% complete
26% complete
27% complete
Upgrading JServer JAVA Virtual Machine
29% complete
30% complete
30% complete
31% complete
Upgrading Oracle XDK for Java
33% complete
Upgrading OLAP Analytic Workspace
34% complete
35% complete
Upgrading OLAP Catalog
36% complete
37% complete
38% complete
39% complete
40% complete
40% complete
Upgrading EM Repository
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
Upgrading Oracle Text
58% complete
59% complete
60% complete
60% complete
61% complete
62% complete
63% complete
63% complete
64% complete
Upgrading Oracle XML Database
66% complete
66% complete
67% complete
68% complete
Upgrading Oracle Java Packages
70% complete
70% complete
Upgrading Oracle interMedia
72% complete
73% complete
73% complete
74% complete
75% complete
Upgrading Spatial
76% complete
77% complete
78% complete
Upgrading Oracle Workspace Manager
80% complete
Upgrading Expression Filter
81% complete
Upgrading Rule Manager
83% complete
83% complete
Upgrading Oracle Application Express
84% complete
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
Check the log file "/u01/app/oracle/cfgtoollogs/dbua/logs/silent.log" for upgrade details.
During "dbua", You can check "Oracle_Server.log" file in /u01/app/oracle/cfgtoollogs/dbua/ORCL/upgrade1 PATH. After upgraded!!! Reviewed in /u01/app/oracle/cfgtoollogs/dbua/logs/silent.log file.

- Checked
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

$ cat /etc/oratab
+ASM:/u01/app/oracle/11.2.0/grid:N # line added by Agent
orcl:/u01/app/oracle/11.2.0/dbhome_1:N # line added by Agent
How in Grid Infrastructure???
$ crsctl stat res ora.orcl.db -p
NAME=ora.orcl.db
TYPE=ora.database.type
ACL=owner:grid:--x,pgrp:asmdba:--x,other::r--,group:oinstall:r-x,user:oracle:rwx
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
CHECK_TIMEOUT=600
CLUSTER_DATABASE=false
DATABASE_TYPE=SINGLE
DB_UNIQUE_NAME=orcl
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)
DEGREE=1
DESCRIPTION=Oracle Database resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=
GEN_START_OPTIONS=
GEN_USR_ORA_INST_NAME=
HOSTING_MEMBERS=
INSTANCE_FAILOVER=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/11.2.0/dbhome_1
PLACEMENT=balanced
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=2
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_POOLS=
SPFILE=+DATA/orclold/spfileorclold.ora
START_DEPENDENCIES=hard(ora.DATA.dg) weak(type:ora.listener.type,uniform:ora.ons) pullup(ora.DATA.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg)
STOP_TIMEOUT=600
TYPE_VERSION=2.2
UPTIME_THRESHOLD=1h
USR_ORA_DB_NAME=
USR_ORA_DOMAIN=
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_INST_NAME=orcl
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
VERSION=11.2.0.2.0
Related Posts:
struggle to Upgrade Oracle Database 11.2.0.1 to 11.2.0.2
Just upgrade Oracle Database 10gR2 to 11gR2 by command-line
Just Step to upgrade (RAC) 10.2.0.4 to 11.1.0.6
Creating Database 11gR1 on ASM 11gR2


No comments: