Re: Need help with Oracle for Netware - Multiple Instances on the same box

On Tue, 6 Mar 2001 21:50:04 +0100, Per Pettersson <info_at_ppss.de> wrote:

Hello,

I'm glad someone else use Oracle on Netware too. (we installed Oracle8.0.3 for netware 4.2)

There is a config file in $ORACLE_HOME\nlm\config.ora. It is read first whenever you load svrmgr , load plus80 , load exp80...etc.

If you want to connect to instance SID1, you could specify 3 parameters in config.ora:
LOCAL=SID1-ipc.world
ORACLE_SID=SID1
ORA_SID1_PWFILE=$ORACLE_HOME\DATABASE\PWDSID1.ORA SID1-ipc.world is the alias name configured in easycfg with IPC protocol.

PWDSID1.ora is created by load orapwd80 after sepcify ORACLE_SID=SID1 in config.ora.

So I will have 2 files : sid1.ora , sid2.ora. when I want to connect to sid1 , just copy sid1.ora config.ora and then load svrmgr30 .

But if your server doesn't have enough memory,i think it's better not to running 2 instances on the same machine.

Hope this helps.

Regards,

Violin.
violin.hsiao_at_mail.pouchen.com.tw

>I want to consolidate two different databases, now running on two machines, I want to run them
>on one server.
>
>I think it has to go some thing like this:
> svrmgr
> set instance s:sid1
> connect internal
> startup pfile=...pfile1
> disconnect
> set instance s:sid2
> connect internal
> startup pfile=...pfile2
> disconnect
>
>but wich (not data) files has to be the same, wich parameters (ifile?) has to be the same and how to
>cofigure the listener? I dont think I need two listeners, is that correct?
>
>by the way... is there a smooth way to change the database name (both are named oracle...)? and tell me,
>to change the sid on an instance, is it all in the init.ora?
>
>Thanks in advance,
>
>Per Pettersson
Received on Tue Mar 06 2001 - 18:52:01 CST