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??
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks,
Your answer led to the solution! My parent directory /opt in /opt/oracle/product/9.2/bi n didn't have execute permissions to run the client. The bin directory had all the right permissions and ownership. Thanks so much!
Regards,
Mark
Your answer led to the solution! My parent directory /opt in /opt/oracle/product/9.2/bi
Regards,
Mark
here you go :) you are right, its a permissions issue.
http://meandering-blog.com/archive/2004/07/02/287.aspx
good luck :)