oracle TNS-01201错误

刘泽宇

[oracle@redhat1 ~]$ lsnrctlstart

LSNRCTL for Linux: Version11.2.0.4.0 - Production on 04-9月 -2020 01:56:27

Copyright (c) 1991, 2013,Oracle.  All rights reserved.

启动/u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr:请稍候...

TNSLSNR for Linux: Version11.2.0.4.0 - Production

系统参数文件为/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

写入/u01/app/oracle/diag/tnslsnr/redhat1/listener/alert/log.xml的日志信息

监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.108)(PORT=1521)))

监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

TNS-01201: 监听程序无法找到可执行的/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle以用于 SID orcl1

监听程序未能启动。请参阅上面的错误消息...

检查发现/u01/app/oracle/product/11.2.0.4/dbhome_1/与/u01/app/oracle/product/11.2.0/db_1/不相符，是由于配置文件是通过scp传过来的，路径与本地ORACLE_HOME不相符，修改为当前ORACLE_HOME即可