can oracle have multiple databases?

[sysdba]

All you need to set is ORACLE_SID
For example, in K shell,
export ORACLE_SID=new_sid
in C shell,
setenv ORACLE_SID new_sid
before issuing create database statement.