OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Manual DB creation (oracle 10.2.0.1.0 - windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Manual DB creation [message #493233]

Sun, 06 February 2011 23:51

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Need some clarification on the Manual DB creation:

1) Do we need to create the folder %oracle_home%\database in capital letter as "%ORACLE_HOME%", when i created with small letter it shows error in further stage.

2) Do we need to fire the below command after the DB creation by manually.
CREATE SPFILE FROM PFILE;

3) I forgot to do the step2 as mentioned above, now once i relogin to the DB, the pfile it searching in different folder.
What is the solution for this?

Regards:
Muktha

Report message to a moderator

Re: Manual DB creation [message #493234 is a reply to message #493233]

Sun, 06 February 2011 23:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

#1) NO

#2) NO

#3) It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Manual DB creation [message #493314 is a reply to message #493234]

Mon, 07 February 2011 05:13

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

You do realise that %oracle_home% is an environment variable don't you? It points to a directory, but it isn't one.

Report message to a moderator

Previous Topic:	Location of a DB Block
Next Topic:	Updating table through concurrent sessions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 18:40:08 CDT 2024