To change the instance name, modify the INSTANCE_NAME parameter in your initialization parameter file. To modify the database name, you'll have to dump your control file to trace, and modify the control file to have the following as your first line:
CREATE CONTROLFILE set DATABASE "newdbname" RESETLOGS .....
For more information, please refer to Metalink Note 15390.1.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.