合 Oracle启动报错terminating the instance due to error 119
👉 本文共约221个字，系统预计阅读时间或需1分钟。
现象
Windows的Oracle通过服务启动正常，前端没有报错，但是看任务管理器是有问题的，内存没有配置，
在监听日志报错：terminating the instance due to error 119
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | 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 D:\app\lhr\product\11.2.0\dbhome_1\RDBMS Autotune of undo retention is turned on. IMODE=BR ILAT =168 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:\APP\lhr\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDAZK.ORA System parameters with non-default values: processes = 1000 sessions = 1528 nls_language = "SIMPLIFIED CHINESE" nls_territory = "CHINA" memory_target = 1G control_files = "D:\APP\lhr\ORADATA\DAZK\CONTROL01.CTL" control_files = "D:\APP\lhr\ORADATA\DAZK\CONTROL02.CTL" db_block_size = 8192 compatible = "11.2.0.0.0" undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=DAZKXDB)" local_listener = "LISTENER_LHR" audit_file_dest = "D:\APP\lhr\ADMIN\DAZK\ADUMP" audit_trail = "DB" db_name = "DAZK" open_cursors = 300 diagnostic_dest = "D:\APP\lhr" USER (ospid: 6676): terminating the instance due to error 119 Instance terminated by USER, pid = 6676 |
从这里就可以看到local_listener的值不对。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
