Skip to content

Instantly share code, notes, and snippets.

@noodles-v6

noodles-v6/gist:3736981

Created September 17, 2012 12:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save noodles-v6/3736981 to your computer and use it in GitHub Desktop.
Save noodles-v6/3736981 to your computer and use it in GitHub Desktop.
Download ZIP
ORA-12162: TNS:net service name is incorrectly specified
Raw
gistfile1.txt
SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 30 10:20:33 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
以上问题基本上有三种原因造成
1：~.bash_profile文件中估计没有正确设置ORACLE_SID环境变量
2：检查sqlnet.ora中sqlnet.authentication_services设置
3：用orapwd重建密码文件
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment