Home » RDBMS Server » Server Administration » how to change spfile parameter name
how to change spfile parameter name [message #286376] Fri, 07 December 2007 04:11 Go to next message
bansal2945
Messages: 5
Registered: December 2007
Junior Member
hi frindz when i startup database that time oracle gives error that pfile does not exise and which file database is tring to find is with my old database SID name so plz tell me how to change these values so that my database start properly.
Re: how to change spfile parameter name [message #286380 is a reply to message #286376] Fri, 07 December 2007 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand what you have or have not.
Do you have a pfile?
Do you have a spfile?
Do you have a pfile for your current SID or another one?
Same question for spfile.

Copy and paste the error you got, don't just describe it.

Read and follow OraFAQ Forum Guide, especially what is said about IM speak.
Always post your Oracle version (4 decimals).


Regards
Michel
Re: how to change spfile parameter name [message #286395 is a reply to message #286380] Fri, 07 December 2007 04:44 Go to previous messageGo to next message
bansal2945
Messages: 5
Registered: December 2007
Junior Member
database is tring to find a file named spfileora25.ora but i have a file spfiletestora.ora

my databse SID name is testora
earlier i had a databse with sid ora25.
Re: how to change spfile parameter name [message #286398 is a reply to message #286395] Fri, 07 December 2007 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So change your ORACLE_SID setting.

Regards
Michel
Re: how to change spfile parameter name [message #286399 is a reply to message #286398] Fri, 07 December 2007 04:53 Go to previous messageGo to next message
bansal2945
Messages: 5
Registered: December 2007
Junior Member
how to change ORACLE_SID settings i don't want to change my current SID name.

in V$parameter table parameter spfile values is /home/oracle/product/10.1.03/dbs/spfileora25.ora
Re: how to change spfile parameter name [message #286403 is a reply to message #286399] Fri, 07 December 2007 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't change your "database SID", change the value of your environment variable to reflect the same as your database SID.

Regards
Michel

[Updated on: Fri, 07 December 2007 06:00]

Report message to a moderator

Re: how to change spfile parameter name [message #286414 is a reply to message #286403] Fri, 07 December 2007 05:31 Go to previous message
bansal2945
Messages: 5
Registered: December 2007
Junior Member
thanx michel...
Previous Topic: max datafile size in Unix/Windows
Next Topic: migration from one server to another
Goto Forum:
  


Current Time: Thu Dec 08 10:17:52 CST 2016

Total time taken to generate the page: 0.05891 seconds