huilingling 发表于 2012-04-26 11:25

linux环境连接数据库不成功，帮忙解释下，谢谢！

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 发表于 2012-04-26 11:35

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

huilingling 发表于 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>

就登陆成功了呢

fengsh_china 发表于 2012-04-26 14:14

学习了

huilingling 发表于 2012-04-26 15:31

学习什么啊，还没搞明白呢？似乎是不分大小写的
回复 4# fengsh_china


   

水平展开 发表于 2012-07-31 12:12

回复 3# huilingling


    10g之前貌似不区分大小写的，10g开始区分了！

bzcat 发表于 2012-08-02 00:21

11g参数sec_case_sensitive_logon 控制
页: [1]
查看完整版本: linux环境连接数据库不成功，帮忙解释下，谢谢！