Solaris-[odbc-oracle WP Driver] several problems encountered

Source: Internet
Author: User
Tags driver manager odbc connection sqlplus

 Make sure you have a few problems with the Oracle and ODBC,ODBC connection database installed before you log in to Oracle and start [email protected]:/export] $su-oracleoracle Corporation SunOS5.10Generic Patch January2005[email protected]:/export/home/oracle] $sqlplus/ asSysdbasql*plus:release10.2.0.2.0-Production on Thu Jul9  One: on: the  -Copyright (c)1982,2005, Oracle. All rights reserved.connected to an idle instance. SQL>Startuporacle instance started. Total System Global Area583008256bytesfixed Size1281480bytesvariable Size159384120Bytesdatabase Buffers415236096Bytesredo Buffers7106560bytesdatabase mounted. Database opened. SQL>quit Second, open the database listening [[email protected]:/export/home/Oracle] $lsnrctl startlsnrctl forSolaris:version10.2.0.2.0-Production on the-jul- -  One: Geneva: -Copyright (c)1991,2005, Oracle. All rights reserved. Starting/opt/oracle/product/10.2.0/db_1/bin/tnslsnr:please Wait ... third, after listening to open, we use the network mode to log in [Email protected]:/export/home/oracle] $sqlplus/Nologsql> conn Scott/[email protected]127.0.0.1/orclconnected. Four, /usr/local/ etc related configuration [[email protected]:/usr/local/etc] $lsODBCDataSources Odbc.ini Odbcinst.iniodbc.ini------------------------[Easysoft ODBC-Oracle WP] Description=easysoft Oracle ODBC WP driver[orcl]driver= Easysoft odbc-Oracle wpdescription=easysoft Oracle ODBC WP driverserver=Localhostport=1521Sid=Orcluser=Scottpassword=tigerlogging=Nologfile=Enable_user_catalog=yesenable_synonyms=Yesmetadata_dont_change_case=Nometadata_dont_do_schema=nometadata_id=Nolimit_long=0--------------------------------------------------------------------------------Odbcinst.ini------------------------[Easysoft ODBC-Oracle WP] Description=easysoft Oracle ODBC WP driverdriver=/usr/local/easysoft/oraclewp/lib/Libesorawp.sosetup=/usr/local/easysoft/oraclewp/lib/libesorawps.sothreading=0FileUsage=1Dontdlclose=1Usagecount=1-------------------------------------------------------------------------------- v. ODBC connection database First error [[email protected]:/USR/LOCAL/ETC] $isql-v ORCL [01000][unixodbc][driver Manager]can'T Open Lib'/usr/local/easysoft/oraclewp/lib/libesorawp.so': File not found[Isql]error:could not SQLConnect solution:/etc/profile the path of the associated library, you can use ldd/usr/local/easysoft/oraclewp/lib/firstlibesorawp.so See what's bad then, search in the root directory (all loaded before, the library file should be there), and then check again to make sure the results are as follows: [[email protected]:/export/home/oracle] $ldd/usr/local/easysoft/oraclewp/lib/libesorawp.so Warning: ldd:/usr/local/easysoft/oraclewp/lib/libesorawp.so: is a non-executable libodbcinst.so.1=/usr/local/easysoft/unixodbc/lib//libodbcinst.so.1libessupp.so =/usr/local/easysoft/lib//libessupp.solibeslicshr.so =/usr/local/easysoft/lib//libeslicshr.solibesextra.so =/usr/local/easysoft/lib//libesextra.soLibsocket.so.1= =/usr/lib/libsocket.so.1libnsl.so.1= =/usr/lib/libnsl.so.1libdl.so.1= =/usr/lib/libdl.so.1libthread.so.1= =/usr/lib/libthread.so.1libc.so.1= =/usr/lib/libc.so.1libmp.so.2= =/usr/lib/libmp.so.2libmd.so.1= =/usr/lib/libmd.so.1libscf.so.1= =/usr/lib/libscf.so.1libdoor.so.1= =/usr/lib/libdoor.so.1libuutil.so.1= =/usr/lib/libuutil.so.1libgen.so.1= =/usr/lib/libgen.so.1libm.so.2= =/usr/lib/libm.so.2 vi. ODBC Connection database second error [[email protected]:/export/home/oracle] $isql-v Orcl[s1000][unixodbc][easysoft][odbc-oracle WP driver][oracle]general error:general error:failed to initialise licensing-no valid licenses for  Thisproduct found,returnCode9[Isql]error:could not SQLConnect solution: This is caused by no relevant license, there are two ways to get permission, an online kind of offline, it is suggested and used online, to register an account. 1first configure the next NIC to make sure you can surf the Internet # ifconfig-Alo0:flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> MTU8232Index1inet127.0.0.1netmask ff000000 e1000g0:flags=1000803<UP,BROADCAST,MULTICAST,IPv4> MTU theIndex2inet192.168.31.100Netmask FFFFFF00 Broadcast192.168.31.255ether0: 1f: -: C:8b:d6 # ifconfig e1000g0 plumbifconfig:siocslifname forip:e1000g0:already exists# ifconfig e1000g0192.168.71.222Netmask255.255.255.0up# Route Adddefault 192.168.71.1Add Netdefault: Gateway192.168.71.1# ifconfig-Alo0:flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> MTU8232Index1inet127.0.0.1netmask ff000000 e1000g0:flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> MTU theIndex2inet192.168.71.222Netmask FFFFFF00 Broadcast192.168.71.255ether0: 1f: -: C:8b:d6 # ping8.8.8.88.8.8.8  isAlive2. Start configuration, start success #cd/usr/local/easysoft/license/#./licenses Next there are a few options I'm here for three, select the installed product [2][2]oracle ODBC Driver (WP) v1.1then enter your registration information, after the loss and then enter (Bullish prompt step by step), there is no direct return. After the completion of the automatic will get the secret key, choose automatically automatic processing is good, I do nothing. Choose to get the secret key automatically [email protected]:/export/home/oracle] $isql-v ORCL+---------------------------------------+|                            connected!                                       || || sql-statement | | Help [TableName] | |                                       Quit | | |+---------------------------------------+SQL>official website Get license details Document: ftp://ftp.easysoft.com/pub/docs/licensing/edalicensing.pdfSolaris Network Configuration reference: http://www.cnblogs.com/jdonson/archive/2011/04/28/2031946.htmlonline Help document: http://www.easysoft.com/support/kb/products/odbc_oracle_driver/ 

Solaris-[odbc-oracle WP Driver] several problems encountered

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.