System DSN for live RPD

Sangeeta Pandey

Hello Experts,

I am trying to configure DSN for live RPD and getting errors. I am using ODBC 64 bit and Oracle BI Server driver.

I tried to use port for bi server from EM (than default 9703).

In server name I passed machine/host name from EM and then tried with passing server name as well (bi_server1) from EM.

However getting same error in both ways.

Port from EM:

Thanks,

Saresh-Oracle

Hi,

Please try with Port 9514.

For the benefit of your community peers, if you find this reply on your thread has either resolved or helped progress your issue, please mark the reply Correct or Helpful.
Refer to Was Your Question Answered in the My Oracle Support Community (MOSC)? Mark Replies Correct or Helpful!

Thanks,

Sareesh

Sangeeta Pandey

Thanks Saresh, it resolved the issue.

Port 9514 is the default port we need to use? How you determine that?

Thanks,

Saresh-Oracle

Hi Sangeeta,

9514 is the default port.
I faced the same issue last week and Its only port 9514 that is working.

Thanks,

Sareesh

Gianni Ceresa

Sangeeta Pandey wrote:Port 9514 is the default port we need to use?

Depends on your install, if you don't change anything in the default ports range of OBIEE 12c, yes, that's the default port.

Sangeeta Pandey wrote:How you determine that?

Sareesh didn't reply to that part, which is the most important. Don't think that ONLY 9514 is the port you need and it's either that or nothing. It could actually be any random port number depending on the installation which has been done.

You can easily find out on any OBIEE 12c what the port is.

Connect to Enterprise Manager, where you were in the screenshot you posted. In the menu on the left pick the BI instance inside the "Business Intelligence" folder (by default it's named 'biinstance'). Once there open the "Availability" tab and expand the BI Servers list to see the port of the BI server.

Sangeeta Pandey

Thank you !!! very helpful.