Tuesday, March 13, 2012

ESRI ArcSDE reference links


ESRI has released so many versions, releases, service packs of ArcMap, ArcSDE and other ArcGIS Server products that it is a challenge to keep a useful list of reference links! At least here is one I accumulated and am accumulating day by day
ArcSDE

ESRI website: http://www.esri.com
ESRI White Papers: http://support.esri.com/en/knowledgebase/whitepapers
ESRI Training: http://training.esri.com/gateway/index.cfm
ESRI Canada: http://www.esricanada.com/
Esri Developer Network: http://edn.esri.com/
ArcGIS Resource Center: http://resources.arcgis.com/
ArcGIS Resource Center - Web-based Help: http://resources.arcgis.com/content/web-based-help
ArcGIS Forums: http://forums.arcgis.com/

ArcGIS Desktop 10: http://help.arcgis.com/en/arcgisdesktop/10.0/help/

ArcSDE Installation Guides - ArcSDE 10 for Oracle: http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade_guide/index.html

ArcSDE Installation Guides - ArcSDE 10 for SQL Server: http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_microsoft_sql_server_installation_and_upgrade_guide/index.html

·         ArcSDE Knowledge Base: http://support.esri.com/en/knowledgebase/techarticles/browse/productid/19/productfamily/0/productVersions/642
·          ArcSDE 9.1 document: http://edndoc.esri.com/arcsde/9.1/
·         ArcSDE 9.2 document: http://edndoc.esri.com/arcsde/9.2/
·         ArcSDE 9.3  Administration Command Reference: http://resources.esri.com/help/9.3/geodatabase/pdf/admincmd.pdf
·         ArcSDE 10.0
o    Geodatabase and ArcSDE 10.0 Help: http://resources.arcgis.com/content/geodatabases/10.0/geodatabase-and-arcsde-help
o    Geodatabase and ArcSDE 10.0 System Requirements: http://resources.arcgis.com/content/geodatabases/10.0/geodatabase-and-arcsde-system-requirements
--ArcSDE 10 SQL Server Database Requirements: http://resources.arcgis.com/content/arcsde/10.0/sql-server-system-requirements

o    ArcSDE Installation Guides: http://resources.arcgis.com/content/geodatabases/10.0/arcsde-installation-guides
o    ArcSDE 10.0 for Oracle Installation Guides: http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade_guide/index.html

o    ArcSDE Geodatabase System Tables-10: http://help.arcgis.com/en/arcgisdesktop/10.0/help/002p/pdf/sdesystables_diagram.pdf

·         ArcGIS Server 9.2 Help: http://webhelp.esri.com/arcgisserver/9.2/java/
·         ArcGIS Server 9.3 Help: http://webhelp.esri.com/arcgisserver/9.3/java/
·         ArcGIS Server 9.3.1 Help: http://webhelp.esri.com/arcgisserver/9.3.1/java/
·         ArcGIS Server 10 Help: http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_java_help/index.html
·          
·         Forum: Geodatabase & ArcSDE: http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE
·          

What's new in ArcGIS 10: http://help.arcgis.com/en/arcgisdesktop/10.0/pdf/whats_new_in_arcgis_10.pdf

·         ArcGIS Server Product Life Cycle Support Status: http://downloads.esri.com/support/product%20life%20cycle/server_gis/ArcGISServer_PLC.pdf
·         ArcSDE 9.3/9.3.1 Oracle Database Requirements: http://wikis.esri.com/wiki/display/ag93bsr/ArcSDE+Oracle+Database+Requirements
·         ArcSDE 10 Oracle Database Requirements: http://resources.arcgis.com/content/arcsde/10.0/oracle-system-requirements
·         Product Announcements for ArcGIS Server: http://support.esri.com/en/knowledgebase/product-announcements/list/productid/66
·         Patches and Service Packs: http://resources.arcgis.com/content/patches-and-service-packs
·         Patches and Service Packs for ArcGIS Server: http://resources.arcgis.com/content/patches-and-service-packs?fa=listPatches&PID=66
Patches and Service Packs for ArcSDE

