Please clarify on DBTune configuration
Please refer the attached screenshot of (Oracle Console and TOAD)
What’s going wrong why the Index is not created in tablespace specified in DBTune Param?
You'll need to provide the contents of DBTUNE keywords, as loaded, for both the DEFAULTS keyword and whatever keyword you've specified --
sdedbtune -o list -k DEFAULTS ...
sdedbtune -o list -k WHATEVER ...
We'll also need the default tablespace for the user in question.
Hi V A ,
Thansk for your resposne
1) The keyword specified is DEFAULT (nothing else)
2) Attached dbtunedef.txt is the contents of DEFAULT @ DBTUNE params listed into text file
3) Default Tablepsace for this Schema GDB is configured as DEV_SDE
Please note that:
Our Configuration uses Multiple Schema GDB Model and configured such a way that
a) Master GDB manages configured with its own tablesapces ( In-fact all datasets resides in respective Schema GDB)
b) Every Schema GDB-SDE created in dedicated tablespaces , And also all data objects such as B-Table/Index/AD/etc created in dedicated tablespaces
(attached gdb.png is the config model used)
Hope this clears...
Did you register this DBTUNE with the user-schema geodatabase? What does the master
DBTUNE table have for the S_STORAGE and S_INDEX_ALL keys?
Have you applied the SP1 and QIP patches to your 10.1 install?
S_INDEX_ALL "PCTFREE 0 INITRANS 4 TABLESPACE SDE_DATA_TBLSPC NOLOGGING "
S_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE SDE_DATA_TBLSPC "
I don't see any QIP for ArcSDE 10.1 in below link;
please help me if any other place i can find it ?
Very sorry for late response, just back to work from vacation...
The link you gave does not have QIP for ArcGIS Server? It got QIP for Desktop only;
However tried to install and end up with problem, For some reason it changes the IIS Settings and gave hard time to restore the site back.
But still the root problem not fixed yet;
I see both Desktop and Server patches, and instructions for Oracle and PostgreSQL geodatabase upgrades.