Re: Please Help with an *Advanced* question. Thanks.

Hi

You do not have to install another copy of Oracle. If you follow the following steps you should do OK:

Create a new init.ora file for the new instance. Run ?:\orant\bin\ORADIM7x
Select NEW to create a new service. This will create your instance as well as your database.
You should specify the SID as well as the DBA Passwords and the init.ora file to use.
You must choose advanced on this window to create a database with a unique name as well as cretae your log, temp, system files etc. Once this step is sucessfull go to your DOS prompt:  set ORACLE_SID=SID
svrmgr23
connect internal;
startup
Your Database will now be ready for use.

You must now edit your listener.ora file etc to be able to access it with SQLNet.

I hope this is useful

Cheers

akader_at_health.sanlam.co.za

NNOOR <Nnoor_at_cris.com> wrote in article
<60pk0l$r2p_at_examiner.concentric.net>...
>
> The time has come for our project to move forward and have us
> developers coexist with the users. That means that the database
> and schema will be used by the users and we can't "play" with it
> anymore. But devlopment requirements are otherwise. We have to have
> a "play" version of the same schema. We are stuck with hardcoding
> the schema name in the application (e.g. we don't say Select * from
> aTable, rather select * from schema.aTable, etc etc). Since we can't
> have the same schema name twice in a database, what we gotta have is
> another database (an instance?) for developers only and leave the
> "live" data alone. The problem is that I don't have a clue as to how
> to implement a brand new database (an instance) and have it running
> on the same NT server (along with the "live" oracle DB server). Do I
> have to install Oracle a 2nd time in a new directory, if so, will it's
> "services" happily co-exist with the other (live) instance? Or what?
> Please pardon my ignorance. I know I am asking for a lot of information
> here, but I will appreciate even the direction towards the right set of
> documentation.
>
> Thank yo uall for all your help!!!
>
> Regards,
> Nasir (nnoor_at_cris.com)
>
  Received on Tue Sep 30 1997 - 00:00:00 CDT