nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ORA-01455 after upgrading to 10.3

Ulises

I just upgraded my desktop to ArcGIS 10.3 and none of my Oracle database connections work. I can't even figure out how to create new connections. SQL Server connections work fine. The error message is "Failed to connect to the specified server. Do you want to continue? UnderlyingDBMS error[ORA-01455: converting column overflows integer datatype. No extended error.]"

Oracle Database is 11.2.0.3 and existent connections were configured using "sde:oracle11g:<<instance>>" in the instance text box.

Any help is appreciated...

Encontre mais publicações marcadas com

Accepted answers

Ulises

Apparently the problem was related to the Oracle client version. Altought I have both 64 and 32 Oracle 11g clients in my box (having the 32-bit client first in my path), I experimented the same problem until I download the Instant Client from ESRI and set it in my system's path as the first option. Hope this help others with the same problem...

All comments

PaulDavidson1

Update: adding a Network\Admin path to the ORACLE_HOME path (C:\app\pdavidson\product\11.2.0\client_1 in my installation) of the instant client install and then putting a TNSNAMES.ORA file into that folder allowed me to get rid of the full admin clients from the path.

More testing underway, such as uninstalling the full admin clients, etc....

I strongly suspect how one setups one's environment depends entirely on how you are connecting to Oracle. I am not an oracle dba. Our setups seem to have always used TNSnames.ora files.

I have not tried ArcPRO to connect to Oracle yet either.

PaulDavidson1

George: one question

Is it a correct assumption that ArcPRO will need the 64bit client?

I too had the problems listed above but my issue seems a bit different.

I had installed the instant client (unaware of this thread) and could connect to oracle and see what were our SDE databases but when i tried to do any preview in ArcCatalog I would pull errors. Don't recall exact errors, sorry.

Since we have had problems in the past with the instant client, I did the full install of 32 bit then 64 bit.

We also had an Oracle employee on site a couple of weeks back and he said he always does the full install, just without the database installation. Apparently instant client is not always so instant or reliable?

But after installing the two full clients I then had the ORA-01455 error. But 64 bit was first in path at that time.

I moved my paths around to have 32 bit instant client, 32 bit admin client, 64 bit admin client at front of path and now ArcCatalog seems to be working fine. I did have to create the TNSNames.ora files for both 32 and 64 bit full installs.

This is all on a VMWare box I'm building for testing.

Doing some testing with the PATH:

Removing the 32 bit instant client from the path == ORA-01455 error occurs.

Adding 32 bit instant client back to path and removing the two full admin clients from the path == Oracle connections happen ok and this time, Previews are working. Note, there is no TNSNAMES file in my instant client (no idea where to put that file in that install)

However, when I went to preview a large road network, ArcCatalog crashed with a fault in ntdll.dll, exception code C0000005

I added the full clients back into the path, connected ok and when I previewed the large road network, it showed the geometry and table just fine. Just to verify, I again pulled the full clients out of the PATH and verified it crashes ArcCatalog. This time the crash was different, the esri equivalent of a BSOD, then serious app error where I email info to Esri.

Putting the full admins back into the path, AFTER, the instant client and these test at least works again.

NOTE: this is not very heavy usage of ArcCatalog and doesn't at all make me warm and fuzzy about deploying this in production anywhere in our organization. I will wait for 10.3.1 before offering it to our users.

Which leads me to conclude, I need both instant client and full admin client installed for ArcCatalog to work properly. I should try a full install and install the full 11.2.0.1.0 client to see if that makes any difference.

I do note that my admin clients are 11.1.0 but instant client is 11.2.0 which matches our Oracle servers (11.2.0.1.0 actually)

RonaldLopez

Thanks to George, I have a fix to this problem. Apparently there is a recently found issue with Oracle 10g client and ArcGIS Desktop 10.3 clients which causes the ORA-01455 error, the workaround is to use Oracle 11g client only.

You don't necessarily need to install your 10g drivers, but merely update your system variable PATH to just use the 11g location, or at least have it listed first:

PATH = <driveLetter>:\oracle\ora1120\bin;...

George_Thompson

Ronald,

Can you connect to the Oracle database in SQLPlus (32 bit version)?

Try uninstalling both the 32 and 64 bit clients, then re-install the 32 bit administrator full client. I have seen where the re-install and configuring of the TNSNAMES corrects the issue.

I would recommend starting with the 32 bit client, then after that is successful add the 64 bit client, if needed.

-George

RonaldLopez

Ah, I failed to mention that my SDE is still at 10.1.

RonaldLopez

I'm running into the same issue, I have both 11g Oracle Client drivers 32 and 64 bit installed and am still getting the same ORA error. In my PATH sys variable I have 32 listed first, then 64. I also transposed these and rebooted and still have the same error. An interesting point is that I also have Desktop 10.3 installed on the server hosting ArcGIS Server and there is no error there connecting to same SDE. Thoughts besides using Oracle Instant Client?

MiguelGonzález

Hi George,

thank you! I thought as much. Just hoped that there was an 'ESRI-version' which would work without fail...

I will check the Oracle site tomorrow and report my progress...

So long,

Simon

George_Thompson

Hi Simon,

You will need to download the Oracle client from Oracle's website.

Here are a few links that I found when I searched in Google:

Be sure to install the correct bit level for your ArcGIS client.

Oracle Instant Clients

Oracle Full Clients

-George

MiguelGonzález

Hello Ulises,

happy you got the answer to your problem which - actually - is my problem still.

I get the same error message and assume that it is also an Oracle client version issue. My database is an oracle 11g (11.2.0.3.0) and my client has 'only' 11.1.0.6.0.

Unfortunately, I do not find any download at the ESRI web pages for the Oracle instant client. Could you post the url, where you found the installer?

Thanks!

Cheers,

Simon

Ulises

same error...

AsrujitSengupta

What if you try Easy Connect syntax? Same error?

Ulises

Also, the error so far appears when trying to establish a geodatabase connection. I was able to succesfully create a connection to another Oracle database that do not store spatial data (this database is 10.2).

Ulises

10.2 geodatabase

cant find anything in log

AsrujitSengupta

What is the version of your sde geodatabase.

Any other information in the SDE Direct Connect log?

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.