·         ArcSDE 10 Service Pack 4  03-05-2012 - SERVICE PACK
·         ArcSDE 10 Service Pack 3 10-12-2011 - SERVICE PACK
·         ArcSDE 10 Service Pack 2 04-28-2011 - SERVICE PACK
·         ArcSDE 10 Service Pack 1  12-03-2010 - SERVICE PACK
·         ArcSDE 10.0 General Update Patch for SQL Server  08-31-2010 - PATCH

·         ArcSDE 9.3.1 Service Pack 2 Register as Versioned using Oracle Spatial Data Patch 08-11-2011 – PATCH
·         ArcSDE 9.3.1 Service Pack 2 General Update Patch for DB2, Informix, and Oracle 11-29-2010 – PATCH
·         ArcSDE 9.3.1 Service Pack 2 11-04-2010 - SERVICE PACK
·         ArcSDE 9.3.1 SP1 SQL Server Raster Catalog and Raster Field Patch  12-23-2009 - PATCH
·         ArcSDE 9.3.1 Service Pack 1  12-19-2009 - SERVICE PACK
·         ArcSDE 9.3.1 SQL Server 2000 Permissions Patch  06-29-2009 - PATCH

·         ArcSDE 9.3 Service Pack 1 Compress with Concurrent Editors Patch  05-11-2009 – PATCH
·         ArcSDE 9.3 Service Pack 1 Memory Allocation Patch  03-18-2009 – PATCH
·         ArcSDE 9.3 Service Pack 1  03-13-2009 - SERVICE PACK
·         ArcSDE 9.3 Service Pack 1 geodatabase direct connect for 9.2 clients setup  11-07-2008 - SERVICE PACK

·         ArcSDE 9.2 SP 6 SQL Server 2000 Permissions Patch  06-29-2009 - PATCH
·         ArcSDE 9.2 Service Pack 6 Compress with Concurrent Editors Patch  04-22-2009 – PATCH
·         ArcSDE 9.2 Service Pack 6 Memory Allocation Patch  02-09-2009 – PATCH
·         ArcSDE 9.2 Connection Performance and Geodatabase Repair Patch  12-19-2008 – PATCH
·         ArcSDE 9.2 ST_Geometry Spatial Index Patch  08-28-2008 – PATCH
·         ArcSDE 9.2 Service Pack 6  07-18-2008 - SERVICE PACK
·         ArcSDE 9.2 Service Pack 5  05-08-2008 - SERVICE PACK
·         ArcSDE 9.2 Oracle Binary and Lob Type Spatial View Patch  05-02-2008 – PATCH
·         ArcSDE 9.2 for Oracle10gR2 for Tru64 UNIX  01-16-2008 – PATCH
·         ArcSDE 9.2 Service Pack 4  11-16-2007 - SERVICE PACK
·         ArcSDE 9.2 Service Pack 3  07-31-2007 - SERVICE PACK
·         ArcSDE 9.2 SQL Server Case Sensitivity Patch 06-07-2007 – PATCH
·         ArcSDE 9.2 Service Pack 2  04-16-2007 - SERVICE PACK
·         ArcSDE 9.2 Versioning Patch  03-21-2007 – PATCH
·         ArcSDE 9.2 Oracle Patch  02-14-2007 – PATCH
·         ArcSDE 9.2 Service Pack 1  01-04-2007 - SERVICE PACK

·         ArcSDE 9.1 Compress with Concurrent Editors Patch  06-16-2009 – PATCH

 More Oracle DBA tips, please visit Oracle DBA Tips 

Posted by Admin at 3/13/2012 10:33:00 AM

Labels:

How to resolve Error 1606 when installing ArcMap 10 Desktop

When installing ArcMap 10 on my workstation, I got the following error:

Error 1606. Could not access network location \\****\****\My Pictures\

Solution:

