Re: oninit -i: passwd problem and error in buildin
Frank copied the whole /usr/informix directory to another AIX box and ran 'oninit -iv'; the startup appeared to succeed but the online log showed several warnings (non-resident shared memory segment, insecure DUMPDIR /tmp, SHMBASE relocation, missing DBSPACETEMP dbspaces) and then repeated '-951: Incorrect password or user informix@otto is not known' errors, ending with 'Error building sysmaster database'. Art Kagel said the warnings are informational and that -951 points to the informix account lacking a valid login/password entry or trust; Martin suggested the copy lost file ownership/permissions on the binaries and recommended re-copying with tar as root with matching UIDs/GIDs. Frank replied informix was in /etc/passwd, and no confirmed resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
All of the messages I see are informational and do not indicate any problems:
15:02:00 Shared memory segment 0x40000000 could not be forced resident.
-- Your new OS may not be configured to allow resident segments as large as
the instance's shared memory segment is. Check the kernel settings.
15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
permissions
-- Check and possibly modify the perms on /tmp
15:02:05 Contiguous shared memory segment allocation failed at 0xd0000000.
Allocation successful at 0x30000000.
Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
-- Do as it says.
15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in
DBSPACETEMP: 'dbtemp1'
-- These are because the ONCONFIG file has a DBSPACETEMP setting naming
dbspaces that do not exist. Since you've just initialized the instance that
makes sense. Create the temp dbspaces you want and possibly modify the ONCONFIG
setting to name those new temp dbspaces and some regular ones for logged temp
tables.
15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
Incorrect password or user informix@otto is not known on the database ser
ver.
-- Looks like you forgot to create a loginable account for user 'informix'
from otto in group 'informix' on the new server machine or otto is not a
trusted host there.
Art S. Kagel
----- Original Message -----
From: Frank <ids@iiug.org>
At: 11/21 10:30:08
hi,
we wrapped up the directory /usr/informix/ where informix was installed
and unwrapped it at another machine.
When we run oninit -iv, it gave the following info.
Any idea?
Thanks,
Frank
informix@otto $ onstat -version
Program Name: onstat
Build Version: 10.00.UC5
Build Number: N202
Build Host: ibm6c1b
Build OS: AIX 5.2
Build Date: Thu May 18 00:09:08 CDT 2006
GLS Version: glslib-4.00.UC8
informix@otto $ 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 '/usr/informix/etc/onconfig.otto'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 68068 kbytes...succeeded
Allocating 1600016 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 5 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
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 16 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Creating database partition...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
BUT, in online log, it showd,
15:01:57 IBM Informix Dynamic Server Started.
15:02:00 shmctl: errno = 1
15:02:00 Shared memory segment 0x40000000 could not be forced resident.
Tue Nov 21 15:02:00 2006
15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
permissions
15:02:00 Event alarms enabled. ALARMPROG =
'/usr/informix/etc/alarmprogram.sh'
15:02:00 Booting Language <c> from module <>
15:02:00 Loading Module <CNULL>
15:02:00 Booting Language <builtin> from module <>
15:02:00 Loading Module <BUILTINNULL>
15:02:00 Affinitied VP 1 to phys proc 1
15:02:00 Affinitied VP 4 to phys proc 2
15:02:00 Affinitied VP 5 to phys proc 3
15:02:00 Affinitied VP 6 to phys proc 4
15:02:00 Affinitied VP 7 to phys proc 5
15:02:00 Affinitied VP 8 to phys proc 6
15:02:05 DR: DRAUTO is 0 (Off)
15:02:05 AIX MP latch code enabled
15:02:05 Contiguous shared memory segment allocation failed at 0xd0000000.
Allocation successful at 0x30000000.
Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std.
If you are using the correct SHMBASE value in your ONCONFIG file, then
consider this message informational only.
15:02:05 IBM Informix Dynamic Server Version 10.00.UC5 Software Serial
Number AAA#B000000
15:02:10 IBM Informix Dynamic Server Initialized -- Complete Disk
Initialized.
15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'dbtemp1'
15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'dbtemp2'
15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'dbtemp3'
15:02:10 Checkpoint Completed: duration was 0 seconds.
15:02:10 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x63
15:02:10 Maximum server connections 0
15:02:10 Dataskip is now OFF for all dbspaces
15:02:10 On-Line Mode
15:02:10 Building 'sysmaster' database ...
15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
Incorrect password or user informix@otto is not known on the database ser
ver.
........................................
15:02:27 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
Incorrect password or user informix@otto is not known on the database
server.
15:02:27 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
Incorrect password or user informix@otto is not known on the database
server.
15:02:27 Error building 'sysmaster' database.
15:02:27 See '/tmp/buildsmi.184778'.
15:07:10 Checkpoint Completed: duration was 0 seconds.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi,
either the problem is what Art Kagel describes below,
or it is that during your "wrap - unwrap" procedure some
of the binaries lost some of their specific file access rights.
Actually I guess it is the latter.
I don't know what you did when you say "wrap - unwrap",
I'm not aware of the existance of such commands.
You can try to use "tar" instead. And with "tar" you have to
do it as user root (both, "tar cvf ... " and "tar xvf ...") to
preserve owner, group and access rights of the files.
Precondition for this to work is that the numerical user IDs of
users ("root" and "informix") and group ID of "informix"
should be the same on both machines respectively.
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html
ids-bounces@iiug.org wrote on 21.11.2006 16:32:22:
>
> All of the messages I see are informational and do not indicate any
problems:
>
> 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> -- Your new OS may not be configured to allow resident segments as large
as
> the instance's shared memory segment is. Check the kernel settings.
>
> 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> permissions
> -- Check and possibly modify the perms on /tmp
>
> 15:02:05 Contiguous shared memory segment allocation failed at
0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
$INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
> -- Do as it says.
>
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
listed in
> DBSPACETEMP: 'dbtemp1'
> -- These are because the ONCONFIG file has a DBSPACETEMP setting naming
> dbspaces that do not exist. Since you've just initialized the instance
that
> makes sense. Create the temp dbspaces you want and possibly modify the
> ONCONFIG
> setting to name those new temp dbspaces and some regular ones for logged
temp
> tables.
>
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@otto is not known on the database
ser
> ver.
> -- Looks like you forgot to create a loginable account for user
'informix'
> from otto in group 'informix' on the new server machine or otto is not a
> trusted host there.
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 10:30:08
>
> hi,
>
> we wrapped up the directory /usr/informix/ where informix was installed
> and unwrapped it at another machine.
>
> When we run oninit -iv, it gave the following info.
>
> Any idea?
>
> Thanks,
> Frank
>
> informix@otto $ onstat -version
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
> informix@otto $ 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 '/usr/informix/etc/onconfig.otto'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 68068 kbytes...succeeded
> Allocating 1600016 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 5 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
> Forking 1 'ipcshm' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 16 flushers...succeeded
> Initializing log/checkpoint information...succeeded
> Opening primary chunks...succeeded
> Opening mirror chunks...succeeded
> Initializing dbspaces...succeeded
> Validating chunks...succeeded
> Creating database partition...succeeded
> Initialize Async Log Flusher...succeeded
> Forking btree cleaner...succeeded
> Initializing DBSPACETEMP list...succeeded
> Checking database partition index...succeeded
> Checking location of physical log...succeeded
> Initializing dataskip structure...succeeded
> Checking for temporary tables to drop...succeeded
> Forking onmode_mon thread...succeeded
> Verbose output complete: mode = 5
>
> BUT, in online log, it showd,
>
> 15:01:57 IBM Informix Dynamic Server Started.
> 15:02:00 shmctl: errno = 1
> 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
>
> Tue Nov 21 15:02:00 2006
>
> 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> permissions
> 15:02:00 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 15:02:00 Booting Language <c> from module <>
> 15:02:00 Loading Module <CNULL>
> 15:02:00 Booting Language <builtin> from module <>
> 15:02:00 Loading Module <BUILTINNULL>
> 15:02:00 Affinitied VP 1 to phys proc 1
> 15:02:00 Affinitied VP 4 to phys proc 2
> 15:02:00 Affinitied VP 5 to phys proc 3
> 15:02:00 Affinitied VP 6 to phys proc 4
> 15:02:00 Affinitied VP 7 to phys proc 5
> 15:02:00 Affinitied VP 8 to phys proc 6
> 15:02:05 DR: DRAUTO is 0 (Off)
> 15:02:05 AIX MP latch code enabled
> 15:02:05 Contiguous shared memory segment allocation failed at
0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
$INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
>
> 15:02:05 IBM Informix Dynamic Server Version 10.00.UC5 Software Serial
> Number AAA#B000000
> 15:02:10 IBM Informix Dynamic Server Initialized -- Complete Disk
> Initialized.
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
listed
>
> in DBSPACETEMP: 'dbtemp1'
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
listed
>
> in DBSPACETEMP: 'dbtemp2'
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
listed
>
> in DBSPACETEMP: 'dbtemp3'
> 15:02:10 Checkpoint Completed: duration was 0 seconds.
> 15:02:10 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x63
>
> 15:02:10 Ma
Art,
Thanks for the reply!
What do you mean about ?
-- Looks like you forgot to create a loginable account for user 'informix'
from otto in group 'informix' on the new server machine or otto is not a
trusted host there.
The account " informix' was created. you mean it needs login passwd for
me to run the command oninit -i ?
There should be no "trusted host" problem because the command was issued
in the same host.
Thanks,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
>
> All of the messages I see are informational and do not indicate any
> problems:
>
> 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> -- Your new OS may not be configured to allow resident segments as large
> as
> the instance's shared memory segment is. Check the kernel settings.
>
> 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> permissions
> -- Check and possibly modify the perms on /tmp
>
> 15:02:05 Contiguous shared memory segment allocation failed at 0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
> -- Do as it says.
>
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
> in
> DBSPACETEMP: 'dbtemp1'
> -- These are because the ONCONFIG file has a DBSPACETEMP setting naming
> dbspaces that do not exist. Since you've just initialized the instance
> that
> makes sense. Create the temp dbspaces you want and possibly modify the
> ONCONFIG
> setting to name those new temp dbspaces and some regular ones for logged
> temp
> tables.
>
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@otto is not known on the database ser
> ver.
> -- Looks like you forgot to create a loginable account for user 'informix'
> from otto in group 'informix' on the new server machine or otto is not a
> trusted host there.
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 10:30:08
>
> hi,
>
> we wrapped up the directory /usr/informix/ where informix was installed
> and unwrapped it at another machine.
>
> When we run oninit -iv, it gave the following info.
>
> Any idea?
>
> Thanks,
> Frank
>
> informix@otto $ onstat -version
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
> informix@otto $ 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 '/usr/informix/etc/onconfig.otto'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 68068 kbytes...succeeded
> Allocating 1600016 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 5 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
> Forking 1 'ipcshm' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 16 flushers...succeeded
> Initializing log/checkpoint information...succeeded
> Opening primary chunks...succeeded
> Opening mirror chunks...succeeded
> Initializing dbspaces...succeeded
> Validating chunks...succeeded
> Creating database partition...succeeded
> Initialize Async Log Flusher...succeeded
> Forking btree cleaner...succeeded
> Initializing DBSPACETEMP list...succeeded
> Checking database partition index...succeeded
> Checking location of physical log...succeeded
> Initializing dataskip structure...succeeded
> Checking for temporary tables to drop...succeeded
> Forking onmode_mon thread...succeeded
> Verbose output complete: mode = 5
>
> BUT, in online log, it showd,
>
> 15:01:57 IBM Informix Dynamic Server Started.
> 15:02:00 shmctl: errno = 1
> 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
>
> Tue Nov 21 15:02:00 2006
>
> 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> permissions
> 15:02:00 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 15:02:00 Booting Language <c> from module <>
> 15:02:00 Loading Module <CNULL>
> 15:02:00 Booting Language <builtin> from module <>
> 15:02:00 Loading Module <BUILTINNULL>
> 15:02:00 Affinitied VP 1 to phys proc 1
> 15:02:00 Affinitied VP 4 to phys proc 2
> 15:02:00 Affinitied VP 5 to phys proc 3
> 15:02:00 Affinitied VP 6 to phys proc 4
> 15:02:00 Affinitied VP 7 to phys proc 5
> 15:02:00 Affinitied VP 8 to phys proc 6
> 15:02:05 DR: DRAUTO is 0 (Off)
> 15:02:05 AIX MP latch code enabled
> 15:02:05 Contiguous shared memory segment allocation failed at 0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
>
> 15:02:05 IBM Informix Dynamic Server Version 10.00.UC5 Software Serial
> Number AAA#B000000
> 15:02:10 IBM Informix Dynamic Server Initialized -- Complete Disk
> Initialized.
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'dbtemp1'
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'dbtemp2'
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'dbtemp3'
> 15:02:10 Checkpoint Completed: duration was 0 seconds.
> 15:02:10 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x63
>
> 15:02:10 Maximum server connections 0
> 15:02:10 Dataskip is now OFF for all dbspaces
> 15:02:10 On-Line Mode
> 15:02:10 Building 'sysmaster' database ...
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@otto is not known on the database ser
> ver.
>
> .........................................
>
> 15:02:27 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@
The messages about user 'informix' were in the log long after the oninit
statup.
Looks like someone (you?) tried to connect to the instance as 'informix' but
there was no valid password entry in /etc/passwd. That's what error code -951
indicates (see 'finderr -951').
Art S. Kagel
----- Original Message -----
From: Frank <ids@iiug.org>
At: 11/21 11:13:16
Art,
Thanks for the reply!
What do you mean about ?
-- Looks like you forgot to create a loginable account for user 'informix'
from otto in group 'informix' on the new server machine or otto is not a
trusted host there.
The account " informix' was created. you mean it needs login passwd for
me to run the command oninit -i ?
There should be no "trusted host" problem because the command was issued
in the same host.
Thanks,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
>
> All of the messages I see are informational and do not indicate any
> problems:
>
> 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> -- Your new OS may not be configured to allow resident segments as large
> as
> the instance's shared memory segment is. Check the kernel settings.
>
> 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> permissions
> -- Check and possibly modify the perms on /tmp
>
> 15:02:05 Contiguous shared memory segment allocation failed at 0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
> -- Do as it says.
>
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
> in
> DBSPACETEMP: 'dbtemp1'
> -- These are because the ONCONFIG file has a DBSPACETEMP setting naming
> dbspaces that do not exist. Since you've just initialized the instance
> that
> makes sense. Create the temp dbspaces you want and possibly modify the
> ONCONFIG
> setting to name those new temp dbspaces and some regular ones for logged
> temp
> tables.
>
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@otto is not known on the database ser
> ver.
> -- Looks like you forgot to create a loginable account for user 'informix'
> from otto in group 'informix' on the new server machine or otto is not a
> trusted host there.
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 10:30:08
>
> hi,
>
> we wrapped up the directory /usr/informix/ where informix was installed
> and unwrapped it at another machine.
>
> When we run oninit -iv, it gave the following info.
>
> Any idea?
>
> Thanks,
> Frank
>
> informix@otto $ onstat -version
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
> informix@otto $ 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 '/usr/informix/etc/onconfig.otto'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 68068 kbytes...succeeded
> Allocating 1600016 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 5 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
> Forking 1 'ipcshm' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 16 flushers...succeeded
> Initializing log/checkpoint information...succeeded
> Opening primary chunks...succeeded
> Opening mirror chunks...succeeded
> Initializing dbspaces...succeeded
> Validating chunks...succeeded
> Creating database partition...succeeded
> Initialize Async Log Flusher...succeeded
> Forking btree cleaner...succeeded
> Initializing DBSPACETEMP list...succeeded
> Checking database partition index...succeeded
> Checking location of physical log...succeeded
> Initializing dataskip structure...succeeded
> Checking for temporary tables to drop...succeeded
> Forking onmode_mon thread...succeeded
> Verbose output complete: mode = 5
>
> BUT, in online log, it showd,
>
> 15:01:57 IBM Informix Dynamic Server Started.
> 15:02:00 shmctl: errno = 1
> 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
>
> Tue Nov 21 15:02:00 2006
>
> 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> permissions
> 15:02:00 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 15:02:00 Booting Language <c> from module <>
> 15:02:00 Loading Module <CNULL>
> 15:02:00 Booting Language <builtin> from module <>
> 15:02:00 Loading Module <BUILTINNULL>
> 15:02:00 Affinitied VP 1 to phys proc 1
> 15:02:00 Affinitied VP 4 to phys proc 2
> 15:02:00 Affinitied VP 5 to phys proc 3
> 15:02:00 Affinitied VP 6 to phys proc 4
> 15:02:00 Affinitied VP 7 to phys proc 5
> 15:02:00 Affinitied VP 8 to phys proc 6
> 15:02:05 DR: DRAUTO is 0 (Off)
> 15:02:05 AIX MP latch code enabled
> 15:02:05 Contiguous shared memory segment allocation failed at 0xd0000000.
> Allocation successful at 0x30000000.
> Check SHMBASE is consistent with the value in
> $INFORMIXDIR/etc/onconfig.std.
> If you are using the correct SHMBASE value in your ONCONFIG file, then
> consider this message informational only.
>
> 15:02:05 IBM Informix Dynamic Server Version 10.00.UC5 Software Serial
> Number AAA#B000000
> 15:02:10 IBM Informix Dynamic Server Initialized -- Complete Disk
> Initialized.
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'dbtemp1'
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'dbtemp2'
> 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'dbtemp3'
> 15:02:10 Checkpoint Completed: duration was 0 seconds.
> 15:02:10 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x63
>
> 15:02:10 Maximum server connections 0
> 15:02:10 Dataskip is now OFF for all dbspaces
> 15:02:10 On-Line M
Art,
The informix entry is in /etc/passwd file.
There is no other user wanted to connected to db.
I am the only user Informix to do the oninit -i there.
Looks IDS wants to build sysmaster db but it could not go through passwd
verification somehow.
> 15:02:10 Building 'sysmaster' database ...
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@otto is not known on the database ser
> ver.
>
> 15:02:27 Error building 'sysmaster' database.
> 15:02:27 See '/tmp/buildsmi.184778'.
> 15:07:10 Checkpoint Completed: duration was 0 seconds.
>
>
Thanks,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
>
> The messages about user 'informix' were in the log long after the oninit
> statup.
> Looks like someone (you?) tried to connect to the instance as 'informix'
> but
> there was no valid password entry in /etc/passwd. That's what error code
> -951
> indicates (see 'finderr -951').
>
> Art S. Kagel
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 11:13:16
>
> Art,
>
> Thanks for the reply!
>
> What do you mean about ?
>
> -- Looks like you forgot to create a loginable account for user 'informix'
> from otto in group 'informix' on the new server machine or otto is not a
> trusted host there.
>
> The account " informix' was created. you mean it needs login passwd for
> me to run the command oninit -i ?
>
> There should be no "trusted host" problem because the command was issued
> in the same host.
>
> Thanks,
> Frank
>
> On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
> >
> >
> > All of the messages I see are informational and do not indicate any
> > problems:
> >
> > 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> > -- Your new OS may not be configured to allow resident segments as large
> > as
> > the instance's shared memory segment is. Check the kernel settings.
> >
> > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> > permissions
> > -- Check and possibly modify the perms on /tmp
> >
> > 15:02:05 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> > Allocation successful at 0x30000000.
> > Check SHMBASE is consistent with the value in
> > $INFORMIXDIR/etc/onconfig.std.
> > If you are using the correct SHMBASE value in your ONCONFIG file, then
> > consider this message informational only.
> > -- Do as it says.
> >
> > 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> listed
> > in
> > DBSPACETEMP: 'dbtemp1'
> > -- These are because the ONCONFIG file has a DBSPACETEMP setting naming
> > dbspaces that do not exist. Since you've just initialized the instance
> > that
> > makes sense. Create the temp dbspaces you want and possibly modify the
> > ONCONFIG
> > setting to name those new temp dbspaces and some regular ones for logged
> > temp
> > tables.
> >
> > 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> > Incorrect password or user informix@otto is not known on the database
> ser
> > ver.
> > -- Looks like you forgot to create a loginable account for user
> 'informix'
> > from otto in group 'informix' on the new server machine or otto is not a
> > trusted host there.
> >
> > Art S. Kagel
> >
> > ----- Original Message -----
> > From: Frank <ids@iiug.org>
> > At: 11/21 10:30:08
> >
> > hi,
> >
> > we wrapped up the directory /usr/informix/ where informix was installed
> > and unwrapped it at another machine.
> >
> > When we run oninit -iv, it gave the following info.
> >
> > Any idea?
> >
> > Thanks,
> > Frank
> >
> > informix@otto $ onstat -version
> > Program Name: onstat
> > Build Version: 10.00.UC5
> > Build Number: N202
> > Build Host: ibm6c1b
> > Build OS: AIX 5.2
> > Build Date: Thu May 18 00:09:08 CDT 2006
> > GLS Version: glslib-4.00.UC8
> >
> > informix@otto $ 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 '/usr/informix/etc/onconfig.otto'...succeeded
> > Creating /INFORMIXTMP/.infxdirs...succeeded
> > Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> > Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> > Writing to infos file...succeeded
> > Checking config parameters...succeeded
> > Allocating and attaching to shared memory...succeeded
> > Creating resident pool 68068 kbytes...succeeded
> > Allocating 1600016 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 5 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
> > Forking 1 'ipcshm' listener threads...succeeded
> > Starting tracing...succeeded
> > Initializing 16 flushers...succeeded
> > Initializing log/checkpoint information...succeeded
> > Opening primary chunks...succeeded
> > Opening mirror chunks...succeeded
> > Initializing dbspaces...succeeded
> > Validating chunks...succeeded
> > Creating database partition...succeeded
> > Initialize Async Log Flusher...succeeded
> > Forking btree cleaner...succeeded
> > Initializing DBSPACETEMP list...succeeded
> > Checking database partition index...succeeded
> > Checking location of physical log...succeeded
> > Initializing dataskip structure...succeeded
> > Checking for temporary tables to drop...succeeded
> > Forking onmode_mon thread...succeeded
> > Verbose output complete: mode = 5
> >
> > BUT, in online log, it showd,
> >
> > 15:01:57 IBM Informix Dynamic Server Started.
> > 15:02:00 shmctl: errno = 1
> > 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> >
> > Tue Nov 21 15:02:00 2006
> >
> > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> > permissions
> > 15:02:00 Event alarms enabled. ALARMPROG =
> > '/usr/informix/etc/alarmprogram.sh'
> > 15:02:00 Booting Language <c> from module <>
> > 15:02:00 Loading Module <CNULL>
> > 15:02:00 Booting Language <builtin> from module <>
> > 15:02:00 Loading Module <BUILTINNULL>
> > 15:02:00 Affinitied VP 1 to phys proc 1
> > 15:02:00 Affinitied VP 4 to phys proc 2
> > 15:02:00 Affinitied VP 5 to phys proc 3
> > 15:02:00 Affinitied VP 6 to phys proc 4
> > 15:02:00 Affinitied VP 7 to phys proc 5
> > 15:02:00 Affinitied VP 8 to phys proc 6
> > 15:02:05 DR: DRAUTO is 0 (Off)
What are your permissions for the oninit task? Should be:
-rwsr-sr-- 1 root informix 17013152 Mar 29 2006 oninit
As someone pointed out that may be a problem depending on how you 'moved' the
directory tree from the original machine.
Art S. Kagel
----- Original Message -----
From: Frank <ids@iiug.org>
At: 11/21 11:36:28
Art,
The informix entry is in /etc/passwd file.
There is no other user wanted to connected to db.
I am the only user Informix to do the oninit -i there.
Looks IDS wants to build sysmaster db but it could not go through passwd
verification somehow.
> 15:02:10 Building 'sysmaster' database ...
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> Incorrect password or user informix@otto is not known on the database ser
> ver.
>
> 15:02:27 Error building 'sysmaster' database.
> 15:02:27 See '/tmp/buildsmi.184778'.
> 15:07:10 Checkpoint Completed: duration was 0 seconds.
>
>
Thanks,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
>
> The messages about user 'informix' were in the log long after the oninit
> statup.
> Looks like someone (you?) tried to connect to the instance as 'informix'
> but
> there was no valid password entry in /etc/passwd. That's what error code
> -951
> indicates (see 'finderr -951').
>
> Art S. Kagel
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 11:13:16
>
> Art,
>
> Thanks for the reply!
>
> What do you mean about ?
>
> -- Looks like you forgot to create a loginable account for user 'informix'
> from otto in group 'informix' on the new server machine or otto is not a
> trusted host there.
>
> The account " informix' was created. you mean it needs login passwd for
> me to run the command oninit -i ?
>
> There should be no "trusted host" problem because the command was issued
> in the same host.
>
> Thanks,
> Frank
>
> On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
> >
> >
> > All of the messages I see are informational and do not indicate any
> > problems:
> >
> > 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> > -- Your new OS may not be configured to allow resident segments as large
> > as
> > the instance's shared memory segment is. Check the kernel settings.
> >
> > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> > permissions
> > -- Check and possibly modify the perms on /tmp
> >
> > 15:02:05 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> > Allocation successful at 0x30000000.
> > Check SHMBASE is consistent with the value in
> > $INFORMIXDIR/etc/onconfig.std.
> > If you are using the correct SHMBASE value in your ONCONFIG file, then
> > consider this message informational only.
> > -- Do as it says.
> >
> > 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> listed
> > in
> > DBSPACETEMP: 'dbtemp1'
> > -- These are because the ONCONFIG file has a DBSPACETEMP setting naming
> > dbspaces that do not exist. Since you've just initialized the instance
> > that
> > makes sense. Create the temp dbspaces you want and possibly modify the
> > ONCONFIG
> > setting to name those new temp dbspaces and some regular ones for logged
> > temp
> > tables.
> >
> > 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> > Incorrect password or user informix@otto is not known on the database
> ser
> > ver.
> > -- Looks like you forgot to create a loginable account for user
> 'informix'
> > from otto in group 'informix' on the new server machine or otto is not a
> > trusted host there.
> >
> > Art S. Kagel
> >
> > ----- Original Message -----
> > From: Frank <ids@iiug.org>
> > At: 11/21 10:30:08
> >
> > hi,
> >
> > we wrapped up the directory /usr/informix/ where informix was installed
> > and unwrapped it at another machine.
> >
> > When we run oninit -iv, it gave the following info.
> >
> > Any idea?
> >
> > Thanks,
> > Frank
> >
> > informix@otto $ onstat -version
> > Program Name: onstat
> > Build Version: 10.00.UC5
> > Build Number: N202
> > Build Host: ibm6c1b
> > Build OS: AIX 5.2
> > Build Date: Thu May 18 00:09:08 CDT 2006
> > GLS Version: glslib-4.00.UC8
> >
> > informix@otto $ 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 '/usr/informix/etc/onconfig.otto'...succeeded
> > Creating /INFORMIXTMP/.infxdirs...succeeded
> > Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> > Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> > Writing to infos file...succeeded
> > Checking config parameters...succeeded
> > Allocating and attaching to shared memory...succeeded
> > Creating resident pool 68068 kbytes...succeeded
> > Allocating 1600016 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 5 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
> > Forking 1 'ipcshm' listener threads...succeeded
> > Starting tracing...succeeded
> > Initializing 16 flushers...succeeded
> > Initializing log/checkpoint information...succeeded
> > Opening primary chunks...succeeded
> > Opening mirror chunks...succeeded
> > Initializing dbspaces...succeeded
> > Validating chunks...succeeded
> > Creating database partition...succeeded
> > Initialize Async Log Flusher...succeeded
> > Forking btree cleaner...succeeded
> > Initializing DBSPACETEMP list...succeeded
> > Checking database partition index...succeeded
> > Checking location of physical log...succeeded
> > Initializing dataskip structure...succeeded
> > Checking for temporary tables to drop...succeeded
> > Forking onmode_mon thread...succeeded
> > Verbose output complete: mode = 5
> >
> > BUT, in online log, it showd,
> >
> > 15:01:57 IBM Informix Dynamic Server Started.
> > 15:02:00 shmctl: errno = 1
> > 15:02:00 Shared memory segment 0x40000000 could not be forced resident.
> >
> > Tue Nov 21 15:02:00 2006
> >
> > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure
> > permissions
> > 15:02:00 Event alarms enabled. ALARMPROG =
> > '/usr/informix/etc/alarmprogram.sh'
> > 15:02:00 Booting Language <c> from module <>
> > 15:02:00 Loading Module <CNULL>
> > 15:02:00 Booting Language <builtin> from modul
Hello,
Both password, os level and in database must match.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
FRANK
Sent: Tuesday, November 21, 2006 11:26 AM
To: ids@iiug.org
Subject: Re: oninit -i: passwd problem and error in bui.... [7858]
Art,
The informix entry is in /etc/passwd file.
There is no other user wanted to connected to db.
I am the only user Informix to do the oninit -i there.
Looks IDS wants to build sysmaster db but it could not go through passwd
verification somehow.
> 15:02:10 Building 'sysmaster' database ...
> 15:02:10 listener-thread: err = -951: oserr = 0: errstr =
informix@otto:
> Incorrect password or user informix@otto is not known on the database
> ser ver.
>
> 15:02:27 Error building 'sysmaster' database.
> 15:02:27 See '/tmp/buildsmi.184778'.
> 15:07:10 Checkpoint Completed: duration was 0 seconds.
>
>
Thanks,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net>
wrote:
>
>
> The messages about user 'informix' were in the log long after the
oninit
> statup.> Looks like someone (you?) tried to connect to the instance as
'informix'
> but
> there was no valid password entry in /etc/passwd. That's what error
code
> -951
> indicates (see 'finderr -951').
>
> Art S. Kagel
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 11:13:16
>
> Art,
>
> Thanks for the reply!
>
> What do you mean about ?
>
> -- Looks like you forgot to create a loginable account for user
'informix'
> from otto in group 'informix' on the new server machine or otto is not
a
> trusted host there.
>
> The account " informix' was created. you mean it needs login passwd
for
> me to run the command oninit -i ?
>
> There should be no "trusted host" problem because the command was
issued
> in the same host.
>
> Thanks,
> Frank
>
> On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net>
wrote:
> >
> >
> > All of the messages I see are informational and do not indicate any
> > problems:
> >
> > 15:02:00 Shared memory segment 0x40000000 could not be forced
resident.
> > -- Your new OS may not be configured to allow resident segments as
large
> > as
> > the instance's shared memory segment is. Check the kernel settings.
> >
> > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has
insecure
> > permissions
> > -- Check and possibly modify the perms on /tmp
> >
> > 15:02:05 Contiguous shared memory segment allocation failed at
> 0xd0000000.
> > Allocation successful at 0x30000000.
> > Check SHMBASE is consistent with the value in
> > $INFORMIXDIR/etc/onconfig.std.
> > If you are using the correct SHMBASE value in your ONCONFIG file,
then
> > consider this message informational only.
> > -- Do as it says.
> >
> > 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> listed
> > in
> > DBSPACETEMP: 'dbtemp1'
> > -- These are because the ONCONFIG file has a DBSPACETEMP setting
naming
> > dbspaces that do not exist. Since you've just initialized the
instance
> > that
> > makes sense. Create the temp dbspaces you want and possibly modify
the
> > ONCONFIG
> > setting to name those new temp dbspaces and some regular ones for
logged
> > temp
> > tables.
> >
> > 15:02:10 listener-thread: err = -951: oserr = 0: errstr =
informix@otto:
> > Incorrect password or user informix@otto is not known on the
database
> ser
> > ver.
> > -- Looks like you forgot to create a loginable account for user
> 'informix'
> > from otto in group 'informix' on the new server machine or otto is
not a
> > trusted host there.
> >
> > Art S. Kagel
> >
> > ----- Original Message -----
> > From: Frank <ids@iiug.org>
> > At: 11/21 10:30:08
> >
> > hi,
> >
> > we wrapped up the directory /usr/informix/ where informix was
installed
> > and unwrapped it at another machine.
> >
> > When we run oninit -iv, it gave the following info.
> >
> > Any idea?
> >
> > Thanks,
> > Frank
> >
> > informix@otto $ onstat -version
> > Program Name: onstat
> > Build Version: 10.00.UC5
> > Build Number: N202
> > Build Host: ibm6c1b
> > Build OS: AIX 5.2
> > Build Date: Thu May 18 00:09:08 CDT 2006
> > GLS Version: glslib-4.00.UC8
> >
> > informix@otto $ 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
'/usr/informix/etc/onconfig.otto'...succeeded
> > Creating /INFORMIXTMP/.infxdirs...succeeded
> > Creating infos file
"/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> > Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> > Writing to infos file...succeeded
> > Checking config parameters...succeeded
> > Allocating and attaching to shared memory...succeeded
> > Creating resident pool 68068 kbytes...succeeded
> > Allocating 1600016 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 5 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
> > Forking 1 'ipcshm' listener threads...succeeded
> > Starting tracing...succeeded
> > Initializing 16 flushers...succeeded
> > Initializing log/checkpoint information...succeeded
> > Opening primary chunks...succeeded
> > Opening mirror chunks...succeeded
> > Initializing dbspaces...succeeded
> > Validating chunks...succeeded
> > Creating database partition...succeeded
> > Initialize Async Log Flusher...succeeded
> > Forking btree cleaner...succeeded
> > Initializing DBSPACETEMP list...succeeded
> > Checking database partition index...succeeded
> > Checking location of physical log...succeeded
> > Initializing dataskip structure...succeeded
> > Checking for temporary tables to drop...succeeded
> > Forking onmode_mon thread...succeeded
> > Verbose output complete: mode = 5
> >
> > BUT, in online log, it showd,
> >
> > 15:01:57 IBM Informix Dynamic Server Started.
> > 15:02:00 shmctl: errno = 1
> > 15:02:00 Shared memory segment 0x40000000 could not be forced
resident.
> >
> > Tue Nov 21 15:02:00 2006
> >
> > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has
insecure
> > permissions
> > 15:02:00 Event alarms enabled. ALARMPROG =
> > '/usr/informix/etc/alarmprogram.sh'
> > 15:02:00 Booting Language <c> from module <>
>
Thanks, Art and Martin,
I believe it is the permission problem! our oninit is wrong,
-rwsr-sr-- 1 informix informix 20836476 Aug 10 16:52 oninit*
I will ask them redo it,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
>
> What are your permissions for the oninit task? Should be:
>
> -rwsr-sr-- 1 root informix 17013152 Mar 29 2006 oninit
>
> As someone pointed out that may be a problem depending on how you 'moved'
> the
> directory tree from the original machine.
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 11:36:28
>
> Art,
>
> The informix entry is in /etc/passwd file.
> There is no other user wanted to connected to db.
> I am the only user Informix to do the oninit -i there.
>
> Looks IDS wants to build sysmaster db but it could not go through passwd
> verification somehow.
>
> > 15:02:10 Building 'sysmaster' database ...
> > 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> > Incorrect password or user informix@otto is not known on the database
> ser
> > ver.
> >
>
> > 15:02:27 Error building 'sysmaster' database.
> > 15:02:27 See '/tmp/buildsmi.184778'.
> > 15:07:10 Checkpoint Completed: duration was 0 seconds.
> >
> >
>
> Thanks,
> Frank
>
> On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
> >
> >
> > The messages about user 'informix' were in the log long after the oninit
> > statup.
> > Looks like someone (you?) tried to connect to the instance as 'informix'
> > but
> > there was no valid password entry in /etc/passwd. That's what error code
> > -951
> > indicates (see 'finderr -951').
> >
> > Art S. Kagel
> > ----- Original Message -----
> > From: Frank <ids@iiug.org>
> > At: 11/21 11:13:16
> >
> > Art,
> >
> > Thanks for the reply!
> >
> > What do you mean about ?
> >
> > -- Looks like you forgot to create a loginable account for user
> 'informix'
> > from otto in group 'informix' on the new server machine or otto is not a
> > trusted host there.
> >
> > The account " informix' was created. you mean it needs login passwd for
> > me to run the command oninit -i ?
> >
> > There should be no "trusted host" problem because the command was issued
> > in the same host.
> >
> > Thanks,
> > Frank
> >
> > On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net>
> wrote:
> > >
> > >
> > > All of the messages I see are informational and do not indicate any
> > > problems:
> > >
> > > 15:02:00 Shared memory segment 0x40000000 could not be forced
> resident.
> > > -- Your new OS may not be configured to allow resident segments as
> large
> > > as
> > > the instance's shared memory segment is. Check the kernel settings.
> > >
> > > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has
> insecure
> > > permissions
> > > -- Check and possibly modify the perms on /tmp
> > >
> > > 15:02:05 Contiguous shared memory segment allocation failed at
> > 0xd0000000.
> > > Allocation successful at 0x30000000.
> > > Check SHMBASE is consistent with the value in
> > > $INFORMIXDIR/etc/onconfig.std.
> > > If you are using the correct SHMBASE value in your ONCONFIG file, then
> > > consider this message informational only.
> > > -- Do as it says.
> > >
> > > 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> > listed
> > > in
> > > DBSPACETEMP: 'dbtemp1'
> > > -- These are because the ONCONFIG file has a DBSPACETEMP setting
> naming
> > > dbspaces that do not exist. Since you've just initialized the instance
> > > that
> > > makes sense. Create the temp dbspaces you want and possibly modify the
> > > ONCONFIG
> > > setting to name those new temp dbspaces and some regular ones for
> logged
> > > temp
> > > tables.
> > >
> > > 15:02:10 listener-thread: err = -951: oserr = 0: errstr =
> informix@otto:
> > > Incorrect password or user informix@otto is not known on the database
> > ser
> > > ver.
> > > -- Looks like you forgot to create a loginable account for user
> > 'informix'
> > > from otto in group 'informix' on the new server machine or otto is not
> a
> > > trusted host there.
> > >
> > > Art S. Kagel
> > >
> > > ----- Original Message -----
> > > From: Frank <ids@iiug.org>
> > > At: 11/21 10:30:08
> > >
> > > hi,
> > >
> > > we wrapped up the directory /usr/informix/ where informix was
> installed
> > > and unwrapped it at another machine.
> > >
> > > When we run oninit -iv, it gave the following info.
> > >
> > > Any idea?
> > >
> > > Thanks,
> > > Frank
> > >
> > > informix@otto $ onstat -version
> > > Program Name: onstat
> > > Build Version: 10.00.UC5
> > > Build Number: N202
> > > Build Host: ibm6c1b
> > > Build OS: AIX 5.2
> > > Build Date: Thu May 18 00:09:08 CDT 2006
> > > GLS Version: glslib-4.00.UC8
> > >
> > > informix@otto $ 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
> '/usr/informix/etc/onconfig.otto'...succeeded
> > > Creating /INFORMIXTMP/.infxdirs...succeeded
> > > Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> > > Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> > > Writing to infos file...succeeded
> > > Checking config parameters...succeeded
> > > Allocating and attaching to shared memory...succeeded
> > > Creating resident pool 68068 kbytes...succeeded
> > > Allocating 1600016 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 5 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
> > > Forking 1 'ipcshm' listener threads...succeeded
> > > Starting tracing...succeeded
> > > Initializing 16 flushers...succeeded
> > > Initializing log/checkpoint information...succeeded
> > > Opening primary chunks...succeeded
> > > Opening mirror chunks...succeeded
> > > Initializing dbspaces...succeeded
> > > Validating chunks...succeeded
> > > Creating database partition...succeeded
> > > Initialize Async Log Flusher...succeeded
> > > Forking btree cleaner...succeeded
> > > Initializing DBSPACETEMP list...succeeded
> > > Checking database partition index...succeeded
> > > Checking location of physical log...succeeded
> > > Initializing dataskip structure...succeede
There is a file in $INFORMIXDIR/etc/IIFfiles which has the correct ownership
and
perms for each file in the installation. However, the best thing to do is to
just perform a clean install using the original media.
Art S. Kagel
----- Original Message -----
From: Frank <ids@iiug.org>
At: 11/21 11:54:12
Thanks, Art and Martin,
I believe it is the permission problem! our oninit is wrong,
-rwsr-sr-- 1 informix informix 20836476 Aug 10 16:52 oninit*
I will ask them redo it,
Frank
On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
>
> What are your permissions for the oninit task? Should be:
>
> -rwsr-sr-- 1 root informix 17013152 Mar 29 2006 oninit
>
> As someone pointed out that may be a problem depending on how you 'moved'
> the
> directory tree from the original machine.
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 11/21 11:36:28
>
> Art,
>
> The informix entry is in /etc/passwd file.
> There is no other user wanted to connected to db.
> I am the only user Informix to do the oninit -i there.
>
> Looks IDS wants to build sysmaster db but it could not go through passwd
> verification somehow.
>
> > 15:02:10 Building 'sysmaster' database ...
> > 15:02:10 listener-thread: err = -951: oserr = 0: errstr = informix@otto:
> > Incorrect password or user informix@otto is not known on the database
> ser
> > ver.
> >
>
> > 15:02:27 Error building 'sysmaster' database.
> > 15:02:27 See '/tmp/buildsmi.184778'.
> > 15:07:10 Checkpoint Completed: duration was 0 seconds.
> >
> >
>
> Thanks,
> Frank
>
> On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
> >
> >
> > The messages about user 'informix' were in the log long after the oninit
> > statup.
> > Looks like someone (you?) tried to connect to the instance as 'informix'
> > but
> > there was no valid password entry in /etc/passwd. That's what error code
> > -951
> > indicates (see 'finderr -951').
> >
> > Art S. Kagel
> > ----- Original Message -----
> > From: Frank <ids@iiug.org>
> > At: 11/21 11:13:16
> >
> > Art,
> >
> > Thanks for the reply!
> >
> > What do you mean about ?
> >
> > -- Looks like you forgot to create a loginable account for user
> 'informix'
> > from otto in group 'informix' on the new server machine or otto is not a
> > trusted host there.
> >
> > The account " informix' was created. you mean it needs login passwd for
> > me to run the command oninit -i ?
> >
> > There should be no "trusted host" problem because the command was issued
> > in the same host.
> >
> > Thanks,
> > Frank
> >
> > On 11/21/06, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net>
> wrote:
> > >
> > >
> > > All of the messages I see are informational and do not indicate any
> > > problems:
> > >
> > > 15:02:00 Shared memory segment 0x40000000 could not be forced
> resident.
> > > -- Your new OS may not be configured to allow resident segments as
> large
> > > as
> > > the instance's shared memory segment is. Check the kernel settings.
> > >
> > > 15:02:00 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has
> insecure
> > > permissions
> > > -- Check and possibly modify the perms on /tmp
> > >
> > > 15:02:05 Contiguous shared memory segment allocation failed at
> > 0xd0000000.
> > > Allocation successful at 0x30000000.
> > > Check SHMBASE is consistent with the value in
> > > $INFORMIXDIR/etc/onconfig.std.
> > > If you are using the correct SHMBASE value in your ONCONFIG file, then
> > > consider this message informational only.
> > > -- Do as it says.
> > >
> > > 15:02:10 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> > listed
> > > in
> > > DBSPACETEMP: 'dbtemp1'
> > > -- These are because the ONCONFIG file has a DBSPACETEMP setting
> naming
> > > dbspaces that do not exist. Since you've just initialized the instance
> > > that
> > > makes sense. Create the temp dbspaces you want and possibly modify the
> > > ONCONFIG
> > > setting to name those new temp dbspaces and some regular ones for
> logged
> > > temp
> > > tables.
> > >
> > > 15:02:10 listener-thread: err = -951: oserr = 0: errstr =
> informix@otto:
> > > Incorrect password or user informix@otto is not known on the database
> > ser
> > > ver.
> > > -- Looks like you forgot to create a loginable account for user
> > 'informix'
> > > from otto in group 'informix' on the new server machine or otto is not
> a
> > > trusted host there.
> > >
> > > Art S. Kagel
> > >
> > > ----- Original Message -----
> > > From: Frank <ids@iiug.org>
> > > At: 11/21 10:30:08
> > >
> > > hi,
> > >
> > > we wrapped up the directory /usr/informix/ where informix was
> installed
> > > and unwrapped it at another machine.
> > >
> > > When we run oninit -iv, it gave the following info.
> > >
> > > Any idea?
> > >
> > > Thanks,
> > > Frank
> > >
> > > informix@otto $ onstat -version
> > > Program Name: onstat
> > > Build Version: 10.00.UC5
> > > Build Number: N202
> > > Build Host: ibm6c1b
> > > Build OS: AIX 5.2
> > > Build Date: Thu May 18 00:09:08 CDT 2006
> > > GLS Version: glslib-4.00.UC8
> > >
> > > informix@otto $ 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
> '/usr/informix/etc/onconfig.otto'...succeeded
> > > Creating /INFORMIXTMP/.infxdirs...succeeded
> > > Creating infos file "/usr/informix/etc/.infos.ncdcprd_tcp"...succeeded
> > > Linking conf file "/usr/informix/etc/.conf.ncdcprd_tcp"...succeeded
> > > Writing to infos file...succeeded
> > > Checking config parameters...succeeded
> > > Allocating and attaching to shared memory...succeeded
> > > Creating resident pool 68068 kbytes...succeeded
> > > Allocating 1600016 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 5 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
> > > Forking 1 'ipcshm' listener threads...succeeded
> > > Starting tracing...succeeded
> > > Initializing 16 flushers...succeeded
> > > Initializing log/checkpoint information...succeeded
> > > Opening primary chunks...succeeded
> > > Opening mirror chunks...succeeded
> > > Initializing dbspaces...succeeded
> > > Validating chunks...succeeded
> > > Crea
pls go thru log file generated in /tmp/filename its given in the log And did you set INFORMIXSERVER parameter properly in .profile
Related threads
- TABLE AN INDEX REORG
- ROLE FOR USERS
- HDR in Windows
- eliminate duplicate rows
- Fragmentation Elimination Problem