Oracle client connectivity issue from SQL Server -
i have user running ssis package connects oracle server. when user runs package failing error "oracle home not found". i'm local admin on server when execute package succeeds. i'm pretty sure user need not local admin have other servers users able connect oracle out admin rights. kindly let me know permission levels might need check user in order resolve issue.
note: os of server windows server 2012 , oracle provider installed of version 12