listener does not currently know of 。。。。

打开Oracle的 listener.ora 文件：

（../oracle/product/10.2.0/db_1/network/admin/listener.ora）

 

设置环境变量：

Oracle_Sid    orcl（为你的数据库实例）

 

 

# listener.ora Network Configuration File: C:\app\Training\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
            (PROGRAM = extproc)
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = C:\app\Training\product\11.2.0\dbhome_1)
        )
//添加此段代码（orcl为你的数据库实例）
        (SID_DESC =
            (GLOBAL_DBNAME = ORCL)
            (ORACLE_HOME = C:\app\Training\product\11.2.0\dbhome_1)
            (SID_NAME = ORCL)
        )
        
)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ooooo)(PORT = 1521))
　　　　　　　　　　　　　　　　　　　　　　//ooooo为你的计算机全名
    )
  )

ADR_BASE_LISTENER = C:\app\Training