Re: sql*net problem, help

Hi,

You can define two instances in one of each files like this.

[seoul]/var/opt/oracle% cat listener.ora LISTENER=

        (ADDRESS_LIST=


                (ADDRESS=


                        (PROTOCOL=TCP)
                        (PORT=1521)
                        (HOST=seoul)
                )
        )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER=
(SID_LIST=

        (SID_DESC=


                (SID_NAME=ora8)


                (ORACLE_HOME=/usr/local/oracle/8.0.4)


        )
        (SID_DESC=


                (SID_NAME=miki)


                (ORACLE_HOME=/usr/local/oracle/8.0.4)


        )

TRACE_LEVEL_LISTENER = OFF
PASSWORDS_LISTENER = (tns)

[seoul]/var/opt/oracle% cat tnsnames.ora ora8=

        (DESCRIPTION=


                (ADDRESS=(PROTOCOL=TCP)


                        (HOST=seoul)
                        (PORT=1521)     )


                (CONNECT_DATA=(SID=ora8))


        )
miki=
        (DESCRIPTION=


                (ADDRESS=(PROTOCOL=TCP)


                        (HOST=seoul)
                        (PORT=1521)     )


                (CONNECT_DATA=(SID=miki))


        )

Kaz

matcha wrote:

> Hi, I have 2 Instances under the same ORACLE_HOME on the same machine. How
> can I let them communicate to each other (It is necessary for Enterprise
> Backup Utility)? Do I have to have 2 listeners and 2 tnsnames.ora file and
> how can I define that I have 2 listeners and 2 tnsnames.ora files in the
> same directory ?
>
> Do they have to have 2 different ports on unix machine?
>
> Your quick respons is highly appreciated?
>
> Cemal