ArcSDE Upgrade  direct connect error

994
1
07-11-2012 07:29 AM
RolandKnietzsch
New Contributor
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_Ora...

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?
0 Kudos
1 Reply
brianscholl
New Contributor
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
0 Kudos