ArcSDE on separate servers

[FranciscoAcosta_Bazán]

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_separa...
2.- http://support.esri.com/en/knowledgebase/techarticles/detail/23753

[VinceAngelo]

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

[FranciscoAcosta_Bazán]

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

[VinceAngelo]

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

[JoeBorgione]

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-

[VinceAngelo]

"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

[FranciscoAcosta_Bazán]

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,

[VinceAngelo]

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

- V

[SteveMcCarthy]

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

[VinceAngelo]

Can it be done?  Of course.

Is it supported?  Sort-of.

Should it be done?  Probably not.

- V