(021) 29427411 ext. 12

    Sometime we face situation to install postgresql in server environment without internet connection. Bellow is step – by – step to manually install postgresql locally. Installation Steps: # rpm -ivh postgresql94-libs-9.4.5-1PGDG.rhel6.x86_64.rpm warning: postgresql94-libs-9.4.5-1PGDG.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY Preparing… ################################# [100%] Updating / installing… 1:postgresql94-libs-9.4.5-1PGDG.rhe################################# [100%] # rpm -ivh postgresql94-9.4.5-1PGDG.rhel6.x86_64.rpm warning: postgresql94-9.4.5-1PGDG.rhel6.x86_64.rpm: […]

    Read More

    The below query can be used for determining the if any object locked in an oracle database. select   c.owner,  c.object_name,  c.object_type,  b.sid,  b.serial#, b.status, b.osuser, b.machine from v$locked_object a , v$session b, dba_objects c where b.sid = a.session_id and a.object_id = c.object_id; And if you need to kill any session you can use the below […]

    Read More