ORA-12154: TNS:could not resolve the connect identifier specified问题求解
环境:Solaris10 oracle10g
在Solaris10上安装了oracle 10g后,一切配置完成,在Windows系统中安装了oracle客户端,使用Net Manager工具建立连接字符串后,用PLSQL工具连接Solaris上的oracle数据库正常,没出现什么问题,但是在Solaris系统中编译的程序连接数据库是却提示ORA-12154: TNS:could not resolve the connect identifier specified错误。
以前连接正常的,时间久了没用,现在重新配置就出现问题了。
Windows系统中tnsnames.ora文件内容:
SERVER1_ORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.15)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora)
)
)
Solaris系统中tnsnames.ora文件内容:
ORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora)
)
)
oracle用户环境变量文件内容:
# This is the default standard profile provided to a user.
# They are expected to edit it to meet their own needs.
MAIL=/usr/mail/${LOGNAME:?}
ULIMIT=3000000
export ULIMIT
ORACLE_SID=ora
export ORACLE_SID
ORACLE_BASE=/export/home/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10gr2
export ORACLE_HOME
ORACLE_TERM=sun5
export ORACLE_TERM
PATH=/usr/bin:/usr/ucb:/etc:$ORACLE_HOME/bin:/bin:/sbin:/usr/ccs/bin:/usr/local/bin
export PATH
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network:/usr/local/lib:/usr/lib
export LD_LIBRARY_PATH
求各位高手帮忙解决,非常感谢!