I would like to move only the RDBMS part of an environment.
Some more details: scrrently I have a windows machine (installed some time ago by guys not in place now) where I have a monolitic OWB 11gR2 + Apex setup installed.
Eg, if I query the installed RDBMS I see this in dba_registry:
Oracle Application Express 4.2.6.00.03
Oracle Enterprise Manager 22.214.171.124.0
OLAP Catalog 126.96.36.199.0
Oracle Multimedia 188.8.131.52.0
Oracle XML Database 184.108.40.206.0
Oracle Text 220.127.116.11.0
Oracle Expression Filter 18.104.22.168.0
Oracle Rules Manager 22.214.171.124.0
Oracle Workspace Manager 126.96.36.199.0
Oracle Database Catalog Views 188.8.131.52.0
Oracle Database Packages and Types 184.108.40.206.0
JServer JAVA Virtual Machine 220.127.116.11.0
Oracle XDK 18.104.22.168.0
Oracle Database Java Packages 22.214.171.124.0
OLAP Analytic Workspace 126.96.36.199.0
Oracle OLAP API 188.8.131.52.0
18 rows selected.
I would like to move only the RDBMS part to a dedicated Oracle Linux 7.4 server.
If I understood correctly, for OWB there are some special "enteprise" features embedded into a standard RDBMS installation.
Is there any simple method to complete the move operation?
My initial idea was to move the RDBMS and then change the tnsnames.ora of the windows server, so that the presentation layer remains inside it but the data part is away.
In the mean time I downloaded official docs and I'm going to analyze them, as actually it seems not so simple.
I just tried a test expdp/impdp operation to get a neutral insight and obviously I'm getting some errors regarding special profiles/featues that fail to import into an 11gR2 + Oct 17 patch standard edition pre-created database on Oracle Linux 7.4.
If possible I would like to avoid a complete reinstall/setup...
Any advice would be welcome.
BTW: during my tests of clean DB creation on the Linux box I noticed that using dbca for rdbms creation, I can select owb and apex components only if I choose the option with pre-installed datafiles, where Oracle does a sort of rman clone starting from a dbf backup inside the installation sw. Is this by design or is it a bug?
Thanks in advance,