I need to get MapViewer going to validate my own data imports. I began the installation on a new weblogic and everything worked fine.

One thing what was pretty stupid was that I tried to get to the admin server console by using http://localhost:7001/, but of course the console is an app and therefore needs to be called  via http://localhost:7001/console.

The really annoying part was that I needed to create a datasource and this did not work with a pluggable database (I just have a multitenant installation).

 

  <map_data_source name="test"
                   jdbc_host="myhost"
                   jdbc_sid="mysid"
                   jdbc_port="1521"
                   jdbc_user="test"
                   jdbc_password="!test" 
                   jdbc_mode="thin"
                   number_of_mappers="3"
                   allow_jdbc_theme_based_foi="false"
                   editable="false"
   />

The documented part is the exclamation mark in front of the password, which autoencrypts the password with the next restart.

But it was not possible to get a connection to the database, I always got

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

I could not get it going for almost a full day. I found an old installation instruction and the solution is to prefix the SID with double slash.

  <map_data_source name="test"
                   jdbc_host="myhost"
                   jdbc_sid="//mysid"
                   jdbc_port="1521"
                   jdbc_user="test"
                   jdbc_password="test" 
                   jdbc_mode="thin"
                   number_of_mappers="3"
                   allow_jdbc_theme_based_foi="false"
                   editable="false"
   />

I could not find any documentation about that, therefore my note here.