Solved

OCIEnvCreate() returned -1

Posted on 2006-11-02
4
424 Views
Last Modified: 2010-05-18
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??
0
Comment
Question by:mrmecho
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:rbrooker
ID: 17862572
Hi,

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

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

good luck :)
0
 

Author Comment

by:mrmecho
ID: 17862951
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
 
LVL 18

Accepted Solution

by:
rbrooker earned 500 total points
ID: 17863177
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
 

Author Comment

by:mrmecho
ID: 17868622
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now