Re: Instance in Oracle 7.2.3

From: Daniel Ady Surya <Daniel.Surya_at_mincom.co.id>
Date: 27 Jan 1999 06:53:41 GMT
Message-ID: <01be49c2$4529c140$9f0a13ac@DAS.mincom.co.id>

Hi...
In Unix OS, you can create multiple database instances in 1 server such as Test instance, Prod instance and Devl Instance. First of all, you have to create file called init[instance].ora for each instance.
To create this file, you can copy 1 default file init.ora to init[instance].ora:
for example: cp init.ora inittest.ora
Init.ora can be found at $ORACLE_HOME/dbs. Then rename db_name=default to db_name=test. Modify several parameters as requirement. Remember !! To create instance(s), you have to log in as Oracle owner. At unix prompt ($) type . oraenv (type test). After that, run svrmgrl and connect internal. Startup nomount;

Create database TEST ...... (see SQL User Guide & Reference)
If success, run catalogs.sql and catprocs.sql which can be found at
$ORACLE_HOME/rdbms/admin.

I don't explain this in detail, if you want to know further, please read Oracle 7Server Administrator's Guide.

I hope this will help you.

Daniel AS
IT Consultant (DBA)

Francisco Javier Paredes Olay <paredes_at_pinon.ccu.uniovi.es> wrote in article <78kubk$jqr$1_at_sci.cpd.uniovi.es>...
>
> Hello,
>
> I have a Server Oracle 7.2.3 with a instance of a database. I need to
make
> another instance of a new database in the same server. How can I make
it?
>
> T.I.A.
>
> --
>
>

---

-
> | ___ __
> Francisco Javier Paredes Olay | / _ \ ____/ /_
> Universidad de Oviedo | / _ /(_-</ __/
> E-Mail: paredes_at_hp400.ccu.uniovi.es | /_//_//___/\__| __ ______
> paredes_at_pinon.ccu.uniovi.es | _ __ / // / __/
> paredes_at_proy2.etsiig.uniovi.es | / |/ /__ \_,_/_/ ___ ___
> http://pinin.ccu.uniovi.es/~paredes | / / -_| __ ))(_-<
> | /_/|_/\__/ /__// ___/
>

---

--
>
Received on Wed Jan 27 1999 - 00:53:41 CST