Sp2-0640: Not Connected

I have 2 oracle db (ORCL and ORCL24) and I can't connect to ORCL database

«Выполняется» = Started

my listener.ora

 SID_LIST_LISTENER01 =   (SID_LIST =
     (SID_DESC =
       (GLOBAL_DBNAME = ORCL24)
       (ORACLE_HOME = G:\app\product\12.2.0\dbhome_1)
       (SID_NAME = ORCL24)
     )   )

 SID_LIST_LISTENER =   (SID_LIST =
     (SID_DESC =
       (SID_NAME = CLRExtProc)
       (ORACLE_HOME = G:\app\product\12.2.0\dbhome_1)
       (PROGRAM = extproc)
       (ENVS = "EXTPROC_DLLS=ONLY:G:\app\product\12.2.0\dbhome_1\bin\oraclr12.dll")

 )
 (SID_DESC =
   (GLOBAL_DBNAME = ORCL)
   (ORACLE_HOME = G:\app\product\12.2.0\dbhome_1)
   (SID_NAME = ORCL)
 )   )

LISTENER01 =   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = PC)(PORT = 1526))   )


 LISTENER =   (DESCRIPTION_LIST =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
     )
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     )   )

ADR_BASE_LISTENER01 = G:\app\product\12.2.0\dbhome_1\log

ADR_BASE_LISTENER = G:\app\product\12.2.0\dbhome_1\log

5
Robert Thorne

Robert Thorne

Automotive & Future Transportation Editor

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.

Share this article