Hi,

After reboot of my test server, I can not logoin back to BAAN. The error I am getting is:

Eror 510 (Database not on) on SELECT

Error in log.oracle8 is:

# tail log.oracle8
2007-07-25[11:20:47]:E:mvr: Check the Oracle settings:
2007-07-25[11:20:47]:E:mvr: NLS_LANG = '' (default US7ASCII)
2007-07-25[11:20:47]:E:mvr: ORACLE_HOME (client) = '/baan2/bse/lib/ora/oracle_home' (resource oracle_client_home)
2007-07-25[11:20:47]:E:mvr: ORACLE_HOME (server) = '/app/oracle/product/8.1.7' (resource oracle_server_home)
2007-07-25[11:20:47]:E:mvr: Oracle Service Name = 'BAAN4b' (resource oracle_service_name --> TWO_TASK)
2007-07-25[11:20:47]:E:mvr: TWO_TASK = 'BAAN4b'
2007-07-25[11:20:47]:E:mvr: ORACLE_SID = 'BAAN4b' (ignored)
2007-07-25[11:20:47]:E:mvr: Logon failed; errno 510
2007-07-25[11:20:47]:E:mvr: Flushed at /port.6.1c.06.02/vobs/tt/servers/ORACLE_2/ora_driver.c : #215.
2007-07-25[11:20:47]:E:mvr: ******* E N D of Error message *******

Any idea why is this happening?
Any input is wellcome.

Regards,
Miro Vran

Apparently your Baan installation and Oracle are on two different servers, is Oracle up? Can you connect directly to Oracle?

Hi Victor,
Thank you for the reply. When I tryt o connect to database ( using Enterprice Manager ), I am getting ORA-12541:TNS:no listener error.

ORA-12541: TNS:no listener

Cause: The connection request could not be completed because the listener is not running.

Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

http://download-east.oracle.com/docs/cd/A58617_01/server.804/a58312/newch255.htm

Refer to the http://technet.oracle.com documentation for more info.

Thank you I will look in to that solution.