Solved

Can not start OracleTNSListener and OracleAgent

Posted on 2003-11-04
7
2,850 Views
Last Modified: 2012-08-14
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
Comment
Question by:MetroNY
  • 3
  • 3
7 Comments
 

Expert Comment

by:mdba
ID: 9681739
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
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 9681826
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
 

Author Comment

by:MetroNY
ID: 9682401
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 9682432
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
 

Author Comment

by:MetroNY
ID: 9682480
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
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 50 total points
ID: 9686551
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
 

Author Comment

by:MetroNY
ID: 9686611
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now