Due to lack of space, I have to move my Oracle db of my test instance to another box.

Once the db is created and configured the network (tnsnames, …), I have edited the tabledef6.1 file changing the ORACLE_HOME variable with the new value and the ORACLE_SID with the new value.

After this, I have imported the company 000 by the oracle imp command and executed the $BSE/bin/ora8.admin6.1 script, without problems.

Does anyone know how to set up my BaaN/Oracle, because when I try to connect by the windows client, BaaN shows me the error 510?

Thanks you,

Joan Sanchez

Make sure you can sqlplus from the application server to the database server.

If that works then:
If you are Oracle 8/9 you've probably set oracle_client_home
in your db_resource. Your tnsnames.ora should be in that directory (oracle_client_home/network/admin). Otherwise you could unset ORACLE_HOME in your tabledef6.1 and set TNS_ADMIN and point that to
where your tnsnames.ora is. (For example TNS_ADMIN=${ORACLE_HOME}/network/admin ) [ of course you can't use $ORACLE_HOME, so fill in the complete path..

Dave

Check out sol #165479 on the support website for more info..

Dave

try to set two_task,
i know, it's called local under nt,
but it works for me too (under w2k),
tabledf6.1 should be

oracle8(two_task=,SID=,NLS_LANG=,TNS_ADMIN=,NLS_SORT=)

please try

Hi!

Get it:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=25685

By!