NL-00303 字符串中存在语法错误;Oracle监听程序启动后自动关闭问题

如题所述

第1个回答  2014-06-11
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-20140218JTLB)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)追问

大哥,说清楚点啊;
1.我自己搞好了,是在中文输入法里输入)的问题;
2.中间(SID_DESC =
)这段没必要添加;
3.(ADDRESS = (PROTOCOL = TCP)(HOST = PC-20140218JTLB)(PORT = 1521))

改成(ADDRESS = (PROTOCOL = TCP)(HOST = 自己的主机名)(PORT = 1521))