Latest Contributions by User35489

‎05-13-2013

Dear Admins, I created a DBTUNE file with customized keyword, directing to below given example. ##CART_VECTOR_DEFAULT GEOMETRY_STORAGE "ST_GEOMETRY" ST_GEOM_LOB_STORAGE " STORE AS ( # TABLESPACE <lob segment tablespace_name> ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE) " ATTRIBUTE_BINARY "BLOB" RASTER_STORAGE "BLOB" B_STORAGE "PCTFREE 0 INITRANS 4" TABLESPACE SDE_TS B_INDEX_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" B_INDEX_USER "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" B_INDEX_XML "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" B_INDEX_RASTER "PCTFREE 0 INITRANS 4 TABLESPACE NOLOGGING" B_INDEX_TO_DATE "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" B_INDEX_SHAPE "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" S_STORAGE "PCTFREE 0 INITRANS 4" TABLESPACE TS_SNDX S_INDEX_ALL "PCTFREE 0 INITRANS 4 TABLESPACE TS_SNDX NOLOGGING" S_INDEX_SP_FID "PCTFREE 0 INITRANS 4 TABLESPACE TS_SNDX NOLOGGING" F_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE SDE_TS F_INDEX_FID "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" F_INDEX_AREA "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" F_INDEX_LEN "PCTFREE 0 INITRANS 4 TABLESPACE TS_NDX NOLOGGING" A_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE <Default ADDS table tablespace name> A_INDEX_ROWID "PCTFREE 0 INITRANS 4 # TABLESPACE <ADDS Table default index tablespace name> NOLOGGING" A_INDEX_SHAPE "PCTFREE 0 INITRANS 4 # TABLESPACE <ADDS Table default index tablespace name> NOLOGGING" A_INDEX_STATEID "PCTFREE 0 INITRANS 4 # TABLESPACE <ADDS Table default index tablespace name> NOLOGGING" A_INDEX_USER "PCTFREE 0 INITRANS 4 # TABLESPACE <ADDS Table default index tablespace name> NOLOGGING" A_INDEX_XML "PCTFREE 0 INITRANS 4 # TABLESPACE <ADDS Table default index tablespace name> NOLOGGING" A_INDEX_RASTER "PCTFREE 0 INITRANS 4 # TABLESPACE <ADDS Table default index tablespace name> NOLOGGING" D_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE <default DELETES Table tablespace name> D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 # TABLESPACE <DELETES Table default index tablespace name> NOLOGGING" D_INDEX_DELETED_AT "PCTFREE 0 INITRANS 4 # TABLESPACE <DELETES Table default index tablespace name> NOLOGGING" RAS_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE <RAS Table tablespace name> RAS_INDEX_ID "PCTFREE 0 INITRANS 4 # TABLESPACE <RAS Table tablespace name> NOLOGGING" BND_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE <BND Table tablespace name> BND_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 # TABLESPACE <BND Table tablespace name> NOLOGGING" BND_INDEX_ID "PCTFREE 0 INITRANS 4 # TABLESPACE <BND Table tablespace name> NOLOGGING" AUX_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE <AUX Table tablespace name> AUX_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 # TABLESPACE <AUX Table tablespace name> NOLOGGING" BLK_STORAGE "PCTFREE 0 INITRANS 4 # TABLESPACE <BLK Table tablespace name> LOB(BLOCK_DATA) STORE AS ( # TABLESPACE <lob segment tablespace_name> ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE) " BLK_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 # TABLESPACE <BLK Table tablespace name> NOLOGGING" UI_TEXT "User Interface text for DEFAULTS" XML_DOC_UNCOMPRESSED_TYPE "CLOB" XML_IDX_TEXT_UPDATE_METHOD "NONE" XML_DOC_MODE "COMPRESSED" XML_DOC_LOB_STORAGE "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW" TABLESPACE SDE_XML XML_DOC_VAL_LOB_STORAGE "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW" TABLESPACE SDE_XML XML_DOC_STORAGE "PCTFREE 0 INITRANS 4" TABLESPACE SDE_XML XML_DOC_INDEX "PCTFREE 0 INITRANS 4 TABLESPACE SDE_XML NOLOGGING" XML_IDX_STORAGE "PCTFREE 0 INITRANS 4" TABLESPACE SDE_XML XML_IDX_TEXT_TAG_STORAGE "" XML_IDX_INDEX_PK "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING" XML_IDX_INDEX_ID "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING" XML_IDX_INDEX_TEXT "" XML_IDX_TEXT_UPDATE_MEMORY "" XML_IDX_INDEX_TAG "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING" XML_IDX_INDEX_DOUBLE "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING" XML_IDX_INDEX_STRING "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING" XML_COLUMN_STORAGE "SDE_XML" # Example for setting XML_COLUMN_STORAGE to native XML type. #XML_COLUMN_STORAGE "DB_XML" #XMLDB_INDEX_TAG "YES" #XMLDB_INDEX_FULLTEXT "NO" END But for my surprise i view the information about the Spatial Index for a layer is created in TableSpace = Null What could be the reason ? Please input your valuable comments My Environment: RHEL 6, Oracle 11.2.0.3.0, ArcSDE 10.1 SP1 With best regards Thanks Abdullah

