InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Seeking help setting up Oracle DB Alias

    Posted Wed March 06, 2019 10:26 AM
    Hello,

    I'm trying to set up a DB Alias for an Oracle 12.1.02 database.  I am using Optim LUW 11.3.6 on Windows Server 2012 R2.  

    What I've done so far:
    1) Downloaded and configured Oracle Instant Client 12.1.02 and corresponding SDK on the Windows Server.
    2)  Updated PATH environment variable to include the Oracle install directory
    3)  Copied our tnsnames.ora file to the Oracle install directory
    4)  Using Optim Configuration - create a new db alias for Oracle 12c
    This produces the error message in the GUI (on the Connect To Database screen):  
    An unknown internal error occurred in function RDB_GethConn. RC=-1.

    The db is using the single byte character set WE8MSWIN1252, so I selected "ASCII/EBCDIC" in Optim Configuration.  But I noticed the following error in the trace file:
    DSQCRCUT DSQLORAMapCharSetToCP (3106) EXCP 03/05/2019 14:50:21 000045 00002730 00003274
    Failed to find Oracle Character set "US7ASCII" in internal table

    If anyone can share how they have successfully created an Oracle DB Alias, I would greatly appreciate it!

    Thank you!



    ------------------------------
    Trong Bo
    Senior Environment Administrator
    HealthNow New York
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Seeking help setting up Oracle DB Alias

    Posted Thu March 07, 2019 02:49 AM
    Rather that using the Oracle Instant Client, can you try the Administration Client.  I've always found that to work.

    ------------------------------
    JIMMY WILSON
    IBM Digital Technical Engagement
    ------------------------------

    Original Message


  • 3.  RE: Seeking help setting up Oracle DB Alias

    Posted Fri March 08, 2019 03:07 AM
    Hi,

    Agree with Jimmy.
    Instant Client is not sufficient, you need full Oracle client.

    Regards,
    Fritz

    ------------------------------
    FRIEDRICH PFNEISL
    Optim SME
    Austria
    ------------------------------

    Original Message


  • 4.  RE: Seeking help setting up Oracle DB Alias

    Posted Mon March 11, 2019 01:04 PM
    Hi, Jimmy.

    Per your suggestion, I have installed the full Oracle client.  I am getting the following error:
    ORA-12154: TNS:could not resolve the connect identifier specified

    I have the following environment variables configured to my "oracle_home" directory:
    TNS_ADMIN
    PATH

    I created an ODBC connection that passes the connection test.  

    I can connect to the db using the ODBC connection and query it using SQLDBX.  Using the ODBC connection in Optim in the "Connection String" field throws the ORA-12154 ERROR.  If I use the actual TNS name, I get the following error:
    ORA-12545: Connect failed because target host or object does not exist

    What should I be using in the "Connection String" field in Optim Configuration?  Should it be the TNS name, the ODBC connection, or the full connection string?  Is there something else I may have configured incorrectly?

    Thank you!

    ------------------------------
    Trong Bo
    Senior Environment Administrator
    HealthNow New York
    ------------------------------

    Original Message


  • 5.  RE: Seeking help setting up Oracle DB Alias

    Posted Mon March 11, 2019 01:34 PM
    Hello Trong - You will need to enter the TNS name in the connection string field when creating the DBAlias.  My suggestion is to test the connection with SQL*Plus prior to creating the alias.

    Jimmy

    ------------------------------
    JIMMY WILSON
    ------------------------------

    Original Message