1 发现无法登陆ASM实例 [grid@host02 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 26 09:46:22 2019 Version 19.4.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact Enter user-name: ^C 2 查看环境变量,发现没有配置LD_LIBRARY_PATH,增加LD_LIBRARY_PATH环境变量 [grid@host02 ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs export PATH export TZ=Asia/Shanghai export ORACLE_SID=+ASM2 export ORACLE_BASE=/u01/app/grid export GRID_HOME=/u01/app/19.0.0.0/grid / export PATH=$GRID_HOME/OPatch:$GRID_HOME/bin:$PATH export ORACLE_HOME=/u01/app/19.0.0.0/grid/ 3 再次检查LD_LIBRARY_PATH,发现多一个/反斜杠 [grid@host02 ~]$ echo $LD_LIBRARY_PATH /u01/app/19.0.0.0/grid //lib:/lib:/usr/lib 4 再次编辑.bash_profile [grid@host02 ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs export PATH export TZ=Asia/Shanghai export ORACLE_SID=+ASM2 export ORACLE_BASE=/u01/app/grid export GRID_HOME=/u01/app/19.0.0.0/grid export PATH=$GRID_HOME/OPatch:$GRID_HOME/bin:$PATH export ORACLE_HOME=/u01/app/19.0.0.0/grid export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib 4 使用sqlplus登录成功 [grid@host02 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 26 09:47:44 2019 Version 19.4.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.4.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.4.0.0.0 [grid@host02 ~]$
sqlplus无法登陆到ASM实例,报ORA-12547: TNS:lost contact错误
来源:这里教程网
时间:2026-03-03 16:43:34
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 网校在线招生模板,快速定制出属于自己的网校小程序
网校在线招生模板,快速定制出属于自己的网校小程序
26-03-03 - 【ORACLE12C】oracle 12C wmsys.wm_concat()函数
- 2021超实用淘宝运营技巧,教你如何与客户做朋友
2021超实用淘宝运营技巧,教你如何与客户做朋友
26-03-03 - Oracle SCN健康状态检查
Oracle SCN健康状态检查
26-03-03 - PLSQL只安装客户端的配置
PLSQL只安装客户端的配置
26-03-03 - 12c rac-rac dg broker和fast-failover及客户端TAF配置详细步骤
- OGG抽取进程延迟100多小时
OGG抽取进程延迟100多小时
26-03-03 - 超实用的短视频脚本写作技巧+脚本公式解析!干货快收藏!
超实用的短视频脚本写作技巧+脚本公式解析!干货快收藏!
26-03-03 - 淘宝死店如何盘活,如何做到日销千单,干货收藏
淘宝死店如何盘活,如何做到日销千单,干货收藏
26-03-03 - 数据库连接异常故障报告
数据库连接异常故障报告
26-03-03
