Saturday, May 28, 2022
ADVERTISEMENT
  • Home
  • Medical
    • NEET Counselling 2021 Expert Advice
    • MBBS Admission
  • Engineering
  • Management
  • Study Abroad
  • Board Results
  • Sarkari Job
  • Sarkari Result
  • Contact Us
No Result
View All Result
  • Home
  • Medical
    • NEET Counselling 2021 Expert Advice
    • MBBS Admission
  • Engineering
  • Management
  • Study Abroad
  • Board Results
  • Sarkari Job
  • Sarkari Result
  • Contact Us
No Result
View All Result
No Result
View All Result
Home Tech News

ORA 12154 tns could not resolve

Team AG by Team AG
September 13, 2020
in Tech News
Reading Time: 2 mins read
1
0
SHARES
2.1k
VIEWS
Share on FacebookShare on TwitterShare on Whatsapp

This issue is faced in some versions of oracle as ORA-12154: TNS: Could not resolve service name. Mostly this issue comes in Oracle 10g and Oracle 11g Express edition which i have faced.

When you or any application try to connect to an Oracle Service via Oracle Networking SQL*Net, it looks up the connect data for the service. When this lookup fails, Oracle client show an error message ORA-12154.

RelatedPosts

How Digital Technology is Changing the Sports Betting Industry

Hublot Watches: The Perfect Fusion of Style and Precision 

Top 10 Cryptocurrency and Blockchain Experts You Must Listen to Stay Ahead of the Curve

Sometimes this error comes when one database instance tries to connect to another database instance via database link.

ADVERTISEMENT

 

Root Cause:

You try to connect to Oracle but the service name is either missing from the TNSNAMES.ORA file or is incorrectly defined.

Resolution:

Option-1:

You have to make sure that the TNSNAMES.ORA file exists in the correct directory and accessible.

%ORACLE_HOME% /network/admin/

ADVERTISEMENT

Ex: In Oracle 11g express, it is located at below path.

C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

Option-2:

You have to make sure that the service name that you are trying to connect is included in the TNSNAMES.ORA file and that it is correctly defined.

Option-3:

Make sure that TNSNAMES is listed as one of the values of the names.directory_path parameter in the sqlnet.ora Oracle Net profile.

Option-4:

You have to make sure that the syntax of TNSNAMES.ORA file is correct.

For example, if there are unmatched brackets in the file (ie: open bracket without the corresponding close bracket), the file will be rendered unusable.

ADVERTISEMENT

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTING.COM)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

If you are still facing the same issue, please write to us in comment section. We will try to help you.

 

ADVERTISEMENT
Team AG

Team AG

Hello friends, Welcome to Admission Guidance , we are team of 5 writers aim to provide article on Engineering, Medical, Study Abroad ,MBBS, Career , Jobs, education news and Recruitment News . We always update article and provide authentic and latest notification to our users. You can subscribe to get notified.

Related Posts

digital gaming
Tech News

How Digital Technology is Changing the Sports Betting Industry

January 20, 2022
12
blog

Hublot Watches: The Perfect Fusion of Style and Precision 

October 9, 2021
41
blockchain and cryptocurrency
Tech News

Top 10 Cryptocurrency and Blockchain Experts You Must Listen to Stay Ahead of the Curve

April 29, 2021
58
3 Style Tips For Young Professionals To Look Sharp
Tech News

3 Style Tips For Young Professionals To Look Sharp 

March 30, 2021
201
Documents converter pdfbear
Tech News

Finding It Difficult To Convert Files? Use These 5 Tools (With Steps)

March 30, 2021
221
news

7 Things To Buy Before You Go On A Vacation 

November 5, 2021
24
No Result
View All Result

Download Our App

Download app

Follow Us

Google news

Telegram

 

Recent Posts

  • Best Novomatic Real Money Casinos in India May 13, 2022
  • The best slots 2022 April 29, 2022
  • SRMJEEE 2022 | SRM Joint Engineering Entrance Exam April 1, 2022
  • Bihar Board 10th Result 2022 Declared: Bihar Board 10th result released March 31, 2022
  •  Can Non-Native English Speakers Teach English as a Foreign Language? March 24, 2022

Download Our App

Download app

Categories

Admission Admit Card Answer Key Bank Jobs BDS Admission blog Board exam Board Exam result Career Commerce Defence Jobs Education Engineering Exam Exam News Govt Jobs jee main job MBA Exam Mbbs Admission MBBS Admission 2021 Medical Medical Jobs neet 2020 neet 2021 Neet Counselling NEET Counselling 2021 news Police Jobs Railway Jobs Results Sarkari Exam Sarkari Job Sarkari result Scholarship SSC Jobs Study Abroad tamilanguide TamilNadu Govt Jobs Teacher Jobs Tech News Technology University UPSC Jobs vacancy
ADVERTISEMENT

Popular Exam

★ NEET (UG) 2021
★ JEE Mains 2021
★ CAT 2020
★ ICAR AIEEA 2021
★ GATE 2021
★ NIFT 2021
★ IIFT 2021
★ SACRED 2021

Download Our App

Download app

Engineering Exams

★ JEE Main 2021
★ SRMJEEE 2021
★ VITEEE 2021
★ KIITEE 2021
★ AEEE 2021
★ MU OET 2021
★ AP EAMCET 2021
★ UPSEE 2021
★ KCET 2021

Medical

★ NEET (UG)
★ NEET (PG)
★ NEET (UG) Counselling 2021

DMCA.com Protection Status

MBA Exam

★ CAT 2021
★ SNAP 2021
★ IBSAT 2020
★ XAT 2021
★ MICAT 2021
★ MAT 2021
★ ATMA 2021

  • About Us
  • Privacy Policy
  • Disclaimer
  • Advertise With Us
  • write for us
  • Contact Us
  • Sitemap

Copyright © 2021 Admission Guidance . ALL RIGHTS RESERVED

No Result
View All Result
  • Home
  • Medical
    • NEET Counselling 2021 Expert Advice
    • MBBS Admission
  • Engineering
  • Management
  • Study Abroad
  • Board Results
  • Sarkari Job
  • Sarkari Result
  • Contact Us

Copyright © 2021 Admission Guidance . ALL RIGHTS RESERVED

wpDiscuz
1
0
Would love your thoughts, please comment.x
()
x
| Reply
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.