Hi,
I wanted to migrate a database from one host to another and I used OEM clone for that. In that process it asked me give a db_unique name different from source and I did. Now the cloned database has the instance running as the db_unique_name. I wanted to change that back to match with dn_name. I was able to do that by simply changing the ORACLE_SID and matching parameter file in ../dbs directory. Everything is good. Now I wanted to make sure I shouldn't be able to start the instance with old ORACLE_SID. But it starts the instance happily with either the old instance name or the new. I am confused. How does it start with the old sid name when I don't have the matching parameter file in the ../dbs directory?
Thanks