Oracle Database Startup Issue- ORA-00119 and ORA-00132

Recently I have come across a strange issue related to Oracle Database startup. Below is the problem statement-

Environment- Oracle Linux Server 6.7, Oracle Database Version 12c, Single Instance

After running the database startup script-
cd $ORACLE_HOME/bin
./dbstart $ORACLE_HOME

The database started but with problem- "Listener Supports No Services"
cd $ORACLE_HOME/bin
lsnrctl status
The listener supports no services

The command completed successfully

I navigated to sqlplus-
./sqlplus /nolog
connect / as sysdba
SQL> startup
SQL> 
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

Finally, I used following solution to work and start my Oracle Database-

Navigate to - spfile location
cd /u01/app/oracle/product/12.1.0/db_1/dbs
vi spfileorcl.ora

Now search for 'LISTENER_ORCL' as specified in error
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=0
*.local_listener='LISTENER_ORCL'
*.memory_target=1529m
*.open_cursors=300

*.processes=300

Just delete the line marked in red to remove LOCAL_LISTENER.

I am not sure whether required but for a precautionary measure, I restarted my machine and started the database

cd $ORACLE_HOME/bin
./dbstart $ORACLE_HOME

Now checked my listener-
Services Summary...
Service "orcl.local" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.local" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

Alternative way-

Create spfile from pfile if you don't have pfile upadted.
SQL> CREATE PFILE FROM SPFILE;


Open the pfile and remove the LOCAL_LISTENER entry.
$ vi /oracle/app/oracle/product/12.0/db_1/dbs/spfileorcl.ora

Again Create spfile from pfile.
SQL> CREATE PFILE FROM SPFILE;

Start the database.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 2019288 bytes
Variable Size 83886120 bytes
Database Buffers 75497472 bytes
Redo Buffers 6369280 bytes
Database mounted.

Database opened.


I am not a DBA or expert but just done google on the respective issue and this solution worked for me.