Re: create new database

On Thu, 1 Jun 2000 23:16:46 -0500, "Robin Witkop-Staub" <robin_at_witkopstaub.com> wrote:

Aha!! someone else using Oracle on netware!!

you want to have multiple databases on one netware server,right?

1. execute easycfg add another instance, add more database alias : %SID%-IPC and %SID%-SPX,with right instance name

2.in the %ORACLE_HOME%\nlm there is a file : config.ora

   if you load svrmgr30 or orapwd80, it will check some parameters to know which    is the default instance to connect,like this:    ORACLE_SID=SID1
   LOCAL=SID1-IPC.WORLD
   ORA_SID1_PWFILE=vol:oranw803\database\pwdsid1.ora

3.create password file :

   each instance has one password file
   load orapwd80 file=filename password=newpasswd

4.check listener.ora if there are more than one SID_NAME

5.if you want to connect to SID1,change config.ora parameters :

   ORACLE_SID and LOCAL and ORA_SID1_PWFILE.    load svrmgr30
   SVRMGR> connect internal
   password:

   Of course change parameters when you want to connect to SID2.

HTH. Violin.
violin.hsiao_at_mail.pouchen.com.tw

>I just installed Oracle 8 on a Novell Netware 5 server that a department in
>my company required for a new software program. I am new to Oracle and am
>going off the supplied Novell documentation for Oracle. It installed with a
>default ORANW80 database that I connected to fine. I now need to set up a
>new database for use by the department. I copied the initorcl.ora file and
>edited the required data. Now the document states I have to check to make
>sure I don't have a conflicting instance. I am using the Instance Manager
>that came with the client (admin install). The only instance I see is for
>the default database and it is running/started? I looked at the tsanames
>file and they all point to a SID=ORCL. My documentation says my SID should
>be the same as my new database name so how do I add a new SID?
>
>Also, Can anyone suggest some good beginner material for learning Oracle on
>my own.
>
>
>
Received on Sat Jun 03 2000 - 00:00:00 CDT