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
Copyright (c) 1982, 2023, Oracle. All rights reserved.
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
Copyright (c) 1982, 2023, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid credential or not authorized; logon denied
Enter user-name: