Create Enteprise GDB in Oracle 12c

[DiegoLlamas]

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

[George_Thompson]

That location is ok. Be sure to update the path for the user library and recompile the SDE schema.

Then run the SQL: select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;

To see if that fixes it.

[DiegoLlamas]

Hello George, 

I run the recompile

But after running select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;

My situation with the database is serious.

Thanks for your help!

Diego 

[George_Thompson]

Change the EXPTROC to "ANY" then retry.

[DiegoLlamas]

Nop, after change to any and recompile, I had the exact same error. 

Do you know how can I find out if the database is corrupted or something of I did wrong the ST compatibility.

If I recreate the database and use create new enterprise geodatabase, i just need to modify the extproc file, copy the library to bin folder, and run this command

SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB';
CREATE OR REPLACE LIBRARY ST_SHAPELIB AS 'E:\app\DLLAMAS\product\12.1.0\client_1\bin\st_shapelib.dll';
ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS;

are those the steps? all this before I add any data or this should work with data in the database?

Regards,

DLL

[George_Thompson]

I would update SET EXTPROC_DLLS=ANY and that is all.

You may have corrupted the GDB install with the create spatial type step. I would create a new empty Oracle DB and then just run the Create Enterprise GDB. You will need to update the library path for the new GDB and that should take care of it. No data is needed in the GDB for this part.

[DiegoLlamas]

Hello George,

Happy new year. I was able to get up and running the new Oracle geodatabase. Now I am re configuring DBTune so I can have the same configuration keywords in the new GDB.

 I have seen several changes. For example in version 10.4 I have this: BND_STORAGE                "PCTFREE 0 INITRANS 4 STORAGE ( INITIAL 409600) "

and in  version 10.6 I have this :BND_STORAGE                "PCTFREE 0 INITRANS 4" this in default section. 

So what I am doing is copy and paste in the new version so then I can update dbtune in new geodatabase. I am checking this page to confirm that it is compatible with version 10.6 Oracle configuration parameters—Help | ArcGIS Desktop 

so my question is, is it ok to add the STORAGE ( INITIAL 409600) for this new version, right?

Regards,

DLL

[George_Thompson]

I would say yes. But most people are not modifying the DBTUNE since the RDBMS's are "smarter" and more efficient now than before.

Be sure to review the parameters based on Oracle documentation also for the storage. I would also be sure to have a backup of the DBTUNE before you modify it.

Also note that it will NOT change the storage configuration of the current data, only new data that is loaded via that KEYWORD.

[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.