STEPs:
1. Create a folder from drive c:\sample. And subfolders UDUMP, BDUMP, CDUMP, PFILE.
2. Open the COMMAND PROMPT from start menu then RUN AS type CMD.
3. Type cd\
4. Create PFILE from notepad using this codes :
#Cache and I/O
db_block_size=4096
db_cache_size=20971520
#Diagnostics
background_dump_dest=c:\sample\bdump
core_dump_dest=c:\sample\cdump
user_dump_dest=c:\sample\udump
#Control file
control_files='c:\sample\control01.ctl'
#Miscellaneous
compatible=9.0.0
db_name=borbon
remote_login_passwordfile=exclusive
#pool
java_pool_size=5242880
large_pool_size=5242880
shared_pool_size=20971520
#Processes
processes=75
#sort,hash
sort_area_size=10485760
#undo,rollback
undo_management=auto
undo_tablespace=UNDOTBS
5. Save the pfile using this filename pfilesample.ora from subfolder pfile and open the file using notepad. (note: select all files)
6. In COMMAND PROMPT type set oracle_sid = borbon.
7. Then type sqlplus/nolog to enter from sqlplus like this SQL>.
8. Then Connect as idle instance system type conn / as sysdba .
9. Then type shutdown abort.
10. Then type startup nomount pfile = c:\sample\pfile\pfilesample.ora.
11. Then create spfile type create spfile = 'c:\sample\spfilesample.ora' from pfile='c:\sample\pfile\pfilesample.ora'; (File created appear).
NOTE: The database name can be set at “db_name=orcl9i”
HOW TO CREATE DATABASE USING COMMAND PROMPT FROM WINDOWS
STEPs:
1.
create database borbon
logfile group 1('c:\sample\redo01.log') size 5m,
group 2('c:\sample\redo02.log') size 5m
maxinstances 1
maxloghistory 1
maxlogfiles 5
maxlogmembers 5
datafile 'c:\sample\system01.dbf' size 200m
undo tablespace undotbs datafile 'c:\sample\undotbs01.dbf' size 100m
character set US7ASCII
national character set AL16UTF16
2. SQL> exit
3. C:\> set oracle_sid = borbon
4. C:\> sqlplus/nolog
5. SQL> connect / as sysdba
6.SQL> shutdown abort then sql> startup
7. SQL> create temporary tablespace temporary
tempfile 'C:\sample\temp01.dbf' size 10m;
8. SQL> create tablespace users01
datafile 'C:\sample\users01.dbf' size 10m;
9. SQL> @%ORACLE_HOME%\rdbms\admin\catalog.sql
10. SQL> @%ORACLE_HOME%\rdbms\admin\catproc.sql
11. Now you need to edit the following files
· C:\oracle\ora92dbase\network\admin\tnsnames.ora
· C:\oracle\ora92dbase\network\admin\listener.ora
NOTE: Copy and paste the following to the given directory but don't replace the existing text file just add below and save..
TNSNAMES
borbon =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unit1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = borbon)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unit1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
LISTENER
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unit1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = borbon)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = borbon)
)
)
1. After you edit the tnsnames.ora and listener.ora exit the sql in command prompt then type the following.
c:\> set oracle_sid = borbon
c:\>oradim –new –sid borbon –intpwd password
13. Open the Enterprise Manager Console (EMC)
>>>click start
>>>program
>>>Oracle – OraHome92
>>>Enterprise Manager Console
14. Right Click in Databases then select add database to tree an option form appear.
15. Select the add selected databases ....... then check only the borbon.
16. Press ok and try to open the database borbon.