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??
mrmechoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rbrookerConnect With a Mentor Commented:
Hi,

chmod.

the user that runs the utility needs read access to the bin directory.  you could also add the user into the dba group maybe..
0
 
rbrookerCommented:
Hi,

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

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

good luck :)
0
 
mrmechoAuthor Commented:
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
0
 
mrmechoAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.