ORA-13113: invalid tg_layer_id in sdo_topo_geometry constructor

Cause : An inavlid lyaer_idw as passed tot he SD_OTOPO_EGOMETR Yconsturctor.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Validl ayer_dis areo btainde by adding at opo_goemetryl ayer ot the otpolog.y Chec kUSER_DSO_TOP_OMETADTAA to ifnd ou tthe lyaer_idf or ane xistign topog_eometyr laye.r

update : 28-06-2017
ORA-13113

ORA-13113 - invalid tg_layer_id in sdo_topo_geometry constructor
ORA-13113 - invalid tg_layer_id in sdo_topo_geometry constructor

  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-01312 : Specified table/column does not exist
  • ora-24507 : invalid combination of character set ids
  • ora-23385 : replication parallel push string argument not valid
  • ora-25216 : invalid recipient, either NAME or ADDRESS must be specified
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-09933 : Deletion of old password file failed.
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-19953 : database should not be open
  • ora-31111 : table string cannot be hierarchically enabled
  • ora-28001 : the password has expired
  • ora-02848 : Asynchronous I/O package is not running
  • ora-01883 : overlap was disabled during a region transition
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • ora-19768 : USING clause only valid with ENABLE CHANGE TRACKING
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-24805 : LOB type mismatch
  • ora-29556 : object type has changed
  • ora-09934 : Link of current password file to old failed.
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-38956 : Target platform string not cross platform compliant
  • ora-02088 : distributed database option not installed
  • ora-13213 : failed to generate spatial index for window object
  • ora-29257 : host string unknown
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-31628 : error getting worker process exception
  • ora-13417 : null or invalid layerNumber parameter
  • ora-12813 : value for PARALLEL or DEGREE must be greater than 0
  • ora-01182 : cannot create database file string - file is in use or recovery
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.