04020 Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it
Ora-04021
enabled. Please turn JavaScript back on and reload this page.
Oracle Metalink
Please enter a title. You can not post a blank message. Please type your message ora-06512 and try again. More discussions in Identity Manager All PlacesFusion MiddlewareIdentity ManagementIdentity Manager This discussion is archived 3 Replies Latest reply on Oct 3, http://www.dba-oracle.com/t_ora_04020_deadlock_detected_while_trying_to_lock_object_string.htm 2013 2:53 PM by ColinPurdon-Oracle OAM 11g R2: Webgate error access protected resource. 914712 Aug 21, 2012 1:15 AM Hello I'm working with the latest OAM and OAM Webgates. Webgate is installed on OHS. I have configured, and integrated the webgate as per the install guide. Platform is OEL x64 https://community.oracle.com/thread/2431387 OHS Server starts, and Webgate appears to talk to OAM Server. When trying to access the Webgate status URL: http://ohs.server.ip:7777/modules/ohs/webgate.cgi?progid=1 I receive the following error: Oracle Access Manager Operation Error The Access Server has returned a fatal error with no detailed information. Contact your website administrator to remedy this problem. Looking at the OAM logs, I see + detected while trying to lock object... From: Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: Oracle error ORA-04020 when importing SDE schema with st_geometry types Error Message When using Oracle's import utility or datapump and importing the ArcSDE SDE schema, the following error can occur:Code:IMP-00003: ORACLE error 4020 encounteredORA-04020: deadlock detected while trying to lock object 30x70000004932FE480x70000003C7213080x70000004ADB1C00IMP-00017: following statement failed with ORACLE error 4020:� "ASSOCIATE STATISTICS WITH TYPES "ST_GEOMETRY" USING "ST_DOMAIN_STATS"" Cause The cause of the problem is Oracle Bug 4454890 (see Oracle Metalink for additional information).When the error is encountered during the import process, the associations, which are required between the st_geometry, st_spatial_index, and relational operators with the st_domain_stats type, are not established. Without the associations, the optimizer does not gather statistics for st_geometry attributes, spatial indexes, and does not call the st_domain_stats type when parsing a SQL statement with st_geometry relational operators for calculating selectivity and cost. Solution or Workaround After the import process fails, connect in SQL*Plus as the SDE user, and execute the following commands to set the association:Code:SQL> ASSOCIATE STATISTICS WITH TYPES 2 sde.st_geometry USING sde.st_domain_stats;SQL> ASSOCIATE STATISTICS WITH INDEXTYPES 2 sde.st_spatial_index USING sde.st_domain_stats;SQL> ASSOCIATE STATISTICS WITH PACKAGES 2 sde.st_domain_operators, sde.st_relation_operators 3 USING sde.st_domain_stats; Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000010054 Software: ArcSDE 9.2, 9.3, 9.3.1 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Contact Support USA +1-888-377-4575 Name Email URL What issues are you having with the site? How can we improve? * Submit Feedback sent successfully. Error while sending mail. Loading