Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • V$ROLLSTAT status is Full Oracle
  • SYSOPER Mystery Oracle
  • This is from Temi Oracle
  • Database logon trigger issue Oracle
  • Python class import from different folders Python/PySpark
  • Read CSV File using Python Python/PySpark
  • Oracle Statspack survival Guide Oracle
  • shr1.sql for MTS or Shared server configuration Oracle
  • How to remove blank lines using vi editor command Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • Renaming Oracle Instance Name Oracle
  • AWR license Oracle
  • Good notes for shared pool Oracle
  • setting prompt display with .profile Linux/Unix

Multiple listeners

Posted on 23-Aug-2007 By Admin No Comments on Multiple listeners

TNS-00512 starting second listener in same node

Hi all,

I have a 8.1.7.4 listener running OK with a 9.2.0.1 listener in the same Solaris box, I get TNS-00512 starting second listener from 9.2.0.1 ORACLE_HOME.

I have changed the ports number, but the problem still persist !!!

Here are the listener.ora file:

Listener.ora (8.1.7.4)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = local))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = gemini)(PORT = 1521))

)

(DESCRIPTION =

(PROTOCOL_STACK =

(PRESENTATION = GIOP)

(SESSION = RAW)

)

(ADDRESS = (PROTOCOL = TCP)(HOST = gemini)(PORT = 2481))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /usr/local/oracle8174)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = sieprod)

(ORACLE_HOME = /usr/local/oracle8174)

(SID_NAME = sieprod)

)

)

Listener.ora (9.2.0.1)

LISTENER92 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = local0))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = gemini)(PORT = 1522))

)

(DESCRIPTION =

(PROTOCOL_STACK =

(PRESENTATION = GIOP)

(SESSION = RAW)

)

(ADDRESS = (PROTOCOL = TCP)(HOST = gemini)(PORT = 2482))

)

SID_LIST_LISTENER92 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /usr/local/oracle92)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = oratest)

(ORACLE_HOME = /usr/local/oracle92)

(SID_NAME = oratest)

)

)

Any suggestion?

Thanks in advance.

Fabio Arienzo

Fabio Arienzo

Data Base Administrator

Kuwait Petroleum

Rome (Italy)

——————————————————————————–

From: Oracle, Kurt Bevers 26-Sep-03 15:26

Subject: Re : TNS-00512 starting second listener in same node

Action :

=========

1# A review on the information seem to show the listener for both the 8i and 9i are setup in the proper manner you did not state how you tried to start the listener when running Multiple Listeners you must use the listener name to start that listener as in this case starting the listener from the command prompt

lsnrctl > start listener <==== this will start the 8i listener called << listener >>

lsnrctl > start LISTENER92 <==== this will start the 9i listener called << LISTENER92 >>

2# there are many thing to keep inmind when using Multiple Listeners please note you have your 9.2.0.1 listener and instance using Port# 1522 however if you have not set the local_parameter in the 9i init.ora file this instance will also register to the 8i listener listening on default port 1521 this can cause many problem even if you have set the Local_Listener in the init.ora file if you are using the SPfile in 9i this will not get updated just by restart the listener or instance, the following information is what I use to resolve most if not all of the problems

======================================================================

1# There couple of rules to follow when running 2 listener

A# There 3 main rules to remember when running Multiple Listeners

Rule #1 : each listener must have it own Unique listener name the default is listener so in this case let’s say the Oracle home 1 listener is called listener then the Oracle home 2 listener will needed a name like << NEW_LIST >> and to start this listener you would use a command from the listener command prompt like

lsnrctl > start << NEW_LIST >> i <==== this will start the 8i listener called << NEW_LIST >>

lsnrctl > start listener <==== this will start the 8i listener called listener Rule #2 each listener must use a Unique Port # the default is 1521 so in this case the Oracle home 1 listener must be on 1521 and your Oracle Home 2 listener can be another port like 1523 or a port of your choosing Rule #3 each listener must have a unique IPC entry’s this is the most over looked mistake and will stop the second listener from starting and the most common entry over looked is the EXTPROC entry just make sure there are no dup IPC entry’s B# Please review the following Oracle Note on setup and running Multiple Listeners Creating Multiple Listeners on UNIX – Including Migration or Upgrades

Creating Multiple Listeners on Microsoft NT using Net 8.0.x

Checklist for Migrating from Oracle7 to Oracle8.1 on UNIX

‘TNS-12539: TNS:buffer over- or under-flow’ in the listener log

RUNNING TWO LISTENERS IN SQL*NET V2 ON UNIX

======================================================================

NOTE: Dparton is answering the Networking Technical Forum in place of Kbevers on 9/26/03

Also if your problem continues please file a TAR# with Oracle support

——————————————————————————–

From: Oracle, Kurt Bevers 26-Sep-03 15:27

Subject: Re : TNS-00512 starting second listener in same node

2# There are other possable problems running 2 listeners in 8i and 9i there is new feature call service registration / auto registration if you do not want the 8i beening register to the 9i listener then you will need to use the Local_Listener parameter in the init.ora file

A# The most common work around to the cross registration problem is using the local listener parameter In the init.ora file add the following parameter there are 2 option to use and in most case cases option 1# is the best to start with.

Option 1# :

=========

