topic Re: Cannot able to upgrade arcgis server 10.0 to 10.3? in Geodatabase Questions

Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Wed, 10 Feb 2016 13:21:00 GMT

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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

AsrujitSengupta — Wed, 10 Feb 2016 14:44:18 GMT

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?

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

VinceAngelo — Wed, 10 Feb 2016 15:15:36 GMT

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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Thu, 11 Feb 2016 08:41:25 GMT

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

(//xxxx: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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Thu, 11 Feb 2016 08:42:58 GMT

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

(//xxxx: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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

AsrujitSengupta — Thu, 11 Feb 2016 11:55:36 GMT

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?

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

VinceAngelo — Thu, 11 Feb 2016 14:01:04 GMT

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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Fri, 12 Feb 2016 06:44:02 GMT

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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Fri, 12 Feb 2016 07:01:29 GMT

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

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

VinceAngelo — Fri, 12 Feb 2016 14:17:26 GMT

Still need an answer to Q5, to see if A6 is significant, but ArcGIS 10.3 is only supported on Oracle 11.2.0.3.x and higher (10.4 will up that to 11.2.0.4.x).

- V

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Mon, 15 Feb 2016 04:31:56 GMT

Hi Vince Angelo,

Answer to question 5 is NO. Can't we upgrade the 10.0 sde database to 10.3 if oracle version is 11.2.0.1.0?

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

VinceAngelo — Thu, 08 Apr 2021 21:32:41 GMT

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.

Re: Cannot able to upgrade arcgis server 10.0 to 10.3?

SadanandacharB1 — Tue, 16 Feb 2016 04:52:46 GMT

Thank you Vince Angelo, I will upgrade the database first and try to upgrade the geodatabase components.

Thank you so much once again for your valuable support