ArcSDE Upgrade direct connect error

RolandKnietzsch — Wed, 11 Jul 2012 14:29:06 GMT

I want a database to Oracle 11.2.0.3 and ArcSDE10 SP4 migrate.

ESRI Upgrade Workflow: http://help.arcgis.com/EN/arcgisdesktop/10.0/help/index.html#/Upgrading_an_ArcSDE_geodatabase_in_Oracle/002n000000p8000000/

My client PC: Windows XP SP3
                    ArcCatalog 10 SP3
                    Oracle 11g client 32bit

My remote server: Windows Server 2008 64bit
                             Oracle 11.2.0.3 64bit
                             ArcSDE Schema 9.2

I would like to create a direct connect to perform the upgrade.
sde.oracle11g: db_servicename

The following error is displayed.                 Failed to connect to database. Underlying DBMS error[Unknown errorNo extended error.]

Oracle client works correctly.

C:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Mi Jul 11 17:22:07 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn sde/***@dhm****
Connect durchgef³hrt.
SQL>

Direct connect to other database oracle 11.2.0.1 32bit works fine.

Who can help me?

Re: ArcSDE Upgrade direct connect error

brianscholl — Thu, 12 Jul 2012 13:02:17 GMT

I use:

Server: username@DSN (our department convention, DSN is what our TSN_NAMES files has in it you dont need anything here)
Service: sde: oracle10g ( you had sde.oracle10g, dont know if that was a typo use : instead of .)
Database:

Database Authentication
username: bsdba
password: bspwd@DSN

topic Re: ArcSDE Upgrade direct connect error in Data Management Questions

ArcSDE Upgrade direct connect error

Re: ArcSDE Upgrade direct connect error