(3)以ingres用户访问(需修改.bash_profile)
[ingres@redflag11012602 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
#.ingVWbash
# ingresvw environment for VW installation
# Generated at installation time, any changes made will be lost
export II_SYSTEM=/user1/app/tmp
export PATH=$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility:$PATH
if [ "$LD_LIBRARY_PATH" ] ; then
LD_LIBRARY_PATH=/usr/local/lib:$II_SYSTEM/ingres/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$II_SYSTEM/ingres/lib
fi
export LD_LIBRARY_PATH
export TERM_INGRES=dumb
# .bash_profile
# Get the aliases and functions
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
#.ingVWbash
# ingresvw environment for VW installation
# Generated at installation time, any changes made will be lost
export II_SYSTEM=/user1/app/tmp
export PATH=$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility:$PATH
if [ "$LD_LIBRARY_PATH" ] ; then
LD_LIBRARY_PATH=/usr/local/lib:$II_SYSTEM/ingres/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$II_SYSTEM/ingres/lib
fi
export LD_LIBRARY_PATH
export TERM_INGRES=dumb
启动VectorWise服务有2种方式,一种是用ingstart命令,注意不能用root用户执行这个命令,另一种方式是用服务的方式启动,必须以 root用户执行/sbin/serviceingresVW start命令。只有rpm安装的软件才支持第2种方式。
[root@redflag11012602 ingres]# ingstart
Starting Ingres as root is not permitted.
[root@redflag11012602 ingres]# su - ingres
[ingres@redflag11012602 ~]$ ingstart
-bash: ingstart: command not found
[ingres@redflag11012602 ~]$ . /home/ingres/.ingVWbash
[ingres@redflag11012602 ~]$ ingstart
VectorWise/ingstart
No VectorWise servers have been configured to start up.
[ingres@redflag11012602 ~]$ /sbin/service ingresVW start
Only 'root' can control this service
[ingres@redflag11012602 ~]$ exit
logout
[root@redflag11012602 ingres]# /sbin/service ingresVW start
Ingres, instance VW has not been setup
Running setup for Ingres 1.5.0-141...
Running setup for dbms... OK
Running setup for net... OK
Running iisudbms... OK
Running iisudas... OK
Running iisuodbc... OK
Starting Ingres, instance VW: [确定]
Starting Ingres as root is not permitted.
[root@redflag11012602 ingres]# su - ingres
[ingres@redflag11012602 ~]$ ingstart
-bash: ingstart: command not found
[ingres@redflag11012602 ~]$ . /home/ingres/.ingVWbash
[ingres@redflag11012602 ~]$ ingstart
VectorWise/ingstart
No VectorWise servers have been configured to start up.
[ingres@redflag11012602 ~]$ /sbin/service ingresVW start
Only 'root' can control this service
[ingres@redflag11012602 ~]$ exit
logout
[root@redflag11012602 ingres]# /sbin/service ingresVW start
Ingres, instance VW has not been setup
Running setup for Ingres 1.5.0-141...
Running setup for dbms... OK
Running setup for net... OK
Running iisudbms... OK
Running iisudas... OK
Running iisuodbc... OK
Starting Ingres, instance VW: [确定]