解决oracle重启后出现无法连接问题

一、解决监听问题

• 在oracle服务器Oracle安装目录（我的在E:\Oracle10g下，每个人的不一样，根据自己的情况查找）Network/admin目录下找到listener.ora 我的如下图所示

# listener.ora Network Configuration File: E:\Oracle10g\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = E:\Oracle10g)
     (PROGRAM = extproc)
   )
   (SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = E:\Oracle10g)
   (SID_NAME = ORCL)
   )
)

 

二、解决dnsnames.ora配置问题：

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

三、重建pfile

sqlplus /nolog

conn /as sysdba

create spfile from pfile=’PFILE_PATH';

startup;

四、如果重建后无效

修改pfile文件：

找到local_listener这一行，然后将其值修改为：

(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))