ORACLE_SID not defined ????

You will need to set either the TWO_TASK or ORACLE_SID environment
variables to the correct values for your database. Consult Oracle
documentation for more details. Test your setting by connecting to
the database using an Oracle tool such as sqlplus. Once you can do
that then you can test DBD::Oracle knowing that it should work.The supplied test will connect to the database using the value of theORACLE_USER environment variable so you should set that to the correct
value before starting the test. Please read README.login.

Did you notice thread was more than two years old?