oracle 安装后连接,ORACLE 11G R2 安装好以后连接不进去

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值