topic Re: ArcSDE 10.2 services are not working in Data Management Questions

ArcSDE 10.2 services are not working

AnuragSharma — Mon, 11 Nov 2013 08:54:20 GMT

Hello Guys...I am new to the sde services provided by esri. I want to connect ArcCatalog 10.2 to my Oracle 11g R2 database using
ArcSDE 10.2. I am using a 64-Bit Windows server 2008.
Till now following are the steps that i have undertaken:

1) Installed Oracle 11g
2) Created a Database named "MASTER"
3) Configured a listener
4) Installed ArcSDE 10.2
5) Default entries regarding the service name and port number have been made in the services file(esri_sde 5151/tcp).
6) The Path environment variable has been set keeping %SDEHOME%/Bin as the first entry
7) Create SDE service using sdeservice -o create command

After this the services are successfully created and registered.
When I start the services via service.msc it says
Arcsde service was started and then stopped. Some services are automatically stopped when not in use

So I used the sdemon -o start command but it also didn't work.
It says could not start Arcsde services--Check network,%SDEHOME%.......

The sde error log says
init_DB DB_instance_open_as_DBA =-93
DBMS error code :1017
Ora_01017 : invalid usrnm/pwd ; Logon denied

I used "sde" as the sde admin password while creating the service

Please do help.http://forums.arcgis.com/images/icons/icon11.png

Re: ArcSDE 10.2 services are not working

NidhinKarthikeyan — Mon, 11 Nov 2013 09:44:28 GMT

The sys password you had provided in 'Create Enterprise Geodatabase' might be incorrect.

Re: ArcSDE 10.2 services are not working

AnuragSharma — Mon, 11 Nov 2013 10:05:11 GMT

Is it necessary to create an enterprise geodatabase before setting up the arcsde service? I assumed that it was meant to be done
after the service was started.

Re: ArcSDE 10.2 services are not working

NidhinKarthikeyan — Mon, 11 Nov 2013 10:17:16 GMT

Hello Guys...I am new to the sde services provided by esri. I want to connect ArcCatalog 10.2 to my Oracle 11g R2 database using
ArcSDE 10.2. I am using a 64-Bit Windows server 2008.
Till now following are the steps that i have undertaken:

1) Installed Oracle 11g
2) Created a Database named "MASTER"
3) Configured a listener
4) Installed ArcSDE 10.2
5) Default entries regarding the service name and port number have been made in the services file(esri_sde 5151/tcp).
6) The Path environment variable has been set keeping %SDEHOME%/Bin as the first entry
7) Create SDE service using sdeservice -o create command.

Is it necessary to create an enterprise geodatabase before setting up the arcsde service? I assumed that it was meant to be done
after the service was started.

Yes.

Create a geodatabase by doing one of the following:

-Run the Create Enterprise Geodatabase geoprocessing tool from ArcGIS for Desktop (Standard or Advanced) to create an sde user, default tablespace, and a geodatabase.
-Run a Python script from a computer running ArcGIS for Desktop (Standard or Advanced), ArcGIS Engine with the Geodatabase Update extension, or ArcGIS for Server Enterprise (Standard or Advanced). Depending on which script you run, you might need to create the sde user and tablespace prior to running the script.
-Manually create an sde user and default tablespace in your Oracle database, grant the sde user privileges to create a geodatabase, then connect to the Oracle database from ArcGIS for Desktop (Standard or Advanced) as the sde user and enable geodatabase behavior. See Enabling geodatabase functionality in an Oracle database for instructions.

Next you must install and configure the ArcSDE application server(If you want to use ArcSDE Service).

Re: ArcSDE 10.2 services are not working

MarcoBoeringa — Mon, 11 Nov 2013 10:52:25 GMT

Hello Guys...I am new to the sde services provided by esri. I want to connect ArcCatalog 10.2 to my Oracle 11g R2 database using
ArcSDE 10.2. I am using a 64-Bit Windows server 2008.

If you are new to this and attempt to create a new geodatabase, it is highly recommended at this point in time to not use an ArcSDE Application Server and ArcSDE services, but instead use Direct Connect.

ArcGIS 10.2 is the last release that will support the ArcSDE Application Server.

See here:
http://forums.arcgis.com/threads/83644-quot-The-ESRI-Geodatabase-Framework-quot-PDF?p=303021&viewfull=1#post303021

And this for more background regarding the difference between Direct Connect and an ArcSDE Application Server:
http://forums.arcgis.com/threads/83644-quot-The-ESRI-Geodatabase-Framework-quot-PDF?p=295462&viewfull=1#post295462

Re: ArcSDE 10.2 services are not working

VinceAngelo — Mon, 11 Nov 2013 11:27:12 GMT

Is it necessary to create an enterprise geodatabase before setting up the arcsde service?.

Actually, it isn't necessary for the geodatabase to be created before the service is created, but it
is necessary to have had geodatabase installation completed before actually starting the service.

That said, there really is no reason to create an ArcSDE 10.2 application server service, especially
in a new installation environment. All of the old reasons for using application servers have been
eliminated over the past three ArcGIS releases.

Direct Connect is going to give you better performance at a lower cost of ownership, and you're
only one release away from that being the only option.

- V

Re: ArcSDE 10.2 services are not working

NidhinKarthikeyan — Mon, 11 Nov 2013 17:59:04 GMT

Actually, it isn't necessary for the geodatabase to be created before the service is created, but it
is necessary to have had geodatabase installation completed before actually starting the service.

Fyi Vince...
You can take a look at ArcSDE application server for Oracle installation guide:

Before you install
You must install a database and create a geodatabase in it before you set up an ArcSDE service. Use the Create Enterprise Geodatabase geoprocessing tool, the Enable Enterprise Geodatabase geoprocessing tool, or a Python script to create a geodatabase before installing the application server and setting up a service.

Note:
An enterprise geodatabase must exist before you can start an ArcSDE service. If you have not already created a geodatabase, do so now.

Anurag had mentioned that he had Installed ArcSDE 10.2 in his initial post (Step 4). I believe he would have installed 'ArcSDE application server for Oracle' in step 4. He had created a database named 'Master' and it was not a Geodatabase. Thats why I suggested him to use one of the three option to create a Geodatabase. His question regarding the sequence of setting up the ArcSDE service was after my above answer.

Is it necessary to create an enterprise geodatabase before setting up the arcsde service? I assumed that it was meant to be done
after the service was started.

Re: ArcSDE 10.2 services are not working

VinceAngelo — Mon, 11 Nov 2013 19:07:33 GMT

It's obvious why the documentation says you should put the horse before the cart,
but in fact, it is possible to create both Unix and Windows services without the
geodatabase to which the service will connect. You can't, of course, connect to
the unpopulated geodatabase, but you can create a broken service (folks do
this all the time).

Back when I created services on Windows, I usually created the service first,
since it populated the ORACLE_SID in dbinit.sde (which often needed to be
changed anyway, especially back in 'sdesetup -o install' days). I've quite
literally done this hundreds of times.

So, while you certainly shouldn't bother with application servers, and if you do
set out to create an application server service, you should always enable the
enterprise geodatabase first, but if you still choose to create the service first,
then there still exists a chance that you haven't yet hopelessly misconfigured
your server (provided you immediately complete the geodatabase install).

- V

Re: ArcSDE 10.2 services are not working

AnuragSharma — Thu, 21 Nov 2013 07:58:22 GMT

Hello guys !!
Thanks for your help...
Could your please help me with the steps in creating a enterprise geodatabase.

Presently I have a database
DB: Oracle
Instance: orcl

I am totally confused... And how do i make a sde user? I had used post installation before...It used to
have repository stetup, table space creation etc etc...but now I am not able to do so...
Please guide me step wise...

Re: ArcSDE 10.2 services are not working

NidhinKarthikeyan — Thu, 21 Nov 2013 08:35:32 GMT

Hello guys !!
Thanks for your help...
Could your please help me with the steps in creating a enterprise geodatabase.

Presently I have a database
DB: Oracle
Instance: orcl

I am totally confused... And how do i make a sde user? I had used post installation before...It used to
have repository stetup, table space creation etc etc...but now I am not able to do so...
Please guide me step wise...

ArcSDE post installation is no longer available from 10.1 onwards.

I understand that you have an empty Oracle database now. You have to run Create Enterprise Geodatabase tool.

Regarding creating sde user- You have the option in the Create Enterprise Geodatabase tool to enter the sde user and password.

Re: ArcSDE 10.2 services are not working

AnuragSharma — Thu, 21 Nov 2013 08:58:51 GMT

thanks nidhinkn...
I tried the create enterprise geogatabase tool but its gives an error...
"ora-12154 TNS : could not resolve the connect identifier specified
No extended error
Failed to execute "

Re: ArcSDE 10.2 services are not working

NidhinKarthikeyan — Thu, 21 Nov 2013 09:12:01 GMT

thanks nidhinkn...
I tried the create enterprise geogatabase tool but its gives an error...
"ora-12154 TNS : could not resolve the connect identifier specified
No extended error
Failed to execute "

You have to Install and configure Oracle client on the client machine.

Re: ArcSDE 10.2 services are not working

AnuragSharma — Fri, 22 Nov 2013 03:11:19 GMT

What kind of client should i install...??
Full client or instant client....
I tried using instant client but it still doesnt work...

Re: ArcSDE 10.2 services are not working

NidhinKarthikeyan — Fri, 22 Nov 2013 07:52:20 GMT

I always install 'Administrator client'. ArcGIS 10.2 documentation says that 'Oracle Instant Client' will work.

Re: ArcSDE 10.2 services are not working

VinceAngelo — Fri, 22 Nov 2013 11:53:12 GMT

Oracle Instant Client does work with ArcGIS 10.2, but you do need to install the correct version.
64-bit applications like ArcGIS Server need the 64-bit client; 32-bit apps like Desktop need the
32-bit client. Also, you need to edit the PATH variable appropriately, since there is no installer
to handle that detail.

- V

Re: ArcSDE 10.2 services are not working

WilliamCraft — Wed, 27 Nov 2013 02:11:16 GMT

When modifying the PATH variable upon installing the 32-bit and the 64-bit Oracle clients, the 64-bit client must be listed first followed by the 32-bit client (source: http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000617000000). Reversing the order of these in the PATH will result in connectivity problems.

Re: ArcSDE 10.2 services are not working

VaL — Tue, 24 Jun 2014 08:59:28 GMT

Hi all
I am a bit lost.
I have an SDE 10.0 MSSQL Server 2008 database with services enabled.
Can I connect to it via services in GIS 10.2.1?
If so how?
I am not interested in direct connect at this time.

Re: ArcSDE 10.2 services are not working

VinceAngelo — Tue, 24 Jun 2014 12:11:35 GMT

Direct Connect is certainly your easiest option, but you can always try reading the
documentation on how to connect using an application server.

In the future, please start a new thread when you want to ask a question unrelated
to the previous topic.

- V

Re: ArcSDE 10.2 services are not working

VaL — Thu, 26 Jun 2014 12:33:55 GMT

Direct Connect is certainly your easiest option, but you can always try reading the
documentation on how to connect using an application server.

In the future, please start a new thread when you want to ask a question unrelated
to the previous topic.

- V

Thanks for that.
Suggestion also noticed.