Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question - listener
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