topic Re: ArcSDE on separate servers in Data Management Questions

ArcSDE on separate servers

FranciscoAcosta_Bazán — Wed, 18 Jan 2012 15:20:35 GMT

Hi I am trying to install ArcSDE on separate servers.
windows server 2008 R2 + Oracle 11G 64 bits
windows server 2008 R2 + Oracle 11G 64 bits (client)
ArcSDE 10 / sp03
and I have a confusion about which procedure should be taken as

1.- http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Installing_Oracle_and_ArcSDE_on_separate_servers/002n0000000q000000/
2.- http://support.esri.com/en/knowledgebase/techarticles/detail/23753

Re: ArcSDE on separate servers

VinceAngelo — Wed, 18 Jan 2012 15:38:30 GMT

They're both the same procedure, though the 10.0 Help link has more details.

I should point out that this is not an optimal install option. If you can't run
the ArcSDE on the database server, you should probably not run an application
server at all (use Direct Connect excludisvely). You should always install
ArcSDE binaries on the Oracle server(s), even if you don't execute the post-
install, so that you have a cleaner solution when it comes time to apply
a service pack (I'm not a fan of copying DLLs).

- V

Re: ArcSDE on separate servers

FranciscoAcosta_Bazán — Wed, 18 Jan 2012 16:47:27 GMT

You think it's the same?
in the PROC 1
order is first copied the dlls on the Oracle server, and assumes that you've created your user / tablespace SDE, but does not mention that create this user privileges
Then, almost at the end of the service creation and more to start another procedure
In the PROC 2
Neither mentions the dll `s

can you give me your personal procedure?
please

Re: ArcSDE on separate servers

VinceAngelo — Wed, 18 Jan 2012 17:49:37 GMT

I can give you my procedure, but it won't you do any good -- I've done so many
ArcSDE Oracle installs, I no longer even need to watch what my fingers are typing.
I doubt I issue the same commands in the same exact order in any two installations,
but I almost never encounter an error.

My procedure is:

Create the database

Create the SDE and data tablespaces

Create the SDE and data-owner users

Create the necessary roles

Grant permissions

Install ArcSDE software

Patch the ArcSDE software

Create the service with the 'sdeservice' (Windows only)

Edit the $SDEHOME/etc and OS etc files

Run sdesetup to create the instance (I never use the GUI)

Revoke SDE user permissions and re-GRANT the minimum necessary

Start the service

Configure the listener

Load data

If you need cookbook instructions, you should follow the steps in the documentation.
If the documentation is incorrect, or you encounter some other failure, then you should
contact Tech Support for assistance, and/or use the troubleshooting how-tos to work
around the issue. The key thing is to start doing, because you could spend weeks
reviewing special case documenation without making any real progress.

Good luck.

- V

Re: ArcSDE on separate servers

JoeBorgione — Wed, 18 Jan 2012 19:28:03 GMT

Not to hijack this thread but....

Vince- is this an Oracle thing only? I've got SDE on one box and SQL Server on another, and was under the impression it's the way to go...

Thanks-

Re: ArcSDE on separate servers

VinceAngelo — Wed, 18 Jan 2012 20:13:13 GMT

"The way to go" has too many variables for blanket statements. However, the reason
for running the ArcSDE server on the database host (tight coupling) hasn't changed.
The main drawbacks are:
1) The ArcSDE instance will consume resources (RAM, mostly) on the database server
2) Since 9.2, you need to license the ArcSDE server host independently

You don't hit the licensing issue if you run the application server on the ArcGIS Server
host, but then you add the processing load of a different server task (which is similar
to the Direct Connect thread, but in a process, which is less efficient). You need a
pretty exotic set of situations for an independent (non-AGS) ArcSDE server to be
optimal.

I recommend using Direct Connect with SQL-Server for two prime reasons:
1) The client is part of the OS (unlike with Oracle)
2) It's not subject to the non-interactive desktop heap connection limitation

You only really need an application server if you have a heterogeneous release
situation not covered by Direct Connect.

- V

Re: ArcSDE on separate servers

FranciscoAcosta_Bazán — Thu, 19 Jan 2012 14:54:12 GMT

Hi, I followed everything it says the procedure 1.- http://help.arcgis.com/en/arcgisdesk...000000q000000/
but I get an error when I run the following test. According to the following article tells me
http://support.esri.com/en/knowledgebase/techarticles/detail/39119

SQL> conn
Enter user-name: sde
Enter password:
Connected.
SQL> select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;
ERROR:
ORA-28575: no se ha podido abrir la conexi¾n RPC con el agente de procedimiento
externo
ORA-06512: en "SDE.ST_GEOMETRY_SHAPELIB_PKG", lÝnea 12
ORA-06512: en "SDE.ST_GEOMETRY", lÝnea 55

any suggestions or help,

Re: ArcSDE on separate servers

VinceAngelo — Thu, 19 Jan 2012 15:08:16 GMT

The KB doc you posted has links to the troubleshooting steps.

- V

Re: ArcSDE on separate servers

SteveMcCarthy — Wed, 26 Sep 2012 18:35:35 GMT

If you want to access Oracle and SQLserver Databases from the same separate server, can this be done?

Re: ArcSDE on separate servers

VinceAngelo — Wed, 26 Sep 2012 19:01:01 GMT

Can it be done? Of course.

Is it supported? Sort-of.

Should it be done? Probably not.

- V

Re: ArcSDE on separate servers

FranciscoAcosta_Bazán — Thu, 27 Sep 2012 16:56:56 GMT

to make successful the procedure is necessary required to install the Visual C++ 2008 Sp1 redistributable.
This already described in help esri for ArcGIS 10.1> Geodata >Oracle >procedure