Location of SPFILE - at Manual DB creation [message #493476] |
Tue, 08 February 2011 05:49 ![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,
URGENT - Need your guidance
I successfully created a DB manually with PFILE.
I want the DB to startup with SPFILE at next login.
So i fired the below command.
CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.
But it shows the error as below:
ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.
please it is very urgent,
Regards:
Muktha
|
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #493684 is a reply to message #493481] |
Wed, 09 February 2011 06:29 ![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 Michel,
1) What is inconsistent on the path?
I meant path is -- 'D:.....'
2) One of my colleague told, we cant change the Oracle home path, all the new DB creation will take the path of "C:\oracle\product\10.2.0\db_1\database" only.
How to create our own location instead of using the above one (which is belongs to the DB ORCL).
Regards:
Muktha
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #493830 is a reply to message #493688] |
Thu, 10 February 2011 03: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) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi Michel,
Thanks,
But why i am not able to create a manual DB successfully?
Do i need to set Environment Variables for all of the below in 10g:
ORACLE_HOME
ORACLE_BASE
ORACLE_SID
ORA_nls33
PATH
LD_LIBRARY_PATH
Below is the way, to create a Environment variables:
my computers --> properties --> Advanced --> Environment variables --> system variables.
Regards:
Muktha
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #493832 is a reply to message #493830] |
Thu, 10 February 2011 03:09 ![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) |
knight
Messages: 111 Registered: January 2009
|
Senior Member |
|
|
Quote:URGENT - Need your guidance
I successfully created a DB manually with PFILE.
and now
Quote:Hi Michel,
Thanks,
But why i am not able to create a manual DB successfully?
Quote:I want the DB to startup with SPFILE at next login.
did you create the spfile successfully?
|
|
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #494027 is a reply to message #493865] |
Fri, 11 February 2011 00:09 ![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 Michel,
Here is the steps:
-----------------
1) Created below folders:
d:\pragati
d:\pragati\data
d:\pragati\control
d:\pragati\log
d:\pragati\bdump
d:\pragati\cdump
d:\pragati\udump
d:\pragati\adump
d:\pragati\pfile
d:\pragati\scripts
d:\pragati\%oracle_home%\database
2) Modified a existing PFILE with the below parameters and pasted in the folder "d:\pragati\pfile".
db_name = pragati
db_domain = " "
etc.....
3) Created a text file called "initpragati.ora" in the folder "d:\pragati\%oracle_home%\database".
with the following contents.
ifile=d:\pragati\pfile\initpragati.ora
4) Setting Oracle SID.
set oracle_sid=pragati
5)Then Setting Environment Variables as below:
Right click on MY COMPUTER -> Properties -> Advanced tab -> Environment variables -> System Variables -> Add -> ORACLE_SID (variable name) -> PRAGATI (variable value).
6) Then Created a Windows service for the database.
oradim -new -sid pragati -startmode a -pfile d:\pragati\pfile\initpragati.ora
7) Connect as SYSDBA:
sqlplusw /nolog
connect sys/change_on_install as sysdba
8) Start an Oracle instance:
Shutdown immediate
startup nomount pfile=c:\pragati\initpragati.ora
9) Create SPfile from Pfile:
CREATE SPFILE FROM PFILE
10) Then ran the DB Creation script.
11) Startup the Database
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN;
Until this stage everything is fine,
But, when i Shutdown and Startup the DB again, it looks for the PFILE/SPLOCATION in the below folder.
C:\oracle\product\10.2.0\db_1\database
Why it is not working out with the folder called - "%oracle_home%/database"?
please it is very urgent.
Regards:
Muktha
CM: disabled smilies
[Updated on: Fri, 11 February 2011 04:25] by Moderator Report message to a moderator
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #494070 is a reply to message #494027] |
Fri, 11 February 2011 04:28 ![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) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
muktha_22 wrote on Fri, 11 February 2011 06:09
Why it is not working out with the folder called - "%oracle_home%/database"?
Does the folder name literally have %oracle_home% in it?
Cause %oracle_home% is an environment variable.
Which I assume points to:
C:\oracle\product\10.2.0\db_1\
|
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #494090 is a reply to message #494086] |
Fri, 11 February 2011 06: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) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi Knight,
If i change the folder name (as - "ORACLE_123/DATABASE" from the line of commands mentioned above in previous post.
Then what to do next?
And also, how the new DB will consider this path ("ORACLE_123/DATABASE") as an ORACLE_HOME?
Thanks and Regards:
Muktha
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #494105 is a reply to message #494101] |
Fri, 11 February 2011 06:49 ![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 |
|
|
Muktha, we have covered this already, in a topic you raised a week or two ago. As you were told before, %ORACLE_HOME% is the Windows syntax for expanding an environment variable called ORACLE_HOME.
Try this, from your c:\> prompt:
set VAR=1
echo %VAR%
and do not ever attenpt to use a % character in a file or directory name.
|
|
|
|
Re: Location of SPFILE - at Manual DB creation [message #494121 is a reply to message #494108] |
Fri, 11 February 2011 07:40 ![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) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I also pointed out the environment variable issue in another thread a couple of days ago.
@muktha_22 - to reiterate what others have said more times than should ever be necessary - you need to read the docs. They cover all this stuff in detail, with examples.
Otherwise buy a good book on oracle DBA.
You can not create and maintain databases effectively with your current level of knowledge, even with our help.
We are here to help people with specific issues.
We are not here to give you a complete training course in all things oracle - that's something people generally charge for and you don't appear to be paying us.
|
|
|
|