POST
|
Tom, thanks for the more in-depth explanation of what occurs during a connection and what changed in 10.1. I was generally aware of the differences between Oracle client libraries and Esri direct connect libraries, but I wasn't sure of how they interacted, especially in 10.1. My questioning and frustration were in earnest; I was trying to understand what changed in 10.1 and why I was seeing certain behaviors. Your statement, "we only have 1 Esri library used to make the connection (which is based on Oracle 11g libraries)," is the most informative for me, and it will be good to communicate the Oracle 11g part of that statement to our organizations IT architects.
... View more
08-19-2011
01:27 PM
|
0
|
0
|
204
|
POST
|
Seeing that the Oracle client choice is supposed to be automatic at 10.1, and the error message I received is the red herring discussed in another thread, I guess it is likely ArcCatalog tried both Oracle clients (10g and 11g), failed with both clients (SDE 9.2 isn't supported anymore), and then only presented one error message to the end user. If there is one suggestion to come out of this experience for me, it would be that more descriptive error messages would help clear the fog for end-users and speed troubleshooting for Esri Support.
... View more
08-18-2011
06:55 AM
|
0
|
0
|
925
|
POST
|
The behavior must have changed for 10.1. I have a machine with Oracle 10g and Oracle 11g clients installed, and both clients are fully functional. When I try to make a connection to SDE 9.2, I get the following error:[INDENT]Database Connection Failed to connect to the specified server. Do you wish to continue? ArcGIS 9.2 geodatabases do not support direct connect using Oracle 11g clients. Please use the Oracle 10g client or the application server. [/INDENT]Ignoring the fact that 10.1 connections to 9.2 are not supported anymore, how does one use the Oracle 10g client if there is no place to specify an Oracle client version when making a connection?
... View more
08-17-2011
07:37 AM
|
0
|
0
|
925
|
POST
|
The previous table of results for 9.3.1 is identical for our machines with ArcGIS 10.0 installed on them.
... View more
08-16-2011
11:24 AM
|
0
|
0
|
925
|
POST
|
ArcGIS simply makes the call to the Oracle client which would be the first one in the library path as the DLL is loaded. I haven't had a chance to test with ArcGIS 10.0 or 10.1, but I just don't believe the situation is so with ArcGIS 9.3/9.3.1. On our organization's machines that are configured with Oracle 10g and 11g clients and ArcGIS 9.3.1, it seems ArcGIS is looking for specific Oracle clients and not just the first Oracle client in the path. The behavior on our machines is: [INDENT]System PATH SDE direct connect string Result
10g path;11g path sde:oracle10g Connection Succeeded
10g path;11g path sde:oracle11g Connection Succeeded
11g path;10g path sde:oracle10g Connection Succeeded
11g path;10g path sde:oracle11g Connection Succeeded
10g path sde:oracle10g Connection Succeeded
10g path sde:oracle11g Failed: Server library could not be loaded
11g path sde:oracle10g Failed: Server library could not be loaded
11g path sde:oracle11g Connection Succeeded[/INDENT] If ArcGIS was simply looking for the first Oracle client in the system path, then errors would be generated if the SDE direct connect string called a different Oracle version than the first one in the system path.
... View more
08-16-2011
10:51 AM
|
0
|
0
|
925
|
POST
|
The example in my earlier post isn't hypothetical, it exists for ArcGIS 9.3.1. I realize ArcGIS 10.1 won't connect to SDE 9.2; my question was really about the larger issue of specifying Oracle clients or libraries. If Esri has added code for the database connection to " automatically figure out which direct connect driver to use", then that is what I needed to know because I could not find documentation that explicitly stated that information. Prior to ArcGIS 10.1, in the not-so-distant past, the user had to specify different clients or libraries on one machine. Automatic is good, as long as it works....
... View more
08-05-2011
09:16 AM
|
0
|
0
|
925
|
POST
|
It is common in our organization for GIS staff, and occasionally other GIS users, to have 2 versions of Oracle client on their machines: Oracle 9i and Oracle 11g. The need for 2 Oracle clients is driven by non-GIS reasons; however, depending on which SDE instance people connect to, the direct connect strings vary. For example, the two most common direct connects are: SDE:ORACLE9i:LEGACYINSTANCE SDE:ORACLE11G:INSTANCE Since the LEGACYINSTANCE has SDE 9.2 SP6, Oracle 11g client cannot be used to connect from ArcGIS Desktop 9.3/9.3.1. It could very well be that both connections are using the Oracle 11g client since it is the first Oracle client in the system's path. I guess that is a question for Esri. If that is the case, i.e., both use the same Oracle client, then my original question should have been: How does one specify different Oracle direct connect libraries in the Database Connection?
... View more
08-05-2011
07:10 AM
|
0
|
0
|
925
|
POST
|
And thank you for providing additional information to clarify the situation.
... View more
08-04-2011
10:44 AM
|
0
|
0
|
633
|
POST
|
It was the fact that 10.0 was connecting that was throwing me off. Accepting that ArcGIS Desktop 10 direct connects using Oracle 11g to SDE 9.2 should not work but do, the behavior of 9.3/9.3.1 and 10.1 make sense. Thanks.
... View more
08-04-2011
09:41 AM
|
0
|
0
|
633
|
POST
|
OK, bear with me on this one.... I understand why 11g server DLLs were created for SDE 9.3 and later and not SDE 9.2 or earlier. That being said, I am trying to understand why I can direct connect using Oracle 11g client in ArcGIS Desktop 10 to SDE 9.2 but why I can't direct connect using Oralce 11g client in ArcGIS Desktop 9.3/9.3.1 to that very same SDE 9.2? Is the fact it works in ArcGIS Desktop 10 a bug, i.e., it works but it shouldn't really work, or was there a change in support between ArcGIS Desktop 9.3/9.3.1 and ArcGIS 10? The situation I am seeing: [INDENT]ArcGIS Desktop 9.3.1 Oracle 11g Direct Connect to SDE 9.2 --> Doesn't work ArcGIS Desktop 10 Oracle 11g Direct Connect to SDE 9.2 --> Works ArcGIS Desktop 10.1 Oracle 11g Direct Connect to SDE 9.2 --> Doesn't work [/INDENT]From everything said in response to my original question, none of the above scenarios should work, right? [INDENT] [/INDENT]
... View more
08-04-2011
06:43 AM
|
0
|
0
|
633
|
POST
|
Thus far, after checking a couple of different Help file locations, I am unable to figure out how to specify the Oracle client version in a Database Connection when a machine has multiple versions of Oracle clients installed. Prior to 10.1, the Oracle client version was easily specified in the connection parameters.
... View more
08-03-2011
02:10 PM
|
0
|
11
|
3568
|
POST
|
I did come across the Help page that shows 10.1 is not compatible for direct connects to SDE 9.2. That being said, if backwards compatibility for 3 versions is an Esri standard design, why doesn't ArcGIS 9.3.1 SP2 support direct connect using Oracle 11g client to SDE 9.2 SP6 but ArcGIS 10.0 SP2 does? ArcGIS 9.3.1 is a whole lot closer to 9.2 than 10.0.
... View more
08-03-2011
01:28 PM
|
0
|
0
|
633
|
POST
|
Similar to my earlier posting, I am cross posting this information to make it easier for others to find. [INDENT]When attempting to make a Database Connection to SDE 9.2 using Oracle 11g client, the following message appears: Database Connection: Failed to connect to the specific server. Do you wish to continue? ArcGIS 9.2 geodatabases do not support direct connect using Oracle 11g clients. Please use the Oracle 10g client or the application server. What is odd about this message is that it appears in ArcGIS 9.3/9.3.1 but went away with ArcGIS 10. Since connecting to SDE 9.2 using Oracle 11g client works in ArcGIS 10.0, it appeared the connection problem in 9.3/9.3.1 was really a client issue and not a server or SDE issue. This is either an ArcGIS 10.0 bug or ArcGIS 10.1 bug. http://betacommunity.esri.com/project/feedback/view.html?cap={74C6DFC2-4C1E-42D2-9420-D7D05E434F9C}&f={54F0A9EF-C6AC-41CA-AD9B-DC82C4A223B9}&uf={762AC5EB-3E91-44A3-987F-5FE58802A8EC}&a=v&t=1 [/INDENT]
... View more
08-02-2011
02:11 PM
|
0
|
10
|
3066
|
POST
|
Has anyone else ran into the situation where installing GDBT for ArcGIS 10 into the non-default directory causes for no errors during installation but the GDBT tab never shows up in ArcCatalog? I am running XP SP3, ArcInfo license level, and I am attempting to install GDBT into "C:\Program Files\ArcGIS\GDBT" instead of the default location "C:\Program Files\GDBT".
... View more
03-25-2011
12:36 PM
|
0
|
3
|
586
|
POST
|
Does the SDE user password meet strong password requirements? When running Mixed Mode authentication, the default is for SQL Server to enforce strong password requirements. I don't recall the exact error codes at the moment, but I definitely ran into strong password problems once at the same installation steps you are at now.
... View more
11-18-2010
05:13 AM
|
0
|
0
|
562
|
Title | Kudos | Posted |
---|---|---|
1 | Wednesday | |
1 | 3 weeks ago | |
2 | 3 weeks ago | |
1 | a month ago | |
2 | 08-12-2024 11:56 AM |
Online Status |
Online
|
Date Last Visited |
4 hours ago
|