алерт лог не могу найти в папке
C:\oracle\ora102\db_1\RDBMS\trace
нету :(
запустился по расписанию оптимизатор
27.02.13 16:59:17 -- OLEGON-ERROR! : List process : java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:17 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:18 -- Cards count :
27.02.13 16:59:18 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:18 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:18 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:19 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:19 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:19 -- Report table created...
27.02.13 16:59:19 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:20 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
27.02.13 16:59:20 -- Task table created...
27.02.13 16:59:20 -- OLEGON-ERROR! : Conn:ocean2:ocean:java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ocean2:1521:ocean
сейчас алерт ищу
Добавлено через 5 минут 2 секунды
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Adm>cd \
C:\>set nls_lang=american_america.cl8mswin1251
C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 27 17:03:40 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1298160 bytes
Variable Size 541065488 bytes
Database Buffers 62914560 bytes
Redo Buffers 7090176 bytes
SQL> alter database mount;
Database altered.
SQL>
Добавлено через 25 минут 8 секунд
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required