|
|
| Re: how to create a new database ( i am a new user) [message #369573 is a reply to message #369559] |
Thu, 26 October 2000 12:27  |
Salman Khan
Messages: 51
Registered: September 2000
|
Member |
|
|
Its very to create.
Create a new Linux user and assign a DBA group.
Put a new SID in your .profile and all oracle env.
Get a init.ora file (its came with oracle and you can find it in your $ORACLE_HOME/dbs/, copy this file with like this initNEWSID.ora (NewSID is your new sid name) change in file initSID control file name and location and change dbname from it.
and then use follow the steps
Step 1. svrmgrl
Step 2. connect internal
Step 3. startup pfile=$ORALCE_HOME/dbs/initNEWSID.ora nomount
Step 3. CHANGE THE BELOW STATMENT ACCORING TO YOUR FILESYSTEM OR DIRECTORY STRUCTURE.
create database NEWDB
DATAFILE
'/usr/skhan/oracle/oradata/system1.dbf' size 25M
LOGFILE
GROUP 1 ('/usr/skhan/oracle/oradata/redoTEST1a.log',
'/usr/skhan/oracle/oradata/redoTEST1b.log')
size 500K,
GROUP 2 ('/usr/skhan/oracle/oradata/redoTEST2a.log',
'/usr/skhan/oracle/oradata/redoTEST2b.log') size 500K
character set WE8ISO8859P1;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
