8 Replies Latest reply on Jun 1, 2016 8:03 AM by simteq

    NL-00303: syntax error in NV string  TNS-01153: Failed to process string: (DESCRIPTION=(CONNECT_DATA=(CID=(PROGRAM=)(HOST=(null))(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)))

    simteq

      Hi

      I am running Mac OSX 10.6.8 and Oracle 10.2.0.4.0 and have the error:

      NL-00303: syntax error in NV string

      TNS-01153: Failed to process string: (DESCRIPTION=(CONNECT_DATA=(CID=(PROGRAM=)(HOST=(null))(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)))

       

      when trying to stop or start the listener using lsnrctl.

       

      I have checked other errors on the net including:

      1. Using netca to check the listener config

      2. ORACLE_HOME and LD_LIBRARY_PATH are set correctly

       

      The DB does come up and I can run sqlplus, SQLDeveloper and use JDBC connections but the bdump/cdump directories keep filling up.

       

      My listener.ora is

      # listener.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/listener.ora

      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (SID_NAME = PLSExtProc)

            (ORACLE_HOME = /oracle/product/10.2.0/db_1)

            (PROGRAM = extproc)

          )

          (SID_DESC =

            (SID_NAME = dex)

            (ORACLE_HOME = /oracle/product/10.2.0/db_1)

          )

        )

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          )

        )

       

      This is a typical part of a trc file in bdump

       

      Mon May 30 12:03:31 2016

      Errors in file /oracle/admin/dex/bdump/dex_d000_48267.trc:

      ORA-07445: exception encountered: core dump [kslgetl()+213] [SIGSEGV] [Address not mapped to object] [0x000000208] [] []

      ORA-00108: failed to set up dispatcher to accept connection asynchronously

      Mon May 30 12:03:34 2016

      found dead dispatcher 'D000', pid = (13, 153)

      Mon May 30 12:03:34 2016

      dispatcher 'D000' encountered error getting listening address

       

      Any help much appreciated.