ArcSDE 10.2 services are not working

4918
18
11-11-2013 12:54 AM
AnuragSharma
New Contributor
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
0 Kudos
18 Replies
AnuragSharma
New Contributor
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 "
0 Kudos
NidhinKarthikeyan
Occasional Contributor III
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.
0 Kudos
AnuragSharma
New Contributor
What kind of client should i install...??
Full client or instant client....
I tried using instant client but it still doesnt work...
0 Kudos
NidhinKarthikeyan
Occasional Contributor III
I always install  'Administrator client'. ArcGIS 10.2 documentation says that 'Oracle Instant Client' will work.
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
WilliamCraft
MVP Regular Contributor
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.
0 Kudos
VaL
by
New Contributor III
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.
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
VaL
by
New Contributor III
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.
0 Kudos