Re: How do you create 2 dbs on the same machine

Only one remark:

if you use orainst ('create new database objects') then don't forget to change your init.ora for your already running instance. Normally your init.ora includes a ifile-stmt for a config-file (default is config.ora)

ifile                           = /home8/oracle/dbs/config.ora

move config.ora to config<sid>.ora and change the ifile-line in init.ora to

ifile                           = /home8/oracle/dbs/config<sid>.ora

Otherwise the creation of the second DB would destroy the config-file for the first DB.

Regards
Helmut

--
Helmut Kuhn                               Tel:   +49 89 636-2887
Siemens-Nixdorf Informationssysteme AG    Fax:   +49 89 636-48332
SNI MR PD 432                             email: helmut.kuhn_at_mch.sni.de
Otto-Hahn-Ring 6
81739 Muenchen