Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

After shutdown CDB, get ORA-12514: Cannot connect to database. Service FREEPDB1 is not registered with the listener

User_LSM9JApr 24 2023

After shutting down the CDB (named FREE with PDB FREEPDB1), I get the following error when trying to restart it

[oracle@localhost admin]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sun Apr 23 22:32:33 2023
Version 23.2.0.0.0

ERROR:
ORA-12514: Cannot connect to database. Service FREEPDB1 is not registered with the listener at host 127.0.0.1 port 1521.
(CONNECTION_ID=+gl3YAD4fXzgUwEAAH+SlQ==)

I tried adding a static listener to the listener.ora for the FREE CDB, then bouncing the listener, but get the same error:

[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = FREE

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

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = FREE)
(ORACLE_HOME = /opt/oracle/product/23c/dbhomeFree)))
[oracle@localhost admin]$

I also tried creating a static listener for the FREEPDB1 PDB, and bouncing the listener, but get the following error:

[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = FREEPDB1

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

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = FREEPDB1)
(ORACLE_HOME = /opt/oracle/product/23c/dbhomeFree)))
[oracle@localhost admin]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Apr 24 16:42:35 2023
Version 23.2.0.0.0

ERROR:
ORA-01017: invalid credential or not authorized; logon denied

Enter user-name:

This post has been answered by User_LSM9J on Apr 25 2023

Jump to Answer

Added on Apr 24 2023

5 comments

2,978 views

1 mention