POST
|
Yes a 32 bit client without a co-existing 64 bit client has worked everytime for years. The 64 bit office apps are more critical to my workflow so I have done without the ArcMap connection. Scott Andres Delaware Geological Survey University of Delaware Newark, DE 19716 302-831-0599 www.dgs.udel.edu
... View more
02-26-2016
08:46 AM
|
0
|
0
|
1009
|
POST
|
Thanks, I have also tried the 32-bit Oracle instant client with the ODBC, OLEDB, and ODAC components.Installation and configuration logs generated by the installer show everything was successful..net-based apps with an explicit connection defined in ODAC calls did function as did tests with *.udl and *.odc methods.But OBDCad32 did not show that the ODBC driver was present so not a solution for Arc.Posts in OTN forum and Oracle docs indicate that this is the way the instant client is supposed to work.The uninstaller was used to remove this client. Checks of the registry don't find any litter that would interfere later. Scott Andres Delaware Geological Survey University of Delaware Newark, DE 19716 302-831-0599 www.dgs.udel.edu
... View more
02-26-2016
06:44 AM
|
0
|
2
|
1009
|
POST
|
thanks the 32 bit client is referenced first in the path and tns_admin variables. that fix was in the first group of tricks that was tried. i have a run time client. Do you have experience or seen interweb resources that reference success with the admin client? Scott Andres Delaware Geological Survey University of Delaware Newark, DE 19716 302-831-0599 www.dgs.udel.edu
... View more
02-26-2016
06:24 AM
|
0
|
4
|
1009
|
POST
|
That was quick, thank you I don't have ArcGIS Pro. This is for 32 bit ArcGIS connection to Oracle. Scott Andres Delaware Geological Survey University of Delaware Newark, DE 19716 302-831-0599 www.dgs.udel.edu
... View more
02-26-2016
06:11 AM
|
0
|
6
|
1009
|
POST
|
Have you has solved this problem? I would appreciate hearing from you. Specifics follow….. I have a Win7 x64 machine with functional 64 and 32 bit Oracle 12.1.0.2 run-time clients complete with functioning ODBC and OLEDB drivers. Did everything recommended by Microsoft, Oracle, and “BIG TIP for ArcGIS/ODBC/OLEDB users on 64 bit Windows” post on GeoNet. ArcCatalog will not create a connection to Oracle. The 32 and 64 bit clients support SQL*Plus, SQL*Developer, and ODBC. The 64 bit ODBC runs connections for 64 bit MS Office. Path and TNS_Admin environment variables are pointing to the appropriate home, bin and network/admin folders. The 32-bit oracle client and ODBC connection have been named to clearly indicate that they are 32 bit. This eliminates any confusion about what client is being invoked when configuring services. The ODBCad32.exe in the syswow64 folder (see “BIG TIP…” post) creates a working connection to my oracle server. My oracle db is using TCP and TNSnames and default port 1521: # tnsnames.ora Network Configuration File: \app\client\asa32\product\12.1.0\client_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. db32 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1.domain1.edu)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db1.domain1.edu) ) ) The add database connection only allows a choice of “Oracle” for the database platform box. It does not display specific information about the ODBC connection or Oracle driver in the instance box. Database authentication is used for all. The ArcCatalog add database connection dialog will not connect to the Oracle server with any variation tried so far: When instance is defined as db1: Failed to connect to the specified server. Do you want to continue? Underlying DBMS error (unknown errorNo extended error.] When instance is defined as db1.domain1.edu: ORA-12154 (TNS:could not resolve the connect identifier…] When instance is defined as the alias “db32”: ORA-12154 (TNS:could not resolve the connect identifier…] Following the naming advice in the on line help instance set to “server1/db32”: Failed to connect to the specified server. Do you want to continue? Failure to access the DBMS server I would appreciate hearing how you would fill in the entries of the Database Connection dialog given the tnsnames.ora shown above or if you think this post should be tagged differently. thanks!
... View more
02-26-2016
05:58 AM
|
0
|
9
|
5245
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|