Home » RDBMS Server » Networking and Gateways » How many listeners can we have in one server
How many listeners can we have in one server [message #233805] Fri, 27 April 2007 09:30 Go to next message
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
Re: How many listeners can we have in one server [message #233806 is a reply to message #233805] Fri, 27 April 2007 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How many listeners can we have in one server [message #233828 is a reply to message #233805] Fri, 27 April 2007 13:04 Go to previous messageGo to next message
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
Re: How many listeners can we have in one server [message #233829 is a reply to message #233805] Fri, 27 April 2007 13:07 Go to previous messageGo to next message
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.
Re: How many listeners can we have in one server [message #233831 is a reply to message #233828] Fri, 27 April 2007 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How many listeners can we have in one server [message #233833 is a reply to message #233805] Fri, 27 April 2007 13:19 Go to previous messageGo to next message
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
Re: How many listeners can we have in one server [message #233843 is a reply to message #233833] Fri, 27 April 2007 13:48 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Listener must be on the same server as instance (exception for RAC instances with load balancing).

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


Current Time: Fri Mar 29 09:53:09 CDT 2024