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.
 


Comments

jakejarson
02/11/2010 18:57

nice information about creating database using command prompt and notepad thankz for the help alitadada

Reply
01/04/2011 23:08

Build a network of EQO friends, keep in touch on the go, and save!

Reply
02/20/2011 19:53

Going on your remarkable writings, I realize it is of the extraordinary experience and suitable thoughts.Think that I will certainly receive which I really want coming from your blogs.Best Regards!

Reply
02/21/2011 00:36

Great article. If you has some free time,Welcom to the Cheap jordan shoes! There are many kinds shoes on the website!

Reply
02/21/2011 00:39

Cheap MBTs on hot sale, they are all in the top-quality ,get the Comfortable and the Health from the MBT.welcome to visite our site . we could offer the best service for you!



Reply
02/28/2011 16:38

You distribute many thoughts and also intention weblog, I yet seriously observed your interior ideas, you want to offer to the current society, certainly is actually my opinion, I've admitted, Furthermore, i respect you.

Reply
03/06/2011 17:21

The shoe due to the unique flex design, otherwise a great running shoe.

Reply
03/22/2011 18:08

Just wish to say your article is striking. The clearness within your put up is merely spectacular and i can take for granted you might be an expert on this field. Nicely with your permission enable me to grab your rss feed to maintain up to date with forthcoming publish. Thank you a million and please retain up the efficient operate.

Reply
12/31/2011 04:02

THX for info

Reply
03/13/2012 13:25

Nice one info, thx

Reply
03/22/2012 16:22

Fine post dude

Reply
07/09/2012 22:05

Good blog, Google collection, very good, I really like your blog, your style is what I want, I am glad to be able to read, I hope next time like you can still see such a goodblog.

Reply
07/10/2012 09:13

I went over this internet site and I think you've got lots of great information, bookmarked (:.

Reply
07/10/2012 09:13

My brother suggested I would possibly like this blog. He was once entirely proper. This submit really created my day. You can�t believe just how so a lot time I had spent for this details! Thank you!

Reply
07/10/2012 22:38

Inadvertently into your blog, the first impression to my surprise, I have been looking for a bar blog as my reference, you want to learn some good experience, your blog is very suitable for me.Thank you very much.

Reply
07/11/2012 01:29

l'administration ne peut avoir qu'une action fort indirecte sur leur disposition,

Reply
07/11/2012 01:30

et les conseils sont souvent sans effet sur la routine et le mauvais vouloir.

Reply
07/11/2012 18:48

Your article, content is rich, contain a wealth of knowledge and information, I look forward to your wonderful share ... ...

Reply
07/11/2012 18:48

I really thank you for sharing this great post. Keep up with your work. Thanks to this very useful information, you have provided us with. Thank you so much for sharing

Reply
07/14/2012 17:49

I cherished up to you�ll receive carried out appropriate here. The sketch is tasteful, your authored material stylish. nonetheless, you command get got an shakiness over that you would like be turning inside the following. sick unquestionably come more formerly once far more since exactly the same just about a whole lot regularly within case you defend this hike.

Reply
07/15/2012 02:53

THX for info

Reply
07/18/2012 01:43

I'm glad to be a visitor of this utter web site ! , thankyou for this rare data! .

Reply
07/19/2012 20:51

And thanks to a greater power than Earth, filling and guide our long-term.

Reply
07/19/2012 20:58

Then, I want to pierce the distant haze, and tear be split mythical curtain.

Reply
07/20/2012 03:23

I like this article because it is not complicated and easy to understand. It also iinspired my determination and ideal.

Reply
07/22/2012 21:00

I have caught such a wonderful site. Anyone can get, in such a way to perfect the written information. Excellent blog!

Reply
07/22/2012 21:00

Guy ... Really thank you with the use of enthusiastic readers information! I will bookmark your site

Reply
07/25/2012 00:23

content is very rich, I would like to take this opportunity to thank you for your professional help, moreover, I believe this one
great Internet site. I 'm very happy .

Reply
07/25/2012 00:24

A sa source, la Sa?ne est à 396 mètres au-dessus du niveau de la mer; à Gray, à 208 ; à Chàlons, à 173 et à son confluent à 162.

Reply
08/02/2012 23:23

Recently, I met your article, and have been reading. Your article has really helped me. I want to love reading the article.

Reply
08/02/2012 23:24

En 1862, la diminution du nombre des affaires s'est arrêtée. Il était, dans l'arrondissement de Lyon, en 1861, de 5053; il est, en 1862, de 5220.

Reply
08/02/2012 23:24

A Lyon, plus que partout ailleurs, les ?uvres de bienfaisance, les fondations pieuses sont multipliées; leur but est toujours la moralisation

Reply
08/14/2012 02:47

Hello. You look very interesting details, I don't know where to start. Do you have any tips or advice? Thanks a million

Reply
08/20/2012 17:49

the conventional straight lines, into a graceful arc, embedded in the inside from the lens, light and wealthy flexible, style, full of flavor. The characteristics on the metal frame is the fact that it allows the wearer is quite delicate, can also be somewhat simple to match clothes. The distinctive frame style jumped out of the regular metal frame glasses, nerdy, and add a lot of style flavor. Both dressed as the younger generation in general influx of

Reply
08/20/2012 17:53

out for these sales due to the fact it can be the most suitable location to Straight Leg Jeans uncover jeans that fit your size and height The deep indigo give these denim beauties a certain casual sophistication that make them a definite need to have for any fashion forward woman's wardrobe I am writing this article to assist the brief females know where they could obtain

Reply
08/20/2012 18:35

sights which will make females really feel so competent about designer handbags. They might be a disagreement, but, they may be significantly on top of that to that particular, simply simply because they definitely improve the risk for woman's appearance a lot a lot more confident. Designer handbags boost the danger for lady really feel stylish and significant, and when you happen to be capable to purchase designer bags for under $100 it's liberating that only

Reply
08/20/2012 19:25

Just after the expertise of numerous years of design, production and marketplace demand, Oakley use on the crystallization of high-tech and intelligent, creating a series of high-performance fashion eyewear. Low-cost Oakley Sunglasses concept of subversion, is that it glasses, comfort, practicality and artisticof integration. Item design or alternative of components, have been a series of advanced scientific experiments and testing to ensure its comfort and premium quality, high degree of integration and also the function and fashion.

Reply
08/21/2012 21:39

Que vous soyez un homme ou une femme, vous trouverez des fois quand transportant les produits que vous devez avoir avec vous sont capables d'être juste une gêne. Lorsque cela se produit, il est certainement un facteur particulier qui permettra d'enregistrer vos armes dans le fardeau et c'est certainement un sac à bandoulière en cuir de cwmalls.com.

Reply
08/21/2012 21:40

Within a substantial establishment like a hotel or a commercial laundry machine center the chances are much more given that the machines run on a daily basis and that as well throughout the day. Even at houses, we land up with dirty garments nearly just about every day and if the machine seizes to function then you'll be able to picture the disaster it could bring.

Reply
08/22/2012 22:28

Just after the expertise of numerous years of design, production and marketplace demand, Oakley use on the crystallization of high-tech and intelligent, creating a series of high-performance fashion eyewear. Low-cost Oakley Sunglasses concept of subversion, is that it glasses, comfort, practicality and artisticof integration. Item design or alternative of components, have been a series of advanced scientific experiments and testing to ensure its comfort and premium quality, high degree of integration and also the function and fashion.

Reply
09/04/2012 01:02

Afterward analyse a couple of by the web log bases about your internet site at once, and I genuinely alike your agency by blogging. I bookmarked them to ah bookmarker internet site ezine and leave comprise agreeing back up before long. Pls check ah internet site also and allow Maine acknowledge what you believe

Reply
09/04/2012 01:03

An adept articles are to comprise able-bodied to appeal the centers by the batches. The articles article can buoy comprise ample and colored and allow lectors empathise easy. Allow it experienced an lit bestowed appeal.

Reply
09/04/2012 01:04

I Look up to the of value fact you bid you at bottom your article. I will bookmarker your internet site and accept ah banters analyse astir the abiding by commonly. I'm actually convinced they'll empathise a lot fresh binge at a lower place than anyone additional!

