Load 2 banks

[jgc]

Good afternoon guys,

I never did this, I honestly need to work with 2 banks one test and other production.
until hj always carried, in different locations, but in this case, I need to load 2 banks on the same machine, on the same server.

In fact I will separate Oracle DBF into the data directories and I will create a database updater at the system input, CFE a parameter file in the operating system.

What steps should I do to put 2 banks simultaneously in the air.

Personal Thanks
JGC

[dr_gori]

It's very simple!
Just install another bank again on a different oracle_home. From there every bank is independent.

I, for example I have 8i and 9i on my machine.

[jgc]

Apologies my colleague, maybe I expressed myself badly, in this case beleza,

but it's 2 databases in the same bank 8i, what changes is that I will separate the DBF files into the Oradata folder.

ex:

Select all

TESTES\ORADATA\SYSTEM.DBF   e outros arquivos 
PRODUCAO\ORADATA\SYSTEM.DBF e outros arquivos

See if you understand and I managed to help me initialize the 2 bases at the same time, say Can I access each one separately exchanging the connection string host for example ????

Valeu
beleza.

[cigano]

Are you using which operating system?
If it is on Linux has a file in the folder / etc that is called oratab ... in it sits the bank boot string and each string's means a different base ...
: Wink:

[syntax]

Has a front end to create new 'database configuration assistant'

this does not serve you?

[] 's

[cacildoborges]

To create 2 databases in the same version is required only to change the Oracle_SID environment variable (defines the instance name).

Mount the OFA structure:

Select all

/u2/oradata/<ORACLE_SID>/...

Create the <oracle_sid> .ora in the $ Oracle_Home / DBS with the memory settings for New Instance. Remember that the 2 sgas should fit the server memory, avoiding swap.

Select all

startup nomount  
create database... 
etc.. 
etc...

[cacildoborges]

I forgot to mention, the access to the base is made by changing the variable oracle_sid.
Normally, an Opport is created in the .profile (if it is UNIX).