Hi
I have set up Oracle software, a database, and listener on my pc for dev/test.
OS: Windows 10 Pro
DB: Oracle 12c Enterprise
So far I have no problem with activation and connection,
but somehow "lsnrctl status" keeps answering as below.
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 03-FEB-2017 12:52:12
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.146)(PORT=1521)))
TNS-01153: Failed to process string: ・･
The corresponding part of log.xml is here (USER and host_id replaced for privacy).
I tried to get all the messages in English, but TNSLSNR does not follow NLS_LANG.
<txt>03-2月 -2017 12:52:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=smith_john))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375680)) * status * 303
</txt>
</msg>
<msg time='2017-02-03T12:52:12.373+09:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='ABC12345PC'
host_addr='fe80::13d:e602:61d:bf3e%15'>
<txt>NL-00303: NV文字列に黒ｶエラーがあります。
</txt>
lastly, this is my listener.ora. Windows user, db name and sid replaced.
# listener.ora Network Configuration File: C:/Program Files (x86)/Oracle/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:/app/smith_john/product/12.1.0/dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:/app/smith_john/product/12.1.0/dbhome_1/bin/oraclr12.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = MYDATA_NAME)
(ORACLE_HOME = C:/app/smith_john/product/12.1.0/dbhome_1)
(SID_NAME = MYDATA)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:/app/smith_john/product/12.1.0/dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:/app/smith_john/product/12.1.0/dbhome_1/bin/oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.146)(PORT=1521))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
)
)
Although the issue is not bothering me badly at the moment, I would appreciate some hints to figure out the cause.