Re: Adding SID's to SQL*NET V2 listener???

Sean Kubovcik wrote:
>
> I have SQL*NET V2 running with one database on one server and
> accessing this database from a client works fine. I want to add 4 more
> databases to the listener and access the database via V2, how do I do
> this. I am currently accessing these 4 databases with SQL*NET V1 but I
> would like to access them with V2 instead. I know I need to modify the
>
> TNSNAMES.ORA and LISTENER.ORA. Any help would be appreciated.
> Thanks,
> Sean

For the server to listen for the others sids, all you should need to do is add SID_DESC entries in the SID_LIST for the appropriate listener.

TCP_LISTENER=                                                         
        (ADDRESS_LIST=
                (ADDRESS =
                        (PROTOCOL = TCP)
                        (HOST = <machine_name>)
                        (PORT = 1521)
                ))
                                                                      
                                                                      
SID_LIST_TCP_LISTENER =
        (SID_LIST =
                (SID_DESC =
                        (SID_NAME = <oracle_sid1>)
                        (ORACLE_HOME = <oracle_home for sid1>)
                )
                (SID_DESC =
                        (SID_NAME = <oracle_sid2>)
                        (ORACLE_HOME = <oracle_home for sid2>)
                )
        )

-- 
Thomas Griffin
Project Leader
QUALITECH Systems, Inc.
tgriffin_at_qualitech.com