How can I see the Database schema in the Service Center?

Hi there.

I installed OracleDB as external DB.

And I'm trying to try to connect the DB schemas and Outsystems Modeles.

I created a schema from Service Center > Administration > Database Schemas > Configure New Database.

I expected I could see the schema name which I created in the screen list.

How can I reflect the schema on the Servise Center.

Or I still haven't connect them each other?


Could anyone help me?

Thanks.

In practice, i am using TOAD to create database

ANd using integration Studio, i integrate the external db to OS

TUNA.COM wrote:

In practice, i am using TOAD to create database

ANd using integration Studio, i integrate the external db to OS

I'm sorry but I can't change this architecture...

After creating the new schema, I can't pass the Test Configuration because of following error.

Database Schema connection test failed with the following error: Owner User needs to be the schema owner: ORA-01017: invalid username/password; logon denied

the User and Password cannot be incorrect because i didn't change the form.
Do you know why this happens?

Yukiya Miyamoto wrote:

TUNA.COM wrote:

In practice, i am using TOAD to create database

ANd using integration Studio, i integrate the external db to OS

I'm sorry but I can't change this architecture...

After creating the new schema, I can't pass the Test Configuration because of following error.

Database Schema connection test failed with the following error: Owner User needs to be the schema owner: ORA-01017: invalid username/password; logon denied

the User and Password cannot be incorrect because i didn't change the form.
Do you know why this happens?


Hi Yukuya,


can check this article, it’s related with case sensitive 


https://stackoverflow.com/questions/14476875/ora-01017-invalid-username-password-when-connecting-to-11g-database-from-9i-clie


Thanks,

balasubramanian