terminating the instance due to error 119

Today, i faced issue 'Terminated the instance due to error 119'. when i was startup database (11g, platform - window 7) from OracleServiceTEST services, i seen error in alert_TEST.log file.


last few lines from alert log file:

============
Tue Nov 18 14:09:53 2014
Adjusting the default value of parameter parallel_max_servers
from 400 to 285 due to the value of parameter processes (300)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =66
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\ORACLE11GHOME\NITIN\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILETEST.ORA
System parameters with non-default values:
    processes                = 300
    sessions                 = 600
    memory_target            = 26240M
    control_files            = "D:\ORACLE11GHOME\NITIN\ORADATA\TEST\CONTROL01.CTL"
    control_files            = "D:\ORACLE11GHOME\NITIN\FLASH_RECOVERY_AREA\TEST\CONTROL02.CTL"
    db_block_size            = 8192
    compatible               = "11.2.0.0.0"
    db_recovery_file_dest    = "D:\Oracle11gHome\NITIN\flash_recovery_area"
    db_recovery_file_dest_size= 4096M
    undo_tablespace          = "UNDOTBS1"
    remote_login_passwordfile= "EXCLUSIVE"
    dispatchers              = "(PROTOCOL=TCP) (SERVICE=testXDB)"
    local_listener           = "LISTENER_TEST"
    audit_file_dest          = "D:\ORACLE11GHOME\NITIN\ADMIN\TEST\ADUMP"
    audit_trail              = "DB"
    db_name                  = "TEST"
    open_cursors             = 300
    diagnostic_dest          = "D:\ORACLE11GHOME\NITIN"
USER (ospid: 7456): terminating the instance due to error 119
Instance terminated by USER, pid = 7456

============


Cause:

the local_listener initialization parameter was cause this issue.


Solutions:

C:\Users\Nitin>sqlplus "/as sysdba"

SQL> create pfile from spfile;

pfile created;

I had no pfile pysically, bcoz accidentally pfile was deleted.


Then i removed below local_listener from pfile.

local_listener= "LISTENER_TEST"

Now, started database using same pfile.

SQL> startup pfile='%ORACLE_HOME%/dbs/initTEST.ora';

And my database get started successfully without any issue.


Hope this will help you.