May I know what is the variables I should adjust or add on $PATH ?

Sure, follow and read the links in Can't locate loadable object for module DBD::Oracle , probably some variation of $ORACLE_HOME