论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2012-04-26 11:25 |只看该作者 |倒序浏览

linux连接数据库不成功报错如下：
linux_lbi_06 chascu/config> sqlplus CHASCPDB/CHASCPDB@CHASCPDB

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 26 11:18:47 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

tnsnames.ora 文件内容如下，

CHACBPDB=
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.71.180.80)(PORT = 1521))
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME =ora11g)
)
  )

CHASCPDB=
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.71.180.80)(PORT = 1521))
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME =ora11g)
)
  )

文库|博客

huilingling

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2012-04-26 11:35 |只看该作者

在线等啊，各位大虾帮忙看看啊！

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

huilingling

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2012-04-26 11:47 |只看该作者

oracle用户是区分大小写的吗？怎么以oracle@linux_lbi_06:~/app/product/11g/db/network/admin> sqlplus chascpdb/chascpdb@CHASCPDB

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 26 11:44:22 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

就登陆成功了呢