问题描述
- inform11.7启动,数据库能创建,但是端口不知道是啥
-
启动过程如下:
[informix@localhost etc]$ oninit -v
Reading configuration file '/opt/IBM/informix/etc/onconfig.ol_informix1170_1'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 14888 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/opt/IBM/informix/etc/.infos.ol_informix1170_1"...succeeded
Linking conf file "/opt/IBM/informix/etc/.conf.ol_informix1170_1"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5sqlhosts.ol_informix1170_1文件内容:
ol_informix1170_1 onsoctcp localhost.localdomain ol_informix1170_1
dr_informix1170_1 drsoctcp localhost.localdomain dr_informix1170_1localhost.localdomain是env中显示的hostname
informix账户.bash_profile添加了内容
export INFORMIXDIR=/opt/IBM/informix
export INFORMIXSERVER=ol_informix1170_1
export ONCONFIG=onconfig.ol_informix1170_1
export INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts.ol_informix1170_1
#export INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts
export PATH=${INFORMIXDIR}/bin:${INFORMIXDIR}/extend/krakatoa/jre/bin:${PATH}
export DBDATE=y4mdetc下的onconfig.ol_informix1170_1文件也没有端口内容
现在是dbaccess能操作,也能创建数据库,就是找不到这个ol_informix1170_1服务监听端口是啥,第一次学安装linux版本的informix,打算用jdbc连接
这个数据库呢,谢谢大家赐教。
解决方案
我是按照informix默认实例安装的
解决方案二:
grep ol_informix1170_1 /etc/services
就可以查看到 informix 数据库的服务端口
解决方案三:
grep ol_informix1170_1 $INFORMIXDIR/etc/sqlhost