Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Oracle > Listener won't start after 9i to 10g upgrade

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-05-08, 21:09
robert xr4x4 robert xr4x4 is offline
Registered User
 
Join Date: Mar 2004
Location: Berkshire, UK
Posts: 158
Listener won't start after 9i to 10g upgrade

On a windows 2000 box I have been running 9i for ages

I have installed 10g and I can't get the listener to start.

I have done exactly the same on 8 other servers now with no problem so I'm not sure why it's not working.

I have installed into a oracle new home, I have checked all the environment variables and none are pointing at the 9i home, I have set TNS_ADMIN to the 10g home but still doesn't work.

What is very strange is it is logging to the 9i directory but using the 10g listener.ora .... any ideas why this is?

I've got to get this working by tomorrow evening :o(

This is the error log :

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JAN-2008 23:50:24

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is C:\oracle\ora10g\network\admin\listener.ora
Log messages written to c:\oracle\ora92\network\log\listener.log
Trace information written to c:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0

Started with pid=2992
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1) ))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable
__________________
There are 10 types of people in the world, those that know Binary and those that don't.

Last edited by robert xr4x4 : 01-05-08 at 21:28.
Reply With Quote
  #2 (permalink)  
Old 01-05-08, 22:30
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 3,569
I know for a fact that if you accept the common defaults (port=1521,etc.),
then no listener.ora file is required for a V10 instance.

I suggest that you rename all listener.ora file out of the way & try again.

IMO, it the V9 listener.log file is being updated, then the V9 listener is REALLY, REALLY the one being invoked.

HTH & YMMV!
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On