Error Creating IDS 7.30 Database on Solaris 2.5.1

[sigterm72]

Im getting the folowing errors when creating a new database.
-----------------------------------
10:49:04 Requested shared memory segment size rounded from 373824KB to 376832KB
10:49:08 shmctl: errno = 1

10:49:08 Shared memory segment 0xa000000 could not be forced resident.
10:49:08 Requested shared memory segment size rounded from 64000KB to 65536KB
10:49:08 Could not disable priority aging: errno = 1

Thu Jun 13 10:49:09 2002

10:49:09 Error: Unable to reset open files limit, must run as super-user
10:49:09 Event alarms enabled. ALARMPROG = '/export/home/informix/etc/log_full.sh'
10:49:09 Could not disable priority aging: errno = 1
10:49:09 Could not disable priority aging: errno = 1
10:49:14 DR: DRAUTO is 0 (Off)
10:49:14 Requested shared memory segment size rounded from 600KB to 608KB
10:49:15 Informix Dynamic Server Version 7.30.UC5 Software Serial Number ACN#J307625
10:49:20 Informix Dynamic Server Initialized -- Complete Disk Initialized.
10:49:20 Warning: Invalid dbspace 'tempspace' listed in DBSPACETEMP.
10:49:20 Checkpoint Completed: duration was 0 seconds.
10:49:20 Dataskip is now OFF for all dbspaces
10:49:20 On-Line Mode
10:49:20 Could not disable priority aging: errno = 1
10:49:20 Affinitied VP 1 to phys proc 1
10:49:20 Could not disable priority aging: errno = 1
10:49:20 Affinitied VP 4 to phys proc 3
10:49:20 Could not disable priority aging: errno = 1
10:49:20 Affinitied VP 3 to phys proc 2
10:49:20 Building 'sysmaster' database ...
10:49:21 listener-thread: err = -951: oserr = 0: errstr = informix: Incorrect password or user informix is not known on the database server.

10:49:21 listener-thread: err = -951: oserr = 0: errstr = informix: Incorrect password or user informix is not known on the database server.
---------------------------------------

my /etc/system file has the follwing statements for shared memory and semaphores.

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=100
set semsys:seminfo_semmap=64
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=100

Any help Appreciated,

THanks

 

[schu]

It looks like you may have copied an onconfig file from another database server and used it here.

I suggest you use the onconfig.std, edit your SHMBASE, server number, nettype connections , dbserveralias, dbservername and other base parameters first.

The check the sqlhosts and /etc/services files to see if you have a port allocated to your tcp services.

e.g. if you have
aaaa tlitcp,30,100,CPU
you should have in the /etc/services something like
aaa 8888/tcp

Now try to start your basic system on these parameters.

If it works, create all your dbspace and chunks, reallocate your logical logs if necessary
Once you have set your dbspace/chunks and logical logs, you should be able to safely use the original config file


I have installed nformix 7.31 on solaris many times and have not encountered any major start up problems using this method.

 

[sigterm72]

I tried what you just asked. I copied the onconfig.std over. Made the necessary changes and then did on oninit -y. I am no longer getting the error that shared memory is a problem but I am unable to get the informix user to be recognized. I checked the sqlhosts file and the services fie and they have the correct info in them.

 

[schu]

I am not sure what you mean by Informix not being recognized.

But I guess that it may be a Network setting problem. Try to copy your original NETTYPE parameter setting to the new onconfig file.

 

[sigterm72]

The Informix user is not allowed to log into the server. The same message that appears in my first post.

My old onconfig file came from a 7.14 database that was upgraded. I didn't create it and am new to informix. I'm an oracle/postgresql DBA. The box is a vendors and I'm trying to create a box for testing/disaster recovery.

I thought about doing a dbexport and import into the new box but since I cant create a new DB on this box then I cant exactly recreate the old one.

I dont have a NETTYPE parameter in the old onconfig file so I need a little help getting that setup.

Thanks

 

[schu]

Try insert
NETTYPE ipcshm,1,100,CPU

after the DBSERVERNAME DBSERVERALIAS

and see if you can connect

 

[sigterm72]

I tried that. didnt work

I changed to tlitcp,1,100,cpu and that did not work either.

 

[schu]

if you are getting error 951 it may be a corrupt .netrc file