Reply
09/18/2012 21:49

This cooperation is by the American custom Watch company Bamford <a href="http://www.brandreplicawatches.net/">Replica Watches</a> Department will Rolex Yachtmaster and Rolex Submarines two watches mixed together, the global set limit to issues 20. <a href="http://www.brandreplicawatches.net/">http://www.brandreplicawatches.net/</a> Rare vigorously water wrist watch global limited 20 besides all show costly besides, still added a childlike innocence, rare collection.

Reply
09/25/2012 06:23

THX for info

Reply

Aloha at that place. I ascertained your internet site along agency by Google altho anticipating an akin issue, your internet site acquired Hera astir. Them comes along to comprise avid. I've bookmarked them inch ah google bookmarks to antagonistic after.

Reply
09/26/2012 00:16

Thank you for your well-thought content. I'm really at perform proper now! So I ought to go off with no reading through all I'd like. But, I place your web site on my RSS feed in order that I can read mor

Reply
09/26/2012 00:17

I'm identical affected all but your aspects and affecting article. I Bob Hope you delegate to bear on authorship a great deal informational article.these web log are identical acquitting , I'm actually happy to base ah annotate about these web log .

Reply
09/26/2012 01:16

Most playpens are in most cases a great deal more compact and lighter, as compared with baby carrier. Your son or daughter can transfer freely with the bigger space offered, even though it occupies a significantly bigger region inside the property. The actual lower limbs supports the compose as well as the excess weight within the playard.

Reply
09/26/2012 01:17

En outre, ils devraient produire l'artisanat superbe supérieure excellent et qualifié. Monte plus, monté considèrent que tous ces bagages sont sur le point de devenir répétitions, étant donné que reproduire, sacs à main peuvent être comme haut calibre commande créateur sacs à main en conjonction avec les réplications inférieures.

Reply
10/04/2012 23:18

Secondo inning e ho legato per inizialmente con esperienza pratica e ho vinto il terzo inning. Ero pieno di gioia, psicologico e tutto, che mi sento le mie scarpe sportive è sicuramente il contributo, sembra che attualmente non indossare stivali da neve e abbigliamento sportivo scarpe è opportuno. Scarpe sportive ha fatto molto di più di stivali da neve correre molto più velocemente.Anche se un po ' freddo, ma psicologico o tiepida, non sento freddo. Domanda di scarpe bambini, ora anche è progressivamente più enorme, in nostro l'intero mercato, davvero è normalmente un numero crescente di home business opportunità esistono, così, fanno le scarpe per bambini, che sicuramente dispone anche di mercato sempre più potente, questo, che potrebbe essere probabilmente più nelle migliori scarpe sportive nella nostra vita, per rendere l'intera nostra società di oggi, può sentire incredibilmente davvero buon effetto, anche possibile lasciare che abbiamo scoperto, per nella nostra società completa, la sorpresa sarà più apparso.

Reply
10/04/2012 23:19

Peut volume de transformation du style de fermeture à glissière permet également la modélisation de sac avec wechselhaft caractéristique, facile à transporter à la fois identique, la mode se sentir riche. Les points sans tracas, la conception, néanmoins encore plus gênante de prendre beaucoup plus difficilement tenir dans le grain kin de serpents. Pas aussi old-fashioned, aussi ne peut pas aussi plats, de couleur crème se remplit de loin le plus propre. Forme concise et atmosphérique est relativement simple à gérer, de fonction ou de l'observation du tissu, sont des marchandises de qualité rares. À fois candidat pour le sac, a quand significativement plus de 1, ce type de rivet pliable sac est vraiment typique.

Reply
10/04/2012 23:20

Oftentimes, if a woman is prepared to sell her highly-priced designer garments at discounted rates, it is since they are out of style. Do not get a shirt just because it really is by a famous designer in the event the style is totally outdated. Rather, acquire from a retailer that only sells new discount garments for women in present fashion trends. Getting discount garments for ladies is really a good option to save capital, but you've to be sensible about it. Do not risk your revenue by acquiring utilised clothing. One can find reliable online retailers that offer brand new, trendy discount garments for ladies.

Reply



Leave a Reply



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