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; } } }

Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1

Hi All,

I am trying to upgarde from arcgis server 10.0 to 10.3,

While doing this i am getting error like below, Please help me on this issue.

[Wed Feb 10 18:25:51 2016] DB_open_instance()::db_connect (OCI8) error: 12560

[Wed Feb 10 18:25:51 2016] Error: Underlying DBMS error (-51).

[Wed Feb 10 18:25:51 2016] Error: DB_arcsde_setup: Unable to connect

[Wed Feb 10 18:25:51 2016] ORA-12560: TNS:protocol adapter error

[Wed Feb 10 18:25:51 2016] ERROR installing/upgrading ArcSDE, Error = -51

Here i have both oracle 64-bit client and 32-bit oracle client and i am able connect from ArcCatalog,

But when i tried to upgarde it is giving this error? Please please help me on this issue

Encontre mais publicações marcadas com

Accepted answers

VinceAngelo

No, 11.2.0.1.0 is not a supported Oracle release. The minimum is 11.2.0.3.0, and an up-to-date build, security-wise, would be 11.2.0.3.15. You must upgrade the database before upgrading the enterprise geodatabase components. The Oracle client library should be at the same (or later) release as the server.

All comments

SadanandacharB1

Answers to your questions

1) The exact version (five digits - e.g. 10.2.0.4.7) of Oracle installed on the original enterprise geodatabase = 11.2.0.1.0

2) The exact version (five digits) of the Oracle client installs = 11.2.0.1.0

3) The 10.0 arsde oracle database is in one system and now i have installed arcgis server 10.3 in another system with oracle clients with same version

4) The exact PATH variable contents = set to oracle 32 bit client so that i can connect to arcgis server and register the database there.

6) background geoprocessing opption enabled = yes

SadanandacharB1

DBMS version of 10.0 gdb is 11.2.0.1.0 and the version of the Oracle database now using is same 11.2.0.1.0

VinceAngelo

We need details to understand what may be going on.

Please provide:

The exact version (five digits - e.g. 10.2.0.4.7) of Oracle installed on the original enterprise geodatabase
The exact version (five digits) of the Oracle client installs
Whether the database has been upgraded or transferred to a different server (and if so, the exact version of that database)
The exact PATH variable contents
Whether you have 64-bit background geoprocessing installed
Whether you have the background geoprocessing opption enabled

Please do not ever post passwords on the Internet (and never make the SDE user password 'sde' -- this is a huge vulnerability that threatens your entire geodatabase).

- V

AsrujitSengupta

You did not provide all the details that were requested.

What was the DBMS version for the 10.0 gdb? Has that been upgraded to a higher DBMS version? What is it now?

SadanandacharB1

I am trying to upgrade sde 10.0 oracle geodatabase.

In one system i have installed arcgis server 10.3 and another syatem contains oracle geodatabase 10.0.

here i have installed both oracle 64bit 11g client and 32bit 11g client, And oracle geodatabase 10.0 has same vesrion.

I am connecting to database through ArcCatalog 10.3 like this

(//xyz:1521/orcl, username:sde, password:sde)

it is successfully connecting to database and Pre-Requisite check is succeeded , But upgradation fails.

[Thu Feb 11 13:14:51 2016] DB_open_instance()::db_connect (OCI8) error: 12560

[Thu Feb 11 13:14:51 2016] Error: Underlying DBMS error (-51).

[Thu Feb 11 13:14:51 2016] Error: DB_arcsde_setup: Unable to connect

[Thu Feb 11 13:14:51 2016] ORA-12560: TNS:protocol adapter error

[Thu Feb 11 13:14:51 2016] ERROR installing/upgrading ArcSDE, Error = -51

SadanandacharB1

Yes i am trying to upgrade sde 10.0 oracle geodatabase

In one system i have installed arcgis server 10.3 and another syatem contains oracle geodatabase 10.0.

here i have installed both oracle 64bit 11g client and 32bit 11g client, And oracle geodatabase 10.0 has same vesrion.

I am connecting to database through ArcCatalog 10.3 like this

(//xyz:1521/orcl, username:sde, password:sde)

it is successfully connecting to database and Pre-Requisite check is succeeded , But upgradation fails.

[Thu Feb 11 13:14:51 2016] DB_open_instance()::db_connect (OCI8) error: 12560

[Thu Feb 11 13:14:51 2016] Error: Underlying DBMS error (-51).

[Thu Feb 11 13:14:51 2016] Error: DB_arcsde_setup: Unable to connect

[Thu Feb 11 13:14:51 2016] ORA-12560: TNS:protocol adapter error

[Thu Feb 11 13:14:51 2016] ERROR installing/upgrading ArcSDE, Error = -51

VinceAngelo

Please clarify what you are attempting by describing the steps preceding this error, and what command produced the error.

It appears you have made changes to the database and have not reconfigured it correctly so that even a tnsping would succeeed. If Oracle has no connectivity, there really isn't anything ArcGIS can do.

- V

AsrujitSengupta

Are you upgrading your SDE Oracle geodatabase?

What was the Oracle Database version at 10.0 (Example: Oracle 10.2.0.1) and what is the version of the Oracle database you are using right now while upgrading to 10.3?

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.