Our database was created by a colleague who had problems with a particular name on Linux. The name adm_p did not work, so he named the database admp, and the instance was named adm_p. Apparently, according to him, the '_' (underscore does not work, he thinks it might be an Oracle to Linux thing.

The '_' helps us read the name better but I hate having to have a different name for our instance and database name since we only have one instance, and it confuses issues. We are creating a new instance and I thought this was an ideal time to change the name on the new system.

Also, can you tell me if I wanted to change the name on our exisiting Production server, what would the procedure be? Any precautions to take?

Any help would be highly appreciated.

Thanks,
Nirasha