OraFAQ Forum: Networking and Gateways » How many listeners can we have in one server

Home » RDBMS Server » Networking and Gateways » How many listeners can we have in one server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many listeners can we have in one server [message #233805]

Fri, 27 April 2007 09:30

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Hello

I have 2 oracle databases installed in the same server but with different Ids 1 = as oracle user home=u01/app/myhome - 1 as different user home=/u02/app/myhome
this is oracle 10GR1 and 10GR2 solaris 10, how can this be configured so that external connections are alowed to both instances of oracle?

thank you
Maria

Report message to a moderator

Re: How many listeners can we have in one server [message #233806 is a reply to message #233805]

Fri, 27 April 2007 09:37

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You only need one listener, use the last version one.
For instance (for 9i and 10g at the same time):

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = XXXX)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = MIK9)
      (GLOBAL_DBNAME = MIK9.WORLD)
      (ORACLE_HOME = C:\Oracle\ora920)
    )
    (SID_DESC =
      (SID_NAME = MIKA)
      (GLOBAL_DBNAME = MIKA.WORLD)
      (ORACLE_HOME = C:\Oracle\ora102)
    )
  )

Regards
Michel

Report message to a moderator

Re: How many listeners can we have in one server [message #233828 is a reply to message #233805]

Fri, 27 April 2007 13:04

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Ok now i keep getting these messages

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied

Report message to a moderator

Re: How many listeners can we have in one server [message #233829 is a reply to message #233805]

Fri, 27 April 2007 13:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I would suspect that Oracle is not running or you are trying to start the listener from a different OS user account; other than the user which owns the Oracle installation.

Report message to a moderator

Re: How many listeners can we have in one server [message #233831 is a reply to message #233828]

Fri, 27 April 2007 13:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I agree with Ana, you tried to start Oracle with a user that is not in the same OS group that Oracle owner.

Regards
Michel

Report message to a moderator

Re: How many listeners can we have in one server [message #233833 is a reply to message #233805]

Fri, 27 April 2007 13:19

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Actually i'm trying to start the listener as oracle user id which did the install, but i have another another install in the same server done with a different id. this is the one that I cant connect to.

so i have only 1 listener running but from different server if I do a tnsping all its ok just when connecting as sqlplus to that oracle install done with a diferent id it fails

Report message to a moderator

Re: How many listeners can we have in one server [message #233843 is a reply to message #233833]

Fri, 27 April 2007 13:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Listener must be on the same server as instance (exception for RAC instances with load balancing).

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-12535 error with a VPN and Router
Next Topic:	connectivity problem from DEV.SERVER to PROD SERVER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 14:20:59 CST 2024