topic SDE 10.1 Geodatabase User Schemas - import, export dbtune in Data Management Questions

SDE 10.1 Geodatabase User Schemas - import, export dbtune

CraigMark — Wed, 31 Oct 2012 13:52:50 GMT

ArcGIS: ArcSDE 10.1
Server: Windows Server 2003 64bit
Database: Oracle 11g R2 11.2.0.2

We use (1) Oracle database and (5) geodatabase user shemas...

I'm trying to modify the dbtune for each of my geodatabase user shemas but don't know how without the port:schema convention. I'd like to change the dbtune for each of my 5 schemas...

Also, I don't see anything in the sdedbtune commands... Am I overlooking something?

Any ideas are greatly appreciated!

- Craig

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

MandarPurohit — Thu, 01 Nov 2012 16:16:38 GMT

Hi Craig,

Creating an ArcSDE 10.1 service, and using it to import/export the dbtune file (using the port:schema convention) would work in this case:

C:\>sdedbtune -o import -f c:\custom_dbtune.txt -i 5151:gis -u gis -p top.secret

ArcSDE 10.1 for Oracle11g Build 768 Thu Aug 23 15:57:13 2012
Attribute Administration Utility
-----------------------------------------------------
Import DBTUNE Table. Are you sure? (Y/N): y

Successfully imported from file "c:\custom_dbtune.txt"

(Followed the following link to create and start the service in Windows:
Creating an ArcSDE service on Windows using the sdeservice command)

- Mandar

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

CraigMark — Thu, 01 Nov 2012 16:55:01 GMT

The users were locked in Oracle...

It works now...

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

ForrestJones — Thu, 01 Nov 2012 17:06:28 GMT

Hi Craig,

What is wrong with using the "-i <port>:<schema>" convention? It should work with the sdedbtune command as Mandar mentions. If using a direct connection you might need to use the tnsnames syntax. For example: "-i sde:oracle:<tnsname>:<schema>"

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

CraigMark — Thu, 01 Nov 2012 17:47:26 GMT

The user was locked in Oracle...

It works now...

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

CuyahogaGIS — Thu, 14 Feb 2013 18:31:16 GMT

Was this question answered?

I am having the same issue. No connection problem.

I am trying to export the DBTUNE file from a User Geodatabase but only seem to be able to export DBTUNE from the Master Geodatabase despite using the credentials from the User Geodatabase.

The Master and User Geodatabases are on the same host.

example:

sdedbtune -o export -f <file> -u <UserGeodb> -p <UGDB.topsecret> -i <directconnect>

I am returned the DBTUNE export from the Master Geodatabase same as this:

sdedbtune -o export -f <file> -u sde -p <topsecret> -i <directconnect>

Is there an option I'm missing?

Thanks

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

VinceAngelo — Thu, 14 Feb 2013 19:14:44 GMT

You should really post the contents of your -i flag, since that's where the problem is.

User-schema geodatabases *must* be in the same instance as the master SDE GDB
(by definition).

- V

Re: SDE 10.1 Geodatabase User Schemas - import, export dbtune

CuyahogaGIS — Fri, 15 Feb 2013 12:25:25 GMT

Ok. I should read the instructions. :confused:

For a user-schema geodatabase:

-i sde:oracle11g:<SQL_Net_alias>:<schema_name>

where <schema_name> = the name of user's schema in which the geodatabase was created

Thanks!