If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > I can't start Informix

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-31-04, 11:41
AlfredoDS AlfredoDS is offline
Registered User
 
Join Date: Mar 2004
Location: Germany
Posts: 18
I can't start Informix

Hello,

I installed IDS and Client SDK on a Linux machine. After that I have define correctly the environment variables INFORMIXDIR, INFORMIXSERVER, LD_LIBRARY_PATH, PATH. The files onconfig and sqlhosts are also Ok (I think so).

But when I want to initialize a database using the command oninit -vi, everything runs succesfully till the line:

Initializing ASF

at this point I get the shell prompt again and the db isn't started. How can I do?

Best Regards

Alfredo
Reply With Quote
  #2 (permalink)  
Old 09-07-04, 13:39
RobP RobP is offline
Registered User
 
Join Date: Mar 2004
Location: Netherlands
Posts: 183
Hi Alfredo,

ASF problems normally occur when you have setup the wrong communication settings. The most probable reason is the sqlhost file or the NETTYPE onconfig parameter. Either they don't match or you have specified an incorrect protocol. A common problem is that people set-up TLI (with ontlitcp) while Linux is using sockets (onsoctcp). If this doesn't help please post your sqlhosts file and your onconfig.

Hope this helps,

Rob Prop
Reply With Quote
  #3 (permalink)  
Old 09-07-04, 13:56
bull_abraham bull_abraham is offline
Registered User
 
Join Date: Feb 2004
Posts: 32
post the output of
oninit -v
sqlhosts file entries.
/etc/services file entries.

-Abraham
Reply With Quote
  #4 (permalink)  
Old 09-07-04, 13:59
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi Alfredo,

If you SO is Linux, please do upgrade of glibc.

Gustavo.
Reply With Quote
  #5 (permalink)  
Old 09-08-04, 08:17
AlfredoDS AlfredoDS is offline
Registered User
 
Join Date: Mar 2004
Location: Germany
Posts: 18
onconfig, sqlhosts, services, oninit -v

Hello,

many thanks to all. I post the files you suggest.

Hi Gurey. Yes, my SO is Linux and my glibc is the 2.2.5-164. Should I actualize it?

Best Regards

Alfredo
Attached Files
File Type: txt onconfig.txt (10.4 KB, 276 views)
File Type: txt oninit.txt (735 Bytes, 253 views)
File Type: txt services.txt (297.7 KB, 415 views)
File Type: txt sqlhosts.txt (1,017 Bytes, 241 views)
Reply With Quote
  #6 (permalink)  
Old 09-08-04, 08:53
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi,

Yes, Up to 2.2.5-165 or highest.

Gustavo.
Reply With Quote
  #7 (permalink)  
Old 09-09-04, 04:05
matute matute is offline
Registered User
 
Join Date: Jun 2004
Location: Madrid, Spain
Posts: 47
Hi,

From the files you sent, it seems that you've missed the DBSERVERNAME parameter:

- Double check that the IFX server name you're using in the sqlhosts file exists in the onconfig file (DBSERVERNAME or DBSERVERALIAS).
- Double check that the host name you're using exists in /etc/hosts.
- I've seen that the service name you're using exists in /etc/services. Double check it anyway.

And next time pls. send the last lines on the online.log file (or the file you've used according to MSGFILE parameter).

Hope it helps.
__________________
José Luis Matute.

Regards from Spain.
Reply With Quote
  #8 (permalink)  
Old 09-09-04, 07:54
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi,
The onconfig.txt file is the default. You should do a copy of the onconfig.std and customizing that copy, should change the values of DBSERVERNAME, DBSERVERALIAS, NUMAIOVP, etc.
I agree with Matute.

Gustavo.
Reply With Quote
  #9 (permalink)  
Old 09-09-04, 11:19
AlfredoDS AlfredoDS is offline
Registered User
 
Join Date: Mar 2004
Location: Germany
Posts: 18
Problem is always there

Hello,

i tested everything you say and unfortunately the problem continues. I check all the values again and the problem is still there. The last lines from the file online.log are:
--------------------------
Mon Sep 6 14:37:39 2004

14:37:39 Event alarms enabled. ALARMPROG = '/opt/informix/etc/log_full.sh'
14:37:39 Assert Failed: net_init.c, line 319, thread 1, errno=13, error in creating /INFORMIXTMP.
14:37:39 Informix Dynamic Server Version 9.30.UC2E3
14:37:39 Who: Session(0, @, 0, 0)
Thread(1, main_thread, 0, 1)
File: neterrb.c Line: 658
14:37:39 stack trace for pid 1131 written to /tmp/af.3e95a13
14:37:39 See Also: /tmp/af.3e95a13, shmem.3e95a13.0
14:37:40 neterrb.c, line 658, thread 1, proc id 1131, net_init.c, line 319, thread 1, errno=13, error in creating /INFORMIXTMP..
14:37:41 PANIC: Attempting to bring system down
--------------------------
The system date on the server is not correct, should be Thu Sep 9, but is not important.

Please help !!! What can I do now?

Best Regards

Alfredo
Reply With Quote
  #10 (permalink)  
Old 09-10-04, 07:51
matute matute is offline
Registered User
 
Join Date: Jun 2004
Location: Madrid, Spain
Posts: 47
Hi,

From the system error (13) it seems it's trying to create/access some files during initialization, and the permission isn't right. It could also be a problem during installation: as far as the oninit process sould have permissions 6755 (notice the set-owner-id and the set-group-id bits) and be owned by root, there should be no problem creating any file. Have you branded the product, runing the RUN_AS_ROOT.xx script? Also check the informix product directories permissions and the chunk persmissions.

If the problem continues and the log states about an af file, send the first lines.

Another point: have you set the ONCONFIG env. variable (it should be your onconfig file name, without the path).

Keep trying,
__________________
José Luis Matute.

Regards from Spain.
Reply With Quote
  #11 (permalink)  
Old 09-13-04, 03:34
AlfredoDS AlfredoDS is offline
Registered User
 
Join Date: Mar 2004
Location: Germany
Posts: 18
Now problem with chunk

Hello,

Thank you very much Matute. I change the owner and rights for oninit and the command oninit -iv comes through. Now I get a problem with the chunk. Excuse me, but I'm not Linux Administrator. I have define as ROOTPATH the path /dev/online_root and this is the chunk for the root dbspace, I think. I get the following error messages:

oninit: Cannot open chunk '/dev/online_root'. errno = 2
oninit: Fatal error in shared memory initialization

What should be /dev/online_root? A directory or a file? Which permission should it have? What should I do in a Linux level to create this chunk? Please, if you can, tell me exactly the required commands to do this.

Best Regards

Alfredo

Pdta: I see you come from Spain. I speek also español, I live in Germany but I come from Southamerica.
Reply With Quote
  #12 (permalink)  
Old 09-14-04, 10:25
artemka artemka is offline
Registered User
 
Join Date: May 2004
Location: New York
Posts: 248
make sure the chunk in user group informix and the permisions are correct

chown informix:informix chunk_name
and the permision is 660

chmod 660 chunk_name

Cheers

Artem
Reply With Quote
  #13 (permalink)  
Old 09-17-04, 03:05
AlfredoDS AlfredoDS is offline
Registered User
 
Join Date: Mar 2004
Location: Germany
Posts: 18
Now works

Hello,

many thanks for all your tips. My Database Server runs now without problem !!!

Best Regards

Alfredo
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On