topic Re: Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2 in Data Management Questions

Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

FernandoHernangomez — Fri, 10 Dec 2021 21:22:14 GMT

I had installed Oracle 10g XE and ArcGIS Server 10 + SP1 on Windows 2008 Web Server R2 with no problems.
The problem is when i try the post-install on arcsde 10 for oracle (i tryed with x32, x64, and with its SP1). It asked me for 'sys password' and 'net services name' but i allways got 'Error conection to oracle'.
I have no problem coneccting to oracle with sqlplus and apex.
This is my tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ALBORGIS-VS3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  )

In 'net services name' i used XE, ALBORGIS-VS3, its IP, localhost .... with the same result =>'Error conection to oracle'
Someone can help me ?
Thanks.

Re: Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

AlvarNõmmik — Wed, 23 Feb 2011 10:10:08 GMT

I have same problem.
Installed:
Oracle 10g XE (10.2.0.1.0)
ArcGIS Server 10 + SP1 on Windows 2008 Web Server R2
Oracle client 10.2.0.1.0

I messed around with it and got connection to oracle with user 'sys', witch created user 'sde'
I can connect using that user with sqlplus, but ArcSDE for Oracle10g is failing:
"The ArcSDE Repository was unsuccessfully completed."

Connection to sde failed(0)

Extended error: ORA-12154: TNS:could not resolve the connect identifier specified

Error creating ArcSDE direct connection (-51)

What might be the problem and how can i fix it?
I think that ArcSDE messes up connection to oracle somehow and is using wrong parameters..

sdedc_Oracle.log:
DB_open_instance()::db_connect (OCI8) error: 12154
CAN'T OPEN INSTANCE: sql:oracle10g.
Spatial Engine Connection Failed (-51).
Cannot Get Access to Instance sql:oracle10g

Re: Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

VinceAngelo — Wed, 23 Feb 2011 10:29:59 GMT

Oracle 10.2.0.1 is not supported by any ArcSDE release. The minimum Oracle 10g release for
ArcSDE 10 is Oracle 10.2.0.3.

Oracle XE is not officially supported, but others appear to have used it as recently as ArcSDE 9.2.

- V

Re: Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

CraigMark — Mon, 28 Feb 2011 13:03:22 GMT

Windows Server 2008 R2
Oracle 11gR2
SDE 10 SP1

I created the SDE User and Tablespace in Oracle

Then went to do the post install...

I'm getting the same error...

When running the post install I get to " Connect to create SDE repository

wise_err.log > connection to sde failed(0)

- I tried running the post install as admin
- I tried taking ownership of SDEHOME

FIXED!!!! - For some reason it didn't like my sde password. I changed the sde user password and it works!

alter user sde identified by (newpassword);

- Craig

Re: Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

AlvarNõmmik — Wed, 09 Mar 2011 08:27:18 GMT

Oracle 10.2.0.1 is not supported by any ArcSDE release. The minimum Oracle 10g release for
ArcSDE 10 is Oracle 10.2.0.3.

Oracle XE is not officially supported, but others appear to have used it as recently as ArcSDE 9.2.

- V

According to this official link, it seems that Oracle 10g XE is somehow supported by ArcSDE 10:

http://resources.arcgis.com/content/arcsde/10.0/oracle-system-requirements

"Express Edition:
Oracle 10g (32 bit) 10.2.0.1 - Windows Only (For development and testing only, not for production deployment)."

At least, supported for development. Therefore, it is possible to install ArcSDE 10 on Oracle 10g XE, isn't it?

Manuel Gonzalez

Is XE Oracle 10g (32 bit) 10.2.0.1 + SDE10 supported or not? Is it possible to make it work?
Any more comments?

Re: Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

VinceAngelo — Thu, 10 Mar 2011 02:11:50 GMT

If the Esri website says it's supported, then it's supported (and known to work).

Other thoughts:

Even though Oracle has discontinued 10g support, their website doesn't indicate that XE support
has stopped (though it's understandably not the same that a paying client would get for 11g).

There are other free databases available that operate with ArcSDE.

I'm not a fan of using operating systems which are significantly newer than the application software.
The software stack is generally more stable when the ArcSDE is newer than the database is newer
than the OS.

- V