When I was trying to LOGIN BAAN from baan user name and password I was encountered with the error message attached below
Your kind support for the above matter is welcome and appreciated.

When I was trying to LOGIN BAAN from baan user name and password I was encountered with the error message attached below
Your kind support for the above matter is welcome and appreciated.

Hello,
as the message say:

Your database is not on.
Start the database.

Regards

Or it can't find your instance. Is your tabledef6.x still the same? If so try to login with sqlplus to check if the instance still is available.

hello,

Please be informed , the problem you specified is too generic .
From Your Profile i Understand that it is of Windows 2003 server , Oracle DB , Baan IVc4.

is the App. server and db on same machine .

if yes - try contacting your DBA

mean time - verify the following :

1.Open services.msc and check the Oracle services of Type "Startup" is in Started State - if not , start it.

2.As mr.Han said - try login in sqlplusw

3.Goto Command Mode and Type "lsnrctl status" - if it does not show ready state - let us know what it says.

4.still does not help - then post the "tnsnames.ora" file (using windows search)

5.Try Tnsping - http://www.orafaq.com/wiki/Tnsping

Regards,
Sushil Kumar Mudaliar

Hi Sushil,

The same 510 error we are getting in ERPLN , and DB is MS SQL 2005.
We are in FP3. So every alternative days, we face this error and restart the server each time. Else users cant use the system.

Thanks in advance.

Regards,
P. Jayanthi

i advise to check these items, google if not familiar. also read the performance tuning doc on sql server.

1) check tabledef, db_resource, mssql_storage, make sure these are properly set
2) check size of tempdb, prefer to move it to separate drive, shrink it if it's a problem.
3) check that BSE_REM is not set on App server
4) please check if the following is applicable to you:

execute sp_configure 'show advanced options', 1
reconfigure with override
execute sp_configure 'max degree of parallelism', 1
execute sp_configure 'priority boost', 0
execute sp_configure 'lightweight pooling', 1 <<< i remember this is especially important.
execute sp_configure 'max worker threads', 255
execute sp_configure 'open objects', 0

5) again please check if applicable to you by looking at your values:

Please go into the Windows Registry & set the shared section in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\windows to:
1024,3072,2048 <<< most of the time you have to change the 3rd number only.