Re: multiple databases on the same server?

George wrote:

> Does anyone know if it is possible to create multiple separate databases on
> the same server?

YES ! but if you have money to buy a server for each database :) ...

>
> I'm trying to use Oracle 8.0.5 in a classroom (running on Solaris). I would
> like to split the students into groups and have each group manage (or at
> least access) their own private database that can't be accessed by students
> in the other groups.
>
> Is this possible? From what I know, this sounds like each group would need a
> separate Oracle instance SID.
>

You have to define your SID in the /var/opt/oracle/oratab file , and then create your databases. You can set the ORACLE_SID in the .profile (or .tchrc ,.bashrc...) of your students.

e.g. for sh or bash (.profile or .bashrc) ORAENV_ASK=NO ; export ORAENV_ASK
ORACLE_SID=yourSID ; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin; export PATH . oraenv
This will set the SID to yourSID

But if you want to restrict the access you need to define differents user&passwords...

>
> Thanks for any info,
>
> George
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 02 1999 - 01:56:35 CST