Re: How to Create 2 similar database on a Server.....

Basavaraj wrote:
>
> Hello,
>
> Can any one help me out with my problem.
>
> Presently I have a database name called "TEST" residing on 2 servers
> having '8' tablespaces on each server. '3' tablespaces contains the
> actual data and they are called 'TEST_TABLESPACE_1', 'TEST_TABLESPACE_2'
> and 'TEST_TABLESPACE_3'. The remaining tablespaces are related to the
> system. Many tables on TEST tablespaces (1,2,3) contain common tables
> (including their tablenames) between the 2 "TEST" Databases.
>
> ORACLE_SID on both system is "TEST". The two servers reside in
> distributed computing env.
>
> I have the respective scripts that where used for creating the "TEST"
> database on the two servers.
>
> The problem is "I NEED TO CREATE TWO "TEST" DATABASES ON A SINGLE
> SERVER".
>
> 1. How can I go about in creation of these two "TEST" databases and what
> options are available to me ?

You can not have more than one data base with identical ORACLE_SIDs on the same server.
Having said that, you may have one called 'TEST' and other 'test', since these
names are NOT indentical. Just set your ORACLE_SID accordingly.

>
> 2. What needs to be taken care if the above objective of creation is to
> meet.

You can create 'test' on the same server where 'TEST' resides. Change your ORACLE_SID, create init.ora for 'test', db create scripts etc.. Export old 'TEST' from other server and import the portions you want to transfer into 'test'.

>
> 3. How to bring the two databases online.

Assuming you are running under UNIX env, add a corresponding entry for 'test' on the /etc/oratab
file. So you could bring up both data bases at machine boot time. Until this change is in place, just make sure your (Oracle DBA's) ORACLE_SID is set appropriately, and run svrmgrl or SQL*DBA as before, to startup/shutdown the data base manually.

Change user profile file(or any global profile applicable to all users) to prompt for correct ORACLE_SID during log on process.

Hope this helps.

>
> Answers to these questions highly appreciated.
>
> Thanx in advance.
>
> Regards
> Basavaraj
 

-- 
Kirti Deshpande        |    E-mail: kirtid658_at_gte.net	
GTE Directories Corp   |    Voice : (972)543-7771
-------------------------------------------------------------
NOTE : Please remove all numbers from my e-mail address prior
       to sending me an e-mail. Thanks.
-------------------------------------------------------------