Skip to Main Content

Oracle Forms

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!

REP-51002 after enabling Job Status Repository for standalone report server on Reports 12c

myluismDec 15 2017 — edited Dec 19 2017

Hi all.

I'm using Forms and Reports lastest version.

I have come across and unexpected error after trying to enable Job Status Repository.

Standalone report server has been running ok but now reports REP-51002.

This output is from rwserver_diagnostic.log log file:

[2017-12-15T20:11:54.166-04:00] [reports] [INCIDENT_ERROR] [REP-12505] [oracle.reports.server] [tid: 1] [ecid: 551a81f2-e4e4-424d-afb8-3b07de785035-00000002,0] REP-12505 : java.sql.SQLException: Listener refused the connecti  on with the following error:[[ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

        at oracle.reports.utility.Utility.newRWException(Utility.java:1016)

        at oracle.reports.utility.DBConnection.connectByThinJDBC(DBConnection.java:197)

        at oracle.reports.utility.DBConnection.connect(DBConnection.java:127)

        at oracle.reports.server.JobRepositoryDB.start(JobRepositoryDB.java:68)

        at oracle.reports.server.JobStore.start(JobStore.java:164)

        at oracle.reports.server.RWServer.startServer(RWServer.java:995)

        at oracle.reports.server.RWServer.jniMain(RWServer.java:289)

However i can open from sqlplus as the user used on enabling Job Status Repository.

How can i resolve this error????

Thanks in advance!!!!

]]

I have this info from config file:

<jobStatusRepository>

      <property name="dbpassword" value="csf:reports:rep_repository"/>

      <property name="dbconn" value="wFIGOBD:1521:BFIGO.aaosa.ve"/>

      <property name="dbuser" value="sfigoaux"/>

   </jobStatusRepository>

My guess is i need to supply an ip address instead of hostname. Change  from wFIGOBD:1521:BFIGO.aaosa.ve to ip_address:1521:BFIGO.aaosa.ve.

But i don't how how to do it using EM Fusion Middleware Control.

Can i manually change rwserver.conf for my standalone report server? $DOMAIN_HOME/config/fmwconfig/components/ReportServerComponent/rep_server1? If so which step to follow?

I've been advised not to manually change this or any config file. So is it safe to change it? If not, how should i do it from EM FMW Control?

Regards, Luis !!!!

This post has been answered by FCH on Dec 16 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2018
Added on Dec 15 2017
10 comments
1,327 views