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 |
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. |
Free forum by Nabble | Edit this page |