Skip to content

FREEPDB1/FREE services not registered #3058

@mkstephenson

Description

@mkstephenson

I am attempting to get a local instance of the free-lite image running on Docker Desktop (through Aspire, but this issue occurs outside of it as well) and am stuck at the error that ORA-12514: Cannot connect to database. Service FREEPDB1 is not registered with the listener at host 127.0.0.1 port 1521 when attempting to connect with the PDBADMIN user using sqlplus inside the container. It then prompts me for username and password (system as the username and the password set via ORACLE_PWD works, pdbadmin doesn't) and then I seem to land in the CDB$ROOT level (the current schema name is SYSTEM). The same issue occurs when I use FREE and also if I try to connect from outside the container.

I am following the guide https://container-registry.oracle.com/ords/ocr/ba/database/free and am simply using Docker Desktop instead of Podman. I am also not mounting any existing data into the container.

The services appear to exist in the tnsnames.ora (I might be looking in the wrong place though) so I am bit stuck now.

sh-4.4$ cat /opt/oracle/oradata/dbconfig/FREE/tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/product/26ai/dbhomeFree/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

FREE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = FREE)
    )
  )

LISTENER_FREE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))


FREEPDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = FREEPDB1)
    )
  )

sh-4.4$ cat /opt/oracle/oradata/dbconfig/FREE/listener.ora

# listener.ora Network Configuration File: /opt/oracle/product/26ai/dbhomeFree/network/admin/listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = FREE

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

Has anyone got any idea why this might be?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions