PL/SQL Developer登录oracle 11g登录超时

PL/SQL Developer登录oracle 11g登录超时

---

修改tnsnames.ora文件：

其中的这一部分：
XE =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = XE)
 )
 )

Host值改为localhost，不是你的主机名;

---

修改listener.ora文件：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = G:\oraclexe\app\oracle\product\11.2.0\server)
      (GLOBAL_DBNAME = XE)
    )
  )