0 Replies Latest reply on Feb 8, 2018 9:04 AM by 798463

    Suggestion on moving only OWB RDBMS

    798463

      Hello,

      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:

       

      COMP_NAME VERSION

      ---------------------------------------- ------------------------------

      Oracle Application Express 4.2.6.00.03

      OWB 11.2.0.4.0

      Oracle Enterprise Manager 11.2.0.4.0

      OLAP Catalog 11.2.0.4.0

      Spatial 11.2.0.4.0

      Oracle Multimedia 11.2.0.4.0

      Oracle XML Database 11.2.0.4.0

      Oracle Text 11.2.0.4.0

      Oracle Expression Filter 11.2.0.4.0

      Oracle Rules Manager 11.2.0.4.0

      Oracle Workspace Manager 11.2.0.4.0

      Oracle Database Catalog Views 11.2.0.4.0

      Oracle Database Packages and Types 11.2.0.4.0

      JServer JAVA Virtual Machine 11.2.0.4.0

      Oracle XDK 11.2.0.4.0

      Oracle Database Java Packages 11.2.0.4.0

      OLAP Analytic Workspace 11.2.0.4.0

      Oracle OLAP API 11.2.0.4.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,

      Gianluca