listener does not currently know of SID given in connect descriptor

listener does not currently know of SID given in connect descriptor

 

Oracle 10G

E:\Working\neworacle\NETWORK\ADMIN

 

 

localhost 改为 127.0.0.1

 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\GRGWorking\neworacle)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
    )
  )

 

 

------------------------------

 

 

 

# listener.ora Network Configuration File: E:\GRGWorking\neworacle\network\admin\listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = E:\GRGWorking\neworacle)

      (PROGRAM = extproc)

    )

   (SID_DESC =

      (SID_NAME = feelview

      (ORACLE_HOME = E:\GRGWorking\neworacle)

      (global_dbname = feelview)

    )

    (SID_DESC =

      (SID_NAME = turkey1

      (ORACLE_HOME = E:\GRGWorking\neworacle)

      (global_dbname = turkey1)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

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

      )

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

      )

    )

  )