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)) ) ) 5ADR_BASE_LISTENER01 = G:\app\product\12.2.0\dbhome_1\log
ADR_BASE_LISTENER = G:\app\product\12.2.0\dbhome_1\log
Related questions 1 Oracle connection problem 0 Error while connecting to oracle DB 6 Oracle database connectivity issue Related questions 1 Oracle connection problem 0 Error while connecting to oracle DB 6 Oracle database connectivity issue 4 Cannot connect to database in new installation of Oracle 12c 3 Oracle database 12c Error while trying to connect: The Network Adapter could not establish the connection 4 Oracle Database12c ORA 01918 and connection error 0 Cannot connect to oracle database 1 Unable to Connect to Database 12c 2 Oracle 12c Unable to connect to Oracle database : ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 1 Can't connect to Oracle DB ORA-12560 error Load 7 more related questions Show fewer related questions
Reset to default
