I have a problem that a computer´s OracleServiceORCL will not start. Neither the OracleOraHome81Listener.
This happened when the computers hard disk was starting to get full, and the network consultant moved the Windows Swap file (virtual memory file) to a new location (other hard drive).
How to I try to start the Oracle service manually? A cannot do it from the ORacle DBA Studio, since it cannot access the database.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I can´t restart manually from the Windows services. I get an error: 5.
When I try lsnrctl start listener I get:
TNS 12536 Operation would block
TNS 12560: protocol adapter error
TNS 00506: Operation would block
32-bit Windows error: 997: Unknown error
(error messages translated from swedish so they might differ somewhat...)
The sqlnet.log says:
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Time: 19-JUN-2007 14:33:40
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12541
TNS-12541: TNS: No listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
You are having problems starting an Oracle instance from WINDOWS. I will show you how to stop everything and then restart it. I assume the space issue on the disk drive is solved. I assume the oracle software was installed only once in this machine.
Log into your machine as the user that installed the Oracle database software. Open a DOS prompt window and enter the following commands.
-- Start of commands
REM: Cleaning up. Stopping the database if still on. Do not worry about Error messages.
NET STOP OracleOraHome81Listener
ORADIM -SHUTDOWN -SID ORCL
REM: Restarting the Database. Send me the error messages if any.
NET START OracleOraHome81Listener
ORADIM -STARTUP -SID ORCL
-- End of commands
This should work for you. The explanation of what I am doing is too long for this forum.
It is better to delete the service using oradim and create new service.
oradim -Delete -SID <sid>
oradim -NEW -SID <sid>
or you can also check the below note from metalink to try resolving the issue.
Subject: LOG & TRACE Facilities on NET v2.
Doc ID: Note:39774.1 Type: FAQ
Last Revision Date: 31-JAN-2002
Business Accounts
Answer for Membership
by: jwahlPosted on 2007-06-19 at 04:16:24ID: 19314702
check in windows services if the tasks are running.
you can start/restart them manually there.
if startup fails, check log and alert files for more informations.