DX Unified Infrastructure Management

  • 1.  UIM 8.5.1 Instalaltion with Oracle 12.2 on Redhat 7.x

    Broadcom Employee
    Posted Oct 25, 2017 08:03 AM

    From the past 1 week I'm struggling to install UIM 8.5.1 with Oracle 12c on Redhat 7.x.

    I'm able to connect with the same user credentials from SQLDeveloper to the Oracle PDB. 

     

    Appreciate any help! 

    - MahaUIM Installer Issue with Oracle 12c PDB#



  • 2.  Re: UIM 8.5.1 Instalaltion with Oracle 12.2 on Redhat 7.x

    Broadcom Employee
    Posted Oct 25, 2017 08:13 AM

    so the ORA error is being returned by the oracle client.

    Have you checked with your DBA?

    I found this like with some suggestion on changes to the database

    oracle - ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client - Stack Overflow 

     

    things to check

    make sure on the UIM server you have the oracle THIN client only.

    make sure the client version matches the bit level of the OS.

    test with a password that does not have any special characters.

     

    Hope this helps



  • 3.  Re: UIM 8.5.1 Instalaltion with Oracle 12.2 on Redhat 7.x

    Broadcom Employee
    Posted Oct 25, 2017 08:29 AM

    In addition to Gene's comments, please try this query while connected in Oracle SQL Developer to the pdb database

    select * from all_users where username LIKE 'CA_UIM';

     

    I would be interested to see your Oracle server tnsnames.ora file also.

    Also, in your screenshot, can you show the other fields please (the popup is blocking)?

     

    Thanks



  • 4.  Re: UIM 8.5.1 Instalaltion with Oracle 12.2 on Redhat 7.x

    Broadcom Employee
    Posted Oct 25, 2017 11:01 AM

    Hi,

    Here are the Connection details and the snapshots.

     

    Thanks in advance!

     

    UIM DB Configuration:

    UIM Oracle Connection details

     

    SQL Developer Connection details & User query:

    SQL_Dev

     

    TNSNAMES.ora

    TNSNames

     

    Listener Service Status:

    LSN_Status

     

    The password is just "oracle123" for SYS & CA_UIM users. 

     

    I'm using the latest Oracle Client lib ojdbc8.jar for Oracle 12.2 Server.

     

    -Maha



  • 5.  Re: UIM 8.5.1 Instalaltion with Oracle 12.2 on Redhat 7.x

    Broadcom Employee
    Posted Oct 25, 2017 11:31 AM

    I think you need to open a support case to look into this in more detail



  • 6.  Re: UIM 8.5.1 Instalaltion with Oracle 12.2 on Redhat 7.x

    Broadcom Employee
    Posted Oct 26, 2017 09:00 AM

    Hello.

    We are not using Software Version of full Oracle client.

    UIM is using series of libraries in Oracle Instant Client.

    This is why UIM ask you the location of Oracle Instant client.

     

    Make sure the below items.

     

    1. Please use ZIP version of Oracle Instant Client. There is also RPM version but do not use RPM version.

    because we need all libraries in the same location.

     

    2. ldd should return no error.

     

    # cd <Location you extracted Oracle Instant Client>
    # ldd libociei.so

     

    Regards,

    Yu Ishitani