SLT Replication with Oracle Source

[former_member227100]

Hi everyone,

I am trying to create a configuration with Oracle as Source. I already created the DB Connection in DBACOCKPIT and the connection is established succesfully. But when I try to create the configuration and the SLT asks me to enter a schema, I get the following error message:

In the DBACOCKPIT, I used the same schema name and the test was fine. So I don't get the problem.

Does anyone have an idea?

Thanks in advance.

Best regards,

Scott

[former_member341019 · Accepted solution]

The solution:

The User used to create the DBConnection needs the permission to read the view DBA_USERS. In this way, the SLT checks if the schema is existing in the database.

Best regards

Ulf

[former_member227100]

Hi,

I updated the SLT Server to the newest Support Package. Now it's working.

Thanks for all your help.

Regards,

Scott

[Andrey_M]

Hi Scott,

I guess that problem can be connected with DB permissions of your user.
Please check the SAP Note 1771460 that describes required permissions for user in case when you use Oracle DB.

Kind regards

[rafaelgalindo]

Hi Scott

Try let's Schema Name and Tablespace Name unfilled if this fields not are mandatory.

Best regards

[former_member227100]

Hi Jose,

unfortunately the configuration requires the tablesspace and schema. I can't leve the fields blank.

[JamesZ]

Hi Scott,

name is case sensitive, did you check this point?

Please let me know the output of following sql from oracle source:

select username from dba_users;

Best regards,
James

[former_member227100]

Hi James,

I tried every option. In capital letters and in small type letters. It didn't work.

Here is the result set of my SQL statement:

I thought about an authorization issue. My DB Connection is using the system user.

[JamesZ]

Yes, maybe this is permission issue, is it possible to have a look at the work process trace? Hopefully we can find more information.