From: chapmitch@aol.com (ChapMitch) Subject: Re: Two instances on Oracle 7.3 Date: 1997/12/12 Message-ID: <19971212031300.WAA14210@ladder02.news.aol.com>#1/1 References: X-Admin: news@aol.com Organization: AOL http://www.aol.com Newsgroups: comp.databases.oracle.server There no no wizard or such so you have to do it to old unix way. First copy the intXXX.ora file to a file with a differnt XXX name. then goto a connand window. theres a newdb.sql file in the oracle_home/rdbms73/admin dir, modify this file to your new specs then- start svrmgr23 and connect nomout and runthis script. then shut the data base and start/oracle for nt/instance manager and add new instance. if dont do this last step the database will not be added to the controlpanel sevrices and will not start on reboot. and dont forget to midifiy your listener.ora file and restart the tnslistener service. good luck