SDE 10.1 Geodatabase User Schemas - import, export dbtune

[CraigMark]

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

[MandarPurohit]

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

[CraigMark]

The users were locked in Oracle...

It works now...

[ForrestJones]

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>"

[CraigMark]

The user was locked in Oracle...

It works now...

[CuyahogaGIS]

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

[VinceAngelo]

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

[CuyahogaGIS]

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!