How to Fix [ORA-12162 TNS:net service name is incorrectly specified] Error in Oracle | Technodope

Sign in with Facebook

Google

Technorati

Tips and Tricks

How to Fix [ORA-12162 TNS:net service name is incorrectly specified] Error in Oracle

How to Fix [ORA-12162 TNS:net service name is incorrectly specified] Error in Oracle

Tech - Tips and Tricks

Posted by Anand Kahaly in Tips and Tricks on June 14, 2010 | 0 Comments

The error [ORA-12162 TNS:net service name is incorrectly specified] is very misleading. The first thing that hits you is, there is something wrong with tnsnames.ora. In reality it has nothing to do with tnsnames.ora. This arises if you have not set ORACLE_HOME and ORACLE_SID. I faced this problem while installing Oracle11gR1 on Suse Linux 10.

order cialis online

To solve [ORA-12162 TNS:net service name is incorrectly specified] error you just have to set ORACLE_HOME and ORACLE_SID. In Unix system, type the following commands as Oracle user:

prompt:\> export ORACLE_HOME=/oracle/app/oracle/product/11.1.0/db_1
prompt:\> export ORACLE_SID=orcl

Where orcl is the database name which you give while running dbca. Its orcl by default. In Windows systems the solution is same, you just have to set ORACLE_HOME and ORACLE_SID.

Tags:

Related Articles

If you found this article helpful, please consider subscribing to Technodope Newsletter.

Email

Drucken

Favoriten

Myspace

Stumbleupon

Digg

MR. Wong

Technorati

aol

blogger

google

reddit

Yahoo

WebSzenario

blog comments powered by DISQUS back to top

More posts by this author

Subscribe to Technodope Newsletter

Post a Job Here for only $10 !!!

Sponsored Links

Tags ...

Most Popular
Most Read
Random
Latest

Chronological Archive

