Skip to Content
author's profile photo Former Member
Former Member

Invalid IS repository connection information to Oracle 11g

I am trying to install information steward (IS) and configure the repository to an oracle 11g database. This is a brand new installation and I was able to connect to the IPS CMS and IPS audit databases using TNS connection. However, the IS repository database is giving me the error above when entering the parameters in the installation GUI. The parameters I am entering are:

Reposiroty Database type: Oracle 11g

JDBC Driver Files: D:\Oracle\product\11.2.0\client_1\jdbc\ojdbc6.jar

Connection details:

Conection Type: Oracle 11

Machine Name: xxxx01.xxxxx.com (machine where the database reposity is hosted at)

Port number: 1521 (same as in TNS entry).

SID: xxxxdev (same as service name in TNS entry)

Username: ISxxx

password: xxxx

The repositories (CMS, Audit, and IS) are on the same database under different Oracle schemas.

Environment: Windows Server 2008 R2, Oracle 11.0.2.0, 3 schemas on same database xxDev, Information Steward 4.2SP1

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2014 at 07:45 AM

    Hi Rene,

    It seems you have not installed the Oracle JDBC driver / the correct version of JDBC driver. Check and install the correct version of Oracle JDBC driver and then connect.

    Thanks,

    Ramakrishna Kamurthy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 16, 2014 at 08:52 AM

    Hi Rene,


    Please refer the below KBA regarding IS


    1773657 - How to migrate Information Steward repository - 4.1 and up

    https://service.sap.com/sap/support/notes/1773657

    1691960 - How to change the repository location - Information Steward 4.0

    https://service.sap.com/sap/support/notes/1691960

    Thanks,

    Daya

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2014 at 07:38 PM

    Did you ever get this fixed?

    I'm having the same problem.

    Best

    Leandro

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes, the issue was fixed when the DBA gave the service account admin access to the schema. The documentation is not clear as to what the specific access the service account needs, so he gave it all.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.