HOW TO CREATE PFILE AND SPFILE FROM WINDOWS USING COMMAND PROMPT

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.
 
 
Start blogging by creating a new post. You can edit or delete me by clicking under the comments. You can also customize your sidebar by dragging in elements from the top bar.
 


Enjoy Visiting and Exploring my site Just Leave Comment or message to borbon_ma.alita@yahoo.com.ph for your Suggestion.