Home » Infrastructure » Windows » Automatically start Oracle instance after booting (Oracle 10 R2 XE, Win2k3)
icon5.gif  Automatically start Oracle instance after booting [message #661008] Sat, 04 March 2017 13:00 Go to next message
chris2018
Messages: 11
Registered: February 2017
Junior Member
All,

I've to manually startup Oracle Instance after booting Windows. (sqlplus, sysdba, startup) If I don't, Database Homepage isn't listening on port 8080. I think Windows Services are configured properly, because in another virtual machine the database is starting normally.

OracleJobSchedulerXE is Disabled
OracleMTSRecoveryService Manually
OracleServiceXE Started
OracleXEClrAgent Manually
OracleXETNSListener Automatically

This is listener.log after booting:
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-MRZ-2017 19:57:59

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Die System-Parameterdatei ist C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Log-Meldungen wurden geschrieben in: C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Die Trace-Information wurde in C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc geschrieben
Die Trace-Ebene ist derzeitig 0

Gestartet mit Pid=1352
Listen auf: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
Listen auf: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE


How can I make it start automatically?

- Chris

[Updated on: Sat, 04 March 2017 13:13]

Report message to a moderator

Re: Automatically start Oracle instance after booting [message #661011 is a reply to message #661008] Sat, 04 March 2017 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

oradim -EDIT -SID xe -STARTMODE auto -SRVCSTART system

Re: Automatically start Oracle instance after booting [message #661012 is a reply to message #661008] Sat, 04 March 2017 22:59 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
On Windows machines, if you wish to use GUI instead of command line, you can right click on start, then select control panel, then select system and security, then select administrative tools, then select services. From there, you can scroll down to the services beginning with the word Oracle. There should be services named Oracle...TNSListener and OracleService.... If you double click on them, one at a time, you will get a menu that will enable you to change their startup type from manual to automatic, then click OK, then click apply. Those changes should take effect the next time that you start your computer. In your case, it looks like only OracleServiceXE needs to be changed to automatic.


[Updated on: Sat, 04 March 2017 23:01]

Report message to a moderator

Re: Automatically start Oracle instance after booting [message #661013 is a reply to message #661012] Sun, 05 March 2017 01:18 Go to previous message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This only changes the service startup action (SRVCSTART) not the instance startup action (STARTMODE) which is MANUAL by default.

Previous Topic: Error in writing to directory
Next Topic: DateTime as DMP File Name
Goto Forum:
  


Current Time: Wed Dec 13 05:23:39 CST 2017

Total time taken to generate the page: 0.01661 seconds