Hello Friends,

Welcome you back on exciting topic, today’s session is on

CPT 4: Connecting to the Database Instance - listener.ora - Client Connection

Server Process:
--- Dedicated Server process
--- Shared Server Process

Sample listener.ora file:
LISTENER_DEVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbnode1.localdomain.com)(PORT = 1522))
)
ADR_BASE_LISTENER_DEVDB = /u01/app/oracle

DEMO:
Show TNS_ADMIN location and listener.ora file
select sid, server from v$session;


#tnsnames #listener #Connection #oracle #database #Instance #architecture #databaseadministration #dba #RAC

Please do follow me and support me on,

LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg


Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg