Conection Error installing ArcSDE 10 for Oracle on Windows 2008 R2

Question

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.oraXE =
  (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.

VinceAngelo · Answer

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

AlvarNõmmik · Answer

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?

CraigMark · Answer

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