Oracle Service doesn't start [message #569263] |
Tue, 23 October 2012 14:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ab197c257b85fcc0e0c14fedcc59c7b4?s=64&d=mm&r=g) |
mbentoalves
Messages: 5 Registered: October 2012
|
Junior Member |
|
|
Hi all,
I'm using Oracle 11g running over a Windows 7 OS. The service OracleServiceORCL doesn't start. Listener.log has the following registry:
23-OCT-2012 19:45:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MBA-DB$))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49445)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
When I try to start in services, is returned the OS error 1067.
This error starts to occur when I did the follow. I executed a PL\SQL command to fill a (big) table with a lot of data. More than 1 day after and while the program still running, I broke the program. After that, Oracle was consuming lot of disk. I broke the process (using taskkill /f) and, after that, the database stopped working.
Any ideas about what is happen?
What I can do to recover my database?
Below I list my listener.ora and tnsnames.ora
mbentoalves
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\mba\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\mba\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
|
|
|
Re: Oracle Service doesn't start [message #569267 is a reply to message #569263] |
Tue, 23 October 2012 15:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8935 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
There should be some indication of why the instance doesn't start in the alert log, which will be a file called something like
C:\app\mba\diag\rdbms\orcl\orcl\trace\alert_orcl.log
|
|
|
Re: Oracle Service doesn't start [message #569268 is a reply to message #569267] |
Tue, 23 October 2012 16:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ab197c257b85fcc0e0c14fedcc59c7b4?s=64&d=mm&r=g) |
mbentoalves
Messages: 5 Registered: October 2012
|
Junior Member |
|
|
Below, I list the last entries of the alert_orcl.log
Any help?
***********************************************************************
Mon Oct 22 18:50:28 2012
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 22-OUT-2012 18:50:59
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:ligaÁ„o fechada
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Mon Oct 22 18:50:58 2012
Started redo application at
Thread 1: logseq 10730, block 21372
Recovery of Online Redo Log: Thread 1 Group 2 Seq 10730 Reading mem 0
Mem# 0: C:\APP\MBA\ORADATA\ORCL\REDO02.LOG
opiodr aborting process unknown ospid (3592) as a result of ORA-609
Mon Oct 22 18:51:00 2012
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Mon Oct 22 18:50:58 2012
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
Time: 22-OUT-2012 18:51:08
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 22-OUT-2012 18:51:11
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:ligaÁ„o fechada
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (1844) as a result of ORA-609
Tracing not turned on.
Tns error struct:
ns main err code: 12537
Mon Oct 22 18:51:15 2012
TNS-12537: TNS:ligaÁ„o fechada
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (2812) as a result of ORA-609
Recovery of Online Redo Log: Thread 1 Group 3 Seq 10731 Reading mem 0
Mon Oct 22 18:51:19 2012
Mem# 0: C:\APP\MBA\ORADATA\ORCL\REDO03.LOG
Mon Oct 22 18:52:30 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10732 Reading mem 0
Mon Oct 22 18:53:25 2012
Mem# 0: C:\APP\MBA\ORADATA\ORCL\REDO01.LOG
Mon Oct 22 18:54:51 2012
Completed redo application of 16.01MB
Mon Oct 22 19:07:34 2012
***********************************************************************
Mon Oct 22 19:07:34 2012
***********************************************************************
Mon Oct 22 19:07:42 2012
Process m000 died, see its trace file
Mon Oct 22 19:07:42 2012
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 22-OUT-2012 19:07:52
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:ligaÁ„o fechada
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (1020) as a result of ORA-609
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
Mon Oct 22 19:07:56 2012
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 22-OUT-2012 19:07:57
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:ligaÁ„o fechada
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (4116) as a result of ORA-609
Mon Oct 22 19:08:01 2012
Thread 1: logseq 10732, block 40352, scn 80945009
94131 data blocks read, 93933 data blocks written, 66046 redo k-bytes read
Mon Oct 22 19:08:18 2012
Thread 1 advanced to log sequence 10733 (thread open)
Thread 1 opened at log sequence 10733
Current log# 2 seq# 10733 mem# 0: C:\APP\MBA\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Mon Oct 22 19:08:22 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Oct 22 19:08:23 2012
SMON: enabling cache recovery
Mon Oct 22 19:08:38 2012
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Mon Oct 22 19:08:39 2012
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
Mon Oct 22 19:08:49 2012
No Resource Manager plan active
Mon Oct 22 19:09:08 2012
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Oct 22 19:10:21 2012
Starting background process QMNC
Mon Oct 22 19:10:22 2012
QMNC started with pid=46, OS id=3852
Mon Oct 22 19:11:24 2012
Completed: alter database open
Mon Oct 22 19:12:37 2012
Starting background process CJQ0
Mon Oct 22 19:12:37 2012
CJQ0 started with pid=61, OS id=4792
Mon Oct 22 19:13:04 2012
db_recovery_file_dest_size of 3912 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Oct 22 19:13:13 2012
Starting background process SMCO
Mon Oct 22 19:13:13 2012
SMCO started with pid=56, OS id=5388
Mon Oct 22 19:19:51 2012
Thread 1 cannot allocate new log, sequence 10734
Private strand flush not complete
Current log# 2 seq# 10733 mem# 0: C:\APP\MBA\ORADATA\ORCL\REDO02.LOG
Mon Oct 22 19:20:06 2012
Thread 1 advanced to log sequence 10734 (LGWR switch)
Current log# 3 seq# 10734 mem# 0: C:\APP\MBA\ORADATA\ORCL\REDO03.LOG
|
|
|
|
|
Re: Oracle Service doesn't start [message #569284 is a reply to message #569281] |
Wed, 24 October 2012 03:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/ab197c257b85fcc0e0c14fedcc59c7b4?s=64&d=mm&r=g) |
mbentoalves
Messages: 5 Registered: October 2012
|
Junior Member |
|
|
After two 2 days off, unexpectedly the database starts working. I don't know what I could do for that. I'm doing a backup of the data and then I will re-start the system to see if starts well again.
Thanks for trying to help.
mbentoalves
|
|
|