Re: Can 2 databases on the same machine?

In article <33966769.59BC_at_gzs.de>, Detlev Goebel wrote:

Sean,

The advice below is almost there, but I was a little confused by the final bit about scripts.

To point at different instances, you need to change the ORACLE_SID  environment variable.
You will need to ensure that you have also created a new  $ORACLE_HOME/dbs/init$ORACLE_SID.ora file, with pointers to new control  files and directories for the dump destinations (e.g. user_dump_dest).  These directories will need to be created prior to the create database command. Then, enter 'sqldba' or 'svrmgrl' and do your 'create database' command. Make sure you allocate at least 20Mb for the SYSTEM tablespace.

You then need to catalog all of the necessary Oracle internals: after creation I normally run:

 $ORACLE_HOME/rdbms/admin/catalog.sql
 $ORACLE_HOME/rdbms/admin/catproc.sql  # If you are using PL/SQL
 $ORACLE_HOME/rdbms/admin/catblock.sql # Some locking views
 $ORACLE_HOME/rdbms/admin/dbmspool.sql # Pinning for shared_pool objects
 $ORACLE_HOME/rdbms/admin/dbmssql.sql  # Dynamic SQL for PL/SQL

Finally, depending upon the Oracle release you may have to:  connect system/manager
 $ORACLE_HOME/sqlplus/admin/pupbld.sql # Stops SQL*Plus users getting errors

                                       # at login time
 $ORACLE_HOME/rdbms/admin/catdbsyn.sql # Allows the SYSTEM user to function as

                                       # a DBA users - necessary

After the database has created, you will need to create the tablespaces and users.

Hope this helps

regards

Neil_Chandler_at_Stratus.com
DBA
>zhang wrote:
>
>> connected to the server. The server is running Solaries 2.5.1 OS,
>> right now we have a running database ( inventory) in oracle account,
>> when I try to create another database( accounts) in oracle account, I
>> always got an error saying " can't start, the instance is already
>> running ora 01081', it asked me to shutdown frist.But when I statup
>> again, it only can start one db,the second will not be allowed to
>> start, do you think I can start both databse on the same account
>> on the same machine?
>> Second, I tried to create a database manually in a different account,
>> with all required files and executables belonging to that account,
>> the databse did come up, but when I tried to logon on, I always
>> got a message, saying " DBMS_STANDARD must be created first, ora 6554"
>> do you have any idea which script I should run to create the
>> DBMS_STANDARD package ?
>> Any advice will be helpful, Thanks in advance.
>>
>> Sean Zhang
>> <zhang_at_visi.net>
>
>Sean,
>
>each user is in need to get the Oracle environment Variables
>ORACLE_HOME, ORACLE_SID and ORACLE_TERM. By changing ORACLE_SID you are
>able to switch between Instances.
>You also need the Control Files to build up for more than one instance.
>You can do this by recreating the control files.
>
>You will find the Scripts for the DBMS stuff in
>$ORACLE_HOME/rdbms/admin.
>The specific file you need is dbmsutil.sql.
>
>Hope this helps
>--
>Detlev Goebel
>
>mailto:detlev.goebel_at_gzs.de
>---------------------------
Received on Thu Jun 05 1997 - 00:00:00 CDT