ORA-00119: invalid specification for system parameter LOCAL_LISTENER - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: ORA-00119: invalid specification for system parameter LOCAL_LISTENER

  1. #21
    Join Date
    Sep 2016
    Posts
    13
    I have attached my alert log
    Attached Files Attached Files

  2. #22
    Join Date
    Sep 2016
    Posts
    14
    Well, I saw in your alert :

    Wed Oct 05 19:15:08 2016

    XDB installed.

    XDB initialized.
    Wed Oct 05 19:39:23 2016


    OK, the XDB component appears to be good, and you already checked the port - so, if you did the exact procedure that I recommended (ie, stop listener, shutdown database, start listener and only then start the database) and even then you don´t see the http protocol line in the listaner status output, as I said probably OR your APEX is not using EPG (and you don´t know what it is using/how it is configured), OR you have some config failure in APEX - in any case I would recommend to you an APEX removal and reinstall / reconfig of APEX, it would be easier than trying to debug the current APEX install ...

    Regards,

    J. Laurindo Chiappa

    Quote Originally Posted by Janning View Post
    I have attached my alert log

  3. #23
    Join Date
    Sep 2016
    Posts
    13
    I think the "database listener" is started...but the APEX...has issue:

    [root@oradev oracle]# tnsping 192.168.1.122:1522

    TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:20

    Copyright (c) 1997, 2014, Oracle. All rights reserved.

    Used parameter files:
    /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

    Used EZCONNECT adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=1522)))
    OK (0 msec)





    [root@oradev oracle]# tnsping 192.168.1.122:7172

    TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:48

    Copyright (c) 1997, 2014, Oracle. All rights reserved.

    Used parameter files:
    /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
    Used EZCONNECT adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=7172)))
    TNS-12541: TNS:no listener
    [root@oradev oracle]#

  4. #24
    Join Date
    Sep 2016
    Posts
    14
    As I said, the most common interface to APEX is the one where it uses the SAME DATABASE LISTENER, being acessed by XML DB (this is called the EPG - Embedded Pl/sql Gateway) : so, if you are using this config BUT the http line is not showing in the Database listener status, Of Course no ping will work, obviously... NO APEX LISTENER would exists in this case, all right ? APEX and database both use the same and only Listener, in this config when EPG is in use...

    So, let me repeat : IF you did the exact procedure that I recommended (ie, stop listener, shutdown database, start listener and only then start the database) and even then you don´t see the http protocol line in the listener status output, as I said probably OR your APEX is not using EPG (and you don´t know what it is the non-EPG gateway/config in use, or how it is configured), OR (another option) you have some config failure in APEX - in any case I would recommend to you an APEX removal and reinstall / reconfig of APEX, it would be easier than trying to debug the current APEX install ...

    Regards,

    J. Laurindo Chiappa
    Quote Originally Posted by Janning View Post
    I think the "database listener" is started...but the APEX...has issue:

    [root@oradev oracle]# tnsping 192.168.1.122:1522

    TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:20

    Copyright (c) 1997, 2014, Oracle. All rights reserved.

    Used parameter files:
    /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

    Used EZCONNECT adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=1522)))
    OK (0 msec)





    [root@oradev oracle]# tnsping 192.168.1.122:7172

    TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:48

    Copyright (c) 1997, 2014, Oracle. All rights reserved.

    Used parameter files:
    /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
    Used EZCONNECT adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=7172)))
    TNS-12541: TNS:no listener
    [root@oradev oracle]#

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width