ORACLE DB Connects only when I do not specify SID
Found the issue. But I don't have any explanation why or how it worked.
It worked after removing GLOBAL_DBNAME parameter in listener.ora under SID_LIST_LISTENER