忘了oracle的账号密码oracle监听文件配置

oracle监听文件配置

 

pl/sql可以启动数据库,但是是myeclipse连接数据库报错,原因是数据库监听文件报错,即listener.ora配置出错,该文件正确的内容如下: 

# listener.ora Network Configuration File: \app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora 

# Generated by Oracle configuration tools. 

oracle账号 

SID_LIST_LISTENER = 

  (SID_LIST = 

    (SID_DESC = 

      (SID_NAME = PLSExtProc) 

      (ORACLE_HOME = \app\Administrator\product\11.1.0\db_1) 

      (PROGRAM = extproc) 

    ) 

    (SID_DESC = 

      (GLOBAL_DBNAME = ORCL) 

      (ORACLE_HOME = \app\Administrator\product\11.1.0\db_1) 

      (SID_NAME = ORCL) 

    ) 

  ) 

 

LISTENER = 

  (DESCRIPTION_LIST = 

    (DESCRIPTION = 

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) 

    ) 

  ) 

 

该文件端口号位1521,连接的位本机可以是127.0.0.1,也可以为localhost

 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。