From tushig007@yahoo.com Thu, 09 Aug 2001 17:53:35 -0700 From: tushi teek Date: Thu, 09 Aug 2001 17:53:35 -0700 Subject: NEW To Oracle - Please Help For Setting Up New Instance Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi Guys, I am new to Oracle but have experience in other RDBMS. I have gone through the Oracle manuals and have feel of Oracle. I am planing to install a test instance to play with it, in one of our development server where we already have two instances running. I will be performing the following task to setup the new instance. I will appreciate your feedback in correcting and adding any step if I have missed/messed up. 1. Create directories for bdump, cdump, udump, pfile. I will be creating these directories on the same model as I have for other instances running this box. 2. Create directories for the datafiles which will be used by new test instance. 3. Add a entry for the new instance in listner.ora & tnsname.ora and use the unique port number. 4. Copy the existing initialization file to the initNEWINSTANCE.ora in pfile directory and modify the control_file name, db_name etc. according to the new instance name. 5. set the $ORACLE_SID to new instance. 6. Start the instance using svrmgrl Connect internal Startup If the instance starts, I will create the database, tablespaces. Please don’t make fun out of me if this approach is entirely wrong, instead I would be thankful for lining me on the right track. THANKS IN ADVANCE Tushi PS. Instance will be setup on HP-UX11, oracle 8.1.6… Also I will be using the "oracle" login which has all the permission on Oracle binaries and being used for starting/shutdown the existing running instances. __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tushi teek INET: tushig007@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).