Latest Contributions by George_Thompson

I understand what you are saying, I think that this is specific to an Oracle library and not another product library. If you are still having issues, you may need to contact Oracle support to have them help configure your EXTPROC to be configured properly. Do you have another Oracle instance that you can test a clean workflow on? -George ... View more

Did you remove the reference from the listener.ora file (see underlined info below)? The issue seems to be a mix up of the configuration settings. -Does the oracle account have access to the location of the .so file and permissions to execute against it? SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = /u01/app/oracle11/product/11.2.0/dbhome_1)       (PROGRAM = extproc)     )     (SID_DESC =       (GLOBAL_DBNAME = PGEO01)       (ORACLE_HOME = /u01/app/oracle11/product/11.2.0/dbhome_1)       (SID_NAME = PGEO01)     )     (SID_DESC =       (SID_NAME = PLSExtProcSDE)       (ORACLE_HOME = /u01/app/oracle11/product/11.2.0/dbhome_1)       (PROGRAM = extproc)         (ENVS="EXTPROC_DLLS=/geocode/arcgis/server/lib/libst_shapelib.so")     )     (SID_DESC =       (SID_NAME = xxxxxx)       (ORACLE_HOME = /u01/app/oracle11/product/11.2.0/dbhome_1)       (PROGRAM = dg4odbc)       (ENVS="LD_LIBRARY_PATH=/u01/app/oracle11/product/11.2.0/dbhome_1/bin")     ) Here is what my listener looks like. I know that is on Windows, but should be very similar. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = CLRExtProc)       (ORACLE_HOME = C:\app\[install location]\product\11.2.0\dbhome_1)       (PROGRAM = extproc)       (ENVS = "EXTPROC_DLLS=ONLY:C:\app\[install location]\product\11.2.0\dbhome_1\bin\oraclr11.dll")     )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = [machine name].esri.com)(PORT = 1521))       (ADDRESS = (PROTOCOL = NMP)(SERVER = [machine name])(PIPE = ORAPIPE))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))     )   ) ADR_BASE_LISTENER = C:\app\[install location] Hope this helps!! -George ... View more

I would not recommend modifying the listener.ora file for the configuration of the ST_Functions with Oracle 11.2. Please review the following documentation for setting this up within your Oracle geodatabase. Configuring the Oracle extproc to access the geodatabase with SQL  - Look at the section for Oracle 11g only!!! Be sure to update the EXTPROC.ora to ANY or the location of the .so file. Include the .so file name in the path. Let us know the results. ... View more

Hi Kendie, You need to install the 32-bit libraries for ArcGIS Desktop. This is a 32-bit client. I attached a screenshot of the libraries from the MyEsri site. If you have issue from MyEsri you may need to look at the PostgreSQL site for the correct version of the 32-bit libraries. Hope this help! -George ... View more

Hi Kendie, You need to install the PostgreSQL client libraries in the ArcGIS Desktop installation folder here: C:\Program Files (x86)\ArcGIS\[Desktop Version]\bin. You can download the client libraries from your MyEsri site. Setting up a connection to PostgreSQL Make sure you also configure the pg_hba.config to accept connections. -George ... View more

Adding a few spaces to help with your question. Enterprise GIS​  Esri Technical Support​ -George ... View more

You would need to grant permissions of select on those specific tables to the user. I would not recommend this as modification of these table can cause geodatabase issues (and is unsupported). Why does that data owner need access to those tables? -George ... View more

Hi Jon, When you use that tool it creates a user that can own data in the geodatabase. Unless the GFPTest user has an data owned there will be nothing to display in SQLPlus. Create a new feature class (just a empty, dummy one) on ArcCatalog as that GFPTest user then look in SQLPlus, does that user now have tables listed? -George ... View more

Hi Hunter, Here is some code that you could use for the ArcPy operations that you are requesting. Using Python scripting to batch reconcile and post versions As for rebooting the machine, you may want to consult with the OS manual. Hope this will get you going in the right direction...... -George Geodatabase​ ... View more

To add on to what Vince said, this is from Help Documentation for 10.2.x for database authentication DB Authentication: 14. If the user requires a matching schema (for example, the user will own data in the geodatabase), type the schema name in the Default schema field. Remember, the user name and schema name must be the same if this user is going to own data. Adding database-authenticated logins to a SQL Server database Windows Authentication: 14. If you are adding an individual login rather than a group, and the user will own data in the geodatabase, type the schema name in the Default schema field. Remember, the user name and schema name must be the same. For Windows groups, a matching schema will be created for any group member the first time the user creates data in the geodatabase. The schema name will be the same as the login name, not the name of the group. This is done automatically; you do not have to create the schema ahead of time. Adding Windows-authenticated logins or groups to a SQL Server database Hope this helps clear up any confusion. -George Geodatabase​ Managing Data​ ... View more

Hi Mark, The only way to safely update the SERVER_CONFIG table value for the license is with the command line tools. You can install them up to the 10.2.2 release. There is a request for a GP tool to be created to update the license file post 10.3 release. Here is a blog that reviews how to update the license before it expires: Updating the license for ArcSDE enterprise geodatabases at 10.1 | Support Services Blog The two tools that you referenced are for creating/enabling the geodatabase functionality in a supported RDBMS. They do not update the license in an existing enterprise geodatabase. Hopefully this help! -George Managing Data​ Geodatabase​ ... View more

Hi Paul, Yes, you would need to have the 64-bit client for Pro. I have the 64-bit full client (for SQLPlus) and the 32-bit Instant client. I have not seen any issues with this configuration in using ArcGIS Pro and ArcGIS 10.2.x/10.3. The 64-bit is first in my path variable as I have ArcGIS Server installed on the same machine. Here is the link of the ArcGIS Pro connections to supported enterprise geodatabases One thing that I noticed in your post is that you are using the Oracle 11.1.0 full client. I would recommend that you use at least the full (admin) client that matches your database version (i.e. 11.2.0.1). I would test with the correct client version of the full clients and see if the crash behavior is present. If the crash still occurs, I would create a case with Esri Technical Support​ so we can investigate the crashing (this should not happen). I have been using the Instant clients for well over 18 months with no issues. As for Oracle recommending the full client install, I could see this as being beneficial as there is more functionality built into it than with the instant client, so no argument there. This really comes down to the preference of your organization and your DBA's. I look forward to the results of your testing with the newer 11.2.0.1 or newer client. -George Managing Data​ ArcGIS-Pro​ ... View more

Hi Randall, I think that we are going to need some more information in order to possibly help with this.... 1. What ArcGIS Desktop version is being used and license level (Basic, Standard or Advanced)? 2. What RDBMS is being used? (Oracle 11.2.0.3. SQL Server 2008, etc...) 3. What are the permissions of the user that is loading the data into the geodatabase? 4. What version was the enterprise geodatabase created at? Those questions may help get some more responses. -George ... View more

Hi Syed, There is also a group call Geodatabase​ that has been created and would be a good resource. -George ... View more