locks

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

locks

Roshan
Oracle DB 19c

Hello Erman,

kindly advise why locks are created on RAC servers in temp folder?

drwxr-xr-x. 2 root root     4096 Aug  4 12:38 lock
prw-r--r--. 1 root root        0 Aug  4 12:39 npohasd
prw-r--r--. 1 root root        0 Aug  4 12:39 npohasd2
-rw-r--r--. 1 root root        0 Aug  4 12:39 sprocr_local_conn_0_PROL_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 sprocr_local_conn_0_PROL
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_INIT_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_INIT
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_scls_opct_t24dr01_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_scls_opct_t24dr01
-rw-r--r--. 1 root root        0 Aug  4 12:39 sOHASD_IPC_SOCKET_11_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 sOHASD_IPC_SOCKET_11
-rw-r--r--. 1 root root        0 Aug  4 12:39 sOHASD_UI_SOCKET_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 sOHASD_UI_SOCKET
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_MDNSD_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_MDNSD
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_EVMD_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_EVMD
-rw-r--r--. 1 grid oinstall    6 Aug  4 12:39 mdnsd.pid
srwxr-xr-x. 1 grid oinstall    0 Aug  4 12:39 mdnsd
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_GPNPD_t24dr01_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_GPNPD_t24dr01
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_GPNPD_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_GPNPD
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 sAevm_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 sAevm
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 sSYSTEM.evm.acceptor.auth_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 sSYSTEM.evm.acceptor.auth
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_GIPCD_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_GIPCD
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_gipcd_t24dr01_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_gipcd_t24dr01
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_MOND_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_MOND
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_st24dr01CRFM_MIIPC_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_st24dr01CRFM_MIIPC
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_st24dr01CRFM_CLIIPC_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_st24dr01CRFM_CLIIPC
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_agent_ag_CSSDAG_z_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_agent_ag_CSSDAG_z
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_monitor_ag_CSSDAG_z_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_monitor_ag_CSSDAG_z
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_CSSD_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_t24dr01_CSSD
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 sOCSSD_LL_t24dr01__lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 sOCSSD_LL_t24dr01_
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_css_ctrllcl_CSSD_BCCM_loc                                                                             k
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 ora_gipc_css_ctrllcl_CSSD_BCCM
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 sOracle_CSS_LclLstnr_t24dr-cluster                                                                             _1_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 sOracle_CSS_LclLstnr_t24dr-cluster                                                                             _1
-rw-r--r--. 1 grid oinstall    0 Aug  4 12:39 sOCSSD_LL_t24dr01_t24dr-cluster_lo                                                                             ck
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:39 sOCSSD_LL_t24dr01_t24dr-cluster
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_CTSSD_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_CTSSD
-rw-r--r--. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_CRSD_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:39 ora_gipc_t24dr01_CRSD
-rw-r--r--. 1 root root        0 Aug  4 12:40 sprocr_local_conn_0_PROC_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:40 sprocr_local_conn_0_PROC
-rw-r--r--. 1 root root        0 Aug  4 12:40 sCRSD_IPC_SOCKET_11_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:40 sCRSD_IPC_SOCKET_11
-rw-r--r--. 1 root root        0 Aug  4 12:40 ora_gipc_st24dr01CRFM_SIPC_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:40 ora_gipc_st24dr01CRFM_SIPC
-rw-r--r--. 1 root root        0 Aug  4 12:40 sora_crsqs_lock
-rw-r--r--. 1 root root        0 Aug  4 12:40 sCRSD_UI_SOCKET_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:40 sCRSD_UI_SOCKET
srwxrwxrwx. 1 root root        0 Aug  4 12:40 sora_crsqs
-rw-r-----. 1 grid oinstall    0 Aug  4 12:40 ora_gipc_t24dr01_CHAD_lock
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 ora_gipc_t24dr01_CHAD
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 sLISTENER
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 s#17101.2
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 s#17101.1
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 sLISTENER_DG
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 s#17107.2
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 s#17107.1
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 sASMNET1LSNR_ASM
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 s#17177.2
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:40 s#17177.1
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:45 sLISTENER_SCAN2
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:45 s#27285.1
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:45 s#27285.2
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:45 sLISTENER_SCAN3
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:45 s#27325.1
srwxrwxrwx. 1 grid oinstall    0 Aug  4 12:45 s#27325.2
-rw-r--r--. 1 root root        0 Aug  4 12:48 ora_gipc_t24dr01_LOGD_lock
srwxrwxrwx. 1 root root        0 Aug  4 12:48 ora_gipc_t24dr01_LOGD
[root@t24dr01 .oracle]# pwd
/var/tmp/.oracle

Thanks,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: locks

ErmanArslansOracleBlog
Administrator
.oracle is an hidden directory.. "." there makes it hidden :)
normally there are socket files there. But it seems lock files are also there.
They should not be there when all the CRS services are down, including the database..
Lock files are for file level locking purposes.. That description is universal.. The presence of lock files prevents simultaneous access of a resource to multiple files trying to access that resource. For instance if a process sees a lock file there, it won't continue its processing.. It is a serialization mechanism.. It is by design.. It is in the Oracle code.

For instance; suppose there is a program, and it should be run alone(by design)..  There should be only one instance of it, running.. So as a developer (who develops this program), you may design this program to check a specific lock file , and if it is there, directly exit processing.. If it is not, just create a lock file there and continue processing.. I guess you understand what I mean.

For removing the socket files there ;
How to remove Network socket files in a RAC Environment for Cluster/Resource startup issues (Doc ID 2099377.1)

Just a note -> do NOT remove those while Oracle software is running on the server.