Is it possible to have a VB.NET aplication using Oracle ODBC driver without running/installing odbc_install.exe?
I want to deploy my application without having to run anything on the client so I guessed that instant client would work but I can't make it work.
I've to install ODBC drivers required by a Windows application ( Windesign ).I've downloaded on Oracle website :
- instantclient-basic-windows.x64-11.2.0.3.0.zip
- instantclient-odbc-windows.x64-11.2.0.3.0.zip
- ODBC driver - Oracle 10.1.exe
- ODBC driver - Oracle 10.2.exe
- ODBC driver - Oracle 9.01.exe
- ODBC driver - Oracle 9.02.exe
But any of them contains install.exe or something like that...So I don't understand how to install instant client...I've found a doc on the web : " ... copy unzipped files into a folder ( ex.: C:OracleInstantClient ) and add Environment Variables TNS_ADMIN and PATH ) ... "I did it. But while adding ODBC driver with Windows admin tools , only SQL Server is available !!!.
The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5
I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).
The error:
[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect
Configuration
odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =
The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.
I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function
odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......
There are three versions of Oracle 10g instant client (10.2.0.2, 10.2.0.3 and 10.2.0.5) on Oracle website. which one works with Window 7? Where I can find the documentation from Oracle website?
View 1 Replies View Related I'm writing on behalf of the MacPorts package management system. I am trying to update the MacPorts port of Oracle Instant Client from 10.2.0.4.0 to 11.2.0.3.0 [URL}...and while many of our ports including the PHP oracle module continue to work fine with this version, soci [URL}.... and TOra [URL]...
ld: can't link with bundle (MH_BUNDLE) only dylibs (MH_DYLIB) for architecture x86_64
This is on OS X 10.8.2 compiling with Xcode 4.6's version of clang ("Apple LLVM version 4.2 (clang-425.0.24) (based on LLVM 3.2svn)").I suspect this is because soci and TOra are doing something with static libraries, and Oracle Instant Client is only shipped as a dynamic library. But I can't explain why this worked with 10.2.0.4.0, unless something has changed about how Oracle Instant
Client is being built. It's not clear whether this is an intentional change in Oracle Instant Client, and if it is, what developers should do to fix their software.I have not heard back from the developers of TOra, and the developers of soci
trying to connect to DB remotely through Toad..
"instantclient" already downloaded and configured as below :
dll files like "oci.dll,... etc" are here : C:Oracleinstantclientinstantclient_11_2
Created both tnsnames.ora & listener.ora are here : C:Oracleinstantclient
etworkadmin
And did the below in user/system variables :
User Variables :
=========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"
System Variables :
===========
TNS_ADMIN with value "C:Oracleinstantclient
etworkadmin"
ORACLE_HOME with value "C:Oracleinstantclient"
Path edited and added this value "C:Oracleinstantclientinstantclient_11_2"
But i am still facing the below error :
ORA-12541: TNS:no listener
I install Oracle instant client 11g in my Windows 7(32bit), and use MSVC6++ to test program occidml.cpp, compile is no problem, but when I run it, it crash on create Connection. I have tried to link with different version of OCCI library ( v8,v9), but all crash on create Connection.
View 0 Replies View Relatedconnecting to an oracle db with the instant client 11.01.06. I can connect to the db via other tools like sqldbx or SqlTools 1.5 which are also using oci. So now I tried it with c++ using Visual Studio 2005 SP1.
First I tried this
Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection("user","pwd","//servername:ip/mydb");
}
and got following error: "the attribute OCI_ATTR_USERNAME is greater than the maximum allowable length of 255".
So I tried:
Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection("user","pwd","tnsservice-name");
}
where tnsservice-name is the name I specified in the tnsnams.ora, and which I used with the other tools working fine -> same error.My username is only 4 long, so I thought it might have something to do with the string. So I tried:
Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
string user="user";
string passwd="pwd";
string db="tnsservice-name";
try{
con=env->createConnection(user,passwd,db);
AfxMessageBox("sucess");
}
now it returned the error "TNS:connect descriptor too long". Can't have anything to do with the .ora file, since it worked fine for the other tools. Plus it didn't matter if I renamed the .ora file or removed it from the TNS_ADMIN directory..So I searched a little more for a solution and so an example, where the the last argument is missing. So I tried
string user="user";
string pwd="pwd";
Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection(user,pwd);
}
It returns: "TNS: protocol Adapter error" which I somehow can understand, since the adapter doesn't know to wich db to connect.I also tried to use some frameworks like soci or otl but was never able to compile them... (link errors, unknown data types etc...).
I have installed the Oracle Instant Client* on UNIX(Mac OS X Lion 10.7.5), and I want to use it on localhost because i just want to study and test it.but here, the some error appeared to me. so I was so screwed up.
here is the error messages and the settings
Command:
~ user$ sqlplus scott tiger
ERROR:
ORA-12545: Connect failed because target host or object does not exist
env settings:
$ORACLE_HOME=/usr/local/oracle
$ORACLE_SID="Oracle 10g+ASM" // I don't know what ORACLE_SID means
$ORACLE_LIBRARY=/usr/local/oracle/instantclient_10_2
$DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/instantclient_10_2
$SQLPATH=$ORACLE_HOME/instantclient_10_2
$PATH=$PATH:$SQLPATH
I have recently installed the latest Oracle 32bit client 10.2.0.3.0 on a Windows 2008 server. Installation was successful and I was able to create the required service names and test them to the Oracle database server. Now when I try to create an ODBC connection with Oracle in OraClient10g_home1, I get the following error: SQORAS32
An unsupported operation was attempted
If I install Oracle client 10.2.0.1.0, I don't get this error. It happens with the latest client. Is there any was to solve this error?
I'm trying to setup ODBC connection for my Oracle client while installing BO. Following are the steps I followed.
1. Downloaded the Oracle Client from the link [URL] . From that downloaded two zip files. “Instant Client Package – Basic Lite" and “Instant Client Package – ODBC”. Extracted the Zip Files to the folder I created under C: as C:Oracleinstantclient_11_2.
2. Since I'm setting up in ODBC in windows 2008 64-bit R2. I was advised to install 32 bit . So in cmd prompt, from the location C:Oracleinstantclient_11_2, ran odbc_install.
3.Created the Environment variables as
i) *TNS_ADMIN - C:Oracleinstantclient_11_2*
ii) *Oracle_Home - C:Oracleinstantclient_11_2*
iii) *Edited the PATH variable with ;C:Oracleinstantclient_11_2*
4. Created the tnsnames.ora file in C:Oracleinstantclient_11_2. Its content are as follows.
clarity_dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = claritydev.vip.its.ebay.com )(PORT = 1521))
)
(CONNECT_DATA =
(SID = clarity)
)
)
5. From the folder %windir%sysWOW64odbacd32.exe, Opens ODBC Data Source Adminsitartor. In that I found my Oracle in instantclient_11_2 and added following details.
Data Source Name : claritydev.vip.its.com
TNS Service Name : clarity_dev
User Id: clarity1
When I test connect it, I get error *ORA-12154:*
* TNS:could not resolve the connect identifier specified*
I've seen FAQs for this error, but couldn't find anything which solves. Is there any steps I'm missing? I've checked in DB properties. It uses SID not the Service Name.
I want to update the ODBC drivers in ORACLE 8i version. it's possible or not.
View 2 Replies View RelatedI am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine
Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager
For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string
Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager
but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database
When I use 'ONSCTL PING' to test the ons status, it says: configure localport and remoteport directives and attempt to start ONS server again.ons is not running.The content of D:app11.2.0gridopmnconfons.config is:
localport=6100 # line added by Agent
allowgroup=true
usesharedinstall=true
remoteport=6200 # line added by Agent
nodes=rac1:6200,rac2:6200 # line added by Agent
The content of D:app11.2.0gridopmnconfons.config.rac2 is:
localport=6100 # line added by Agent
allowgroup=true
usesharedinstall=true
remoteport=6200 # line added by Agent
nodes=rac1:6200,rac2:6200 # line added by Agent
The configuration file is almost the same in rac1.But the output of 'srvctl status nodeapps' is :
ons is enabled
ons is running on node1:rac1
ons is running on node2:rac2
I newly installed the Forms 10.1.2.0.2 and my database version is 10.1.0.2.0.
I hope it successful installed. I done the following workings
1. Edit preferences done perfectly.
2. OC4J also started.
When i run my 1st sample form. On my 1st run it should ask for Jinititor installation. But my run is not asking the Jinitiator installation and form is not running.
Even tried with run a form on web option it is also not running
I have a Windows Server 2008 R2 64x with Oracle DB 11.2.0.1.0 64x and client 64x correctly installed and working. I need install the client 32x because some applications require.
View 2 Replies View RelatedI have a Windows Server 2008 R2 64x with Oracle DB 11.2.0.1.0 64x and client 64x correctly installed and workingI need install the client 32x because some applications require.
View 8 Replies View RelatedWhat are the free linux OS's that are suited for running Oracle 11g smoothly?
View 17 Replies View RelatedI am trying to install grid infrastructure on oracle linux 6.3 at Virtual box.I am getting error Running a 64-bit JVM is not supported on this platform while verifying cluster trough cluvfy
runcluvfy.sh stage -pre crsinst -n host1 -verbose
Running a 64-bit JVM is not supported on this platform.
I have checked java version is 64 bit installed on machine
[root@rac1 grid]# java -version
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.1) (rhel-1.45.1.11.1.el6-x86_64)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)
getting this error when running from AIX client
database server is on 10.2.0.5.0
ORA-01019 is the error
I need to say I am an absolute NOOB when it comes to SQL.I need a script to run in TOAD that will reference a CSV file saved onto my local hard drive. I'll try and describe exactly what I need to do.
The current script which I use via TOAD on our companies READ ONLY database is this:
SELECT d.number_id,
d.status_id,
FROM table.number_t d
WHERE d.number_id IN ('1230001', '1230002', '1230003')
This will return a result for each number that exists within the table.number table along with the status of each number i.e. active or inactive. A very basic query.
What I need to be able to do is run that query but instead of having to copy each number into TOAD manually, I need TOAD to check a .csv file of said numbers and then return the results.So I imagine the query would look something like:
SELECT d.number_id,
d.status_id,
FROM table.number_t d
WHERE d.number_id IN (check
I need to run Toad codexpert using command line I am trying the following command
"C:Program Files... oad.exe" CX="C:... CmdLineTest.ini"
When I execte the command from command line .Codeexprt run and stop after some time and it make entry in the error log as "ora-00942 table or view does not exist".
I run procedure on toad 10.5, it gave me this error
Buffer overflow, limit of 20000 bytes
then it can not continue running the procedure.
Had some annoying problems with installing TOAD on Windows 7, 64 bit.Got I working now, but anyway I thought I share it here.
1. Toad 10.1(latest) doesn't work with the Oracle 64 bit client. The problem is that this is a limitation of the tool Quest uses to build Toad. So that will not work in a "near" future.
2. Never choose the default suggested installation path which is "C:Program Files(86)",that will mess it up totally. Point to a new or existing directory without brackets.
I rarely do client installs. I have not downloaded upgrades on a couple of years. I have been doing other stuff and oracle supports patching page has changed.
Need to install 11.2 on HP Itanium 64 bit. I can get 11.2.0.1 from otn.oracle.com.
1. I downloaded the 11.2.0.1 client from otn. I want to see if there is an 11.2.0.2 or 11.2.0.3 patch on Oracle support. I can only find upgrades that are specifically for the databsae server. Do I use this? See below for the notes I used so far. Note: Oracle Database Upgrade Path Reference List [ID 730365.1]
Which leads me to the following patch below. However, this download is much larger than the client download on otn. It also says 'database server' and does not break out to 'database client'.So not sure if this is what I use to patch the client or not. This upgrade is also much larger than the straight client download. So not sure if this is what I use to just upgrade the client.
Patch:10404530 Description 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
Product Oracle Database Family
This upgrade seems to be for the whole database and not just for the client install.
2. Do you apply PSU's to the client? I see them listed for the 'database'. Not sure if you apply to a separate client install.
3. We use the proC pre-compiler. When I look in the instant client download section, I see a seperate section for the proC pre-compiler download. I don't see that for the full blown client. Does the regular client download include the proC pre-compiler?
can we install oracle 10g,developer 2000 at window7 64 bit
View 9 Replies View RelatedI want to install Toad on Ubuntu 8.04 . provide me link where step by step instruction guide is available
View 3 Replies View RelatedHow To Run Forms 6i from Server without Runtime Installation on Client Pc.
View 5 Replies View RelatedI have Windows 2008 R2 64 Bit Operating Server Installed.
Other software that are Installed :
1) Visual Studio 2010 Ultimate 32 Bit.
2) Microsoft SharePoint server 2010 64 Bit.
For my development purpose I want to install both oracle 11g client 32 bit and oracle 11g client 64 on the same machine.
Is it possible to install both 32 and 64 bit instance on the same machine.
where to download - Oracle database client(32-bit) 11.2.0.3 for windows 7 ?
View 5 Replies View Related