topic Re: Running multiple SDE instances on separated Oracle DB in Data Management Questions

Running multiple SDE instances on separated Oracle DB

DahaeHwang — Mon, 25 Oct 2010 19:21:10 GMT

I have a server that ArcGIS Advanced Enterprise v9.3 is running on with EDN licenses. On the box SDE 9.3 with Oracle 10g is running, but I would like to use this for test environment with ArcSDE 10 as well.
The idea is to install a separate geodatabase with Oracle 11g(or 10g) on the same box and to run a separate SDE instance in the new geoDB. Here, is it possible to set up the new SDE instance with version 10 EDN license on the same machine where 9.3 sde license is already authorized?

If this is not possible, what is the best scenario to set up this kind of test environment with ArcSDE 10 by minimizing authorizing/deauthorizing the licenses on the test machine?

Any help will be appreciated.

Re: Running multiple SDE instances on separated Oracle DB

VinceAngelo — Mon, 25 Oct 2010 19:47:58 GMT

There's no problem running multiple ArcSDE instances on the same server (I always have
between three and five instances on any host), but when using Oracle, you need to create
one database instance per ArcSDE server.

Actually, I take that back -- There is a problem: You can't install ArcSDE 9.3 and ArcSDE 10.0
on the same server. This has been covered in this forum repeatedly.

- V

Re: Running multiple SDE instances on separated Oracle DB

DahaeHwang — Tue, 26 Oct 2010 11:21:10 GMT

I already read your thread on multiple ArcSDE before asking this questions but I was still confused. What do you mean when you said 'some I'm running three versions of ArcSDE on my laptop'? Could you please clarify that?
Thanks in advance.

Re: Running multiple SDE instances on separated Oracle DB

VinceAngelo — Tue, 26 Oct 2010 14:22:51 GMT

I'm not really sure what you mean by clarify. I regularly need to run the same
versions as my clients, so I'll have 9.2, 9.3, and 10.0 releases on the same
machine. As long as the services are created correctly with the 'sdeservice'
command, there's no technical reason to prevent this from happening.

- V

Re: Running multiple SDE instances on separated Oracle DB

DahaeHwang — Tue, 26 Oct 2010 15:17:20 GMT

Thanks Vince,
I was confused from the answer saying "you can't install ArcSDE 9.3 and ArcSDE 10.0 on the same server".
So you meant that I CAN'T install two different sde versions on the same box "with the ArcSDE installer", but it is still possible to install them with command-line utilities including the 'sdeservice' command and some other unsupported techniques?

Re: Running multiple SDE instances on separated Oracle DB

VinceAngelo — Tue, 26 Oct 2010 19:06:03 GMT

Exactly. My friends over in Tech Support aren't happy when I lead folks by
hand into Unsupported Territory (and you'll notice I'm not a willing guide),
but if you can find the road yourself, then you're not likely to need to call
Tech Support.

The supported mechanism is to establish a test server, load software there,
transition your install to 10, then post it back to the production server. But
some production servers are beefy enough to support a bit more, which is
how we found ourselves in this mess.

Keep in mind that nothing I've posted on this topic addresses the issues
surrounding licensing. You still need to adhere to your license agreement
with regard to number of server-CPUs, and the supported mechanism of
using a different server to run the 'sdesetup', and not installing a service
for the new instance (using only Direct Connect), is far more likely to fit in
the licensing model as-is (but you'd need to speak with your local Esri office
to clarify any of that).

- V

Re: Running multiple SDE instances on separated Oracle DB

DahaeHwang — Wed, 27 Oct 2010 11:24:35 GMT

Thanks a lot, Vince. About the tech support/license issue, I got your point.
You answers were so helpful.
Thanks.