You receive an "Error 1606" error message when you try to install or remove a Microsoft program (http://support.microsoft.com/kb/886549 )


To resolve this issue yourself, follow these steps:
  1. Click Start, click Run, type Regedit.exe, and then click OK.
  2. Locate and then click the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
  3. In the right pane, verify that the values are the same as the values in the following table. If each value matches the table, go to step 7. 
For Windows Vista, Windows 7 and Windows Server 2008
Value nameTypeValue data
{374DE290-123F-4565-9164-39C4925E467B}REG_EXPAND_SZ%USERPROFILE%\Downloads
AppDataREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming
CacheREG_EXPAND_SZ%USERPROFILE%\AppData\Local\Microsoft\Windows\Temporary Internet Files
CookiesREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Cookies
DesktopREG_EXPAND_SZ%USERPROFILE%\Desktop
FavoritesREG_EXPAND_SZ%USERPROFILE%\Favorites
HistoryREG_EXPAND_SZ%USERPROFILE%\AppData\Local\Microsoft\Windows\History
LocalAppDataREG_EXPAND_SZ%USERPROFILE%\AppData\Local
My PicturesREG_EXPAND_SZ%USERPROFILE%\Pictures
My MusicREG_EXPAND_SZ%USERPROFILE%\Music
My VideoREG_EXPAND_SZ%USERPROFILE%\Videos
NetHoodREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Network Shortcuts
PersonalREG_EXPAND_SZ%USERPROFILE%\Documents
PrintHoodREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Printer Shortcuts
ProgramsREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs
RecentREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Recent
SendToREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\SendTo
Start MenuREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Start Menu
StartupREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup
TemplatesREG_EXPAND_SZ%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Templates
Then tried again. It works!

More Oracle DBA tips, please visit Oracle DBA Tips 

Posted by Admin at 3/13/2012 10:07:00 AM 0 comments

Saturday, December 11, 2010

Oracle DBA Tips

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

Please visit Canada DBA Jobs for DBA and database jobs in Canada!

Posted by Admin at 12/11/2010 02:24:00 PM 0 comments

Thursday, July 29, 2010

SESSIONS

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.



Property
Description
Parameter type
Integer
Default value
Derived: (1.1 * PROCESSES) + 5
Modifiable
No
Range of values
1 to 231
Basic
Yes
SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number of concurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.
Oracle uses the default value of this parameter as its minimum. Values between 1 and the default do not trigger errors, but Oracle ignores them and uses the default instead.
The default values of the ENQUEUE_RESOURCES and TRANSACTIONS parameters are derived from SESSIONS. Therefore, if you increase the value of SESSIONS, you should consider whether to adjust the values of ENQUEUE_RESOURCES and TRANSACTIONS as well. (Note that ENQUEUE_RESOURCES is obsolete as of Oracle Database 10g release 2 (10.2).)
In a shared server environment, the value of PROCESSES can be quite small. Therefore, Oracle recommends that you adjust the value of SESSIONS to approximately 1.1 * total number of connections.
Oracle initializatoin parameters

More Oracle DBA tips, please visit Oracle DBA Tips 

Posted by Admin at 7/29/2010 02:10:00 PM 0 comments

Labels:

V$TRANSACTION_ENQUEUE

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.


V$TRANSACTION_ENQUEUE displays locks owned by transaction state objects.

Column
Datatype
Description
ADDR
RAW(4 | 8)
Address of lock state object
KADDR
RAW(4 | 8)
Address of lock
SID
NUMBER
Identifier for session holding or acquiring the lock
TYPE
VARCHAR2(2)
Type of lock. TX indicates transaction enqueue.
ID1
NUMBER
Lock identifier #1 (depends on type)
ID2
NUMBER
Lock identifier #2 (depends on type)
LMODE
NUMBER
Lock mode in which the session holds the lock:
  • 0 - none
  • 1 - null (NULL)
  • 2 - row-S (SS)
  • 3 - row-X (SX)
  • 4 - share (S)
  • 5 - S/Row-X (SSX)
  • 6 - exclusive (X)
REQUEST
NUMBER
Lock mode in which the process requests the lock:
  • 0 - none
  • 1 - null (NULL)
  • 2 - row-S (SS)
  • 3 - row-X (SX)
  • 4 - share (S)
  • 5 - S/Row-X (SSX)
  • 6 - exclusive (X)
CTIME
NUMBER
Time since current mode was granted
BLOCK
NUMBER
The lock is blocking another lock

Oracle data dictionary views


Oracle dynamic performance views

Last updated: 2009-11-12 Thursday

Posted by Admin at 7/29/2010 02:09:00 PM 0 comments

Labels:

Subscribe to: Posts (Atom)