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
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
of list
ORACLE-L [EMAIL PROTECTED]
ovadx.com cc:
Sent by: Subject: Create New Instance
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
]
ovadx.com cc:
Sent by: Subject: Create New Instance
[EMAIL PROTECTED]
m
05/01/2002
02:23 PM
Please respond
to ORACLE-L
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