topic Re: DBTune parameter on Multiple Enterprise Geodatabase ArcSDE 10.1 in Data Management Questions

DBTune parameter on Multiple Enterprise Geodatabase ArcSDE 10.1

AmitGupta — Fri, 15 Mar 2013 02:09:32 GMT

Hi All,
I'm working with Oracle 11.2, ArcSDE 10.1 and ArcGIS 10.1 and I have created multiple enterprise geodatabase from Arc Catalog. It means I have 10 enterprise geodatabase and one SDE enterprise geodatabaseall, all have its own user administrator.

My requirement is, I have to separate the index tablespace and data tablespace by editing DBtune file for each enterprise geodatabase.

In case of SDE, there is no problem I can export and import the edited dbtune file. But in case of other 10 Enterprise geodatabase only export command is working, if I want to import edited dbtune file using sdedbtune command it gives me error "insufficient privileges".

Need an expert advice. Please its urgent.

Thanks in Advance

Amit

Re: DBTune parameter on Multiple Enterprise Geodatabase ArcSDE 10.1

TravisVal — Mon, 18 Mar 2013 21:46:59 GMT

Can you post the command you are trying to use?

It worked for me using the following:

sdedbtune -o import -f ..\etc\dbtune.sde -u sde2 -p *** -i sde:oracle11g:myserver/orcl:sde2

Travis

Re: DBTune parameter on Multiple Enterprise Geodatabase ArcSDE 10.1

AmitGupta — Tue, 19 Mar 2013 10:29:39 GMT

Thank you very much Travis.
Your reference code is working and I can import modified dbtune file for another user. Actually i was forgetting to add full service name path -i sde:oracle11g:myserver:user.

Once again Thank u very much for your support.

Amit

Re: DBTune parameter on Multiple Enterprise Geodatabase ArcSDE 10.1

TravisVal — Tue, 19 Mar 2013 18:39:05 GMT

Your welcome, I am happy I was able to help.

Travis