RE: Create New Instance

2002-05-01 Thread Alec Macdonell
I am on Solaris using 8.1.7.3 to create an istance 1. startup nomount pfile=init.ora - run this from svrmgrl connected internal 2. create database command 3. run catalog and catproc (i also run catexp) 4. create my tablespaces 5. create my rollback segments 6. edit init.ora to load rollbacks at s

RE: Create New Instance

2002-05-01 Thread Hamid Alavi
Oracle 8.1.7 on sun solaris. -Original Message- Sent: Wednesday, May 01, 2002 12:58 PM To: Multiple recipients of list ORACLE-L 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

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 datab

Re: Create New Instance

2002-05-01 Thread Rick_Cale
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   -INTPWD    -STAR

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