Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WHY LOCAL=YES are coming by default ..even no session is established !

JhilFeb 17 2018 — edited Feb 18 2018

Dear all,

As we know LOCAL=YES means its local connection.

I am testing on my laptop.

No sessions are established then why i am getting 4 local connections (LOCAL=YES) ??

For what purpose they are coming ?

[root@RAC1 ~]# ps -ef | grep racdb

oracle 4966 1 0 17:34 ? 00:00:00 ora_pmon_racdb1

oracle 4968 1 0 17:34 ? 00:00:00 ora_psp0_racdb1

oracle 4972 1 1 17:34 ? 00:00:08 ora_vktm_racdb1

oracle 4976 1 0 17:34 ? 00:00:00 ora_gen0_racdb1

oracle 4980 1 0 17:34 ? 00:00:00 ora_diag_racdb1

oracle 4982 1 0 17:34 ? 00:00:00 ora_dbrm_racdb1

oracle 4985 1 0 17:34 ? 00:00:00 ora_ping_racdb1

oracle 4988 1 0 17:34 ? 00:00:00 ora_acms_racdb1

oracle 4990 1 0 17:34 ? 00:00:02 ora_dia0_racdb1

oracle 4994 1 0 17:34 ? 00:00:02 ora_lmon_racdb1

oracle 4996 1 0 17:34 ? 00:00:02 ora_lmd0_racdb1

oracle 4998 1 1 17:34 ? 00:00:08 ora_lms0_racdb1

oracle 5002 1 0 17:34 ? 00:00:00 ora_rms0_racdb1

oracle 5004 1 0 17:34 ? 00:00:00 ora_lmhb_racdb1

oracle 5006 1 0 17:34 ? 00:00:01 ora_mman_racdb1

oracle 5008 1 0 17:34 ? 00:00:00 ora_dbw0_racdb1

oracle 5010 1 0 17:34 ? 00:00:00 ora_lgwr_racdb1

oracle 5012 1 0 17:34 ? 00:00:00 ora_ckpt_racdb1

oracle 5014 1 0 17:34 ? 00:00:00 ora_smon_racdb1

oracle 5016 1 0 17:34 ? 00:00:00 ora_reco_racdb1

oracle 5018 1 0 17:34 ? 00:00:00 ora_rbal_racdb1

oracle 5020 1 0 17:34 ? 00:00:00 ora_asmb_racdb1

oracle 5022 1 0 17:34 ? 00:00:01 ora_mmon_racdb1

oracle 5024 1 0 17:34 ? 00:00:00 ora_mmnl_racdb1

grid 5026 1 0 17:34 ? 00:00:00 oracle+ASM1_asmb_racdb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 5028 1 0 17:34 ? 00:00:00 ora_d000_racdb1

oracle 5030 1 0 17:34 ? 00:00:00 ora_s000_racdb1

oracle 5032 1 0 17:34 ? 00:00:00 ora_mark_racdb1

oracle 5040 1 0 17:34 ? 00:00:01 ora_lck0_racdb1

oracle 5048 1 0 17:34 ? 00:00:00 ora_rsmn_racdb1

oracle 5055 1 0 17:34 ? 00:00:01 oracleracdb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 5111 1 0 17:34 ? 00:00:00 ora_arc0_racdb1

oracle 5113 1 0 17:35 ? 00:00:00 ora_arc1_racdb1

oracle 5115 1 0 17:35 ? 00:00:00 ora_arc2_racdb1

oracle 5117 1 0 17:35 ? 00:00:00 ora_arc3_racdb1

oracle 5140 1 0 17:35 ? 00:00:00 ora_gtx0_racdb1

oracle 5142 1 0 17:35 ? 00:00:00 ora_rcbg_racdb1

oracle 5144 1 0 17:35 ? 00:00:00 ora_qmnc_racdb1

oracle 5148 1 0 17:35 ? 00:00:01 ora_q001_racdb1

oracle 5157 1 0 17:35 ? 00:00:00 oracleracdb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 5168 1 0 17:35 ? 00:00:00 oracleracdb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 5184 1 0 17:35 ? 00:00:01 ora_cjq0_racdb1

oracle 5186 1 0 17:35 ? 00:00:01 ora_vkrm_racdb1

oracle 5237 1 0 17:36 ? 00:00:00 ora_q002_racdb1

oracle 5253 1 0 17:36 ? 00:00:00 ora_gcr0_racdb1

oracle 5339 1 0 17:40 ? 00:00:00 ora_smco_racdb1

oracle 5341 1 0 17:40 ? 00:00:00 ora_w000_racdb1

root 5496 5443 0 17:44 pts/0 00:00:00 grep racdb

NOTE : This is RAC Database (11.2.0.3 running on OL 6.5)

This post has been answered by Gaz in Oz on Feb 17 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2018

Added on Feb 17 2018

#general-database-discussions

6 comments

1,661 views