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' ...