BTW, in 8i the maximum length of SID can be 64 characters (not 8 or 4).

I myself still folow my personal rule: SID=4 characters long, DB_NAME is the same as SID. Old habits, I guess....