Link to home
Start Free TrialLog in
Avatar of mrmecho
mrmecho

asked on

OCIEnvCreate() returned -1

I am trying to connect a 9.2 Oracle client to a 10g server but am receiving OCIEnvCreate() returned -1.  I am using a utility that uses this information to connect to the database.  The utility creates tables using the connection info.  The utility justs sits there spinning it's wheels, but should be instanteanous.  I checked the error log and found this info.  I think this error may have something to do with permissions or not linking properly to the correct libraries.  I am stuck...any ideas??
Avatar of rbrooker
rbrooker
Flag of New Zealand image

Hi,

here you go :) you are right, its a permissions issue.

http://meandering-blog.com/archive/2004/07/02/287.aspx

good luck :)
Avatar of mrmecho
mrmecho

ASKER

Thanks for the update...forgot to mention I'm on a linux box.  I assume it's still a permissions issue there as well??
I have /opt/oracle/product/9.2/ for $ORACLE_HOME.  There's a bin/ directory under this path.  Do I need to chmod these permissions or chown??

Thanks,
Mark
ASKER CERTIFIED SOLUTION
Avatar of rbrooker
rbrooker
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mrmecho

ASKER

Thanks,
    Your answer led to the solution!  My parent directory /opt in /opt/oracle/product/9.2/bin didn't have execute permissions to run the client.  The bin directory had all the right permissions and ownership.  Thanks so much!

Regards,
Mark