I'm new to oracle, but I'm looking to upgrade an existing oracle database 11.2.0.1 to 11.2.0.2. Can anyone tell me if this will require wiping my existing database or will it remain intact? Thanks in advance.
–Adam
Database – upgrade Oracle 11g 11.2.0.1 to 11.2.0.2 and keep the database intact
databaseoracleoracle-11g
Related Topic
- What’s the difference between instance and server process in Oracle database
- Ubuntu – installing oracle 11g in ubuntu 10.10
- Database – How to mount an Oracle database to new instance
- Database – How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server
- Windows – How to have oracle database accessible remotely
- Windows – Unable to connect to an Oracle XE database from another PC, or a local program / webpage
Best Answer
Firstly, separate the concepts of database "software installation" from the database "store of data".
11.2.0.2 has changed the upgrade mechanism. Previously you had to install the base version of the software then run an upgrade. 11.2.0.2 is installed as a separate product.
There's a walkthrough here, but the actual steps may vary depending on what your database config is (single node or RAC etc). If you are not confident, make your backup, restore to another machine and test your upgrade first. Only upgrade production when you are confident.