ORACLE不能访问

问题：

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)

    )

）

  2. Add：
      (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