Re: Personal Oracle 7 Instances

Arman Rotabi wrote:
>
> Can anyone tell me how I can create a second or third database instance on
> my Personal Oracle 7 Database.
>
> I have tried 'CREATE DATABASE' but am not sure of the syntax, also not 100%
> sure if you can have multiple instances on Personal Oracle.
>
> Any help is much appreciated.......
>
> Arman
> (arman_at_dircon.co.uk)

This has been a topic of much discussion. I succeeded after a lot of fooling around with
the Oracle svrmgr. Read my correspondence with another guy, Jay, below. You can e-mail me
if you don't understand.
I changed the rules a little. Instead of step 1 I typed C:\set oracle_sid=ABCD.
No need for step 2.
To get the commands for server manager, type help at the svrmgr prompt. It might be
necessary to use the SET INSTANCE routine after step 4.

-- 
Femi Aderounmu
Vanderbilt University
Nashville, Tn

--

************************************************************************************
************************************************************************************
************************************************************************************
   Subject: 
        RE: Non-ORCL instance on PO7/95
  Date: 
        Fri, 6 Jun 97 16:20:20 +0000
  From: 
        Jay Ramadorai <jayr_at_softwarebuilders.com>
    To: 
        "'aderounmu_at_worldnet.att.net'" <aderounmu_at_worldnet.att.net>


Femi,
    This is what I ended up doing to create an instance called (say)
ABCD. I "tried and erred" my way into this approach. There may be a
better one.
1. run regedit. Under LOCAL_MACHINE...SOFTWARE....ORACLE, change
ORACLE_SID to ABCD.
2. reboot (probably not needed)
3. run orapwd73 (which should be in the ORAWIN\bin directory
   So, cd \mydbdir
         \orawin\bin\orapwd73 file=pwdabcd.ora password=mypw
4. run svrmgr
5. connect internal, password = mypw
6. startup pfile=\path\initabcd.ora
7. create database
8. @catalog
9. @catproc
10. etc...
Hope this helps
Jay
----------
From:   Femi Aderounmu[SMTP:aderounmu_at_worldnet.att.net]
Reply To:       aderounmu_at_worldnet.att.net
Sent:   Friday, June 06, 1997 11:34 AM
To:     jayr_at_softwarebuilders.com
Subject:        Re: Non-ORCL instance on PO7/95

Jay Ramadorai wrote:


> 

> Folks,

>    Recently someone on the list had mentioned they had successfully

> created a second instance using PO7. I want to create one instance but

> call it something other than ORCL. So I say no to the "create starter

> database?" question at install-time. However, when I run svrmgr (so I

> can connect internal and startup nomount an instance of my choice, and

> do a create database, etc), it won't let me connect internal. Keeps

> asking for a password. In Unix, one would just set their ORACLE_SID to

> the new instance name, and the connect internal would work fine, but not

> so in PO7/win95. I've also tried passwords like change_on_install,

> manager, null, etc but to no avail. Do I have to do something with

> orapwd73 to preset the password for the uncreated instance?

> Incidentally the documentation that comes with the downloaded PO7 is all

> NT stuff. It talks of setting ORACLE_SID in the registry which I did,

> but that doesn't change anything.

> 

> Any ideas? Pls cc my email direct.

> Thanks

> Jay Ramadorai

> jayr_at_softwarebuilders.com


Hello Jay,
        Sorry I can't anwwer your question. I have the same problem but
you
are far ahead of me. In fact I almost danced for joy when I read in your
e-mail 
that someone had actually accomplished what I was beginning to think was
impossible.
If you have any new info please help me out. Thanks.
-- 
Femi Aderounmu
Vanderbilt University
Nashville, Tn

--