topic Re: SDE Post Installation Fails in Data Management Questions

SDE Post Installation Fails

Anonymous User — Wed, 08 Jun 2011 09:31:44 GMT

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?

Re: SDE Post Installation Fails

VinceAngelo — Wed, 08 Jun 2011 11:29:31 GMT

Did you install 32-bit ArcSDE or 64-bit ArcSDE? What do the error logs contain?

- V

Re: SDE Post Installation Fails

Anonymous User — Thu, 09 Jun 2011 03:38:46 GMT

Original User: tariqchpk75

Its ArcSDE 10 64 bit, however there is no error log entry for ArcSDE

Re: SDE Post Installation Fails

VinceAngelo — Thu, 09 Jun 2011 11:35:10 GMT

I believe you need to do manual installation in a remote server configuration. I always
use manual install. The documentation has the details of what is necessary.

- V

Re: SDE Post Installation Fails

Anonymous User — Fri, 10 Jun 2011 03:09:20 GMT

Original User: tariqchpk75

Thanks for you replies.

I can connect to oracle server db from the client as sys user as sysdba or with any valid db user and can execute all the sql commands as well.

I have tried to follow steps as per the document you specified, but it provides wizard based configuration and it stops at sde table space and sde user creation process and unfortunately without generating any error log.

Can you plz give me step by step manual commands to create/configure sde environment and sde authorization?

Regards

Re: SDE Post Installation Fails

VinceAngelo — Fri, 10 Jun 2011 03:37:35 GMT

Look again at the link "Creating an ArcSDE service from a remote Windows server". It starts out:

If your database management system (DBMS) is installed on one server and ArcSDE is installed on a separate Windows server, you cannot run the ArcSDE Post Installation wizard to create the service. Instead, you must use the sdeservice command to create an ArcSDE service if you want to use one.

- V

Re: SDE Post Installation Fails

Anonymous User — Fri, 10 Jun 2011 05:19:40 GMT

Original User: tariqchpk75

Thanks for the very prompt reply.

That is true regarding creation of sde service that will come in the later steps.

Please refer to your earlier recommended document regarding "Installing Oracle and ArcSDE on separate servers" at

http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade_guide/index.html#/Installing_Oracle_and_ArcSDE_on_separate_servers/00940000000w000000/

It works fine till step 4 and the confusion arises at step 5 which is

# Configure the Oracle database, adding an sde user and Setting variables for the sde OS user on Linux or UNIX if necessary.

moreover this step is for LINUX/UNIX OS whereas I have windows 2008 Server.

As I am unable to create sde table space and sde user through post installation wizard, so my question is how to do that? I have tried to use

sdesetup -o install -d Oracle11g

command but remained unsuccessful with output screen as in diagram1.

my Oracle DB net service name is gis1 and password for all the user accounts i.e. sys, system etc is 1234. and from the command prompt I can successfully connect to my remote DB (as in the diagram2) and execute all SQL commands including DRL, DML, DDL and even commands for oracle management that is creation of tablespace/users and granting/revoking roles and permissions etc.

Re: SDE Post Installation Fails

VinceAngelo — Fri, 10 Jun 2011 10:16:30 GMT

The process for creating tablespaces and users in Oracle on a Windows host is identical
to that on a Unix host (the only difference is the presence of a drive letter and direction
of slashes in the file name). I don't ever use the post-installer. I suggest reading the
entire New Installations section of the install guide, and if you're still having difficulty,
contacting Tech Support for assistance.

- V

Re: SDE Post Installation Fails

Anonymous User — Fri, 10 Jun 2011 11:21:39 GMT

Original User: gssathia

You could create SDE user manualy from your ArcSDE server if you have the tablespaces ready in your oracle machine using the simple create user command via system user. Even if you do not have the tablespaces ready, you can create the tablespaces manually, from SDE server too.

Creating SDE User & Tablespaces in the Oracle server via post installation execution in SDE server would not work for obvious reasons.

Once you are done with these steps you can create your SDE service from your remote server.

Re: SDE Post Installation Fails

Anonymous User — Wed, 15 Jun 2011 09:56:01 GMT

Original User: tariqchpk75

As I have remote DB and wanted to create SDE service so I followed various steps given in the help at

http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade_guide/index.html#//009400000040000000.htm

esri_sde service is visible in Windows services and if i try to start it manually it starts and then stops without completion of process.

and if try to start it with sde command "sdemon"
the message is unregistered service despite the fact I have successfully created and registered the service, plz see the attached file.

Can any one help me to get out of this?

Re: SDE Post Installation Fails

VinceAngelo — Wed, 15 Jun 2011 11:10:06 GMT

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

Re: SDE Post Installation Fails

Anonymous User — Fri, 17 Jun 2011 09:45:05 GMT

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

Re: SDE Post Installation Fails

VinceAngelo — Fri, 17 Jun 2011 10:09:09 GMT

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

Re: SDE Post Installation Fails

Anonymous User — Sun, 19 Jun 2011 04:37:52 GMT

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.

Re: SDE Post Installation Fails

VinceAngelo — Sun, 19 Jun 2011 23:16:25 GMT

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

Re: SDE Post Installation Fails

Anonymous User — Tue, 21 Jun 2011 02:57:31 GMT

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

Re: SDE Post Installation Fails

VinceAngelo — Tue, 21 Jun 2011 09:46:45 GMT

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

- V

Re: SDE Post Installation Fails

Anonymous User — Tue, 21 Feb 2012 06:34:54 GMT

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

Re: SDE Post Installation Fails

VinceAngelo — Tue, 21 Feb 2012 10:01:42 GMT

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