- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Baan x Unix x NT
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 07:47 AM
тАО07-16-2002 07:47 AM
I have a problem that I have to consider in do the following:
I have BaanIV with Oracle in the same server (UNIX HPUX11.00). I don't have disk space and I'm trying to user Baan on UNIX and a database (export/import) on NT with Oracle (same version that unix).
Anyone can help me or know if it is possible?
My initial problem is how to set oracle_home on Baan environment on UNIX server...?
Thanx,
Lima.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 08:02 AM
тАО07-16-2002 08:02 AM
Re: Baan x Unix x NT
You don't have many ORACLE env variables to change because you are still going to need Oracle (at least the network client pieces) on your UNIX box; ORACLE_HOME will stay the same. Each Baan user has a .profile so that that will take care of any changes. The best way is to have a file (e.g. /usr/local/bin/baanenv.sh) that each .profile sources.
e.g. . /usr/local/bin/baanenv.sh
(This file must not have an exit or return statement).
You will need to change (actually not set) ORACLE_SID. Replace it with export TWO_TASK=baanprdnt (or whatever the listener name is).
You will need to set up a listener on your NT box. After setting TWO_TASK on your UNIX box, you must be able to use sqlplus to make a test connection to your NT box.
Your final step is to change ${BSE}/lib/tabledef6.1.
Each line will have something like
ccrmp530:*:oracle8(ORACLE_HOME=/u01/app/oracle/product/8.1.7,ORACLE_SID=baanprd):N
You need to change ORACLE_SID=baanprd to TWO_TASK=baanprdnt (or whatever you set the listener up as).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 10:09 AM
тАО07-16-2002 10:09 AM
Re: Baan x Unix x NT
we have common directory with .profile for all user baan on Unix;
well, if I did undertand I have to have Oracle installed on UNIX, ok? If not, how can I run sqlplus to connect to NT
DB?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2002 10:25 AM
тАО07-16-2002 10:25 AM
SolutionOn your UNIX box you must have an entry in ${ORACLE_HOME}/network/admin/tnsnames.ora that matches your TWO_TASK setting to complete the connection to the listener on the NT box.
Your tabledef6.1 file can actually have multiple hosts/instances configured. One might be for a table in a local Oracle instance while another might be defined as a remote Oracle or even Informix table.
I should mention that by far your easier answer is to hang more diskspace on your existing UNIX box; you are going to take a big performance hit with a remote database on an NT box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-17-2002 06:16 AM
тАО07-17-2002 06:16 AM
Re: Baan x Unix x NT
I configured and now I already have users using it system.
I have a little problem with user bsp, but I think it's a bit problem.
Thanx so much,
Best regards.
Lima.