local_listener = “(address=(protocol=tcp)(host=serverhostname)(port=your_port))”

Option 2# :

========

local_listener=listener_alias

where listener_alias is an alias known in the tnsnames.ora file.

Add, for example:

local_listener=list2.world

In the tnsnames.ora file, add the following service_name entry:

listener_alias=

(description=

(address=(protocol=tcp)(host=serverhostname)(port=your_port)))

Add for example:

list2.world=

(description=

(address=(protocol=tcp)(host=hostname)(port=1522)))

NOTE: With both options the instance will need to be restarted and if possable the listener as well,to gain a better understanding of the service registration feature please review

Service Registration in Net 8i

Disabling Automatic Registration of the Database with the Default Listener

Service Name Usage in Net8i

SERVICE_NAME parameter in Oracle8i – Resolving ORA-12514

Oracle8i – Instance Registration to Listeners

How to display the database service names that are registered against a listener

CHECK GLOBAL_DBNAME PARAMETER IN LISTENER.ORA FILE ON HOST

Global Database Name Explained

3# In the 9i there is another new feature called the SPFile, when the database is starts for the first time this will read from the init.ora file, now when the instance is after this point the SPFile retain this information and noloanger reads from the init.ora file so any changes made to the init.ora will not be read please review the following Oracle note on the SPfile, PLEASE do not edit this file by hand

How to Modify the Content of an SPFILE Parameter File

The SPFILE is created from an existing init.ora file using the CREATE SPFILE command. This can be performed from any database state (nomount, mount, or open), since it only requires a command parser to read and evaluate the init.ora file to generate the SPFILE.

Example SQL to create an SPFILE.

SQL> create SPFILE=’/opt/oracle/admin/O901/pfile/spfileO901.ora’from Pfile=’/opt/oracle/admin/O901/pfile/initO901.ora’;

File created.

The file produced by the “create spfile” command is in a binary file format and created with a logical blocksize as specified by the db_block_size. A header block is also created and contains a checksum and some basic meta-data information. External (user) changes made to the SPFILE will result in a checksum failure and the inability to open the SPFILE. Therefore end-users should not edit the file.

To view the contents of the SPFILE, the Unix “strings” command (against the file) or the v$spparameter view can be used. See Figure 1 for a listing of the v$spparameter view.

4# In the 9i listener when running the status command you will see unknown in the service summary to understand this new feature of the 9i listener please review the following Oracle note

Oracle Net 9i Listener – Lsnrctl services / “status UNKNOWN” displayed

——————————————————————————–

From: Fabio Arienzo 29-Sep-03 15:09

Subject: Re : Re : TNS-00512 starting second listener in same node

Hi Kurt,

usefull info from you about listener … now it’s a little more clear.

many thanks

Bye

Fabio Arienzo

Data Base Administrator

Kuwait Petroleum

Rome (Italy)

——————————————————————————–

From: Dean Booth 01-Oct-03 17:02

Subject: Re : TNS-00512 starting second listener in same node

Hi,

I am facing similar type of problem. The difference is i am on WIndows 2000 5.00 service pack 3. I have oracle 9201 running on this server. The database and listener are running fine. I had to install oracle8170 on same server due to some internal requirenment. I installed oracle 8170 as seperate oracle home and trying to create database manually and facing “TNS Protocol adapter error”.

oracle home name for oracle9201 is “oracledt” and oracle_home is c:oracle9201ora9201. Oracle home name for oracle817 is “oraclets” and oracle_home is c:oracle817ora817.

The listener for oracle9201 is running on port 1521 and name is LISTENER.

I have configured listener.ora in oracle_home c:oracle817ora817

to run on port 1524 and nameis listener8i.

When i try to svrmgrl to create database manually it gives me

error. I have set the oracle_sid,oracle_home and Path for oracle 8170 and also checked service oracleservicetama (created manually)is running.

C:>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 – Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

“ORA-12560: TNS:protocol adapter error.”

When i try to start the listener for oracle 8170(with or without oracle9201 listener is running) it gives me below mentioned error

LSNRCTL> START LISTENER8I

Starting tnslsnr: please wait…

Failed to start service, error 997.

TNS-12536: TNS:operation would block

TNS-12560: TNS:protocol adapter error

TNS-00506: Operation would block

32-bit Windows Error: 997: Unknown error

When i try to start listener8i from services in control panel it says “could not service on local computer. This culd be internal windows error or onternal service error”

I cannot create the oracle 8170 database. Can anyone pelase help.

Thanks,

Sunny.

——————————————————————————–

From: Oracle, Kurt Bevers 03-Oct-03 15:54

Subject: Re : Re : TNS-00512 starting second listener in same node

You need to create a ServiceRequest(TAR) with the Dataserver group to assist with creating a database. TNSListener is not required for SVRMGRL connect internal or database creation.

Oracle, SQL scripts

Post navigation

Previous Post: Good RAC & Standby Notes
Next Post: _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade

Related Posts

  • Histogram Overview Oracle
  • Find All internal Parameters Oracle
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • Set Role explaination. Oracle
  • Jai Shree Ram Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • My Test Case On 21-OCT-2005 Oracle
  • replace alphabets using sed Linux/Unix
  • This is from Temi Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • xargs use Linux/Unix
  • TRUNCATE Privs Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme