SDE Post Installation Fails

[Anonymous User]

Original User: tariqchpk75

I have installed Oracle 11 g R2 64 bit on Windows 2008 Server 64 bit on one machine

Then I installed Oracle 11g R2 64 bit client and ArcSDE 10 for Oracle 11g R2 on another Windows 2008 Server 64 bit on another machine

Now Oracle Client is successfully connecting to Oracle DB.

But when I try to perform ArcSDE Post Installation to create ArcSDE Schema/tablespace, User and Service and authorize it i am facing ArcSDE Post Installation error -1:0, plz see the diagram as well.

I am using the same Oracle DB instance/netservice for SDE as that of oracle client.

If this error is because of Oracle Client that is it should 32 bit instead of 64 bit for ArcSDE or something else is wrong?

[VinceAngelo]

If you provide the text of your error messages in your posts, there are three main benefits:
1) There will never be an issue with missing attachments
2) More people will view your error message (this is especially true for large images or
for non-image attactments, e.g. *.doc)
3) Others who have the same problem will be able to search on the error text and find your
solution (IMHO, this is the most important reason -- you can help others while getting help)

Creating a service is not the end of the configuration process for a remote Oracle host.
You also need to change the "ORACLE_SID" variable in SDEHOME/etc/dbinit.sde to use the
special Oracle TNS variable "LOCAL" ("TWO_TASK" on Linux). 

It's hard to tell what else may be wrong without the contents of the etc logs and configuration
files.  If you had contacted Tech Support they would have asked for these before you spoke
with the analyst.

- V

[Anonymous User]

Original User: tariqchpk75

Sorry sir last time due to some error doc file could not be uploaded so this time everything is in text format so that u can understand my problem and guide me where I went wrong. With your help and guidance, I have been able to make and start sdeservice, however still unable to create connection through ArcCatalog which is installed on the same machine as that of ArcSDE with following error:

Failed to connect to the specified server.
SDE not running on server

While creating service I had a problem which is
---------------------------------------------
while creating service I was unable to make it so I used -n switch with

sdeservice -o create command as otherwise I had an error

Error creating SDE Service(esri_sde).
Database service OracleServiceGIS1 doesnot exist.
Use option -n to exclude OracleServiceGIS1 from ArcSde dependent Service.

---------------------------------------------------------------------------

In the process I have made various system settings and output of some of executed commands are given below:



Environment Variable (System Variable) is
-----------------------------------------
SDEHOME=C:\Program Files\ArcGIS\ArcSDE\ora11gexe\

Entries of dbinit.sde is as under
---------------------------------
# Oracle SID for service esri_sde.
set ORACLE_SID=GIS1


Windows Services File located at c:\windows\system32\drivers\etc is as under
----------------------------------------------------------------------------
# Copyright (c) 1993-2004 Microsoft Corp.
#
# This file contains port numbers for well-known services defined by IANA
#
# Format:
#
# <service name> <port number>/<protocol> [aliases...] [#<comment>]
#

.
.
.

esri_sde 5151/tcp #ArcSDE for Oracle


On executing sde command (sdeservice -o list) output is
-------------------------------------------------------

SDE service Information
--------------------------------------------------------------------
RDBMS: Oracle
Name: ArcSde Service(esri_sde)
SDEHOME: C:\Program Files\ArcGIS\ArcSDE\ora11gexe\
Net_Service_Name: gis1
Version: 10.0
Status: SERVICE_RUNNING


On executing sde command (sdemon -o status) out put is
------------------------------------------------------
Server Connection Mode: Accepting Connections
Active Server Processes: 0

On executing command (Sdemon -o info -I instances) output is
------------------------------------------------------------

ArcSDE Instance esri_sde's instances on SdeSvc at Fri Jun 17 21:04:48 2011
-------------------------------------------------------------------------
Instance Created Id
-------------------- -------------------------------- ------------------------
SDE Fri Jun 10 17:56:02 2011 0


When I try to make Spatial Database Connection with following entries using ArcCatalog
--------------------------------------------------------------------------------------
Server: 10.33.100.225 (it is remote PC and oracle server)
Service: 5151/tcp (as listed in windows service file)
Database: (Left Blank)

User Name: sde/system (tested both users and are valid DB users)
Password: 1234 (DB User password for both the users)


Message on Testing Connection
------------------------------
Failed to connect to the specified server.
SDE not running on server

[VinceAngelo]

I'm confused. You write that that your dbinit.sde has ORACLE_SID and that the service starts
and then stops (which is the expected result -- Use LOCAL as the variable), and that sdemon
and sdeservice report the service up and running -- which is it?

Application server connects are made to the ArcSDE host, not the Oracle host. Even if you're
running locally, an enabled firewall may block connection when you refer by the local IP.

You really should use robust passwords for administrative database users (and try to avoid
publishing them on the Internet). I try to avoid connecting as the SDE user, and never use
SYSTEM to connect via ArcSDE. Best practice is to create at least one tablespace to store
data and create one or more database users to own spatial data (with default tablespace
to (one of) the new tablespace(s)).  I usually create a "read-mostly" user, which is granted
only SELECT access (via a "browse" role) to the spatial tables, and use that to connect
for mapping applications.

- V

[Anonymous User]

Original User: tariqchpk75

Service automatically starts successfully. There is no problem in that however I am unable
to create connection using ArcCatalog which is installed on the same ArcSDE Server machine,

I am creating connection with following details:

Server: 10.33.100.225 (it is remote PC and oracle server)
Service: 5151/tcp
Database: (Left Blank)

User Name: sde (tested both SDE and SYSTEM users and these are valid DB users I am able to connect
to DB using different oracle clients like SQLPLUS/Keep tools Hora etc from the same ArcSDE Server machine or for that matter any other machine on the network and the the entire SDE schema is visible)
Password: 1234 (DB User password for both the users)

If there is something wrong with the above detail specified, the error message is as under:?


Message on Testing Connection
------------------------------
Failed to connect to the specified server.
SDE not running on server


dbinit.sde contains only one entry i.e.
---------------------------------------
set ORACLE_SID=GIS1

do I need to make another entry i.e

set LOCAL=GIS1

* GIS1 is the DB net service name

Only one entry is required or both?

Firewalls on all the machines are disabled.

[VinceAngelo]

Without the LOCAL variable, service start should fail. If your service started correctly,
there shouldn't be difficulty connecting through it.  You really need to take this to Tech
Support for resolution.

- V

[Anonymous User]

Original User: tariqchpk75

Thanks for your guidance,

I manually amended dbinit.sde and added Local entry and now its working.

Entry that I made is

set LOCAL= Oracle Net_Service_Name;

Thanks once again.

Now for better performance of SDE should I follow various settings ( or some of them) given at

http://proceedings.esri.com/library/userconf/proc01/professional/papers/pap869/p869.htm

or otherwise?

Regards

[VinceAngelo]

I don't recommend you follow a ten year old tuning guide. There are plenty of
modern tuning steps listed in the documentation.

- V

[Anonymous User]

Original User: tommb

I experienced the exact same "error -1:O" when performing the ArcSDE Post Installation on a 64 bit Windows R2 2008 Server. When the post installation creates the sde user, it seems to expect that the temporary tablespace in Oracle is named "TEMP". In our case it was named "TEMPTBS1" (default by Oracle11g setup). Changed the Oracle default temporary tablespace to "TEMP" and the post installation worked fine.

Tommb

[VinceAngelo]

I *always* create my own SDE tablespace and SDE user before beginning post-installation.
I also prefer to execute 'sdesetup' (and 'sdeservice') at the command line, but even the
post-install allows you to skip tablespace and user creation.

- V