Oracle Error Libclntsh.so.10.1
EDB Postgres Advanced Server Author Message 17 Mar 2009 18:44:50 Subject: DB Link To Oracle...can't load libclntsh.so library.... Jeff_H Member Joined: 12 Mar 2009 14:10:03 Messages: 24 Offline I'm creating a database link to Oracle using Oracle 11g client library. ORACLE_HOME is set as well as LD_LIBRARY_PATH, but when I try selecting anything from the database link, i get: ERROR near line 1: unable to load OCI library: libclntsh.so: cannot open shared object file: No such file or directory Hint: Either the ORACLE_HOME environment variable or oracle_home setting must be defined at the time you start the server. Any ideas here? The server was started with these paths set in the environment, but still same message. 17 Mar 2009 22:52:05 Subject: Re:DB Link To Oracle...can't load libclntsh.so library.... scottiebo Senior member Joined: 23 Oct 2005 21:05:02 Messages: 197 Offline When you set your environment and start the server, how are you starting the server? If you're using the /etc/init.d/edb_x.x script, it is going to su - enterprisedb -c "serviceControl.sh" to run the command, so the environment you're setting is not getting loaded. Make sure that the user that owns the database server process has the environment set in their .bash_profile or in the 'serviceControl.sh' script. (/opt/PostgresPlus/8.3AS/serviceControl.sh) The other thing you can do is: su - enterprisedb
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign http://forums.enterprisedb.com/posts/list/1661.page up libclntsh.so.11.1: cannot open shared object file up vote 14 down vote favorite 2 I want to schedule a task on linux by icrontab, and the task is written in python and have to import cx_Oracle module, so I export ORACLE_HOME and LD_LIBRARY_PATH in .bash_profile, but it raise the error: libclntsh.so.11.1: cannot open shared object file. Since it is ok to run the http://stackoverflow.com/questions/2708317/libclntsh-so-11-1-cannot-open-shared-object-file task by issue the command in shell like python a.py # ok I change the task in icrontab into a shell script which invoke my python script, but the exception recurred? # the shell script scheduled in icrontab #! bash python a.py Could you help how to do with it? oracle shell cron environment-variables crontab share|improve this question edited Sep 2 '10 at 7:35 Yasir Arsanukaev 7,50222550 asked Apr 25 '10 at 13:08 e.b.white 3352414 add a comment| 6 Answers 6 active oldest votes up vote 12 down vote accepted Possibly you want to specify PATH — and also ORACLE_HOME and LD_LIBRARY_PATH — so that cron(1) knows where to find binaries. Read "5 Crontab environment" here. share|improve this answer edited Apr 25 '10 at 14:02 answered Apr 25 '10 at 13:10 Yasir Arsanukaev 7,50222550 but we I update the shell script as below: #! /bin/bash echo $ORACLE_HOME echo $LD_LIBRARY_PATH and redirect the output of crontab to log file why these path have been found and writted to log? –e.b.white Apr 25 '10 at 14:17 @zhangzhong I suppose you'd like to use export no
and SafetyAsset NetworkAsset Operations http://anuj-singh.blogspot.com/2011/07/libclntshso101-cannot-open-shared.html and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury oracle error and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and oracle error libclntsh.so.10.1 Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and Transpo
libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directoryerrorOne moment please...err: ERROR Unable to check database.err: Error description: Database access error. Reason Loading shared object failed. First tried to load library clntsh and failed because of error: [clntsh: cannot open shared object file: No such file or directory]. Second tried to load library libclntsh.so and failed because of error: [libclntsh.so: cannot open shared object file: No such file or directory].Please press Enter to continue...===# .bash_profileexport ORACLE_HOME=/opt/app/oracle/product/10.2export LANG=en_US.utf8export LC_ALL=en_US.utf8export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:# or 32bit lib path # export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib32:# LD_LIBRARY_PATH=$ORACLE_HOME/lib#Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup programs#PATH=$PATH:$HOME/bin#export PATHexport PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:$PATH:$HOME/bin===Try to connect sqlplus from different user [bobjxi@apt-jtime-01 ~]$ sqlplussqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directoryldd /home/oracle/oracle/product/10.2.0/lib32/libclntsh.so.10.1 [bobjxi@apt-jtime-01 lib]$ -rwxr-x--- 1 oracle dba 18451220 Jul 13 16:18 libclntsh.so.10.1-rw-r----- 1 oracle dba 3093860 Jul 13 16:18 clntsh.maplrwxrwxrwx 1 oracle dba 50 Jul 13 16:18 libclntsh.so -> /opt/app/oracle/product/10.2/lib/libclntsh.so.10.1[bobjxi@apt-jtime-01 lib]$ ldd libclntsh.soldd: error: you do not have read permission for `./libclntsh.so'[bobjxi@apt-jtime-01 lib]$ ldd libclntsh.soldd: error: you do not have read permission for `./libclntsh.so'permission problem -rw-r----- 1 oracle oinstall 3104536 Jul 13 16:18 libn10.a-rwxr-x--- 1 oracle dba 18451220 Jul 13 16:18 libclntsh.so.10.1 <<<<<<< change the group dba to oinstall-rw-r----- 1 oracle dba 3093860 Jul 13 16:18