can oracle have multiple databases?

[james07]

Can I have two different database on one server? not running at the same time off course.

let say I have database A and database B.

I want to be able to start one of these database from one server. because one will used for dev, and the other will be used for testing purposes.

appreciated.

[Halo]

Yes.

[contactrb]

Well I dont think it will create problem. Right now I am using two instances in the same server, started running simultaneously.

Only issue is, u must have sufficient RAM size, processor capacity, proper disk I/O load shed and proper Init parameter tuning. Otherwise the server will suffer performance issues.
---
What is the server capacity and its details, oracle version and the database sizes? Max. user sessions expected etc., etc.,

[jm]

as long as you have enough memory and disk space - I have a machime with 6 instance running share with many programmers.

[dba_dada]

Sure you can. You can have multiple instances or two DB in same machine. I just did it and work fine so far…all you have to make sure that your environment is set accordingly…

I’m not sure about NT…

Thanks

[GARYM]

I run four instances on a WinNT machine and have no problems. Running 1 Gig Processer and 1.5 gig memory.

Hardware Raid Mirrored drives.


Gary

[james07]

DBA_DADA

could you give me some of the example of which settings I need to change?

I'm now to this Unix stuff.


thanks.

[sysdba]

All you need to set is ORACLE_SID
For example, in K shell,
export ORACLE_SID=new_sid
in C shell,
setenv ORACLE_SID new_sid
before issuing create database statement.

[dba_dada]

james07...

Please follow “sysdba” suggestion and you will be fine…that exactly how I did it….

[murugappan]

Hi

Take the help of ./dbassist. Easy way create
database. When asked for oracle_home,
give different home. And the rest you
know. Simple.

Regards
vrm