Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Create New Instance
You have to create a new instance first. You do this by using the ORADIM utility or you could use database configuration assistant. I think most folks prefer oradim. You did not say what platform/version. This is for Oracle 8.1 on Win NT/2000
Oradim syntax
ORADIM -NEW -SID <SID> -INTPWD <password> -STARTMODE <mode> -PFILE
<pfile>
where:
<SID> -- the database SID
<password> -- is the password for INTERNAL
<mode> -- is the startup mode for the services, either AUTO or MANUAL
<pfile> -- is the full path and name of the INIT<sid>.ORA file
Review the ORADIM log file for any errors.
Hamid Alavi <hamid.alavi_at_qu To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> ovadx.com> cc: Sent by: Subject: Create New Instance root_at_fatcity.co m 05/01/2002 02:23 PM Please respond to ORACLE-L
Hi all,
I want to know when you want to create a new database before that do you have to create a new instance first if yes HOW? This is my first step for create a new database(or instance).
ORACLE_SID=TEST
export ORACLE_SID
CONNECT INTERNAL
STARTUP NOMOUNT PFILE ='PATH/initTEST.ORA' ----->> BUT HERE IN INIT FILE WE
HAVE TO MENTINED THE CONTROL FILE THIS SHOULD BE JUST THE LOCATION & NAME
??
SO WHEN I RUN THIS SCRIPT THE DATABASE & INSTANCE WILL BE CREATED OR I HAVE
TO DO MORE STEPS.
THANKS FOR HELP
Hamid Alavi
Office 818 737-0526
Cell 818 402-1987
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: hamid.alavi_at_quovadx.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_at_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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Rick_Cale_at_teamhealth.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_at_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).Received on Wed May 01 2002 - 14:57:55 CDT
![]() |
![]() |