Home » RDBMS Server » Networking and Gateways » Multiple home listener configuration (Oracle 10g R2, Windows 2003)
Multiple home listener configuration [message #517931] Fri, 29 July 2011 09:24 Go to next message
geobraik
Messages: 34
Registered: April 2011
Member
Hi,

I have installed Oracle 10g in windows 2003 two times with two different homes. (D:\oracle\home and E:\oracle\home).
Databases db01 and db02 created in these homes respectively.
Please tell me how to configure listener and tnsnames to aceess these databases.

Thanks in advance
Geo
Re: Multiple home listener configuration [message #517932 is a reply to message #517931] Fri, 29 July 2011 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
No listener.ora file is required to start listener.

tnsnames.ora file is client side file & not required on DB server system.
Both DB's can be accessed without use of *SQL*net.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Multiple home listener configuration [message #517936 is a reply to message #517931] Fri, 29 July 2011 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't know how to do it then use netca.
You could also read Net Services Reference and help you with examples you have in %ORACLE_HOME%\network\admin\sample directory.


Regards
Michel
Re: Multiple home listener configuration [message #517972 is a reply to message #517936] Sat, 30 July 2011 06:01 Go to previous messageGo to next message
geobraik
Messages: 34
Registered: April 2011
Member
I have started listener from first home. Then edited listener.ora to add second home
In environmental variable 'path' removed bin of second home and retained bin of first home.
# listener.ora Network Configuration File: E:\app\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\Oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    
    (SID_DESC =
          (SID_NAME = new01)
          (ORACLE_HOME = E:\app\Oracle2\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Oracle2\product\11.2.0\dbhome_1\bin\oraclr11.dll")
        )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Muhsin-PC.lan)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = E:\app\Oracle


SQLNET.ORA
# sqlnet.ora Network Configuration File: E:\app\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)


TNSNAME
NEW01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Muhsin-PC)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = new01)
    )
  )

TNSPING
C:\windows\system32>TNSPING NEW01

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-JUL-2011 13:57:44

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
E:\app\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Muhsin-PC)(PORT = 1521))) (CONNECT_DATA = (SER
VICE_NAME = new01)))
OK (10 msec)


CONNECTION TESTING
C:\windows\system32>SQLPLUS TEST/TEST@NEW01

SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 30 13:58:57 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error


Enter user-name:


Please help me to solve this issue
Re: Multiple home listener configuration [message #517979 is a reply to message #517972] Sat, 30 July 2011 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have installed Oracle 10g in windows 2003 two times with two different homes. (D:\oracle\home and E:\oracle\home).
>(ORACLE_HOME = E:\app\Oracle2\product\11.2.0\dbhome_1)
Both Oracle Version & HOME directory are different from first post in this thread.
I don't know what is fact & what is fiction.
Re: Multiple home listener configuration [message #517985 is a reply to message #517979] Sat, 30 July 2011 11:42 Go to previous messageGo to next message
geobraik
Messages: 34
Registered: April 2011
Member
The actual server is 10g in windows 2003. Since today is holiday i am trying that in my laptop.
Re: Multiple home listener configuration [message #517986 is a reply to message #517985] Sat, 30 July 2011 11:44 Go to previous messageGo to next message
geobraik
Messages: 34
Registered: April 2011
Member
I tried SQLNET.AUTHENTICATION_SERVICES= (NONE) in sqlnet.ora. Still same issue. Then I commented that line but no result.
Please help me
Re: Multiple home listener configuration [message #517987 is a reply to message #517986] Sat, 30 July 2011 11:51 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
28547, 0000, "connection to server failed, probable Oracle Net admin error"
// *Cause:   A failure occurred during initialization of a network connection
//           from a client process to the Oracle server.  The connection
//           was completed but a disconnect occurred while trying to
//           perform protocol-specific initialization, usually due to
//           use of different network protocols by opposite sides
//           of the connection.  This usually is caused by incorrect
//           Oracle Net administrative setup for database links or external
//           procedure calls.   The most frequent specific causes are:
//           --  The connection uses a connect string which refers
//               to a Heterogeneous Services agent instead of
//               an Oracle server.
//           --  The connection uses a connect string which includes
//               an (HS=) specification.
//           --  Hitting Ctrl+C before connection initialization is
//               complete.
//           --  Using DRCP on Windows with SQLNET.AUTHENTICATION_SERVICES
//               set to NTS.
//           --  Connection timeout due to SQLNET.INBOUND_CONNECT_TIMEOUT
//               parameter when all shared servers are busy in
//               shared server configuration.
// *Action:  Check Oracle Net administration in the following ways:
//           --  When using TNSNAMES.ORA or an Oracle Names server, make sure
//               that the client connection to the Oracle server uses
//               the correct service name or SID.
//           --  Check LISTENER.ORA on the connection end point's host machine
//               to assure that this service name or SID refers
//               to the correct server.
//           --  Confirm in TNSNAMES.ORA or the equivalent service definition
//               that the connect string does not contain (HS=).
//           --  Set SQLNET.AUTHENTICATION_SERVICES to NONE when using DRCP
//               on Windows.
//

What is the purpose of having multiple ORACLE_HOME folders for same Oracle version on same system?

A single ORACLE_HOME can support multiple databases.

having multiple listeners is unnecessary & potentially problematic
post results from following OS commands

lsnrctl status
lsnrctl service

[Updated on: Sat, 30 July 2011 12:09]

Report message to a moderator

Previous Topic: Objects refering to db links
Next Topic: select for update - how to kill old locks
Goto Forum:
  


Current Time: Fri Mar 29 08:05:55 CDT 2024