A couple of things to consider:
There is no XE database for Oracle 12. That means that you may need some licenses for either SE2 or EE.
Then, there is no direct upgrade path from 220.127.116.11 to 18.104.22.168. That means that you will either have to do do two upgrades or you will have to migrate your data e.g. with data pump.
The 12c (12.1) upgrade guide has a chapter on upgrading from XE: "Moving from Oracle Database Express Edition (Oracle Database XE) to Oracle Database". Check https://docs.oracle.com/database/121/UPGRD/intro.htm for details.
Then, as usual:
Make sure you have a good backup.
Read the upgrade guides thoroughly
Test your upgrade first on an unimportant system
Thanks Andris for your assitance. So my strategy for backup will be:
Take a exp from the XE db
uninstall XE db
install 12c db
imp the exported dump
But in between these process I am not sure how my installed OBIEE 12c will be impacted, as the metadata is already existing in XE db. My intention is to upgrage the DB without having impact on OBIEE. Please let me know if it is feasible.
1 person found this helpful
Kaushik D wrote:
OBIEE 12c will be impacted, as the metadata is already existing in XE db. My intention is to upgrage the DB without having impact on OBIEE. Please let me know if it is feasible.
"without having impact"? No, most certainly not.
Read the documentation link that Andris posted: "To upgrade Oracle Database 11g Express Edition (Oracle Database XE) to Oracle Database 12c, you must install the new Oracle Database software on the same system as Oracle Database XE and use DBUA to perform the upgrade."
So you will have a new DB instance with a new address which then must be correctly referenced by all components using this. REfer to MOS Doc ID 2177562.1
So if I assume correct the approach will be like this:
- Uninstall OBIEE
- Uninstall XE DB
- install 12c DB
- install OBIEE
Safest way but have you looked at the MOS Doc I referenced?
Yes, it was very helpful and understood in my context. thanks again Chris.