Upgrade to 10 Failed

Posted in 2006

Summary

A DBA upgrading IDS 9.4.UC7 to 10.0.UC4 on Red Hat (new install directory, copied ONCONFIG settings, moved the $INFORMIXDIR symlink) found the instance aborting during conversion with "The chunk '/ifxdbsys/dbspace/links/rootdbs' must have READ/WRITE permissions for owner and group (660)". Chunks were 2GB cooked files reached via symlinks. Suggestions were to check oninit's permissions/setuid, to run the first conversion boot as user informix, and to verify the symlink targets were 660 informix:informix — all of which the poster confirmed were already correct. No resolution is recorded in the thread.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades, Storage & Space Management, Server Administration, Versions, Editions & End-of-Life

Jarratt, Linwood B. — Wed, 25 Jan 2006 17:00:58 — source: IIUG Forums & Mailing Lists

I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on RedHat Linux. Here are the steps I performed: Backed up 9.4 database Shutdown Instance Installed IDS 10 into a seperate directory Updated the IDS 10 onconfig file with the correct paramaters from my 9.4 instance. Moved the link so informix now looked at IDS directories Started Instance. It fails with the following error (from online.log): Mon Jan 23 21:12:17 2006 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) '/ifxbak/dumps' has insecure permissions 21:12:17 Event alarms enabled. ALARMPROG = '/ifxapp/informix/etc/alarmprogram.sh' 21:12:17 Booting Language <c> from module <> 21:12:17 Loading Module <CNULL> 21:12:17 Booting Language <builtin> from module <> 21:12:17 Loading Module <BUILTINNULL> 21:12:22 DR: DRAUTO is 0 (Off) 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000 21:12:23 Conversion from version 9.40 Started 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must have READ/WRITE permissions for owner and group (660). 21:12:23 IBM Informix Dynamic Server Stopped. 21:12:23 mt_shm_remove: WARNING: may not have removed all/correct segments I changed the root dbspace permissions to 660 from 666. I still received the same error. All my dbspaces are 2 GB cooked files. Each one has a symbolic link pointing to the real file as follows: lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> ../files/rootdbs.000 -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 What am I missing or what should I try next? Thanks. Lennie Informix DBA Information Technology Tax team Lake County, IL O: 847-377-2092 C: 847-309-7718 Math illiteracy affects 7 out of every 5 people.

↪ replying to Jarratt, Linwood B.

Obnoxio The Clown — Wed, 25 Jan 2006 17:02:41 — source: IIUG Forums & Mailing Lists

Jarratt, Li.... said: > > > I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on RedHat Linux. > Here are the steps I performed: > > Backed up 9.4 database > Shutdown Instance > Installed IDS 10 into a seperate directory > Updated the IDS 10 onconfig file with the correct paramaters from my 9.4 > instance. > Moved the link so informix now looked at IDS directories > Started Instance. > > It fails with the following error (from online.log): > > Mon Jan 23 21:12:17 2006 > > 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) '/ifxbak/dumps' has > insecure permissions > 21:12:17 Event alarms enabled. ALARMPROG = > '/ifxapp/informix/etc/alarmprogram.sh' > 21:12:17 Booting Language <c> from module <> > 21:12:17 Loading Module <CNULL> > 21:12:17 Booting Language <builtin> from module <> > 21:12:17 Loading Module <BUILTINNULL> > 21:12:22 DR: DRAUTO is 0 (Off) > 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial > Number AAA#B000000 > 21:12:23 Conversion from version 9.40 Started > 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must have READ/WRITE > permissions for owner and group (660). > > 21:12:23 IBM Informix Dynamic Server Stopped. > > 21:12:23 mt_shm_remove: WARNING: may not have removed all/correct segments > > I changed the root dbspace permissions to 660 from 666. I still received > the same error. All my dbspaces are 2 GB cooked files. Each one has a > symbolic link pointing to the real file as follows: > > lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> > .../files/rootdbs.000 > -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > > What am I missing or what should I try next? I think your binaries probably don't have the correct permissions. oninit specifically. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com

↪ replying to Obnoxio The Clown

Robert Roussey\\\$MIS\\\$ — Wed, 25 Jan 2006 17:09:32 — source: IIUG Forums & Mailing Lists

Remember that for the initial conversion, you must start oninit as user informix. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com 586.741.8991 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The.... Sent: Wednesday, January 25, 2006 12:03 PM To: ids@iiug.org Subject: Re: Upgrade to 10 Failed [6271] Jarratt, Li.... said: > > > I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on RedHat Linux. > Here are the steps I performed: > > Backed up 9.4 database > Shutdown Instance > Installed IDS 10 into a seperate directory > Updated the IDS 10 onconfig file with the correct paramaters from my 9.4 > instance. > Moved the link so informix now looked at IDS directories > Started Instance. > > It fails with the following error (from online.log): > > Mon Jan 23 21:12:17 2006 > > 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) '/ifxbak/dumps' has > insecure permissions > 21:12:17 Event alarms enabled. ALARMPROG = > '/ifxapp/informix/etc/alarmprogram.sh' > 21:12:17 Booting Language <c> from module <> > 21:12:17 Loading Module <CNULL> > 21:12:17 Booting Language <builtin> from module <> > 21:12:17 Loading Module <BUILTINNULL> > 21:12:22 DR: DRAUTO is 0 (Off) > 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial > Number AAA#B000000 > 21:12:23 Conversion from version 9.40 Started > 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must have READ/WRITE > permissions for owner and group (660). > > 21:12:23 IBM Informix Dynamic Server Stopped. > > 21:12:23 mt_shm_remove: WARNING: may not have removed all/correct segments > > I changed the root dbspace permissions to 660 from 666. I still received > the same error. All my dbspaces are 2 GB cooked files. Each one has a > symbolic link pointing to the real file as follows: > > lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> > .../files/rootdbs.000 > -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > > What am I missing or what should I try next? I think your binaries probably don't have the correct permissions. oninit specifically. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Obnoxio The Clown

Jarratt, Linwood B. — Wed, 25 Jan 2006 17:12:54 — source: IIUG Forums & Mailing Lists

oninit permissions are as follows: -rwsr-sr-- 1 root informix 13193542 Jan 23 06:33 oninit The install was run as root, but oninit was being run as informix. Lennie > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > Obnoxio The.... > Sent: Wednesday, January 25, 2006 11:03 AM > To: ids@iiug.org > Subject: Re: Upgrade to 10 Failed [6271] > > > > Jarratt, Li.... said: > > > > > > I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on > RedHat Linux. > > Here are the steps I performed: > > > > Backed up 9.4 database > > Shutdown Instance > > Installed IDS 10 into a seperate directory > > Updated the IDS 10 onconfig file with the correct > paramaters from my 9.4 > > instance. > > Moved the link so informix now looked at IDS directories > > Started Instance. > > > > It fails with the following error (from online.log): > > > > Mon Jan 23 21:12:17 2006 > > > > 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) > '/ifxbak/dumps' has > > insecure permissions > > 21:12:17 Event alarms enabled. ALARMPROG = > > '/ifxapp/informix/etc/alarmprogram.sh' > > 21:12:17 Booting Language <c> from module <> > > 21:12:17 Loading Module <CNULL> > > 21:12:17 Booting Language <builtin> from module <> > > 21:12:17 Loading Module <BUILTINNULL> > > 21:12:22 DR: DRAUTO is 0 (Off) > > 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 > Software Serial > > Number AAA#B000000 > > 21:12:23 Conversion from version 9.40 Started > > 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must > have READ/WRITE > > permissions for owner and group (660). > > > > 21:12:23 IBM Informix Dynamic Server Stopped. > > > > 21:12:23 mt_shm_remove: WARNING: may not have removed > all/correct segments > > > > I changed the root dbspace permissions to 660 from 666. I > still received > > the same error. All my dbspaces are 2 GB cooked files. Each > one has a > > symbolic link pointing to the real file as follows: > > > > lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> > > .../files/rootdbs.000 > > -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > > > > What am I missing or what should I try next? > > I think your binaries probably don't have the correct > permissions. oninit > specifically. > > -- > Bye now, > Obnoxio > > "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" > - Coluche > > did i mention i like nulls? heck, i even go so far as to say that all > columns in a table except the primary key could/should be > nullable. this > has certain advantages, for example, if you need to insert a > child record > and you don't have a parent row for it, just do an insert > into the parent > table with the primary key value (everything else null), and voila, > relational integrity is preserved. but this is, admittedly, a bit > controversial among modellers. > > --r937, dbforums.com > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jarratt, Linwood B.

