• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2864
  • Last Modified:

Can not start OracleTNSListener and OracleAgent

hello everyone,  

I have recently installed Oracle9i (9.2.0.1) on a Windows 2000 server. Before installing the latest patch, everything was fine and all services were up and running.
After installing the patch to upgrade to Oracle 9.2.0.4. I could not longer start the Oracle9iTNSListener and the Oracle9iAgent. I have not created a dB instance yet as I was about to so and now I can't. would anyone have an idea as to what may be wrong? many thanks!!.

-Sorin
0
MetroNY
Asked:
MetroNY
  • 3
  • 3
1 Solution
 
mdbaCommented:
What is the error you are getting when you try to start it up?  Does it just time out?  Have you looked at the log file in the listener directory to see if there are any errors there?
0
 
Mark GeerlingsDatabase AdministratorCommented:
Without some more specifics from you, it is difficult to trouble shoot this.  Oracle9.2.0.4 certainly works on Windows2000 - I have that combination.  Have you tried rebooting?  If you try to start the Oracle service from a DOS prompt, what happens?  The syntax is:
net start [service_name]

For the listener, it is:
lsnrctl start

or:
lsnrctl status

or:
lsnrctl stop
0
 
MetroNYAuthor Commented:
oh, sorry, ok, here's what happens:
the service just times out
I tried the Net Start and still times out
when I try to run the Oracle commands (any command), I get an error that says some information is missing from dynamic library Oranls9.dll.  I don't know much about this file and what it does. I hope some of this information is useful.

-Sorin
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mark GeerlingsDatabase AdministratorCommented:
I'm not familiar with that Ora*.dll file.  Have you tried starting the listener from a DOS prompt?  Have you rebooted since installing the patch?
0
 
MetroNYAuthor Commented:
yes..I rebooted multiple times...and I did try the

lsnrctl start
lsnrctl status

from the DOS prompt...and still nothing...I am beginnig to wonder if the upgrade process went wrong. I think I'll try to reinstall it or something...and the first thing I upgraded was the Universal installer, so it had no reason to complain...I'll try again...

0
 
Mark GeerlingsDatabase AdministratorCommented:
You tried:
lsnrctl status

and the response was "nothing"?  I find that hard to believe.  I would expect either a DOS/Windows "bad command or file name" message or some kind of response from the Oracle listener.  Here's what I get from my PC (with the listener not started):
C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production on 05-NOV-2003 08:28:44

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=G0841)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

C:\>

- - -(end of pasted output from "lsnrctl status") - - -

Maybe you are best off doing a complete uninstall and re-install.  There is no automated way to do a thorough uninstall, you have to do at least part of it manually.  I find it fastest to do the complete uninstall manually.

1. Open the "Services" windows and stop any/all Oracle-related services.
2. From Windows Explorer:
  a. delete the Oracle_home directory tree
  b. delete the C:\Program files\Oracle directory tree
3. Run Regedit:
  a. go to Hkey-Local-Machine, Software and remove the Oracle key
  b. go to Hkey-Local-Machine, System, CurrentControlSet, Services and remove the "Oracle..." entries
4. Remove any Oracle-related directories from your search path.  To do this:
right-click "My Computer"
choose Properties, then click the Advanced tab
In the "System Variables" area, scroll to "Path", click "Edit", then remove the two entries:
[Oracle_home]\bin
[Oracle_home]\jdk\bin
Save the changes, then reboot and re-install Oracle.
0
 
MetroNYAuthor Commented:
well, the response when I ran the "lsnrctl status" command was a pop up and it said that some information is missing from dynamic library Oranls9.dll.  and now I can not reproduce the error message because the network admin wiped out the server and starterd over.  The server was new and we were trying to install 9i.  I will try the entire install process again and upgrade and I will post any results I obtain. Thank you for your help.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now