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

Back to Forums

Yukiya Miyamoto

Question

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.

19 Sep 2019

IQ78

In practice, i am using TOAD to create database

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

19 Sep 2019

2 replies

Last reply 19 Sep 2019

Show thread

Hide thread

Yukiya Miyamoto

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?

19 Sep 2019

Balasubramanian Prakasam

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

19 Sep 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines