CODEWITHSUNDEEP
linuxoracle-databaseoracle12c
Aj Anning
Aj Anning

Reputation: 41

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Let me start by saying, I'm not really a beginner at all this, but by no means an expert. I have Oracle 12c enterprise set up on a Oracle Enterprise Linux ver 7 box. This has always worked fine, start Linux, from a terminal window:

[oracle@oradev ~]$ sqlplus /nolog
SQL> conn SYS as SYSDBA
Enter password: xxxxx`
SQL> startup
[oracle@oradev ~]$lsnrctl start

All was well. I have this running on VMware® Workstation 12 Pro, 12.5.0 build-4352439. I recently updated VMware...now when I get to startup I get:

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oradev.attlocal.net)(PORT=1522))'
SQL>

Please advise?

Upvotes: 2

Views: 13429

Answers (1)

atokpas
atokpas

Reputation: 3351

Make sure your host name is correct in the value of the local_listener parameter.

My hostname is as follows:

[oracle@ora12c admin]$ hostname ora12c.dba.com

Go to $ORACLE_HOME/network/admin/ directory.

Then create TNS entry in the tnsnames.ora file as shown below to point the listener(In my case its LISTNER_ORACDB).

[oracle@ora12c admin]$ vi tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORACDB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c.dba.com)(PORT = 1522)) 


ORACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c.dba.com)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracdb)
    )
  )

Next,

[oracle@ora12c admin]$ sqlplus / as sysdba

SQL> alter system set local_listener='LISTENER_ORACDB';

Upvotes: 3

Related Questions