?
Solved

Oracle 10g Listener Set up on windows

Posted on 2008-11-09
4
Medium Priority
?
6,829 Views
Last Modified: 2013-12-19
I have installed Oracle Database 10.2.0.1 on windows NT, But i am not able to bring the listener up
 there is  a 9i database with its listener. so i got this 9i listener down and cleared the registry
and rebooted the windows server. So there is no 9i listener now on the server

weird thing is  when i am trying to bring the 10g listener up the previous 9i logs are getting updated.
I have set the ORACLE_SID  and ORACLE_HOME and PATH so that they reflect new 10g parameters

Here are the listener.ora and tnsnames file

******************************************Listener File**************************************
 
SID_LIST_LISTENER10GR =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora10g2)
      (PROGRAM = extproc)
    )
  )
LISTENER10GR =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = *******)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ********(PORT = 1521)(IP = FIRST))
    )
  )

***************************************************tnsnames****************************************
LISTENER10GR =
  (ADDRESS = (PROTOCOL = TCP)(HOST = *********)(PORT = 1521))
 
 
****** =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =********)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST =********)(PORT = 1521))
       (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ****)
    )
  )

Here are  the steps i am following to get the 10g listener up on command prompt

set ORACLE_SID=****  (new 10g sid)
set ORACLE_HOME=****(new 10g home)
PATH=%ORACLE_HOME%\bin;%PATH%  (new 10ghome\bin)
set TNS_ADMIN=%ORACLE_HOME%\network\admin  (10g network admin)

lsnrctl start LISTENER

LSNRCTL for 32-bit windows: version 10.2.0.1.0 - Production on 09-NOV-2008 19:00:23

Copy right (c) 1991, 2005, Oracle. All rights reserved

starting  tnslsnr: please wait ....

TNS-12560: TNS: protool adapter error


-- so this is the error i am getting "TNS-12560: TNS:protool adapter error"

when i look at SQL NET log i see the following error

Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=********)(Port=1521))(CONNECT_DATA=(SID=******)(CID=(PROGRAM=oracle10 _home\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=*********)(USER=SYSTEM))))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
 Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
  Time: 09-NOV-2008 19:25:54
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener
    nt secondary err code: 61
    nt OS err code: 0



Let me know what the solution can  be to bring the listener up


Thanks

0
Comment
Question by:reddysr
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 22919594
You can create  a new listener by using Oracle "Net configuration assistance" just make sure 9i listener is not using default port (in order words) select different port#.

You can use 1 listener to connect to Oracle9i and Oracle10g database using 1521 default port number. There is no need to create additional listener. See Oracle documentation on Network Management.

Here is the link:
http://www.oracle.com/pls/db111/portal.portal_db?selected=4&frame=#network_management

Good luck!




0
 

Author Comment

by:reddysr
ID: 22922041
Thanks for the note mohammadzahid,

I tried to configure a new listener using NETCA as you have suggested
again i specified the 10g env from command prompt and invoked NETCA from command prompt itself

the GUI tool  says that the net configuration is completed  but here is what it shows on the command prompt

netca
Oracle Net Services Configuration:
Configuring Listener: LISTENER
default local naming configuration complete
listener configuration complete
Oracle net listener Startup:
    Running Listener control:lsnrctl start LISTENER
LISTENER not Started because another listener may aleady be up


But.. There is no listener up, I  have deleted the registry for the listener
and another wierd this is the NETCA is creating it new tnsnames and listener.ora files in the previous 9i
ORACLE_HOMe_9i_/network

The logs are getting updated in

ORACLE_HOME_9i/logs

i still can understand why 9i  files systems are updated when i set the environment to 10g in the command prompt


is it because of the registry which is overriding my 10g settings for the envinronment?
let me know, thanks for the help

thanks
   
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 22924923
Did you run "Net configuration assistance" from 10g home or from 9i home. I am assuming you have 2 separate folders (1 for 9i and other for 10g installation)?

Try issuing commands for listener from the command line that will give you more detail on what is going on with the listener configuration.

1. C:> LSNRCTL

2. LSNRCTL> help

3. LSNRCTL> status  
0
 

Accepted Solution

by:
reddysr earned 0 total points
ID: 23031574
The system level environment variables must be unset
i
0

Featured Post

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!

Question has a verified solution.

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

Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
An article on effective troubleshooting
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

807 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