on unix
$ ORACLE_SID=newname;export ORACLE_SID

to make it permanent edit .profile

on NT
C:/>set ORACLE_SID=newname;
to make it permanent set environment variable