Home » Infrastructure » Windows » Oracle Service doesn't start (Oracle 11g Win7 64 bits)
Oracle Service doesn't start [message #567563] Wed, 03 October 2012 06:02 Go to next message
mbentoalves
Messages: 5
Registered: October 2012
Junior Member
I've installed oracle 11.2 in Windows 7 - 64 bits. Everything was working fine until suddenly stops working. Oracle Service (OracleServiceORCL) doesn't start and when I try to start manually, returns OS error 1067. Listener starts well. Below I list my listener.ora, sqlnames.ora and sqlnet.ora

# listener.ora Network Configuration File: C:\app\mba\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

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))
    )
  )

ADR_BASE_LISTENER = C:\app\mba

**********************
# tnsnames.ora Network Configuration File: C:\app\mba\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

***************************
# sqlnet.ora Network Configuration File: C:\app\mba\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


*****************

Any ideas?

Thanks,
mbentalves
Re: Oracle Service doesn't start [message #567566 is a reply to message #567563] Wed, 03 October 2012 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1067L, "ERROR_SERVICE_SPECIFIC_ERROR: The service has returned a service-specific error code."


Check in Windows application event log what is the error Oracle encounters/returns.

Regards
Michel
Re: Oracle Service doesn't start [message #567571 is a reply to message #567566] Wed, 03 October 2012 06:38 Go to previous messageGo to next message
mbentoalves
Messages: 5
Registered: October 2012
Junior Member
Hi Michel,

I found the problem. It was the Windows firewall. I read somewhere to try to disable the firewall, I did it and the service starts well. I turn on again the firewall but I define a rule to port 1521. My main problem was that everything was working fine and suddenly doesn't work. Perhaps was a windows update that changes firewall definitions.

(Simple solution that take me several hours to solve)

mbentoalves
Re: Oracle Service doesn't start [message #567576 is a reply to message #567571] Wed, 03 October 2012 07:01 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know.

Regards
Michel
Previous Topic: Can not create database PACKS and create a user PACKS (merged)
Next Topic: Unable to delete SMON trace file
Goto Forum:
  


Current Time: Thu Mar 28 13:14:26 CDT 2024