Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th July 2004, 07:31
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Detected Database Server Termination

None of our users able to login!!
Error "Detected database server termination"!!

log.oracle8 file is attched
Attached Files
File Type: txt log.oracle8.txt (6.7 KB, 110 views)
File Type: txt log.bshell.txt (3.4 KB, 91 views)
File Type: txt olg.pdaemon6.2.txt (11.2 KB, 42 views)
Reply With Quote
  #2  
Old 26th July 2004, 07:47
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Hi there,

the information is a bit thin, but it looks like the database driver lost it's connection to the database. All the other errors are consequences from this.

Try the following:

a) Is Oracle up and running?
b) Can you conect via sqlplus?
c) Do you use SQLNet?
d) Did you try to reboot the server? It's windows after all!
e) Think also, wether you did any configuration changes, which migt have caused this?
f) Is any of the disks full?
g) Does the alert.log of oracle say anything?
h) Did a (online) backup fail?

Good luck,

Markus
Reply With Quote
  #3  
Old 26th July 2004, 08:02
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Thanks

We rebooted the server (it was Unix by the way) and it worked!!!
Reply With Quote
  #4  
Old 26th July 2004, 08:22
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
if it is unix, then you should honestly do a bit of investigation how this happened :-)

Seriously, Unix doe snot have this sporadic behaviour. You might have a kernel parameter set too small and by rebooting you freed ressources. But this just means, the error will happen again. So you better look into it.

Regards

Markus
Reply With Quote
  #5  
Old 26th July 2004, 08:35
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Yes we are facing this problem 4th time in the same server same error.

First time it was the issue of the password and once we reset it worked..

Second time the problem was that of disk full

Third time network problem..

this time rebooting!!!

Please let me know what kernal parameters needs to be checked and what are the idle values. This server is on IBM AIX4.3, Baan application B50c
Reply With Quote
Sponsored Links
  #6  
Old 26th July 2004, 09:00
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Unfortunately I can not help your here much. I am more familiar with Baan IV on HP-Ux. Anyway I am sure somebody in this forum posted at some stage the AIX Kernel Tuning Guide. Also check the Oracle requirements for AIX on Metalink.

regards

Markus
Reply With Quote
  #7  
Old 27th July 2004, 08:09
Martin Martin is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 135
Martin is on a distinguished road
Baan: IVc, ERP5c - DB: oracle 9i, 10g, 11g - OS: Windows, HP-UX, SLES8/9/10/11
Hi @all

semms it is an error on database level.
to verify, please look to the oracle udump directory and post the related trace file.

martin
Reply With Quote
  #8  
Old 9th August 2004, 06:15
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Hi Martin,

Can you let me know where is Udump directory is located.

We faced this problem again today!!!

Restarting the server is solving our problem!!!
Reply With Quote
  #9  
Old 9th August 2004, 13:07
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Ok, you're losing connection to your DB.. maybe the listener or something is crashing...

This:
2004-07-26[09:19:16(UTC-04:00)]:E:root: Pid 499960 Uid 0 Euid 0 Gid 0 Egid 0 Pset root@fpibaan1:151722
2004-07-26[09:19:16(UTC-04:00)]:E:root: user_type S language 2 user_name root tty locale ISO88591/NULL
2004-07-26[09:19:16(UTC-04:00)]:E:root: Errno 0 bdb_errno 110 (End of file reached)
2004-07-26[09:19:16(UTC-04:00)]:E:root:
2004-07-26[09:19:16(UTC-04:00)]:E:root: dbs_errno = 0Error 522 occurred:
2004-07-26[09:19:16(UTC-04:00)]:E:root: Error ORA-3114 occurred during commit.
2004-07-26[09:19:16(UTC-04:00)]:E:root: ORA-03114: not connected to ORACLE
2004-07-26[09:19:16(UTC-04:00)]:E:root:
2004-07-26[09:19:16(UTC-04:00)]:E:root: Error BDB-522 returned.
2004-07-26[09:19:16(UTC-04:00)]:E:root: Flushed at /view/port.7.1d.03/vobs/tt/servers/ORACLE_2/ora_db.c : #70.
2004-07-26[09:19:16(UTC-04:00)]:E:root: ******* E N D of Error message *******

is nothing to worry about, its your printer daemon, it won't stop you from logging in.

This:

2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: ******* S T A R T of Error message *******
2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: Log message called from /view/port.7.1d.03/vobs/tt/lib/al_1/al_sig.c: #173 keyword: CORE DUMPED
2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: Pid 8155314 Uid 294 Euid 294 Gid 125 Egid 125 Pset ravi@GEICITRIX:11208
2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: user_type N language 2 user_name 01wh4733 tty ote locale ISO88591/NULL
2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: Errno 0 bdb_errno 110 (End of file reached)
2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: Log_mesg: core_dumped() signal 11 cwd: '/appl/baan5/bse/home/06wh4733'
2004-07-26[09:19:20(UTC-04:00)]:E:01wh4733: ******* E N D of Error message *******

is your users dumping core. This is where your problem is..
do a "strings -a " on the core file that was generated "/appl/baan5/bse/home/06wh4733" and see if you can find which binary is dumping core
and if it gives a reason why.

Also check the udump and bdump Oracle directories, as well as your
unix syslog and messages file.

(Look on metalink for info on udump and bdump, ask your OS vendor for the syslog files if you don't know where they are...)

Additionally, you need to post your $BSE/lib/tabledef6.2 and all of the files in $BSE/lib/defaults/
and the output of the followings commands:
ulimit -a
bshell6.2 -v
uname -a

Dave
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to split Baan Application and Baan Database ? baaniac Operating Systems & Databases 4 2nd June 2009 03:48
Detected database server termination & Data dictionary not found kevinlee Tools Administration & Installation 1 2nd April 2004 22:09
Detected database server termination (help! aide! ayuda! hilfe! ayuto! hellup! •‚¯!)! Francesco Operating Systems & Databases 15 20th July 2002 11:37


All times are GMT +2. The time now is 04:37.


©2001-2018 - Baanboard.com - Baanforums.com