как исправить ошибку SP2-0640: Not connected?

Я установил Oracle 11g, но не могу настроить Sql developer ошибка ORA-12505, что может быть?

alexsemen94,

А воспользоваться поиском религия не позволяет?

UDW,

а я уже 4 час бегаю по сети, и листенер менял и еще дофига чего и ничего.... лучше бы норм советом помогли

alexsemen94,

Начни поиск строки '12505'

1. tnsnames.ora
2. listener.ora
3. lsnrctl services

PS
Не надо столько бегать по сети, надо скачать один раз доку. В данном случае зри том Error Messages

tru55,
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = pc-00241.office.lamoda.ru)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc-00241.office.lamoda.ru)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully

автор

LSNRCTL> services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER The command completed successfully

У Вас не зарегистрирован сервис XE в LISTENER
причины:
- не запущен OracleServiceXE
- Ошибка (TCP/IP)/параметр local_listener для автоматической регистрации XE в listener

Последовательно проверьте:

C:\>sc query OracleServiceXE

SERVICE_NAME: OracleServiceXE
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 4  RUNNING
                                (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

C:\> ping pc-00241.office.lamoda.ru
...
C:\> set ORACLE_SID=XE
C:\> sqlplus / as sysdba
SQL> show parameters local_li
SQL> exit

Довесок: Oracle не очень любит имена хостов, в которых содержится тире

Vadim Lejnin,

C:\> sqlplus / as sysdba
здесь вылетает ошибка ORA-12638: Credential retrieval failed

alexsemen94,

запустил cmd через администратор теперь вылазит такая ошибка
ORA-12560 TNS: protocol adapter error