Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS Listeners with multi-instance
Hong Zhou wrote:
>
> I installed Oracle 7.3 on NT4.0 server, I created threee instances.
> There are running, but why my TNS listener just list on service, ORCL.
> The other two were not listed. When I made alises for the other two,
> their names can not resolved. I got error message 12204.
> My listener.ora have the following entries:
>
> ################
> # Filename......: listener.ora
> # Node..........: local.world
> # Date..........: 24-MAY-94 13:23:20
> ################
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL= IPC)
> (KEY= oracle.world)
> )
> (ADDRESS=
> (PROTOCOL= IPC)
> (KEY= ORCL)
> )
> (ADDRESS=
> (COMMUNITY= NMP.world)
> (PROTOCOL= NMP)
> (SERVER= ORACLE)
> (PIPE= ORAPIPE)
> )
> (ADDRESS=
> (COMMUNITY= TCP.world)
> (PROTOCOL= TCP)
> (Host= oracle)
> (Port= 1521)
> )
> (ADDRESS=
> (COMMUNITY= TCP.world)
> (PROTOCOL= TCP)
> (Host= oracle)
> (Port= 1526)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = ADMIN
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ORCL)
> )
> )
> PASSWORDS_LISTENER = (oracle)
>
> ---- End of file-----
> There are no other SIDs, I have other two instance called TEST, REPO.
>
> Any help will be appreciatted.
>
> Thanks
The easiest way to create the appropriate and syntactically correct
configuration files is to use Network Manager, available as a 16-bit
application in your \orawin\bin directory. Use the new network walkthru
feature to create one node, one listener, and three databases, generate
the configuration files, place copies in \orant\network\admin and
\orawin\network\admin, stop and start your listener
(\orant\bin\lsnrctl), and you should be all set.
-- Rich Woods Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.Received on Sat Jan 18 1997 - 00:00:00 CST