问题:
sqlplus sys/oracle as sysdba 能访问
sqlplus sys/oracle@sggis as sysdba 不能
原因:oracle安装后未能正确维护listener.ora文件
1. vi <OracleHome>/network/admin/listener.ora文件,找到:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
(SID_DESC =
(GLOBAL_DBNAME = sggis)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = sggis)
)
3. Last:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = sggis)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = sggis)
)
)
4、重启监听lnstrl stop /start