‎05-06-2013

Dear All, In ArcCatalog, a layer in geodatabase, shows the table but when i switch to geography option it shows nothing. I tried to open that layer in ArcMap it gives out below error "Warning, Inconsistent extent One or more of the added layers has an extent that is not consistent with the assosciated spatial reference information. Reprojecting the data in such a layer may lead to unexpected behaviour. Use ArcCatalog to confirm the spatial reference is correct and adjust if necessary" When i checked sde logs, i found error "Load_buffer error -51 on layername, rowid -1" Previous day it was working fine. Environment: RHEL 5, Oracle 11.2.0.2.0, ArcSDE 9.3 SP1 Please look into this issue. -Abdullah

‎04-23-2013

Problem has been solved. I found a better way of having this done. Case closed! Thanks. Hey Dude, I was wondering how did you solve the issue. Please let me know, i need the solution. Thanks -AS

‎04-21-2013

Update: The above error is resolved by fixing the privilege. i.e. granting the privilege execute on DBMS_SQL to the Schema account. But unfortunately, the paste once again failed as it gives out below error, "Failed to paste "LayerName" Underlying DBMS error [ORA-04020: deadlock detected while trying to lock object SDE.ST_DOMAIN_METHODS] Trying to resolve this issue ..... Thanks -AS

‎04-19-2013

Thanks all for excellent support. The issue behind the scene was related to oracle user's expired credentials. It was continiously trying to connect through a service leading to large number of process creation in Oracle. As there was no successful connection, no information entry found in Process_Information table. Resetting the password worked out and processes got back to normal. -Abdullah Saleh

‎04-16-2013

Dear Admins, When a user initiates a connection through ArcGIS Desktop application. It creates a process in Oracle RDBMS. as user disconnects or exits the application, the Oracle process must quit i beleive, but it is remaining back in Oracle RDBMS as Orphaned process leading to hang the system as at a point it is reaching maximum number of processes allowed. Please help me out with your great ideas and experiences. Environment: ORACLE RDBMS 11g, ArcSDE 9.3, RHEL 5, TCPKEEPALIVE=TRUE Thanks in advance Abdullah

‎04-13-2013

Thanks for your response, it's really helpful. Hi Zhang, You can specify the question is answered. It will be helpful for other members. Thanks Best Regards |Abdullah

‎04-10-2013

You should probably contact Tech Support, since I don't think your install procedure succeeded. Your alternative is to reinstall from scratch, then if it fails again, contact Tech Support. DO NOT UNDER ANY CIRCUMSTANCES DROP THE SDE USER WHILE GIS DATA OWNERS HAVE TABLES WITH ST_GEOMETRY TYPE COLUMNS -- THIS WILL CORRUPT YOUR ORACLE INSTANCE. - V Even i doubt that the SDE tablespaces are not as less as 35MB. I will cross check the space SDE System tables aquires, if anyone else has the ArcSDE 10.1 installed. Anyways thank you so much for the guidence. Will share the updates with you. Thanks -AS

‎04-09-2013

Vince, FYR, Error 1: Paste Failed Failed to paste NAMEOFLAYER Underlying DBMS error [ORA-29876: failed in the execution of the ODCIINDEXDELETE routine ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SQL", line 1199 ORA-06512: at "SDE.SPX_UTL", line 1860 ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2237 ][SDE.GDB_Items][STATE_ID=0] Underlying DBMS error [ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SQL", line 1199 ORA-06512: at "SDE.SPX_UTL", line 1860 ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2237 ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2371 ][SDE.GDB_Items] Another thing i want to make sure about is the size of the tables in SDE user after "Enable Enterprise Geodatabase" is successful. I alloted 1GB for SDE tablespace. It is filled 3.5%. i.e. 35MB only. Is it normal ? Thanks for you interest -AS

