2009-12-20 设置Sybase用户的环境变量

在SUSE Linux Enterprise Server 10 SP2上安装完Adaptive Server Enterprise version 15.5 Developer's Edition，测试连接数据库服务器却发现：

sybase@localhost:~/OCS-15_0/bin> isql -SLOCALHOST -Usa -P

[@more@]**********************************************
* unixODBC - isql *
**********************************************
* Syntax *
* *
* isql DSN [UID [PWD]] [options] *
* *
* Options *
* *
* -b batch.(no prompting etc) *
* -dx delimit columns with x *
* -x0xXX delimit columns with XX, where *
* x is in hex, ie 0x09 is tab *
* -w wrap results in an HTML table *
* -c column names on first row. *
* (only used when -d) *
* -mn limit column display width to n *
* -v verbose. *
* -lx set locale to x *
* --version version *
* *
* Notes *
* *
* isql supports redirection and piping *
* for batch processing. *
* *
* Examples *
* *
* cat My.sql | isql WebDB MyID MyPWD -w *
* *
* Each line in My.sql must contain *
* exactly 1 SQL command except for the *
* last line which must be blank. *
* *
* Please visit; *
* *
* http://www.unixodbc.org *
* pharvey@codebydesign.com *
* nick@easysoft.com *
**********************************************

原来执行的是unixODBC的isql，而不是Sybase的isql：

sybase@localhost:~> which isql
/usr/bin/isql
sybase@localhost:~> rpm -qf /usr/bin/isql
unixODBC-2.2.11-21.4
sybase@localhost:~> pwd
/opt/sybase
sybase@localhost:~> find . -name isql
/opt/sybase/OCS-15_0/bin/isql

这是因为没有设置sybase用户的环境变量。在软件安装目录下可以找到一个包含环境变量设置的文件：

sybase@localhost:~> ls -lh SYBASE.sh
-rwxr-xr-x 1 sybase sybdba 1.3K 2009-12-20 17:11 SYBASE.sh
sybase@localhost:~> head SYBASE.sh
#
# Sybase Product Environment variables
#
SYBASE_JRE6_32="/opt/sybase/shared/JRE-6_0_6_32BIT"
export SYBASE_JRE6_32
SYBASE_JRE6="/opt/sybase/shared/JRE-6_0_6_32BIT"
export SYBASE_JRE6
SYBASE="/opt/sybase"
export SYBASE
SYBASE_OCS="OCS-15_0"

将该文件的内容添加到.bashrc文件中：

sybase@localhost:~> cp .bashrc .bashrc_bak
sybase@localhost:~> echo "" >> .bashrc
sybase@localhost:~> cat SYBASE.sh >> .bashrc
sybase@localhost:~> tail .bashrc
PATH="/opt/sybase/ASE-15_0/bin:/opt/sybase/ASE-15_0/install":$PATH
export PATH
LD_LIBRARY_PATH="/opt/sybase/ASE-15_0/lib":$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
LD_POINTER_GUARD="1"
export LD_POINTER_GUARD
SYBASE_WS="WS-15_0"
export SYBASE_WS
PATH="/opt/sybase/ASE-15_0/jobscheduler/bin":$PATH
export PATH

退出从新切换到sybase用户，环境变量已自动设置好：

sybase@localhost:~> exit
logout
localhost:~ # su - sybase
sybase@localhost:~> which isql
/opt/sybase/OCS-15_0/bin/isql
sybase@localhost:~> isql -SLOCALHOST -Usa -P
1> quit

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11662464/viewspace-1029835/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11662464/viewspace-1029835/