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 !!!!