‎04-09-2013

Yup, Vince It was a typo. It is ST_GEOMETRY. Please find the errors attached. Thanks -AS

‎04-08-2013

Dear Admins, We installed new server with RHEL 6, Oracle 11.2.0.3.0, ArcSDE 10.1. Our old server is on RHEL 5, Oracle 10.2.0.3, ArcSDE 9.3. When i tried to import the feature class to new server or copy the feature class from old to new one, migrate storage etc. I faced errors given below. I donot know whether it is because of the change of Geometry type, as in 9.3 we used to have SDEBINARY and in 10.1 we have ST_BINARY. Please look into this issue. 1. Error 000210: Cannot create output Database Connections\ ... 2. Failed to paste [FeatureClassName] Underlying DBMS error [ORA-00604: error occurred at recursive SQL level 1 ORA- 04063 ... ORA- 06508 ... 3. ERROR 000955: Error encountered migrating the database storage ... Thanks Abdullah

‎03-09-2013

Dear All, I am trying to trace account being locked intermittently.I found this error in ArcSDE Log files. Can anyone explain what exactly it means " [Sun Mar 10 07:13:06 2013] [1103747] [srv2]:5 234926078 :6 120152181 :7 225834855 :8 112615086 DB_open_instance()::db_connect (OCI8) error: 28000 SDE_Oracle Error: 28000 ORA-28000: the account is locked CAN'T OPEN INSTANCE: sdepro. Spatial Engine Connection Failed (-51). Cannot Get Access to Instance sdelb " I understand that 1103747 - SDE ID Server Name: srv2 :5 234926078 - What does this mean :6 120152181 - What does this mean :7 225834855 - What does this mean :8 112615086 - What does this mean Thanks in advance Abdullah Saleh

‎03-03-2013

As i was guessing, Since the user stopped running heavy caching process, SDE is back to normal. We do not face any HANG's now. Thanks all for your contribution. -AS

‎03-01-2013

I repeat: There is no way to trace a hang in the ArcSDE logs. Keep in mind that a service hang is 'giomgr' failure, while an application crash is 'gsrvr' failure. There should be no correlation at all between the two (except an unsupported database release). - V PS: Migration to 10.1 won't help with an old Oracle instance. ArcSDE 9.3 and 10.1 were both certified with Oracle 10.2.0.3. If you're not running at least 10.2.0.3, then that is the cause of your hangs. It will be RHEL 6.2, Oracle Database 11g Enterprise Edition 11.2.0.3.0 64bit Production, ArcSDE 10.1 -AS

‎02-26-2013

The best possible source for Oracle hangs is using Oracle 10.2.0.1 (which is unsupported) (and very buggy -- it should not be used). All 9.3 instances should have been upgraded to 9.3.1 SP2 years ago, after it was released. There is no way to trace a hang in the ArcSDE logs. - V Vince I agree with you to move our system to the recommended versions. And we are planned to migrate to 10.1 within few days. Meanwhile i need to support the users, and struggling for that. I hope you understand the situation. Dear Let me ask you a question I feel that some limitations which are set in GIOMGR is been exceeded by a user who is running cache process. Is there a way to find the entries in GIOMGR has been exceeded by any process that leads to HANGING ? Thanks for your support -AS

Online Status	Offline
Date Last Visited	‎12-01-2025 02:32 AM

My Ideas

Latest Contributions by User35489

Spatial Indexes shows Tablespace Null ???

Layer View Error

Re: Copy Feature class Geometry field to another Feature Class Geometry Field using

Re: Data Load Issue

Re: ArcSDE - Oracle Processes Issue

ArcSDE - Oracle Processes Issue

Re: ArcSDE should support zlinux (SLES or RHEL for System z, IBM Mainframe)

Re: Data Load Issue

Re: Data Load Issue

Re: Data Load Issue

Data Load Issue

SDE Log Contents

Re: Arcsde Service "hangs" intermittently

Re: Arcsde Service "hangs" intermittently

Re: Arcsde Service "hangs" intermittently

Sample Interval Custom Option

Re: ArcGIS Desktop License Deauthorize Issue

Display Coded value from Domains instead of Descri...

Re: Related records don't display in new Map Viewe...

Re: Disable Services Directory Access To Selected ...

Python AddIns

Cartography and Maps