ORA-00132

APPLIES TO

Operating System - Oracle Linux Server 7.9
Oracle Database - Enterprise Edition - version 11.2.0.4.0
Oracle Grid Infrastructure - version 11.2.0.4.0

SYMPTOMS

Fails with error ORA-00132 during startup database.

~]# /etc/init.d/oracle_ORCL.sh start; echo $?

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 25 18:45:04 2024

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LI_ORCL'
SQL> Disconnected

CAUSE

Listener address has syntax error or cannot be resolved.

SOLUTION

cat >> /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora << EOF
LI_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.184.146)(PORT = 1521))

EOF