to change instance name

1. shutdown your database
2. export ORACLE_SID=new_instance_name
3. start your database
4. check v$instance it should now indicates a new instance name