ORACLE 11G R2 安装好以后连接不进去
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 23 19:39:05 2011Copyright (c) 1982, 2009, Oracle. All rights reserved.Enter user-name: SYSTEM Enter password: ERROR:ORA-12162: TNS:net service name is incorrectly specified安装环境是cent os 6.0
在用户密码那边我是在sys、system。。。使用相同的密码,密码设置的很简单,所以oracle安装的时候有提示,我也没有认真看,就确定了。后面用我安装时候设置的密码在sqlplus登录不进去。使用默认的密码也可以。
OEM也进不了,firefox的版本是很新的,用ps -ef | grep oralce oralce的进程有在跑的。
求解!!!
[zeng@www Desktop]$ su - oracle
Password:
-bash-4.1$ echo $ORACLE_SID
sales
-bash-4.1$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1
-bash-4.1$
-bash-4.1$ oerr ora 12162
12162, 00000, "TNS:net service name is incorrectly specified"
// *Cause: The connect descriptor corresponding to the net service name in
// TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is
// incorrectly specified.
// *Action: If using local naming make sure there are no syntax errors in
// the corresponding connect descriptor in the TNSNAMES.ORA file. If using
// directory naming check the information provided through the administration
// used for directory naming.
使用服务名连接是出现的错误。
oerr ora 12541
12541, 00000, "TNS:no listener"
// *Cause: The connection request could not be completed because the listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.
-bash-4.1$ echo $ORACLE_SID