Issue in Manual DB creation [message #490100] |
Fri, 21 January 2011 00:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi All,
Iam seeking help for the manual DB creation.
I gone through the below steps:
1) created appropriate folders.
2) Copied a PFILE from an existing DB and changed the contents like DB name etc...
3)Then I Created a text file called
%ORACLE_HOME%\DATABASE\initmuktha.ora with the following contents:
ifile=c:\prag\pfile\initmuktha.ora
4) Then i set Oracle SID (Through Environment variable in MY COMPUTER --> PROPERTIES...)
5) Then I Created a Windows service for the DB.
6) startup nomount pfile= c:\prag\pfile\initmuktha.ora
7) Then I ran the database creation command.
The DB was created but when i log in again, it is looking for the pfile in the another DB's location rather than from "%ORACLE_HOME%\DATABASE".
Where i missed out to create new oracle_home folder?
Regards:
Muktha
|
|
|
|
Re: Issue in Manual DB creation [message #490108 is a reply to message #490100] |
Fri, 21 January 2011 01:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Did you install a new Oracle Home for this database? If so, you'll have to create shell scripts that set the home, either to the original home or to the new one. You didn't say where you are setting %ORACLE_HOME%.
|
|
|
|
|
Re: Issue in Manual DB creation [message #490228 is a reply to message #490152] |
Sat, 22 January 2011 02:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi John,
I have created (Manually) the %ORACLE_HOME% in the below location.
C:\prag\admin
C:\prag\flash_recovery_area
C:\prag\oradata
C:\prag\%ORACLE_HOME%\DATABASE
Is it ok, if we create the folder manually?
Regards:
Muktha
|
|
|
Re: Issue in Manual DB creation [message #490231 is a reply to message #490228] |
Sat, 22 January 2011 03:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi - I've asked two questions, which you haven't answered: did you install a new Oracle Home? Did you create a directory called %ORACLE_HOME% ? If you installed a new Oracle Home, you will have to environment variables appropiately in order to connect to it. If you created a directory called %ORACLE_HOME% you have done something so bizarre that I do not feel capable of commenting further. Sorry.
|
|
|