Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create multiple oracle instances on Same Server

SoofiFeb 25 2019 — edited Feb 27 2019

Hi All,

We have Linux (Centos) Operating System Server with Oracle DB 11g R2 installed.

We created some 5 schemas in that DB for an APEX application.

Now we have another APEX Application that uses the same Schema Names and DB structure and hosted in another separate server.

Is it possible to host these two Oracle Instances in the same linux based server?

DB will be 11g R2 and APEX version will be 5.

Thanks in advance.

Regards,

Soofi

Comments

Christian Pitet

What means BIP ?

User_TYVZT

Hi Christian Pitet

Oracle Business Intelligence Publisher (BI Publisher) (BIP)

Christian Pitet

I guess you are using an Interactive report. Do you have a Submit page process on that page ?

InoL

While generating report in BIP, that data is saved as sample data.
What do you mean by that? Generating a report via BI Publisher and saving sample data? I don't see the connection.
How are you using BIP? As the print server for Intercative Reports? Or a custom report template?

User_TYVZT

Hi InoL
So for creating report, I have xdm(data model) and xdo. In xdm, after providing the sql query, I can see the data when I click view data. There I can do "save as sample data". Then after link my data model with xdo which has template in it, I can view my report in various formats. There even though there is data I'm not able to see the data in xls and pdf format. Only CSV format report shows data.

InoL

I have xdm(data model) and xdo
I have no idea what that is, not APEX anyway. Is this something from BI Publisher? Maybe you can ask this in that forum then.

User_TYVZT

Hi InoL
Yes it is from BI Publisher(BIP). Could you share forum link?

Christian Pitet

Here is a forum link :
bi publisher (0 Bytes)Regards.

1 - 8

Post Details

Added on Feb 25 2019
14 comments
8,086 views