Re: Question - listener

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: Fri, 29 May 1998 10:06:58 -0700
Message-ID: <356EEB32.3E11@mdsi.bc.ca>

You don't need to create a new listener.ora. Just add an entry in the existing listener.ora.

Under the ADDRESS_LIST, add PROTOCOL and KEY, eg:   (ADDRESS=
   (PROTOCOL=IPC)
   (KEY=new_sid)
  )

Under SID_DESC, describe where is the new instance and the name: (SID_DESC=

   (SID_NAME=new_sid)
   (ORACLE_HOME=.......)
   (GLOBAL_DBNAME=......)

)

When you start the listener, you should see the Service Summary has the new key shown like: .....
new_sid has 1 service handler(s)

Should work.

javier wrote:
>
> I have a oracle server 7.3 on Solaris 2.5
>
> my listener is ok, but now I have a new database on server and I want my
> clients be able to view this database.
>
> I think that I must to create a new listener.ora file, but I dont know how
> to do it.
>
> thanks.

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------

Received on Fri May 29 1998 - 12:06:58 CDT