Manually creating an Oracle 10g database using command prompt involves:
1. Creating required folders and files for the new database.
2. Configuring the initialization files with the new database name.
3. Running ORADIM to create a new instance and connect to it.
4. Creating the database using a SQL script specifying the datafiles and tablespaces.
5. Running additional scripts to utilize Oracle utilities.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as DOC, PDF, TXT or read online from Scribd
Manually creating an Oracle 10g database using command prompt involves:
1. Creating required folders and files for the new database.
2. Configuring the initialization files with the new database name.
3. Running ORADIM to create a new instance and connect to it.
4. Creating the database using a SQL script specifying the datafiles and tablespaces.
5. Running additional scripts to utilize Oracle utilities.
Manually creating an Oracle 10g database using command prompt involves:
1. Creating required folders and files for the new database.
2. Configuring the initialization files with the new database name.
3. Running ORADIM to create a new instance and connect to it.
4. Creating the database using a SQL script specifying the datafiles and tablespaces.
5. Running additional scripts to utilize Oracle utilities.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as DOC, PDF, TXT or read online from Scribd
Manually creating an Oracle 10g database using command prompt involves:
1. Creating required folders and files for the new database.
2. Configuring the initialization files with the new database name.
3. Running ORADIM to create a new instance and connect to it.
4. Creating the database using a SQL script specifying the datafiles and tablespaces.
5. Running additional scripts to utilize Oracle utilities.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as DOC, PDF, TXT or read online from Scribd
Download as doc, pdf, or txt
You are on page 1/ 3
MANUAL DATABASE CREATION IN ORACLE 10G USING COMMAND
PROMPT
1 At the time database creation manually we have to create a folder of our
database
‘amlngp1’ in each folder of ORACLE that is in
2 {admin,oradata folder and in flash recovery folder } ex. Our database name is amlngp1
(NOTE: flash recovery folder is present only in oracle 10g not in
oracle9i)
3 Open the “admin” folder open your amlngp1 folder now create other six folder’s that is
(adump,bdump,cdump,dpdump,udump,pfile)
4 Open the pfile folder & copy the “init.ora” file from an existing other databse.In the pfile
of amlngp1 database
5 Then rename these “inti.ora” file and erase the numeric value of that file.
(NOTE: in ORACLE 9i pfile dose not consist of any numeric value in
it’s name.)
6 Now open the init.ora file and replace the previous database name with the new
database name using replace command save the changes which we have made.
7 Now open the “db_1” folder open the “database” folder now copy (initsid.ora )here sid
stand for (system identifier of the database)then rename these file with your database (initamlngp1.ora) this is known as “I file” open the file change the database name by replace command save the changes
8 Open the command prompt write the command
C:\>ORADIM –NEW –SID AMLNGP1 –INTPWD ADMIN (Admin is your password.)
9 Message will be retrieve as instance created now on command prompt
connect to this
new database by giving command
10 set oracle_sid=amlngp1 (no space between sid=amlngp1)
11 now connect to SQLPLUS & enter the user name as (sys as sysdba)
12 enter the password admin
13 then type the command startup pfile=’complete path of your pfile’ you can give that
path by dragging initsid.ora file on command prompt now database will up
and open. In these stage database will in a mount phase.(NOTE: if in oralcle10G path of the control file is not found then it will give the error, but in oracle9i database will open normally)
14 now run the database creation script which is previously created & saved as an .sql file
15 Database creation script is as follows. Write this script on notepad file and save as .sql
format. And run on command prompt. By giving @C: \amlngp1.sqlp;
16 After successfully running this script message will retrieve as database is
successfully
Created.
17 Now for utilizing the other utility of oracle we have to run some other supporting files
from “db_1” folder of oracle which have the following path these files are (catalog.sql,catproc.sql & pupbld.sql)path for catlog & catproc.sql is (D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN) and for pupbld.sql path is (D:\oracle\product\10.2.0\db_1\sqlplus\admin)
FOR DELETING PERTICULAR INSTANCE FROM COMMAND PROMPT
COMMAND IS CONNECT THROUGH COMMAND PROMPT C:\> ORADIM - DELETE –SID ALMNGP1 ------ENTER (AFTER THIS COMMAND YOU SHOULD MANUALLY DELETE ALL THE FILES & FOLDERS OF THAT PERTICULAR DATABASE YOU ALSO HAVE TO DESIBLE SERVICES FROM CONTROL PANEL.)
