Restoring an Oracle Enterprise Edition DB into XE for use with APEX
Hello, we're just in the process of decomissioning a load of servers and I came across an old Oracle DB box which has an install of APEX (well, HTMLDB) and a backend DB on an Enterprise Edition server, after battling with Oracle for 2 days I finally managed to get it to a state where I think it's restored successfully onto XE but up on the final "startup" I was presented with:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-39712: XE edition server cannot open database
I really want\need to get this DB off of this server, because as you all probably know - Oracle DB EE isn't exactly cheap, and seen as though it's used for this historical app I kinda need to get it off of this hardware\software and into a low-end VM for it to chug away happily and be accessed when needs be...
Another option I though of, if I were to do a reinstall of XE, and then data pump the info from the EE to XE? Would that work?
I apologies for any numptiness in this question, but I really haven't got any experience with Oracle - and it's been a learning curve of much frustration coming from my easy to use MSSQL interfaces!
The steps I took were:
1) Run nid to rename the DB from "XE" to "ESTALTST"
a) Do some faffing about with tnsnames and listener.ora to get it to realise ESTALTST
2) Take a backup of logs\db from source
3) Catalog the backups
4) Restore control file
5) A lot of messing about getting the DB happy with the structures of things
6) recover database;
7) alter database resetlogs; <- this is where it said I had to do startup upgrade;
8) shutdown immediate; startup upgrade;
9) Where I am now.
Thanks,
Rich.