Latest Contributions by KimPeter

Hi Joe, Do you mean that when you connect to the geodatabase in Desktop, you only see dbo.DEFAULT as the transactional version option?  You restarted Desktop after re-creating your geodatabase, right?  If you create a new spatial database connection, does it still show dbo.DEFAULT only? And you did say you deleted the database from the SQL Server instance before you re-ran the Post Installation wizard.  If you didn't completely get rid of the database and start from scratch, re-running the Post Installation wizard on the existing database wouldn't switch schemas.  I seem to recall that when you delete a database in SQL Server, there's an option that asks if you want to restore from backup.  Is it possible that was checked and, therefore, it restored a backup that already contained the ArcSDE geodatabase system tables? When you open the database in Management Studio, if the ArcSDE geodatabase system tables are shown to be in the dbo schema (i.e., they're named things like dbo.sde_layers), either try running the Post Installation wizard and provide a different name for the database, or drop the existing database, be sure it is gone from the SQL Server instance, and run the Post Installation wizard to re-create the database and geodatabase, specifying an sde-schema. -Kim ... View more

I think the problem is the Oracle client you installed: "I've installed the Oracle 11g 64-bit full client on the client machine" Desktop is a 32-bit client and requires a 32-bit DBMS client. http://resourcesbeta.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_Oracle/002n00000038000000/ "Some ArcGIS clients, such as ArcGIS for Desktop and ArcGIS Engine, are 32-bit applications. If you are making a database connection from one of these clients, you must use a 32-bit Oracle client to connect to the Oracle database. This is true even if you install the ArcGIS client application on a computer with a 64-bit operating system (OS) and the database and server OS are 64-bit." ... View more

You cannot use the sdesetup command to create a geodatabase at 10.1; that's why install is no longer a listed operation. Sorry - I didn't elaborate on the ArcGIS client step.  If the ArcGIS client is on a machine separate from the DBMS, you must install the DBMS client on the machine with the ArcGIS client to connect to the database.  That's why you got the "database client software failed to load" message; there likely is not an Oracle client on the machine where you installed Desktop.  See the Setting up a geodatabase in Oracle section of this topic, it has an overview of creating a geodatabase in Oracle at 10.1. http://resourcesbeta.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_setting_up_a_geodatabase_in_Oracle/002n00000001000000/ ... View more

The gdb I'm connecting to was created when I was using the SDE personal license; now, after i've switched to an SDE Workgroup license, it seems like the gdb still only accepts the max. # of personal license  connections; almost as if this wasn't updated. That's expected; the license doesn't get updated in individual geodatabases until you detach then re-attach them. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Changing_license_keys_for_database_servers_and_their_geodatabases/003n0000006v000000/ ... View more

Hi Matt, The installation guide also says this: "Before you install You must install a database and create a geodatabase in it before you set up an ArcSDE service. Use the Create Enterprise Geodatabase geoprocessing tool, the Enable Enterprise Geodatabase geoprocessing tool, or a Python script to create a geodatabase before installing the application server and setting up a service." The installation guide is for installing and creating a service only.  Geodatabase creation has to happen prior to that. So your steps would be: 1.) Install an ArcGIS client. 2.) Run the Create Enterprise Geodatabase tool (or script). 3.) setting up prereq's (environment variables, OS sde user, etc) 4.) install ArcSDE 10.1 5.) Edit the sde and OS services files. 5.) sdemon -o start ... View more

Hi Mario, Had you altered the pg_hba.conf file to allow connections to the database cluster?  The fact that the server name didn't work but localhost did made me think this might be the issue. Just a thought. -Kim ... View more

Yes; Upgrade Geodatabase did all of that. In general, the numbers in the version table do not change for service packs; they only change if there are repository schema changes, which we try to avoid in service packs.  If the Upgrade Geodatabase button is now inactive, then your geodatabase (all bits) are now upgraded to the same release/service pack as the Desktop application from which you upgraded. ... View more

The query for PostgreSQL should be the same as for SQL Server, since the system table name is the same in both: sde_versions. update sde.sde_versions set name = 'DEFAULT' where version_id = 1 ... View more

Hi Scott, Geodatabase upgrades for ArcGIS 10+ are done using the Upgrade Geodatabase tool from Desktop, which it sounds like you did.  There is no need to run the sdesetup -o upgrade command. (The error you're seeing when you run the sdesetup command is a result of the inclusion of the -i option; that is only used with the sdesetup command to specify a user-schema geodatabase in Oracle.) Respectfully, Kim ... View more

...some commands cannot be used on specific operating systems. These are as follows:     Linux 64-bit: cov2sde and sde2cov     HP Itanium: cov2sde, sde2cov, sde2shp, shp2sde, sde2tbl, tbl2sde, and shpinfo You are correct, Alex.  The operating system/command line utility combinations you have listed are the only ones that are not supported for 10.1. -Kim ... View more

That is likely the problem, then.  At 10.1, only 64-bit databases are supported. http://resourcesbeta.arcgis.com/en/help/system-requirements/10.1/index.html#/Oracle_Database_Requirements/01510000006s000000/ ... View more

Hi Marc, Were you using a 32-bit Oracle XE 11g database? Or was it 64 bit? -Kim ... View more

Hi Royce, That variable always confuses me too; I'm not sure why it is that way. To create a service on a remote machine requires an additional option. "When you create a service, the sdesetup command requires you to include the -d option and value. However, it is not possible for a Windows service to have a dependency on a service that is on a remote server. Therefore, you must specify the -n option to negate the dependency." http://resourcesbeta.arcgis.com/en/help/install-guides/arcsde-application-server-oracle/10.1/index.html#/Creating_an_ArcSDE_service_from_a_remote_Windows_server/009400000066000000/ ... View more

Royce, Don't perform step 6; this isn't needed for Oracle since there's no database name to register (we're fixing this topic). If you do the other steps, though, this should work. -Kim ... View more