nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

geometry storage

SyedMasood_Khadri

hi

I want to change dbtune parameter for geometry_storage from st_geometry to sdo_geometry.
ArcSDE installed on windows 2008 R2, oracle client is 64-bit.
I have used sdedbtune command but not succesful to change geometry_storage
Please help me..

Find more posts tagged with

Accepted answers

jskinner

Hi Syed,

Your command looks correct, you will just need to specify the '-i' parameter, which will be the ArcSDE service name, port number, or direct connection information. Ex:

-i sde:oracle11g:ORCL

ORCL above is the Oracle instance.

All comments

VinceAngelo

It has been a long time since Service Pack 1 to ArcGIS 10.1 was
released, and the Quality Improvement Patch is getting long
in the tooth as well. Both should be applied to all ArcGIS 10.1
installations.

- V

SyedMasood_Khadri

hi, really thanks for that.

jskinner

Hi Syed,

Your command looks correct, you will just need to specify the '-i' parameter, which will be the ArcSDE service name, port number, or direct connection information. Ex:

-i sde:oracle11g:ORCL

ORCL above is the Oracle instance.

SyedMasood_Khadri

hi

(1) Oracle server 11.2.0.1.0 on Redhat linux 5.

(2) Oracle client (64 bit), ArcSDE 10.1 installed on Windows 2008 R2.

(3) ArcGIS desktop 10.1, Oracle client (32 bit) on Windows 7 (direct connection is succesful with oracle serever).

The following command is used where ArcSDE is installed.

sdedbtune -o alter -k defaults -P geometry_storage -v sdo_geometry -s 194.61.63.132 -D newdb -u sde

ArcSDE 10.1
Attribute Administration Utility
-----------------------------------------------------

Error: Entry for SDE instance not found in services file (-102).
Error: Could not create a connection on server 194.61.63.132, for user sde.

VinceAngelo

Please provide:

A complete description of the software environment (exact database
The exact contents of the DBTUNE file you attempted to upload
The exact command you used to upload the DBTUNE changes
The exact keyword you used on subsequent feature class creation
The exact output of 'sdelayer -o describe_long' on the created layer

- V

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.