OraFAQ Forum: Networking and Gateways » Listener configuration for 2 databases

Home » RDBMS Server » Networking and Gateways » Listener configuration for 2 databases

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

Listener configuration for 2 databases [message #66364]

Thu, 02 May 2002 09:01

jialian
Messages: 2
Registered: May 2002

Junior Member

Hi,

We are having a problem with setting up the listener for two instances running on the same unix server.

Background info:
----------------
In our database, oracle software was installed by the default "oracle" user with the default sample database created (say sample9i). The files belong to the "oracle" user in "oinstall" group. The "oracle" user has a secondary group of "dba". Then, we manually created another database (say newdb) using another unix user (say "neworacle" with the "dba" group as the primary group).

Currently, our listener is set up as:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/orac901)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = newdb)
(ORACLE_HOME = /opt/oracle/orac901)
(SID_NAME = newdb)
)
(SID_DESC =
(GLOBAL_DBNAME = sample9i)
(ORACLE_HOME = /opt/oracle/orac901)
(SID_NAME = sample9i)
)
)

Problems:
---------
When we start up the listener from the "oracle" user account, we can connect to sample9i database but when we change the ORACLE_SID=newdb and try to login through sqlplus with:
sqlplus user@newdb

We encountered an error:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
SVR4 Error: 13: Permission denied

The strange thing is that "tnsping newdb" works.

When we start up the listener from the "neworacle" user account, we can connect to the newdb database but not to the sample9i database.

Questions:
----------
1. Are we setting up the listener correctly?
2. Do we need to set up 2 listeners? Do the 2 listeners have to be assigned to 2 different ports or can they use the same port?
3. Is there any permissions issues that we need to look into? Should we just set both "oracle" and "neworacle" to the same group?

Thanks in advance for your help,
Jia Lian

Report message to a moderator

Re: Listener configuration for 2 databases [message #66367 is a reply to message #66364]

Thu, 02 May 2002 12:11

John Anker Corneliussen
Messages: 5
Registered: February 2002

Junior Member

remeber to checkout your /etc/oratab

<-------------------------------------
# sample oratab 4U
# ^SID:"$ORAHOME":[[Y&#124N]]
sample9i:/opt/oracle/orac901:Y
newdb:/opt/oracle/orac901:Y
<-------------------------------------

Remeber the case-sensitivity issue both
regarding sid and logical instance names
as well as [[Y&#124N]] in this configurationfile

Report message to a moderator

Re: Listener configuration for 2 databases [message #66371 is a reply to message #66364]

Fri, 03 May 2002 07:47

Grant
Messages: 578
Registered: January 2002

Senior Member

I believe you have to have them both in the oinstall group as primary. Also make sure your Oracle executable has the correct privs. Your listener looks fine. You can have two listeners but it needs to work with one first. I always install with oracle and group dba. All DB's are created with oracle.

Report message to a moderator

Previous Topic:	ORA-03113 error while installing ORACLE 817 Personal Ed.
Next Topic:	How to use sendmail from Solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 04:11:34 CDT 2025