I was getting the below error while starting up the Oracle 23c
database, which is a new release from Oracle.
The same
error was getting repeated while starting and shutting down.
SQL>
shu immediate
Database
closed.
Database
dismounted.
ORACLE
instance shut down.
ERROR:
ORA-12514:
Cannot connect to database. Service FREE is not registered with the
listener
at host 127.0.0.1 port 1521. (CONNECTION_ID=+wf/LAyCEVfgUwEAAH9uOg==)
Warning:
You are no longer connected to ORACLE.
[oracle@localhost
Desktop]$ sqlplus sys@free as sysdba
SQL*Plus:
Release 23.0.0.0.0 - Developer-Release on Sat May 6 14:19:05 2023
Version
23.2.0.0.0
Copyright
(c) 1982, 2023, Oracle. All rights reserved.
Enter
password:
ERROR:
ORA-12514:
Cannot connect to database. Service FREE is not registered with the
listener
at host 127.0.0.1 port 1521. (CONNECTION_ID=+wgWspJwEdfgUwEAAH9dmQ==)
Enter
user-name: sys
Enter
password:
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=+wgWspJxEdfgUwEAAH9dmQ==)
Enter
user-name: ^C
Below
is the solution to resolve this error, there is one parameter called TWO_TASK,
which we need to unset
[oracle@localhost
Desktop]$ echo $ORACLE_SID
FREE
[oracle@localhost
Desktop]$ echo $TWO_TASK
FREEPDB1
[oracle@localhost
Desktop]$ unset TWO_TASK
Once
you unset this parameter, connect using sqlplus as sysdba and try to start the
database
[oracle@localhost
Desktop]$ sqlplus
SQL*Plus:
Release 23.0.0.0.0 - Developer-Release on Sat May 6 14:23:16 2023
Version
23.2.0.0.0
Copyright
(c) 1982, 2023, Oracle. All rights reserved.
Enter
user-name: /as sysdba
Connected
to an idle instance.
SQL>
SQL>
startup mount
ORACLE
instance started.
Total
System Global Area 1608409424 bytes
Fixed
Size
10043728 bytes
Variable
Size
671088640 bytes
Database
Buffers 922746880 bytes
Redo
Buffers
4530176 bytes
Database
mounted.
SQL>
In this way, there is the solution for everything in oracle database