Changing the port no of an informix instance
A user on AIX shut down an IDS 10 instance with onmode -ky, changed the port number in sqlhosts, and then oninit failed. Responders confirmed that editing the port in sqlhosts is a valid way to change it, and that an /etc/services entry isn't needed when a numeric port is used. When the poster posted oninit -v output and the online log, the real cause appeared: the root chunk /mount/fs2/rootdbs_10 was mode 770 instead of the required 660. A chmod 660 on the chunk (and checking other chunks) fixed it and the instance started.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
An informix instance inst1 is running on 9090 port in an AIX host.
I shutted down the instance through "onmode -ky" and changed the port number
in sqlhosts file. And tried to restart the instance through "oninit" command.
After that instance is not coming UP and wanted to know is it a right way to
change the port number..??
Regards
Saravanan
2009/9/17 SARAVANAN AJ <saran_psg@rediffmail.com>:
> Hi,
>
> An informix instance inst1 is running on 9090 port in an AIX host.
>
> I shutted down the instance through "onmode -ky" and changed the port number
> in sqlhosts file. And tried to restart the instance through "oninit" command.
>
> After that instance is not coming UP and wanted to know is it a right way to
> change the port number..??
>
> Regards
> Saravanan
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Saravanan
What is the error you are getting in the on-line log?
Is there any other application using the new port number?
Why did you feel the need to change the port number in the first place?
Will the instance start if you revert to the original port?
Keith
Hi Saravanan,
If you could post some more information from the Informix log file, it would
help to narrow down the possible cause.
The most likely cause is that the port number that you are changing to, is
either not specified in the /etc/services file or it is conflicting with
something else.
if you execute
grep 9090 /etc/services
you should get the format of the line that was working.
Next check for the new port number using the same command.
grep <new number> /etc/services
make sure that the name of the service is distinct for your old and new ports
in the /etc/services file.
Another possible cause is by changing the port number in the sqlhosts file,
you have created a duplicate nettype/port combination.
If this does not help, you will need to post some more information.
Regards
Mark
> To: ids@iiug.org
> From: saran_psg@rediffmail.com
> Subject: Changing the port no of an informix instance [17042]
> Date: Thu, 17 Sep 2009 04:54:55 -0400
>
> Hi,
>
> An informix instance inst1 is running on 9090 port in an AIX host.
>
> I shutted down the instance through "onmode -ky" and changed the port number
> in sqlhosts file. And tried to restart the instance through "oninit" command.
>
> After that instance is not coming UP and wanted to know is it a right way to
> change the port number..??
>
> Regards
> Saravanan
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
More than messagescheck out the rest of the Windows Live.
http://www.microsoft.com/windows/windowslive/
Hi,
/etc/services does not have the entry for this port/service. I hope it is not
required.. Because other instances are working fine in my host, those are also
not having entries in /etc/services file.
-bash-4.0# cat /mount/fs1/informix_10.0/etc/sqlhosts.inst1inst1 onsoctcp sportage 9090
Now my question is, can we change the port number of already running
instance..?? Is it possible after shutting down the instance..??
Hi,
the /etc/services file is where the operating system looks for ports to listen
on.
It is possible to change the port number on an instance that is already
running.
1. Add an entry into the /etc/services file. You already have an entry for
port 9090/tcp, just copy that line, change the port to the port that you
desire and give the port a unique name.
2. Change the entry in the sqlhosts file, using the new number.
3. Restart the database server
4. Reconfigure the clients to access the new port.
> To: ids@iiug.org
> From: saran_psg@rediffmail.com
> Subject: Re: RE: Changing the port no of an informix instan [17046]
> Date: Thu, 17 Sep 2009 05:35:23 -0400
>
> Hi,
>
> /etc/services does not have the entry for this port/service. I hope it is not
> required.. Because other instances are working fine in my host, those are
also
> not having entries in /etc/services file.
>
> -bash-4.0# cat /mount/fs1/informix_10.0/etc/sqlhosts.inst1> inst1 onsoctcp sportage 9090>
> Now my question is, can we change the port number of already running
> instance..?? Is it possible after shutting down the instance..??
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
See all the ways you can stay connected to friends and family
http://www.microsoft.com/windows/windowslive/default.aspx
Post the oninit -v output and the relevant lines from the end of the online
message log, or call IBM support.
Changing the port number in the sqlhosts file should be fine, no problems
there. Something else is going on.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Thu, Sep 17, 2009 at 4:54 AM, SARAVANAN AJ <saran_psg@rediffmail.com>wrote:
> Hi,
>
> An informix instance inst1 is running on 9090 port in an AIX host.
>
> I shutted down the instance through "onmode -ky" and changed the port
> number
> in sqlhosts file. And tried to restart the instance through "oninit"
> command.
>
> After that instance is not coming UP and wanted to know is it a right way
> to
> change the port number..??
>
> Regards
> Saravanan
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00151747365278e4360473c3cc9d
Yes, it is possible, and you don't need an /etc/services entry if you are
using a port number rather than a service name.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Thu, Sep 17, 2009 at 5:35 AM, SARAVANAN AJ <saran_psg@rediffmail.com>wrote:
> Hi,
>
> /etc/services does not have the entry for this port/service. I hope it is
> not
> required.. Because other instances are working fine in my host, those are
> also
> not having entries in /etc/services file.
>
> -bash-4.0# cat /mount/fs1/informix_10.0/etc/sqlhosts.inst1> inst1 onsoctcp sportage 9090>
> Now my question is, can we change the port number of already running
> instance..?? Is it possible after shutting down the instance..??
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0ce0edb864630f0473c3d850
Thanks for your reply.
Instance is not coming UP and the logs are mentioned below...
-bash-4.0# oninit -iv
This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run mode...succeeded
Reading configuration file
'/mount/fs1/informix_10.0/etc/onconfig.sarav1'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/mount/fs1/informix_10.0/etc/.infos.sarav1"...succeeded
Linking conf file "/mount/fs1/informix_10.0/etc/.conf.sarav1"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1444 kbytes...succeeded
Allocating 4016 kbytes for buffer pool of 4K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
FAILED
-bash-4.0#
online.log message :
------------------------
21:18:10 IBM Informix Dynamic Server Started.
Fri Sep 18 21:18:10 2009
21:18:10 Event alarms enabled. ALARMPROG =
'/mount/fs1/informix_10.0/etc/alarmprogram.sh'
21:18:10 Requested shared memory segment size rounded from 8316KB to 8320KB
21:18:10 Dynamically allocated new virtual shared memory segment (size 8320KB)
21:18:10 Memory sizes:resident:5904 KB, virtual:16512 KB, no SHMTOTAL limit
21:18:10 Booting Language <c> from module <>
21:18:10 Loading Module <CNULL>
21:18:10 Booting Language <builtin> from module <>
21:18:10 Loading Module <BUILTINNULL>
21:18:15 DR: DRAUTO is 0 (Off)
21:18:15 AIX MP latch code enabled
21:18:15 IBM Informix Dynamic Server Version 10.00.FC8 Software Serial Number
AAA#B000000
21:18:15 The chunk '/mount/fs2/rootdbs_10' must have READ/WRITE permissions
for owner and group (660).
21:18:15 IBM Informix Dynamic Server Stopped.
21:18:15 mt_shm_remove: WARNING: may not have removed all/correct segments
NOTE :
-------
-bash-4.0# ls -l /mount/fs2/rootdbs_10
-rwxrwx--- 1 informix informix 30720000 Sep 18 18:02 /mount/fs2/rootdbs_10
-bash-4.0#
This is 770 and not 660:
rwxrwx---
660:
rw-rw----
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
SARAVANAN AJ
Sent: Thursday, September 17, 2009 7:02 AM
To: ids@iiug.org
Subject: Re: Changing the port no of an informix instance [17053]
Thanks for your reply.
Instance is not coming UP and the logs are mentioned below...
-bash-4.0# oninit -iv
This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be
accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run mode...succeeded
Reading configuration file
'/mount/fs1/informix_10.0/etc/onconfig.sarav1'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file
"/mount/fs1/informix_10.0/etc/.infos.sarav1"...succeeded
Linking conf file
"/mount/fs1/informix_10.0/etc/.conf.sarav1"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1444 kbytes...succeeded
Allocating 4016 kbytes for buffer pool of 4K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
FAILED
-bash-4.0#
online.log message :
------------------------
21:18:10 IBM Informix Dynamic Server Started.
Fri Sep 18 21:18:10 2009
21:18:10 Event alarms enabled. ALARMPROG =
'/mount/fs1/informix_10.0/etc/alarmprogram.sh'
21:18:10 Requested shared memory segment size rounded from 8316KB to
8320KB
21:18:10 Dynamically allocated new virtual shared memory segment (size
8320KB)
21:18:10 Memory sizes:resident:5904 KB, virtual:16512 KB, no SHMTOTAL
limit
21:18:10 Booting Language <c> from module <>
21:18:10 Loading Module <CNULL>
21:18:10 Booting Language <builtin> from module <>
21:18:10 Loading Module <BUILTINNULL>
21:18:15 DR: DRAUTO is 0 (Off)
21:18:15 AIX MP latch code enabled
21:18:15 IBM Informix Dynamic Server Version 10.00.FC8 Software Serial
Number
AAA#B000000
21:18:15 The chunk '/mount/fs2/rootdbs_10' must have READ/WRITE
permissions
for owner and group (660).
21:18:15 IBM Informix Dynamic Server Stopped.
21:18:15 mt_shm_remove: WARNING: may not have removed all/correct
segments
NOTE :
-------
-bash-4.0# ls -l /mount/fs2/rootdbs_10-rwxrwx--- 1 informix informix 30720000 Sep 18 18:02
/mount/fs2/rootdbs_10
-bash-4.0#
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
2009/9/17 SARAVANAN AJ <saran_psg@rediffmail.com>:
> Thanks for your reply.
>
> Instance is not coming UP and the logs are mentioned below...
>
> -bash-4.0# oninit -iv>
> This action will initialize IBM Informix Dynamic Server;
> any existing IBM Informix Dynamic Server databases will NOT be accessible -
> Do you wish to continue (y/n)? y
> Checking group membership to determine server run mode...succeeded
> Reading configuration file
> '/mount/fs1/informix_10.0/etc/onconfig.sarav1'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file "/mount/fs1/informix_10.0/etc/.infos.sarav1"...succeeded
> Linking conf file "/mount/fs1/informix_10.0/etc/.conf.sarav1"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 1444 kbytes...succeeded
> Allocating 4016 kbytes for buffer pool of 4K page size...succeeded
> Initializing rhead structure...succeeded
> Initializing ASF...succeeded
> Initializing Dictionary Cache and SPL Routine Cache...succeeded
> Bringing up ADM VP...succeeded
> Creating VP classes...succeeded
> Onlining 0 additional cpu vps...succeeded
> Onlining 2 IO vps...succeeded
> Initialization of Encryption...succeeded
> Forking main_loop thread...succeeded
> Initializing DR structures...succeeded
> Forking 1 'soctcp' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 1 flushers...succeeded
> FAILED
> -bash-4.0#
>
> online.log message :
> ------------------------
> 21:18:10 IBM Informix Dynamic Server Started.
>
> Fri Sep 18 21:18:10 2009
>
> 21:18:10 Event alarms enabled. ALARMPROG =
> '/mount/fs1/informix_10.0/etc/alarmprogram.sh'
> 21:18:10 Requested shared memory segment size rounded from 8316KB to 8320KB
> 21:18:10 Dynamically allocated new virtual shared memory segment (size
8320KB)
> 21:18:10 Memory sizes:resident:5904 KB, virtual:16512 KB, no SHMTOTAL limit
> 21:18:10 Booting Language <c> from module <>
> 21:18:10 Loading Module <CNULL>
> 21:18:10 Booting Language <builtin> from module <>
> 21:18:10 Loading Module <BUILTINNULL>
> 21:18:15 DR: DRAUTO is 0 (Off)
> 21:18:15 AIX MP latch code enabled
> 21:18:15 IBM Informix Dynamic Server Version 10.00.FC8 Software Serial Number
> AAA#B000000
> 21:18:15 The chunk '/mount/fs2/rootdbs_10' must have READ/WRITE permissions
> for owner and group (660).
>
> 21:18:15 IBM Informix Dynamic Server Stopped.
>
> 21:18:15 mt_shm_remove: WARNING: may not have removed all/correct segments
>
> NOTE :
> -------
> -bash-4.0# ls -l /mount/fs2/rootdbs_10
> -rwxrwx--- 1 informix informix 30720000 Sep 18 18:02 /mount/fs2/rootdbs_10
> -bash-4.0#>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
-rwxrwx--- is READ/WRITE/EXECUTE permissions (770), 660 is -rw-rw---- !!
Correct this, check all your other chunks and then try to rstart the engine.
Keith
Thank You all.. It works fine.. Regards Saravanan
And there is your problem. In the log it says:
21:18:15 The chunk '/mount/fs2/rootdbs_10' must have READ/WRITE permissions
for owner and group (660).
But, as you show below the privs on the root chunk are not 660, but 770!
-bash-4.0# ls -l /mount/fs2/rootdbs_10
-rwxrwx--- 1 informix informix 30720000 Sep 18 18:02 /mount/fs2/rootdbs_10
chmod 660 /mount/fs2/rootdbs_10
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Thu, Sep 17, 2009 at 8:01 AM, SARAVANAN AJ <saran_psg@rediffmail.com>wrote:
> Thanks for your reply.
>
> Instance is not coming UP and the logs are mentioned below...
>
> -bash-4.0# oninit -iv>
> This action will initialize IBM Informix Dynamic Server;
> any existing IBM Informix Dynamic Server databases will NOT be accessible -
> Do you wish to continue (y/n)? y
> Checking group membership to determine server run mode...succeeded
> Reading configuration file
> '/mount/fs1/informix_10.0/etc/onconfig.sarav1'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file
> "/mount/fs1/informix_10.0/etc/.infos.sarav1"...succeeded
> Linking conf file "/mount/fs1/informix_10.0/etc/.conf.sarav1"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 1444 kbytes...succeeded
> Allocating 4016 kbytes for buffer pool of 4K page size...succeeded
> Initializing rhead structure...succeeded
> Initializing ASF...succeeded
> Initializing Dictionary Cache and SPL Routine Cache...succeeded
> Bringing up ADM VP...succeeded
> Creating VP classes...succeeded
> Onlining 0 additional cpu vps...succeeded
> Onlining 2 IO vps...succeeded
> Initialization of Encryption...succeeded
> Forking main_loop thread...succeeded
> Initializing DR structures...succeeded
> Forking 1 'soctcp' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 1 flushers...succeeded
> FAILED
> -bash-4.0#
>
> online.log message :
> ------------------------
> 21:18:10 IBM Informix Dynamic Server Started.
>
> Fri Sep 18 21:18:10 2009
>
> 21:18:10 Event alarms enabled. ALARMPROG =
> '/mount/fs1/informix_10.0/etc/alarmprogram.sh'
> 21:18:10 Requested shared memory segment size rounded from 8316KB to 8320KB
> 21:18:10 Dynamically allocated new virtual shared memory segment (size
> 8320KB)
> 21:18:10 Memory sizes:resident:5904 KB, virtual:16512 KB, no SHMTOTAL limit
> 21:18:10 Booting Language <c> from module <>
> 21:18:10 Loading Module <CNULL>
> 21:18:10 Booting Language <builtin> from module <>
> 21:18:10 Loading Module <BUILTINNULL>
> 21:18:15 DR: DRAUTO is 0 (Off)
> 21:18:15 AIX MP latch code enabled
> 21:18:15 IBM Informix Dynamic Server Version 10.00.FC8 Software Serial
> Number
> AAA#B000000
> 21:18:15 The chunk '/mount/fs2/rootdbs_10' must have READ/WRITE permissions
> for owner and group (660).
>
> 21:18:15 IBM Informix Dynamic Server Stopped.
>
> 21:18:15 mt_shm_remove: WARNING: may not have removed all/correct segments
>
> NOTE :
> -------
> -bash-4.0# ls -l /mount/fs2/rootdbs_10
> -rwxrwx--- 1 informix informix 30720000 Sep 18 18:02 /mount/fs2/rootdbs_10
> -bash-4.0#>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015174736ac14066f0473c5c049