Oracle - Invalid service name in Repository Creation Utility

Question

I get this error message "Invalid service name" when submitting the Database Connection Details form in Repository Creation Utility. I have put the required information as below:

Host Name : localhost

Port : 1521

Service Name : orcl

Username : sys

The version of the database I have installed is 19c.

Any idea how to fix that?

Answer 1

I have fixed it! I should have connected to a pluggable database instead of the container database. In order to do that, I ran the command-lines below:

1. sqlplus user/password as sysdba
2. ALTER PLUGGABLE DATABASE orclpdb OPEN;
3. ALTER SESSION SET CONTAINER = ORCLPDB;

Afterwards, I put the service name as orclpdb.lan instead of orcl in the Database Connection Details form. So, the relevant required information should be as below:

Host Name : localhost

Port : 1521

Service Name : orclpdb.lan

Username : sys