Stuart Stephens — Wed, 25 Jan 2006 17:13:37 — source: IIUG Forums & Mailing Lists

Looks like you are using symbolic links so are the target file permissions 660 also? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jarratt, Li.... Sent: 25 January 2006 17:01 To: ids@iiug.org Subject: Upgrade to 10 Failed [6270] I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on RedHat Linux. Here are the steps I performed: Backed up 9.4 database Shutdown Instance Installed IDS 10 into a seperate directory Updated the IDS 10 onconfig file with the correct paramaters from my 9.4 instance. Moved the link so informix now looked at IDS directories Started Instance. It fails with the following error (from online.log): Mon Jan 23 21:12:17 2006 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) '/ifxbak/dumps' has insecure permissions 21:12:17 Event alarms enabled. ALARMPROG = '/ifxapp/informix/etc/alarmprogram.sh' 21:12:17 Booting Language <c> from module <> 21:12:17 Loading Module <CNULL> 21:12:17 Booting Language <builtin> from module <> 21:12:17 Loading Module <BUILTINNULL> 21:12:22 DR: DRAUTO is 0 (Off) 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000 21:12:23 Conversion from version 9.40 Started 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must have READ/WRITE permissions for owner and group (660). 21:12:23 IBM Informix Dynamic Server Stopped. 21:12:23 mt_shm_remove: WARNING: may not have removed all/correct segments I changed the root dbspace permissions to 660 from 666. I still received the same error. All my dbspaces are 2 GB cooked files. Each one has a symbolic link pointing to the real file as follows: lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> .../files/rootdbs.000 -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 What am I missing or what should I try next? Thanks. Lennie Informix DBA Information Technology Tax team Lake County, IL O: 847-377-2092 C: 847-309-7718 Math illiteracy affects 7 out of every 5 people. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Stuart Stephens

Jarratt, Linwood B. — Wed, 25 Jan 2006 17:18:30 — source: IIUG Forums & Mailing Lists

Link: lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> ..../files/rootdbs.000 Target: -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > Stuart Stephens > Sent: Wednesday, January 25, 2006 11:14 AM > To: ids@iiug.org > Subject: RE: Upgrade to 10 Failed [6274] > > > > Looks like you are using symbolic links so are the target > file permissions > 660 also? > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Jarratt, Li.... > Sent: 25 January 2006 17:01 > To: ids@iiug.org > Subject: Upgrade to 10 Failed [6270] > > I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on > RedHat Linux. > Here are the steps I performed: > > Backed up 9.4 database > Shutdown Instance > Installed IDS 10 into a seperate directory > Updated the IDS 10 onconfig file with the correct paramaters > from my 9.4 > instance. > Moved the link so informix now looked at IDS directories > Started Instance. > > It fails with the following error (from online.log): > > Mon Jan 23 21:12:17 2006 > > 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) > '/ifxbak/dumps' has > insecure permissions > 21:12:17 Event alarms enabled. ALARMPROG = > '/ifxapp/informix/etc/alarmprogram.sh' > 21:12:17 Booting Language <c> from module <> > 21:12:17 Loading Module <CNULL> > 21:12:17 Booting Language <builtin> from module <> > 21:12:17 Loading Module <BUILTINNULL> > 21:12:22 DR: DRAUTO is 0 (Off) > 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 > Software Serial > Number AAA#B000000 > 21:12:23 Conversion from version 9.40 Started > 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must > have READ/WRITE > permissions for owner and group (660). > > 21:12:23 IBM Informix Dynamic Server Stopped. > > 21:12:23 mt_shm_remove: WARNING: may not have removed > all/correct segments > > I changed the root dbspace permissions to 660 from 666. I > still received > the same error. All my dbspaces are 2 GB cooked files. Each one has a > symbolic link pointing to the real file as follows: > > lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> > ..../files/rootdbs.000 > -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > > What am I missing or what should I try next? > > Thanks. > > Lennie > > Informix DBA > Information Technology Tax team > Lake County, IL > O: 847-377-2092 > C: 847-309-7718 > > Math illiteracy affects 7 out of every 5 people. > > ************************************************************** > ************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jarratt, Linwood B.

Robert Roussey\\\$MIS\\\$ — Wed, 25 Jan 2006 17:28:47 — source: IIUG Forums & Mailing Lists

My raw devices are 660 informix:informix and my symlinks are typical 777 root:root. Upgrade from 9.40 to 10.00 worked fine. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com 586.741.8991 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jarratt, Li.... Sent: Wednesday, January 25, 2006 12:19 PM To: ids@iiug.org Subject: RE: Upgrade to 10 Failed [6275] Link: lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> ...../files/rootdbs.000 Target: -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > Stuart Stephens > Sent: Wednesday, January 25, 2006 11:14 AM > To: ids@iiug.org > Subject: RE: Upgrade to 10 Failed [6274] > > > > Looks like you are using symbolic links so are the target > file permissions > 660 also? > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Jarratt, Li.... > Sent: 25 January 2006 17:01 > To: ids@iiug.org > Subject: Upgrade to 10 Failed [6270] > > I am attempting to upgrade IDS 9.4.UC7 to IDS 10.0.UC4 on > RedHat Linux. > Here are the steps I performed: > > Backed up 9.4 database > Shutdown Instance > Installed IDS 10 into a seperate directory > Updated the IDS 10 onconfig file with the correct paramaters > from my 9.4 > instance. > Moved the link so informix now looked at IDS directories > Started Instance. > > It fails with the following error (from online.log): > > Mon Jan 23 21:12:17 2006 > > 21:12:17 Warning: ONCONFIG dump directory (DUMPDIR) > '/ifxbak/dumps' has > insecure permissions > 21:12:17 Event alarms enabled. ALARMPROG = > '/ifxapp/informix/etc/alarmprogram.sh' > 21:12:17 Booting Language <c> from module <> > 21:12:17 Loading Module <CNULL> > 21:12:17 Booting Language <builtin> from module <> > 21:12:17 Loading Module <BUILTINNULL> > 21:12:22 DR: DRAUTO is 0 (Off) > 21:12:23 IBM Informix Dynamic Server Version 10.00.UC4 > Software Serial > Number AAA#B000000 > 21:12:23 Conversion from version 9.40 Started > 21:12:23 The chunk '/ifxdbsys/dbspace/links/rootdbs' must > have READ/WRITE > permissions for owner and group (660). > > 21:12:23 IBM Informix Dynamic Server Stopped. > > 21:12:23 mt_shm_remove: WARNING: may not have removed > all/correct segments > > I changed the root dbspace permissions to 660 from 666. I > still received > the same error. All my dbspaces are 2 GB cooked files. Each one has a > symbolic link pointing to the real file as follows: > > lrwxrwxrwx 1 informix informix 20 Nov 23 14:34 rootdbs -> > ..../files/rootdbs.000 > -rw-rw---- 1 informix informix 2097152000 Jan 25 10:18 rootdbs.000 > > What am I missing or what should I try next? > > Thanks. > > Lennie > > Informix DBA > Information Technology Tax team > Lake County, IL > O: 847-377-2092 > C: 847-309-7718 > > Math illiteracy affects 7 out of every 5 people. > > ************************************************************** > ************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Upgrade to 10 Failed

Glossary

Your privacy choices