2013 (194)
- May (47)
- April (101)
  - • 30 - NLIT Summit 2013
  - • 30 - NLIT Summit 2013
  - • 30 - NLIT Summit 2013
  - • 30 - Oregon Digital Government Summit 2013
  - • 30 - Georgia GMIS Spring Conference 2013
  - • 30 - Joint Warfighting Customer Appreciation Event
  - • 30 - Platform-as-a-Service tour
  - • 14 - Live Chat Recap with $99 Linux Supercomputer’s Andreas Olofsson
  - • 30 - Red Hat Satellite Network open demo series
  - • 30 - How To Make Android Multi-Touch Coding Simpler with GestureDetector
  - • 30 - Enterprise Caching Solutions using IBM WebSphere DataPower SOA Appliances and IBM WebSphere eXtreme Scale
  - • 30 - 6 Key New Features in Linux 3.9
  - • 29 - Announcing Outreach Program for Women Internships for the Linux Kernel: Please Apply
  - • 29 - Slideshow: 7 Android and Linux Smartwatches
  - • 26 - Gallery : 7 Android- and Linux-Based Smartwatches Available
  - • 26 - Gallery : 7 Android and Linux-Based Smartwatches
  - • 25 - IT modernization strategies: Proactively evolve your IT portfolio
  - • 26 - Governing Operational Decisions in an Enterprise Scalable Way
  - • 25 - PCLinuxOS So Cool Ice Cubes are Jealous
  - • 26 - Friday Funnies : Google Glass Top 3 Concerns
  - • 25 - WebSphere Application Server: New Features in V8.5.5
  - • 25 - Modernizing z/OS Applications with Decision Management and BPM
  - • 25 - Student Shares Feedback on Virtual Linux Training
  - • 25 - IBM and Cisco: Together for a World Class Data Center
  - • 25 - IBM Business Process Manager Version 8.0 Production Topologies
  - • 25 - IBM Makes Push for Open Source Virtualization with KVM
  - • 25 - Jim Zemlin at TEDx: What We've Learned from Linus Torvalds
  - • 24 - Public sector intelligent integration roundtable
  - • 24 - Boosting Linux Power Efficiency with Kernel Scheduler Updates
  - • 24 - Improving Productivity with IBM ISPF Productivity Tool V7.1 for z/OS
  - • 24 - Git Turns 8, Sees Wide Adoption in the Enterprise
  - • 22 - Android Application Development Tutorial: How to Handle Multi-Touch
  - • 22 - Environment Isolation in IBM PureApplication System
  - • 22 - $45 BeagleBone Black Keeps Eyes on the Pi's
  - • 21 - Application security: Take precautions now, avoid possible breaches later
  - • 20 - Implementing the IBM BladeCenter S Chassis
  - • 19 - The Interconnecting of Everything
  - • 19 - IBM Flex System and PureFlex System Network Implementation
  - • 18 - Applying Lean, Six Sigma, BPM, and SOA to Drive Business Results
  - • 18 - Applying Lean, Six Sigma, BPM, and SOA to Drive Business Results
  - • 18 - Applying Lean, Six Sigma, BPM, and SOA to Drive Business Results
  - • 18 - Applying Lean, Six Sigma, BPM, and SOA to Drive Business Results
  - • 17 - How to Bring More Women to Free and Open Source Software
  - • 17 - Gallery : Collaboration Summit 2013 Day Two, Technical Prese
  - • 17 - Gallery : Collaboration Summit 2013 Day Two
  - • 16 - 5 Favorite Sessions from Collaboration Summit Attendees
  - • 15 - 5 Great Quotes of the Day from the Linux Foundation Collaboration Summit
  - • 15 - Jon Corbet's Linux Forecast, Netflix and More from Collaboration Summit
  - • 15 - Friday Funnies : All Star Wars, all the time
  - • 15 - Talks by Jaguar Land Rover, Samsung, Adapteva Underscore Industry Trend Toward Collaboration
  - • 10 - Implementing SmartCloud Entry on IBM PureFlex System
  - • 15 - Welcome Xen as a Linux Foundation Collaborative Project
  - • 15 - You're Invited: Design the Future of Automotive Infotainment
  - • 14 - How open software-based storage is disrupting the storage market
  - • 14 - Live Chat Recap with $99 Linux Supercomputer’s Andreas Olofsson
  - • 12 - Linux in the mainstream
  - • 12 - Red Hat's John Mark Walker: The Open Cloud Needs Open Storage
  - • 12 - Enabling Mobile Apps with IBM Worklight Application Center
  - • 12 - IBM Financial Transaction Manager for Corporate Payment Services
  - • 11 - The People Who Support Linux: Tony Awtrey, Linux Developer and Opera Singer
  - • 11 - How to Monitor, Benchmark, Use a Calendar, and Play Games in the Linux Terminal
  - • 10 - The forecast for UNIX: Hazy and overcast
  - • 11 - IBM Business Process Manager V8.0 Performance Tuning and Best Practices
  - • 11 - IBM SAN and SVC Stretched Cluster and VMware Solution Implementation
  - • 11 - Gallery : Collaboration Summit 2013 Day Two: Xen's Birthday
  - • 11 - Gallery : Collaboration Summit 2013 Day One Photos
  - • 11 - My Linux Foundation Collaboration Summit Picks and Details on Live Video Access to Keynotes
  - • 11 - Improve Design and Deployment of Processes Using IBM Business Process Manager V8.0
  - • 11 - IBM Financial Transaction Manager for SEPA Services
  - • 11 - IBM FlashSystem 710 and IBM FlashSystem 810
  - • 11 - IBM FlashSystem 720 and IBM FlashSystem 820
  - • 10 - James Gosling Smartens up Floating Robot with Linux/Java Regulus OS
  - • 10 - 6 (More) Signs the Open Source Cloud Is Gaining Ground
  - • 09 - IBM Systems Director 6.3 Best Practices: Installation and Configuration
  - • 08 - ODROID-U2 Part 2: Benchmarking the ARM Beast
  - • 05 - Live Chat Recap with $99 Linux Supercomputer’s Andreas Oloffson
  - • 08 - Prolifics Insight for Improving Customer Loyalty through Business Process Optimization and Advanced Business Analytics
  - • 08 - OpenDaylight Project Marks New Dawn for Software-Defined Networking
  - • 05 - IBM Flex System NAS Solutions
  - • 05 - IBM Power Systems HMC Implementation and Usage Guide
  - • 05 - Automated Conversions to IBM DB2 for z/OS
  - • 05 - Building and Implementing a Social Portal
  - • 05 - Review: The Surprising SUSE Linux
  - • 02 - 5 must-haves for your enterprise Platform-as-a-Service (PaaS)
  - • 05 - 10 Hot New Linux-Ready Embedded ARM Modules
  - • 04 - Experiences with Oracle 11gR2 on Linux on System z
  - • 04 - Experiences with Oracle 11gR2 on Linux for System z
  - • 04 - Gallery : 10 Hot New Linux-Ready Embedded ARM Modules
  - • 04 - Gallery : 30 Linux Kernel Developers in 30 Weeks, Part 1
  - • 04 - OpenStack 'Grizzly' Debuts with More Than 200 New Features
  - • 03 - HTML5 and Qt, Two Popular Tools for Embedded Linux Application Development
  - • 03 - Rapid Data Backup and Restore Using NFS on IBM ProtecTIER TS7620 Deduplication Appliance Express
  - • 03 - Friday Funnies : Keep The Cash
  - • 03 - z/TPF Application Modernization using Standard and Open Middleware
  - • 03 - Law Librarian Creates LibreOffice, gscan2PDF How-to Videos for 100 Linux Tutorials Campaign
  - • 02 - Taste of Training: Building applications using CDI with JBoss
  - • 03 - Real-time Fraud Detection Analytics on IBM System z
  - • 02 - Get started with Red Hat JBoss Fuse
  - • 02 - IBM Real-time Compression Appliance Version 4.1
  - • 01 - How to Run Linux on ODROID-U2: A Monster of an ARM Machine
  - • 01 - Jon Corbet Mulls Linux Kernel Changes
- March (46)
2012 (6)
- December (4)
  - • 14 - NOAALink Expo 2013
  - • 14 - Collaborating in the Clouds 2013
  - • 14 - OSSI DHS Industry Day 2013
  - • 31 - Defining the Cloud for Government
- November (2)
  - • 14 - Red Hat Enterprise Virtualization Technical Workshop 2012
  - • 14 - NextGov Prime 2012

Powered by mod LCA

Posts ...

Popular Posts
Latest Posts