1 Reply Latest reply: Oct 8, 2012 11:05 PM by Kgronau-Oracle RSS

    Cannot connect to Oracle Database in 1521 port while using dg4msql listener

      Hi all,

      I am trying to connect to my Oracle Database 11G via JDBC via BI Publisher 11G. I am using dg4msql to connect to SQL Server 2008R2. Oracle & SQL Server in same Windows machine.

      Here the entries in tnsnames.ora file in the gateway: C:\product\11.2.0\tg_1\NETWORK\ADMIN
      dg4msql =
      XE =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = AA-PC)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = XE)
      There is no issues with the gateway and I can ATM read all SQL Server tables/views fine, but the only way I can connect to the database is via SQL Plus or via APEX, not through SQL Developer or through BI Publisher (JDBC).

      I have tnsping'ed both XE and dg4msql and both came up as ok.

      My JDBC connection String in BI Publisher is:

      The error I got was:           
      Could not establish connection.

      Would be great if someone can point out how I can connect to my Database without switching off the dg4msql listener. Cheers.