tklinz2001
IS-IT--Management
Hi, I need to rename an oracle 10g database but not change the database id. I have identified the steps from different articles but I had a couple questions regarding a couple of steps. I understand all the steps but need clarification with the following. My main concern is the modifications to SPFILE as I can't find too much information on my specific questions.
The step that identifies renaming the SPFILE to match the new DBNAME
Questions:
1) Do I simply rename the file from SPFILEolddatabasename.ORA to SPFILEnewdatabasename.ORA or do I need to change anything in the file? I see in the file that it has the database name in it so that is why I am questioning it. Also, is there a particular tool that I should use?
The step for using Windows says that I must recreate the service so the correct name and parameter file are used and lists the following as an example:
oradim -delete -sid TSH1
oradim -new -sid TSH2 -intpwd password -startmode a -pfile c:\oracle\920\database\spfileTSH2.ora
Question:
2) Is that all that has to be done for this step, is the syntax complete? I know that it is an example using Oracle's example database names but I just need to know if it is complete. Is this the complete process of recreating the service?
The step for altering the listener.ora and tnsnames.ora setting to match the new database name and restart the listener: lsnrctl reload
Question:
3) Best way to alter the listener.ora and tnsnames.ora setting?
Thank you so much
The step that identifies renaming the SPFILE to match the new DBNAME
Questions:
1) Do I simply rename the file from SPFILEolddatabasename.ORA to SPFILEnewdatabasename.ORA or do I need to change anything in the file? I see in the file that it has the database name in it so that is why I am questioning it. Also, is there a particular tool that I should use?
The step for using Windows says that I must recreate the service so the correct name and parameter file are used and lists the following as an example:
oradim -delete -sid TSH1
oradim -new -sid TSH2 -intpwd password -startmode a -pfile c:\oracle\920\database\spfileTSH2.ora
Question:
2) Is that all that has to be done for this step, is the syntax complete? I know that it is an example using Oracle's example database names but I just need to know if it is complete. Is this the complete process of recreating the service?
The step for altering the listener.ora and tnsnames.ora setting to match the new database name and restart the listener: lsnrctl reload
Question:
3) Best way to alter the listener.ora and tnsnames.ora setting?
Thank you so much