Create New Instance

2002-05-01 Thread Hamid Alavi
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

RE: Create New Instance

2002-05-01 Thread Bob Metelsky
Something like this, your paths may vary... copy C:\build_db\initDB.ora D:\Admin\YOURSID\PFILE\initYOURSID.ora pause set ORACLE_SID=YOURSID oradim -new -sid YOURSID -intpwd superman -startmode manual -pfile D:\Admin\YOURSID\PFILE\initYOURSID.ora svrmgrl @C:\build_db\build_tablespace.sql oradim

Re: Create New Instance

2002-05-01 Thread Rick_Cale
of list ORACLE-L [EMAIL PROTECTED] ovadx.com cc: Sent by: Subject: Create New Instance

RE: Create New Instance

2002-05-01 Thread Alec Macdonell
You will also have to run your create database command giving the system tablespace and redo log locations. You will want to create a rollback segment or two and then edit your init file to include the rollback segments at start time. Then create your tablespaces and you should have an empty

RE: Create New Instance

2002-05-01 Thread Hamid Alavi
] ovadx.com cc: Sent by: Subject: Create New Instance [EMAIL PROTECTED] m 05/01/2002 02:23 PM Please respond to ORACLE-L

RE: Create New Instance

2002-05-01 Thread Alec Macdonell
by: Subject: Create New Instance [EMAIL PROTECTED] m 05/01/2002 02:23 PM Please respond to ORACLE-L Hi all, I want to know when you want to create