I asked a question before, but was probably not specific enough, so didn't get the information I required. My fault completely.

I am creating a new sde instance on a server. This needs to be pointed at an existing Oracle 11g database, that has a pre exisiting SDE schema and data in it.

Now all the installs I have seen, have created all of the system tables, but this one doesn't need to, as they are there. Also, which is more alarming, is that I cannot perform an upgrade, as it hasn't been installed before.

Not too sure how to take it from here. I don't normally work with SDE, buit have thoroughly researched the issue. Has anyone seen this issue, or have advice as regards the issue?

Thanks in advance.

EDIT This is my plan of action.

  • Dump file of Oracle non spatial data
  • Install SDE
  • Create new Schema
  • export SDE data from old DB (sdeexport)
  • import SDE data from sdeexport file

We'll see how that fares, but it appears the only way to me.

  • I think you will find this works - are you using ArcSDE 10? Commented Feb 2, 2012 at 10:49
  • No, 9.3.1 unfortunately
    – Hairy
    Commented Feb 2, 2012 at 11:39

1 Answer 1


I am trying to clearly understand your pre-conditions:

  1. You have existing Oracle 11g instance.
  2. There is an SDE schema there with data.
  3. There is no ArcSDE installation and service.

Am I right?

If yes, then actually I think you can access you data right now via Direct Connection. You have no need in ArcSDE service for accessing you data.

To setup ArcSDE service you need to perform following actions:

  1. install ArcSDE. Skipping Post-Install step if you are using Windows.
  2. create ArcSDE service using sdeservice command.

You can have more info from this Esri article: HowTo: Manually install ArcSDE for Oracle on Windows

You need to perform steps 7, 10 and 11.

Refer to ArcSDE Administration Command Reference for further info.

  • No, we have to create the new 11g instance, and migrate the data from 9i, and also create a new instance of SDE. I have got to the stage now in my career that I can now install SDE blindfolded!
    – Hairy
    Commented Feb 9, 2012 at 7:15
  • In any case I think you can consider transfering sde schema by dump (or tablespace) as an option. Commented Feb 9, 2012 at 11:54
  • Not too sure about this, as the indexing gets fubar'd. I'll have a look, but the last time we did this, it was a rm -r jobby
    – Hairy
    Commented Feb 9, 2012 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.