有没有人这么做:
在另外一个linux主机上, 打开终端:执行ssh oracle@[B] "sqlplus / as sysdba" 来登陆数据库.
我在一个两节点RAC(两个节点上的各个环境变量、目录结构都是一样的)上做了测试:
[oracle@rac1 ~]$ ssh 10.0.38.123 hostname
rac2
[oracle@rac1 ~]$ ssh 10.0.38.123 date
Fri Sep 19 22:14:02 CST 2008
[oracle@rac1 ~]$ ssh 10.0.38.123 "sqlplus / as sysdba"
bash: sqlplus: command not found
[oracle@rac1 ~]$ ssh 10.0.38.123 "lsnrctl stat"
bash: lsnrctl: command not found
[oracle@rac1 ~]$ ssh 10.0.38.123 "/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl stat"
LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 19-SEP-2008 22:14:51
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNSMessage 1050 not found; No message file for product=network, facility=TNS
Message 1050 not found; No message file for product=network, facility=TNS
Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1052 not found; No message file for product=network, facility=TNS[oracle@rac1 ~]$
[oracle@rac1 ~]$ ssh 10.0.38.123 "/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus / as sysdba"
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@rac1 ~]$
这些又表明什么呢?
[ 本帖最后由 ruluo 于 2008-9-18 22:40 编辑 ]
|