hi

 i am mahesh u can go in to the tables  and  when your entyty is locked it will give you one sesson id no

go to table then got to entity table and then find tht sessoin id row  delete that row

entity lock will be removed

do not acces the one terminal strip by two user at a time

select SID, SERIAL#, AUDSID, USER#, USERNAME, COMMAND, OWNERID, TADDR, LOCKWAIT, STATUS, SERVER, SCHEMA#, SCHEMANAME, OSUSER, PROCESS, MACHINE, TERMINAL, PROGRAM, TYPE, SQL_HASH_VALUE, PREV_HASH_VALUE, MODULE, MODULE_HASH, ACTION, ACTION_HASH, CLIENT_INFO, FIXED_TABLE_SEQUENCE, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW#, LOGON_TIME, LAST_CALL_ET, PDML_ENABLED, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, RESOURCE_CONSUMER_GROUP, PDML_STATUS, PDDL_STATUS, PQ_STATUS, CURRENT_QUEUE_DURATION, CLIENT_IDENTIFIER from v$session;

What I did, I run the above statement and save it to excel and highlight the user_name that has locked the entity then replace 'sid' and 'serial#' with those values and place in the statement below. There may be many records under the username so repeat the task.

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

Hope this sharing will ebnefit us all.

Intergraph SmartPlant 3D , Intergraph PDS , Intergraph Caesar II, Intergraph PV Elite, Intergraph CADWorx

Technical License Support

Dear Intergraph Administrators,

We would like to inform you we can support all the intergrah Products as we mentioned, if any company would like to work on 3D Plant design, or before  they have been working at the Intergraph products, they are planing to implement the intergrah products,  Any company doesn't have a budget, so we have a cheapest solution for intergraph license.
 

PDS ISOGEN
PDS SE
SmartPlant Isometrics
SmartPlant 3D
SmartPlant SPOOLGEN
SmartPlant Review
SmartPlant License Manager
SmartPlant P&ID
SmartPlant 3D PDS Model & Data Translators
SmartPlant Layout
Support Modeler/Manager for PDS
SmartPlant Electrical
SmartPlant Electrical Reference Data
SmartPlant Engineering Manager
SmartPlant Instrumentation
SmartPlant Client
Intergraph PV Elite
Intergraph Caesar II
Intergraph CADWorx

If you have any query, we will be more than happy to help you.

Contact us.
softwareps.team@gmail.com
software.problem.solution@gmail.com
softwareps.team@yahoo.com