This content has been marked as final. Show 6 replies
redologger wrote:Yes - starting with 184.108.40.206, patchsets are not patchsets, but complete installs - you can install 220.127.116.11 and 18.104.22.168 directly - see this MOS Doc
just feeling confuse from all the read up notes on upgrading from 22.214.171.124 - 126.96.36.199.
The part where it mention that on the target database, one have to:
1. download and install oracle 11g r2 in a new oracle home. and make sure there are no relinking errors.
My question here is,
- does it refer using the 11g r2 installer? and with that i install a new oracle binaries on a new Oracle home.
Important Changes to Oracle Database Patch Sets Starting With 188.8.131.52 [ID 1189783.1]
My confusion starts here:Ideally you should download and unzip all 7 files - but I believe for database only install, the first two zip files are sufficient.
i download the patchset which contain 7 separate files. If i am not wrong , 1of7 and 2of7 can be use as the ' full installation'? I don't really understand the README file.
If i am wrong about the patchset , then where does these files come to use during the upgrading process?Yes - pl see upgrade documentation - http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm
2. the part where one invoke DBUA to upgrade the database is from the new oracle home /bin right?
I don't see anywhere on the upgrading process where these patchset i have downloaded to be use in any part.Pl also see these MOS Docs
Complete Checklist to Upgrade the Database to 11gR2 using DBUA [ID 870814.1]
Things to Consider Before Upgrading to 184.108.40.206 to Avoid Poor Performance or Wrong Results [ID 1392633.1]
If you unzip the 7 files, the following would be the directory structure
bash-3.2$ ls -ltr
drwxr-xr-x 20 oracle dba 4096 Sep 22 2011 deinstall
drwxr-xr-x 8 oracle dba 4096 Sep 22 2011 grid
drwxr-xr-x 7 oracle dba 4096 Sep 22 2011 gateways
drwxr-xr-x 6 oracle dba 4096 Sep 22 2011 examples
drwxr-xr-x 8 oracle dba 4096 Sep 22 2011 database
drwxr-xr-x 6 oracle dba 4096 Sep 22 2011 client
p10404530_112030_platform_1of7.zip & p10404530_112030_platform_2of7.zip are for rdbms/database level
p10404530_112030_platform_3of7.zip- -for oracle ASM,oracle restart
Starting from 220.127.116.11 , oracle recommends Out of Place upgrade. After unzipping the files go to database folder
bash-3.2$ cd database
bash-3.2$ ls -ltr
-rwxr-xr-x 1 oracle dba 5466 Aug 23 2011 welcome.html
drwxr-xr-x 12 oracle dba 4096 Sep 18 2011 doc
-rwxr-xr-x 1 oracle dba 3226 Sep 22 2011 runInstaller
drwxr-xr-x 2 oracle dba 4096 Sep 22 2011 rpm
drwxr-xr-x 2 oracle dba 4096 Sep 22 2011 response
drwxr-xr-x 4 oracle dba 4096 Sep 22 2011 install
drwxr-xr-x 14 oracle dba 4096 Sep 22 2011 stage
drwxr-xr-x 2 oracle dba 4096 Sep 22 2011 sshsetup
-rwxr-xr-x 1 oracle dba 28122 Sep 22 2011 readme.html
Invoke the runInstaller and install the 18.104.22.168
To upgrade the database:
export ORACLE_HOME=<22.214.171.124 Home path>
type dbua----it should pick from 126.96.36.199 home
dbua -silent -sid <sidname>
Yes ,188.8.131.52 and 184.108.40.206 are complete installs - they are not patchsets - see MOS Doc 1189783.1 reference above.
Install 220.127.116.11, apply the latest PSU on top, then run DBUA to upgrade
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch [ID 865255.1]
Oracle Database Upgrade Path Reference List [ID 730365.1]
Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]