getting error while configuring Map Viewer

Question

Hello Expert,

I am getting error in Map report.

I have went to mapviewer admin console and tried to check the logs present over there and getting below error

oracle.sdovis.ds.NativeOracleDataSource <init>

SEVERE: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

java.sql.SQLException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

OBI Version - 12.2.1.1.0

Database version - Oracle 12c

Thanks for all your help.

Abhi

Robert Angel · Answer

Have you reviewed =>

https://www.databaseusers.com/article/5998747/Cannot+read+tile+layer+config+log+from+database

User_B7ZTH · Answer

Hello,

Thanks for your suggestion, we have created a connection with Service name. But now map is coming up but no layers.

We have check the map log and getting this error:-

WARNING: Cannot read tile layer config log from database.(TESTIT1

Feb 06, 2018 11:22:45 AM oracle.lbs.mapserver.core.MapperPool getStats

WARNING: Cannot obtain connection stats: Connection Cache with this Cache Name does not exist

We tried to search everything on google but no luck.

I am wondering what is wrong with layers now.

Why no layer is getting displayed.

Can you please please help.

Thanks in advance.

Abhi

Robert Angel · Answer

See => https://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid