ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise SP1

ChandesrisBasile — Fri, 18 Jan 2013 14:12:16 GMT

ArcSDE 10.1 SP1 for Oracle11g installation on Windows Server 2008 R2 Enterprise SP1

ArcToolbox > Data Management Tools > Geodatabase Administration > Create Enterprise Geodatabase > Oracle

(1) All passwords fields are optional ?!

(2) With SDE only with rights accesses configuration, the installation fails:
[Fri Jan 18 16:12:59 2013]
ST_Geometry is not installed.[Fri Jan 18 16:12:59 2013] Instance initialized for ((sde)) . . .

[Fri Jan 18 16:12:59 2013] VERSION table created...
[Fri Jan 18 16:12:59 2013] SPATIAL_REFERENCES table being created...
[Fri Jan 18 16:12:59 2013] SPATIAL_REFERENCES table created...
[Fri Jan 18 16:12:59 2013] GEOMETRY_COLUMNS table being created...
[Fri Jan 18 16:12:59 2013] GEOMETRY_COLUMNS table created...
[Fri Jan 18 16:12:59 2013] LAYERS table being created...
[Fri Jan 18 16:13:00 2013] LAYERS table created...
[Fri Jan 18 16:13:00 2013] METADATA table being created...
[Fri Jan 18 16:13:00 2013] METADATA table created...
[Fri Jan 18 16:13:00 2013] RASTER_COLUMNS table being created...
[Fri Jan 18 16:13:00 2013] RASTER_COLUMNS table created...
[Fri Jan 18 16:13:00 2013] TABLE_REGISTRY table being created...
[Fri Jan 18 16:13:00 2013] TABLE_REGISTRY table created...
[Fri Jan 18 16:13:00 2013] COLUMN_REGISTRY table being created...
[Fri Jan 18 16:13:00 2013] COLUMN_REGISTRY table created...
[Fri Jan 18 16:13:00 2013] STATES table being created...
[Fri Jan 18 16:13:00 2013] STATES table created...
[Fri Jan 18 16:13:00 2013] VERSIONS table being created...
[Fri Jan 18 16:13:00 2013] VERSIONS table created...
[Fri Jan 18 16:13:00 2013] MVTABLES_MODIFIED table being created...
[Fri Jan 18 16:13:00 2013] MVTABLES_MODIFIED table created...
[Fri Jan 18 16:13:00 2013] STATE_LINEAGES table being created...
[Fri Jan 18 16:13:01 2013] STATE_LINEAGES table created...
[Fri Jan 18 16:13:01 2013] LOCATORS table being created...
[Fri Jan 18 16:13:01 2013] LOCATORS table created...
[Fri Jan 18 16:13:01 2013] XML tables being created...
[Fri Jan 18 16:13:01 2013] XML tables created...
[Fri Jan 18 16:13:01 2013] Instances tables being created...
[Fri Jan 18 16:13:01 2013] Instances tables created...
[Fri Jan 18 16:13:01 2013] ARCHIVES table being created...
[Fri Jan 18 16:13:01 2013] ARCHIVES table created...
[Fri Jan 18 16:13:01 2013] LAYER_STATS table being created...
[Fri Jan 18 16:13:01 2013] LAYER_STATS table created...
[Fri Jan 18 16:13:02 2013] LOGFILE_POOL tables being created...
[Fri Jan 18 16:13:02 2013] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='MINSTANDALONELOGS' >
[Fri Jan 18 16:13:02 2013] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='MAXSTANDALONELOGS' >
[Fri Jan 18 16:13:02 2013] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='LOGFILEPOOLSIZE' >
[Fri Jan 18 16:13:02 2013] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='ALLOWSESSIONLOGFILE' >
[Fri Jan 18 16:13:02 2013] LOGFILE_POOL tables created...
[Fri Jan 18 16:13:02 2013] DBTUNE table being created...
[Fri Jan 18 16:13:02 2013] DBTUNE table created...
[Fri Jan 18 16:13:02 2013] SERVER_CONFIG tables being created...
[Fri Jan 18 16:13:02 2013] SERVER_CONFIG tables created...
[Fri Jan 18 16:13:02 2013] SDENUMTAB type being created...
[Fri Jan 18 16:13:02 2013] SDENUMTAB type created...
[Fri Jan 18 16:13:02 2013] DBMS stored procedures being created or updated...
[Fri Jan 18 16:13:05 2013] SQL Stmt: <ALTER PACKAGE instances_util COMPILE>
[Fri Jan 18 16:13:05 2013] WARNING: package instances_util did not compile!
[Fri Jan 18 16:13:05 2013] ERROR in creating system stored procedures.
Error: -51
DBMS error code: 4043
ORA-04043: objet INSTANCES_UTIL inexistant

[Fri Jan 18 16:13:06 2013] SQL Stmt: <drop trigger SDE.BIFER_61217>
[Fri Jan 18 16:13:06 2013] SQL Stmt: <drop trigger SDE.BIFER_61221>
[Fri Jan 18 16:13:06 2013] SDE schema object install not completed.
[Fri Jan 18 16:13:06 2013] ERROR installing/upgrading ArcSDE, Error = -529

(3) Only SYS account enable the SDE 10.1 SP1 for Oracle11g Windows installation!

>> http://ideas.arcgis.com/ideaView?id=087300000008KLVAA2 SDE: Security improvement for ORACLE Data Center
>> http://ideas.arcgis.com/ideaView?id=087300000008HY6AAM "Harden" ArcSDE repository on Oracle: do not grant privileges to PUBLIC role unnecessarily

>> http://ideas.arcgis.com/ideaView?id=08730000000bn4wAAA Improve security, cost and flexibility for SDE ORACLE: Allow to change name of the SDE schema

>> http://ideas.arcgis.com/ideaView?id=087300000008708AAA Publish the SDE Schema Procedures, Functions...

>> http://ideas.arcgis.com/ideaView?id=08730000000bxZrAAI Oracle Enterprise Linux 6: Certify the Geodatabase and ArcSDE

Re: ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise

RicaSaporta — Wed, 06 Feb 2013 19:33:56 GMT

Hello,
I ran into the same issue using the SYS user in the database. And I know very little about the inner workings of Oracle.
while I agree that the ideas suggest would be helpful - they do not help me solve the issue.
Any comments on how to solve this?
thanks
rica

Re: ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise

RicaSaporta — Wed, 06 Feb 2013 20:07:08 GMT

Found an answer ...
As with most issues in ArcCatalog you need to re-launch the ArcCatalog session.
Apparently in 10.1, if you tried to create the SDE enterprise geodatabase and for some reason have to re-run this geoprocessing tool, and recreate the master geodatabase, you must restart ArcCatalog.

Here is the technical article on this particular cause
http://support.esri.com/en/knowledgebase/techarticles/detail/40330

There maybe other causes to this symptom, but at least we have a solution to this one.
thank you to Rhiann of Esri Canada support on this.

rica

topic ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise SP1 in Data Management Questions

ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise SP1

Re: ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise

Re: ArcSDE 10.1 SP1 Oracle11g installation issues on Window Server 2008 R2 Enterprise