CentOS4.5+Oracle10.2
安裝成功,在客戶端用TOAD連接可以正常使用,但在服務器上操作卻有以下問題:[root@orasrv bin]#sqlplus /nolog
SQL*Plus: release 10.2.0.1.0 - Production on Sat Aug 11 17:16:31 2007
Copyright(c) 1982,2005,Oracle. All rights reserved.SQL>connect sys/xxx as sysdba;
ERROR:
ORA-01031: insufficient privilegesSQL>connect sys/xxx
ERROR:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
linux Error:2:No such file or directory請教各位以上錯誤如何解決.
SQL>connect payroll/xxx
ERROR:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
linux Error:2:No such file or directory但用toad在客戶機連接可以正常使用,同一用戶和密碼,在客戶機可以用,在服務器卻不可用,真奇怪,是不是服務器哪里設置不對?
ORACLE_SID 改了一下就可以了.