Oracle error.

128 views
Skip to first unread message

Soumyen

unread,
Oct 11, 2008, 11:20:51 AM10/11/08
to Oracle Apps Technology
In my hope PC I have Windows XP, I am going to install Oracle 9i,

Installation completed successfully except 'Agent Configuration
Assistant' failed.

When I am trying to start the listener services from the Windows
Service Utility, i am getting the following error for couple of
services namely --
OracleOraHome92Agent,OracleOraHome92HTTPServer,OracleOraHome92PagingServer
OracleOraHome92TNSListener etc.

Error:
The Oracle92TNSListener on Local Computer Started and then Stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alert service

If i delete all my previous listener services from oracle through "Net
Manager", although these listener services are showing in the "
Window's Service window" --why?

When i am trying to run listener from windows command prompt, getting
the following error

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is E:\oracle\ora92\network\admin\listener.ora
Log messages written to E:\oracle\ora92\network\log\listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=home-8bdc697937)(P
ORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

How to proceed?

oracleapps...@gmail.com

unread,
Oct 13, 2008, 9:01:22 AM10/13/08
to Oracle Apps Technology
Hi Soumyen,

Deleting through NetManager will only remove the entries from
listener.ora, it is not going to remove it from windows service
manager. To delete a window server you need to use this command:

sc delete <Service Name>

For example:
sc delete Oracle81TNSListener

It seems like port 1521 is occupied by a previous installation of
Oracle. To verify give this command on command prompt:

telnet localhost 1521

If your screen goes blank, that means port 1521 is occupied. You can
exit the blank screen by pressing Ctrl + ] (right common square
bracket), which will bring you to telnet prompt, from where you can
type exit. On the other hand if port 1521 is available then you'll
get a message like this:

C:\>telnet localhost 1521
Connecting To localhost...Could not open connection to the host, on
port 1521: Connect failed

You need to stop all the old listener services, only then you'll be
able to start listener from windows command prompt.

Hope this helps

- Vikram
Reply all
Reply to author
Forward
0 new messages