I have a BD ORACLE 11G and AGServer 10 in windows server 2008 R2 .
I used the setup option for creating the repository manually changing the parameters of dbtune,
for it had created user "sde" and tablespace "sde" and "sde_movegdba" and for versioning
In the dbtune only change the parameters to DATADICTIONARY
dbtune.sde :
##DATA_DICTIONARY
ATTRIBUTE_BINARY "BLOB"
B_STORAGE "PCTFREE 0 INITRANS 4
TABLESPACE sde
STORAGE (INITIAL 40K)"
B_INDEX_ROWID "PCTFREE 0 INITRANS 4
TABLESPACE sde
STORAGE (INITIAL 40K) NOLOGGING"
B_INDEX_USER "PCTFREE 0 INITRANS 4
TABLESPACE sde
STORAGE (INITIAL 40K) NOLOGGING"
STATES_TABLE "INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 1M)"
STATES_INDEX "INITRANS 5
TABLESPACE sde_movegdba
STORAGE (INITIAL 128K) NOLOGGING"
STATE_LINEAGES_TABLE "PCTFREE 0 INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 7M)"
STATE_LINEAGES_INDEX "PCTFREE 0 INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 5M) NOLOGGING"
VERSIONS_TABLE "INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 256K)"
VERSIONS_INDEX "INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 128K) NOLOGGING"
MVTABLES_MODIFIED_TABLE "INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 2M)"
MVTABLES_MODIFIED_INDEX "INITRANS 4
TABLESPACE sde_movegdba
STORAGE (INITIAL 2M) NOLOGGING"
XML_INDEX_TAGS_TABLE "INITRANS 4
TABLESPACE sde
STORAGE (INITIAL 1M)"
XML_INDEX_TAGS_INDEX "INITRANS 5
TABLESPACE sde
STORAGE (INITIAL 1M)"
END
But try I get the message
VERSION table created...
SPATIAL_REFERENCES table being created...
SPATIAL_REFERENCES table created...
GEOMETRY_COLUMNS table being created...
GEOMETRY_COLUMNS table created...
LAYERS table being created...
LAYERS table created...
METADATA table being created...
METADATA table created...
RASTER_COLUMNS table being created...
RASTER_COLUMNS table created...
TABLE_REGISTRY table being created...
TABLE_REGISTRY table created...
COLUMN_REGISTRY table being created...
COLUMN_REGISTRY table created...
STATES table being created...
STATES table created...
VERSIONS table being created...
VERSIONS table created...
MVTABLES_MODIFIED table being created...
MVTABLES_MODIFIED table created...
STATE_LINEAGES table being created...
S_instance_add_lineage_id_index:Error creating index (2158)Error: << ORA-02158: opción CREATE INDEX no válida
DB_instance_lineages_table_exists:Error creating STATE_LINEAGE(lineage_id) index (2158)
ERROR in creating STATE_LINEAGES table.
Error: 2158
DBMS error code: 2158
ORA-02158: opción CREATE INDEX no válida
SDE schema object install not completed.
ERROR installing/upgrading ArcSDE, Error = -1
It is an error in reading the xml oracle or bad is that I have set the parameters of DBTUNE ????