 Automatically start Oracle instance after booting [message #661008] |
Sat, 04 March 2017 13:00  |
 |
chris2018
Messages: 16
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 #661012 is a reply to message #661008] |
Sat, 04 March 2017 22:59  |
 |
Barbara Boehmer
Messages: 9104
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
