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.