Solved

Can not start OracleTNSListener and OracleAgent

Posted on 2003-11-04
7
2,857 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 35

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
Independent Software Vendors: 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!

 
LVL 35

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 35

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
any step by steps guide on how to install Oracle 12c on Windows 10 8 191
Checking for column width 8 49
oracle query 3 35
Oracle - BLOB Extract Line 2 21
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

752 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