1

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create a database connection (both as sys and system users).

However, when I am trying to execute the tool create enterprise geodatabase, it fails. I asks for administrator username and password as shown in the image.

enter image description here enter image description here

Any ideas about how this could be resolved or debugged ?

Improve this question
2
  • You might try going to menu Geoprocessing -> Results. Might give you a bit more details. Also, don't use Oracle :p. Seems like ArcGIS.com themselves have moved to PostgreSQL!
    – janechii
    Commented Oct 1, 2014 at 17:26
  • If I could, maybe I would :) However the dbms of our system, which already contains non spatial information is in Oracle. As a result I would like to use some of the existing tables containing spatial information as well as non spatial info.
    – Smalis
    Commented Oct 1, 2014 at 21:15

2 Answers 2

Reset to default
1

You will need the sys password of that Oracle instance in order to run the create enterprise geodatabase. If you have another user with dba privileges you can run this to change the password:

alter user sys identified by NEWPASSWORD;

If you have a database administrator in your organization, they should have the sys password.

Optionally, if you have an Oracle database created you can run the enable enterprise geodatabase tool to create the SDE system tables.

http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000162000000

Improve this answer
2
  • 1
    Indeed, Enable Enterprise Geodatabase can be used as a replacement for Create Enterprise Geodatabase, IF you issue the necessary PUBLIC grants and create the SDE tablespace and SDE user beforehand.
    – Vince
    Commented Oct 1, 2014 at 22:49
  • The fact is that I am using an oracleXE so as to have administrator rights. However using the sys password I have set on my own has no results.
    – Smalis
    Commented Oct 2, 2014 at 7:52
1

The problem was that I was not completing the geodatabase administrator field since it says that it is optional. When I provided one, it worked properly.

Improve this answer

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.