Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem Using 2 Oracle Environments with 2 Listeners
On Thu, 12 Aug 1999 07:17:15 GMT, jmvegalerin_at_my-deja.com wrote:
>Hello.
>
>I thing what you need is to have:
>
>1) two full environments for Oracle, one for /oracle1.. and other for
>/oracle2..
>
> ORACLE_HOME=/oracle1... for working with listener MYNAME1
> and
> ORACLE_HOME=/oracle2.... for working with listener MYNAME2
>
> If yor work with the same user (oracle8 for exmaple) you need change
> the value of ORACLE_HOME when work with one envirinment or other.
>
>2) two lisener.ora.
>
> One /oracle1.../network/admin/listener.ora whith MYNAME1 and port 1520
> and /oracle2.../network/admin/listener.ora with MYNAME2 and port 1521
> for example.
>
>
> If you wish to work with MYNAME1:
> ORACLE_HOME=/oracle1.....
> export ORACLE_HOME
> lsnrctl start MYNAME1
>
> If you wish to work with MYNAME2:
> ORACLE_HOME=/oracle2.....
> export ORACLE_HOME
> lsnrctl start MYNAME2
>
>Sorry for my bad english.
>
This is exactly how I have it. /oracle1 has its own user, oracle1 and /oracle2 has its own user oracle2.
The environment var's are set up correctly and I am starting the listener as each user respectively.
???
Chuck
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Aug 12 1999 - 10:50:46 CDT