oracle-databasedatabase-connectionutilityerror-messagingservice-name

Oracle - Invalid service name in Repository Creation Utility

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?

Solution

  • 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