I have Baan IV, Oracle 8, NT on one server. say A-1234(server name)

Now I have another server B-1234 where I ahve installed Baan IV application only. Now how to configure so that B-1234 works as an application server and A-1234 as a database server?

Regards,
Srinivas

edit your tabledef6.1 at B1234 to point to another server (a1234).

I believe you would have to edit ttaad4110m000 to include System Name (in this case A-1234).

What Oracle Serives do I have to install on B-1234?
Does it need any SQL NET services?

If you have Baan installed on the new application server, will you still be running Baan on the database server (for example for batch jobs)?

The Baan app server will need to have Net8 installed and the listener will have to be configured on the database server. Then, instead of having the ORACLE_HOME and ORACLE_SID in your tabledef file, you will refer to the ORACLE_SID in the tnsnames.ora (or name services) file. The Oracle installation guide for Baan has some examples. If you need more information, let me know via a post here and I will post some examples.

-- Jim

Let me explain in detail what I am doing.

I have installed BaaN IVC4, and Oracle database on a machine say A-1234.
Now I want to install BaaN on another m/c B-1234 which will act as an application server only. I loaded Oracle Client on this m/c and so Net80 is installed I suppose. But here while loading baan I selected the option User Interface + logic and given A-1234 asthe databse. But I found that Application directory is not instaaled and tools tables are also not installed. My question is why the are not installed? If these are not present in B-1234 how can I use as a test server(for baan application)?

Next How the tabledef file should look in my Application server i.e. B-1234.


My TNSORA file is like this

********************************************

Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS=
(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
(ADDRESS=
(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
(CONNECT_DATA=(SID=ORCL))
(SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC0)
)
(CONNECT_DATA = (SID = extproc)
)
)


spider.world =
(DESCRIPTION =
(SDU=8096)
(TDU=8096)
(ADDRESS =
(COMMUNITY=tcp.world)
(PROTOCOL = TCP)
(Host = A-1234)
(Port = 1521)
)
(CONNECT_DATA = (SID = BAAN)
)
)


*********************************************


TABDEF file looks like
********************************************


*:*:A-1234
*****************


LISTENERORA FILE ON DATABASE SERVER looks like

**************************************************


LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= baan.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= EXTPROC0)
)
(ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= A-1234)
(PIPE= ORAPIPE)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= A-1234)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= A-1234)
(Port= 1526)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= spider)
(Port= 1521)
(QUEUESIZE=1000)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 1000
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = A-1234)
(SID_NAME = BAAN)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = ()


*****************************

ALSO I added some env variables on application server
LOCAL=spider
ORACLE_HOME=D:\orant
ORACLE_SID=BAAN

But SQL Plus is not connecting to Database server from Application server after I changed TNSORA on client and LISTENERORA on server as I have shown above. Before that it connected

Pls.let me know if u want some more info

Regards,
Srinivas

First of all, the UI + Logic is a "Fat Client" installation that does not include the application directories or tools. It only includes the capability to run the bshell on the same server as the bw client.

I will take a look at your files and make another post, but the tabledef is very bare at this point. What does it look like on you DB server?

-- Jim

From your post and the "test server" phrase, I think there'se something wron about the roles you want for your A/B machines...

A has SQL+Baan(full). This is to remain as it is?

So, B will be used for what exactly?

1. Do you want to setup B as a test server (but keeping A as it is)? Then you need a second database for B (as a clone of A).
You cannot have different application on A and B but trying to access/keep the same DB data.

2. or you want to split load balance by having the database on A1234 and Baan(full) on B1234? If so, you want a Baan(A)->Baan(B, thin)->Oracle(B) or a direct Baan(A)->Oracle(B)?

3. other option?

This is the a part of tabledef on the DB Server
*******************************************************************

cpcom000:*: oracle8(ORACLE_HOME=E:/orant,ORACLE_SID=BAAN,NLS_SORT=BINARY):Y
cprpd000:*: oracle8(ORACLE_HOME=E:/orant,ORACLE_SID=BAAN,NLS_SORT=BINARY):Y


********************************

Victor - I have seen such a setup in my previous company.

BaaN (Full Application), Informix Database on a Unix m/c
BaaN (full application) On an NT server.
Some users were on Unix and some on NT. So a baan user on NT cannot log in to unix. Ofcourse users on NT said baan was very SLOW. If we make a print session in Unix baan we had to make the same(import the session dump) in NT baan.

Yes you can have that, but it's something I don't see advantages on (maybe somebody can clarify this by posting advantages?)

On that kind of setup you need to keep sync'd both servers regarding dict, application and same portingset version, otherwise there are inconsistencies between the APDD and RTDD.
Anything that is changed on one server must be reflected on the other (OS level).