nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create Enteprise GDB in Oracle 12c

DiegoLlamasOlivares

Hello,

I am super new using Oracle and I am having some problems creating a database in oracle. I have installed Oracle (with no database created) I also set the path environment variable in windows server and I am able to access other Oracle DBs already created.

I do not have an oracle database created in this new server Do I need to have one so I can use that name to access it? because I do not have any but I am using the IP:port/the name of the database I want to give to it, is this correct?

This tool is going to create the sys user automatically?

I am getting this error

Is there something I need to do?

Thanks,

Diego Llamas

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

DiegoLlamasOlivares

Hello George Thompson's Blog After your help I was able to create the database and create roles and user gisadmin, giseditor and gisviewer, the users has their privileges set. So I started to copy paste data sets from an old database to the new one. In the middle of the process of migrating the data I remember that I did not configure the ST_Geometry type to the new database, so I copied the st_shapelib.dll from server to the database server, modify the extproc.ora file as shown in Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop run this on the SQL Developer

SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB';
CREATE OR REPLACE LIBRARY ST_SHAPELIB AS 'C:\Oracle_ST_GeometryLIB\st_shapelib.dll'; ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS;

and run the create spatial type geoprocessing tool.

After I did that, I tried to copy and paste the rest of the data sets and I got this erros

If I add the existed data from the database to arcmap I got this error.

Draw error

If I try to create a new feature class

Error copy paste data sets

If I try to delete something from the database, it erase but once refreshed it come again.

I run one procedure in one of your post and I got this

Any suggestion, What did I do wrong?

Regards,

DLL

Asrujit_SenGupta

What error do you receive related to the user?

The tool is capable of creating the SDE user and SDE user's tablespace for you. So it is not necessary to create them beforehand.

George_Thompson

Hi Diego - You can create the SDE user in advance. Just follow the documentation above and look in the "The Oracle administrator configures the database; the geodatabase administrator creates the geodatabase" Section. It will give you the information to run the correct tools.

DiegoLlamasOlivares

Hello, George Thompson's Blogt

I was able to create the database in Oracle C with the listener, database but when I run the create EGB tool, it gives me an error for user, so, my question is, do I need to create the SDE user also in Oracle, before running the tool?

Regards,

Diego Llamas

George_Thompson

Yes, create the DB on the Oracle instance before you use that GP tool. You will need the SYS user PW for the EGDB creation.

Then you can use EZConnect for the connection string; i.e ServerName/SID SID = Oracle DB name

Here are the options: Create a geodatabase in Oracle—Help | ArcGIS Desktop

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Iniciar Sesión
Registrarse

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.