| OracleService does not start [message #138593] |
Thu, 22 September 2005 10:20  |
rcoumans
Messages: 1
Registered: September 2005
Location: Netherlands
|
Junior Member |
|
|
Hello,
I installed Oracle Server 8.1.5 and the Oracle Enterprise Manager. I used a PC with Windows XP Pro.
I have configured the server, configured the client-machine and after a day of configuring it worked fine. The client-application was working too. All good at the end of the day.... I thought.
I boot the Windows XP Pro 'server', and from then on the trouble started.
My OracleService does not start anymore. In my Computer
Management-Services it was configured as Startup Type Automatic. The status is Starting and it never stops Starting. It will not go to Started. So I've set the startuptype to manual, rebooted and tried to start the OracleService manually via Computer Management-Services. After a while I get the message Error 1053 that the service couldn't be started in a
timely fashion.
The TNSListener is started.
computername: hertog-oracle
global databasename: DBHERTOG
SID: SIDHERT
TNSNAMES.ORA:
DBHERTOG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hertog-oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBHERTOG)
)
)
Please help!! How can I get the database started again? I heard it could via SQL Plus, I tried 1000 users, passwords (just the defaults), and host-strings, nothing works to log on. What host-string should I use in this case?
Thanks in advance,
Roy
|
|
|
|
| Re: OracleService does not start [message #138596 is a reply to message #138593] |
Thu, 22 September 2005 10:26  |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
Go to a command line prompt and type
CMD>sqlplus "/ as sysdba"
SQL> startup
This will still not probably start the database as the service is still stopped, but it might throw up an error or two.
Your best bet is to got to your alert log and see what errors it has recorded.
This can be found (usually) in an admin/udump directory on the server (PC) the file is called ALERThert.ora.
Have a look at it and post us your entries and we will see what we can do.
Allie
|
|
|
|
| Re: OracleService does not start [message #138597 is a reply to message #138596] |
Thu, 22 September 2005 10:35 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Do below writeen steps
Press Alt+Ctl+Del.
then click at task manger
in that click processes tab
than right click oracle.exe
than click end process tree.
Note :- As your database is down ... to kill oracle.exe will not going to make any difference.
now go to services in that make services all manual
then reboot your system.(server)
Thats it.... i hope it shud work
Regard
Always friend sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
