Home » RDBMS Server » Networking and Gateways » Multiple Oracle homes...
Multiple Oracle homes... [message #66809] Tue, 21 January 2003 00:38 Go to next message
PraD
Messages: 5
Registered: December 2002
Junior Member
How to configure listeners for multiple oracle homes.? Also, I am able to connect to my current Oracle_home databse thro SQL * plus by simply entering the user/password, Is there any default HOST STRING?

Pllllzz. help.
~dpk
Re: Multiple Oracle homes... [message #66811 is a reply to message #66809] Tue, 21 January 2003 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there is NO DEFAULT hostring.( some seed databases carry some demo hoststring with em).
edit your tnsnames.ora and add entries to create a hoststring.
If you u have multiple databases in  multiple home,
you can have 
either
   single listener for all databases
or
   single listener for each database.
IF this is prod environmnet in DMZ etc
its better to have ONE LISTENER PER DATABASE.
else
you can just have one listener servicing multiple databases (which is easy, in administration point of view).
for multiple listeners 
1. OPEN different ports.
2. configure listeners to listen to their respective ports and add entries.

Re: Multiple Oracle homes... [message #66876 is a reply to message #66809] Mon, 24 February 2003 14:57 Go to previous messageGo to next message
bijay pusty
Messages: 1
Registered: February 2003
Junior Member
Hi
I have a single listener for 2 dB,
1 DB is the RDBMS
other is thee 9iAS

But the listener goes down automatically after some time
is there any reason why is it so ...?
Re: Multiple Oracle homes. [message #67619 is a reply to message #66811] Mon, 22 November 2004 15:29 Go to previous message
pe
Messages: 2
Registered: November 2001
Junior Member
retard
Previous Topic: Need to connect to Oracle DB without Client installed
Next Topic: jre.exe has generated errors
Goto Forum:
  


Current Time: Thu May 02 01:53:32 CDT 2024