操作系统:windows 7 oracle版本:oracle 12.2.0
启动监听时出现异常:
>lsnrctl start LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 26-MAY-2019 21:35:08 Copyright (c) 1991, 2016, Oracle. All rights reserved. Starting tnslsnr: please wait... Unable to OpenSCManager: err=5 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error检查lsnrctl status 信息
>lsnrctl status LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 26-MAY-2019 21:36:47 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lj-PC)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory错误截图如下:
打开cmd时,需要右键选择“以管理员身份运行”: