CPT 3: Connecting to the Database Instance - tnsnames.ora Connection String - What is tnsnames.ora?

Опубликовано: 05 Октябрь 2024
на канале: Vismo Technologies

36,588

211

Hello Friends,

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

CPT 3: Connecting to the Oracle Database Instance - tnsnames.ora - Connection String

Parameters required for the client to connect to database
Username and Password
Hostname
DB Server name
Port Name
Protocol

Sample tnsanames.ora file:
DEVDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbnode1.localdomain.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = DEVDB)
)
)

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

Please do follow me and support me on,

LinkedIn:   / mallik034
YouTube:    / mallik034
Fakebook:   / mallik034
Blog: https://mallik034.blogspot.com
twitter:   / mallik034
Instagram:   / mallik034
FBPage:   / mallik034oracledba
Skype: malluramadurg

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