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

    xarg-Xrc
      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 =
         (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=AA-PC)(PORT=1522))
          (CONNECT_DATA=(SID=dg4msql))
          (HS=OK)
       )
      
      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:
      jdbc:oracle:thin:@AA-PC:1521:XE

      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.