ORA-12528

 

ORA-12528:all appropriate instances are blocking new connections

 Listener.ora

# listener.ora Network Configuration File: c:/oracle/product/10.1.0/Db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = c:/oracle/product/10.1.0/Db_1)

      (PROGRAM = extproc)

    )

 

 

    (SID_DESC =

      (GLOBAL_DBNAME = ofs1)

      (ORACLE_HOME = c:/oracle/product/10.1.0/Db_1)

      (SID_NAME= ofs1)

    )

 )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

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

      )

      (ADDRESS_LIST =

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

      )

    )

  )