POST
|
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
... View more
01-18-2013
06:12 AM
|
0
|
2
|
872
|