In this post we can see that how many background processes will come after starting the Oracle 18c Database on virtual box. Also we can create listener in Read Only Home to connect the database remotely with the help of tns entry.
Let me start the newly created 18c Database.
Configured the Listener Manually or with netmgr. Notice that it’s under Read Only Home path.
Now we need to create the tnsnames.ora.
Now we are connecting the newly created 18C database remotely with the help of TNS
Below are the some background processes in Oracle 18c database.
[oracle@18c admin]$ ps -ef|grep tns root 15 2 0 02:40 ? 00:00:00 [netns] oracle 6141 1 0 02:46 ? 00:00:00 /u01/app/oracle/product/18.0.0.0/db_1/bin/tnslsnr LISTENER_18C -inherit oracle 8818 4479 0 03:48 pts/0 00:00:00 grep --color=auto tns [oracle@18c admin]$ [oracle@18c dbs]$ ps -ef|grep ORCL18C oracle 6827 1 0 03:00 ? 00:00:00 ora_pmon_ORCL18C oracle 6829 1 0 03:01 ? 00:00:00 ora_clmn_ORCL18C oracle 6831 1 0 03:01 ? 00:00:00 ora_psp0_ORCL18C oracle 6833 1 0 03:01 ? 00:00:00 ora_vktm_ORCL18C oracle 6837 1 0 03:01 ? 00:00:00 ora_gen0_ORCL18C oracle 6841 1 0 03:01 ? 00:00:00 ora_mman_ORCL18C oracle 6843 1 0 03:01 ? 00:00:00 ora_gen1_ORCL18C oracle 6846 1 0 03:01 ? 00:00:00 ora_diag_ORCL18C oracle 6848 1 0 03:01 ? 00:00:00 ora_ofsd_ORCL18C oracle 6851 1 0 03:01 ? 00:00:00 ora_dbrm_ORCL18C oracle 6853 1 0 03:01 ? 00:00:00 ora_vkrm_ORCL18C oracle 6855 1 0 03:01 ? 00:00:00 ora_svcb_ORCL18C oracle 6857 1 0 03:01 ? 00:00:00 ora_pman_ORCL18C oracle 6859 1 0 03:01 ? 00:00:00 ora_dia0_ORCL18C oracle 6861 1 0 03:01 ? 00:00:02 ora_dbw0_ORCL18C oracle 6863 1 0 03:01 ? 00:00:08 ora_lgwr_ORCL18C oracle 6865 1 0 03:01 ? 00:00:01 ora_ckpt_ORCL18C oracle 6867 1 0 03:01 ? 00:00:00 ora_smon_ORCL18C oracle 6872 1 0 03:01 ? 00:00:00 ora_smco_ORCL18C oracle 6880 1 0 03:01 ? 00:00:00 ora_w000_ORCL18C oracle 6886 1 0 03:01 ? 00:00:00 ora_reco_ORCL18C oracle 6891 1 0 03:01 ? 00:00:00 ora_w001_ORCL18C oracle 6898 1 0 03:01 ? 00:00:00 ora_lreg_ORCL18C oracle 6903 1 0 03:01 ? 00:00:00 ora_pxmn_ORCL18C oracle 6914 1 0 03:01 ? 00:00:00 ora_mmon_ORCL18C oracle 6918 1 0 03:01 ? 00:00:00 ora_mmnl_ORCL18C oracle 6922 1 0 03:01 ? 00:00:00 ora_tmon_ORCL18C oracle 6966 6965 48 03:02 ? 00:07:12 oracleORCL18C (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 6973 1 0 03:02 ? 00:00:00 ora_tt00_ORCL18C oracle 6975 1 0 03:02 ? 00:00:00 ora_tt01_ORCL18C oracle 6977 1 0 03:02 ? 00:00:00 ora_tt02_ORCL18C oracle 6979 1 0 03:03 ? 00:00:00 ora_w002_ORCL18C oracle 6981 1 0 03:03 ? 00:00:00 ora_aqpc_ORCL18C oracle 6983 1 0 03:03 ? 00:00:00 ora_qm02_ORCL18C oracle 6985 1 0 03:03 ? 00:00:00 ora_q001_ORCL18C oracle 6997 1 0 03:03 ? 00:00:00 ora_w003_ORCL18C oracle 6999 1 0 03:03 ? 00:00:00 ora_w004_ORCL18C oracle 7014 1 0 03:03 ? 00:00:00 ora_w005_ORCL18C oracle 7016 1 0 03:03 ? 00:00:00 ora_w006_ORCL18C oracle 7018 1 0 03:03 ? 00:00:00 ora_w007_ORCL18C oracle 7371 1 0 03:16 ? 00:00:00 ora_m000_ORCL18C oracle 7373 1 0 03:16 ? 00:00:00 ora_m001_ORCL18C [oracle@18c dbs]$
Stay tuned for More articles on Oracle 18c
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
Hi
is media available for install & explore InHouse servers?
is exadata media can be installed locally, please suggest
No, media is not available for InHouse and Offically Exadata is appliance, we can not installed it
what an article! Start a listener, connect and list the processes-very useful indeed