Connecting to Oracle from a Sun Server

[Matf]

Hi,

I have a map that connects to an Oracle database and grabs information. When I run it in my local machine it works fine. However, when I compile it in the sun format and FTP it into the server and run it, it fails to connect to the database.

I have made sure that the TNS name is in the server and when I try to connect to oracle from the server prompt it works. However my maps cannot connect.

Any ideas?
I would really appreciate it.

 

[MrStiffler]

Have you made the changes described in the System Requirements (Chapter 1 in the Oracle Adapter Reference, page 6 & 7 )
I'm just doing the same thing as you !
Do you have some mercator samples to work whit a oracle db?
greets

 

[Matf]

I don't know what the Oracle Adapter Reference is. I basically don't have any documentation from Mercator only the on-line documentation.

I have 2 maps that access the database in different ways one through the input card the other in a dblookup. If you send me your email I can send those to you.

 

[Keyno]

Try "-TE logfile " adapter command to trace error then if you want you can write it to here.

 

[jinkys]

What files did you transfer? Did you include the mdq file?

 

[Matf]

The problem seems to be that I have Mercator 6.5.2 and I'm trying to connect from a Sun server to Oracle 9i. fr what I can gather Mercator does not have drivers on 6.5.2 to connect to Oracle 9i. Some people have told me that I need to rename some driver or something like that.

Has anybody had this issue?

 

[MrStiffler]

Here are the system requirements and an description how to install connection from a sun unix server :

System Requirements
In addition to the requirements detailed in the Getting Started book, to install and
run the Oracle database adapters:
? You must be running Oracle 7 version 7.3.4 or Oracle 8 version 8.0.5 or later.
? Verify that the Oracle environment variables (for example, ORACLE_HOME) are
defined. Refer to your Oracle documentation for information about how to do
this.
? When running on UNIX, the Oracle client creates a process whenever a
connection is made to Oracle. If any of these processes terminates, defunct
processes will remain in the process list. Although not required (because these
do not cause problems nor do they consume resources), you can prevent this
occurrence by adding the following line to the sqlnet.ora file in the
$ORACLE_HOME/network/admin path:
bequeath_detach=YES
The effect of this line will be to create these same connection processes as
detached orphans, thus eliminating the possibility of them becoming defunct.
? Set the shared library path environment variable for UNIX.
After installing the database adapters on a UNIX platform and running the
environment variable setup program (setup), add the Mercator directory to
your shared library path environment variable if it is not already there. The
following instructions assume that your Mercator installation directory is
defined in the environment variable MERC_HOME_DIR.


O r a c l e A d a p t e r R e f e r e n c e G u i d e
Note After you have initially run the setup program, if you make changes to
your path and/or library path at a later date, you need to re-run this
program.
Note These instructions assume that your UNIX environment is the Korn (ksh)
or Bourne (sh) shell.
For HP-UX
SHLIB_PATH=$MERC_HOME_DIR/libs:$ORACLE_HOME/lib:$SHLIB_PATH
export SHLIB_PATH
For Sun Solaris
LD_LIBRARY_PATH=$MERC_HOME_DIR/libs:$ORACLE_HOME/
lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH
For IBM RS/6000 AIX
LIBPATH=$MERC_HOME_DIR/libs:$ORACLE_HOME/lib:$LIBPATH
export LIBPATH
For Compaq Tru64 UNIX
LD_LIBRARY_PATH=$MERC_HOME_DIR/libs:$ORACLE_HOME/
lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH



i hope you can use it as help
greets stiffler
if you like send me that files: dj1@gmx.ch

 

[Matf]

Mrstiffler,

Thanks for the info. However, we have discovered a problem with Mercator. Mercator version 6.5.2 does not connect to Oracle 9i from a sun server. This has been confirmed by the vendor.

The only way to connect to Oracle 9i if you have Mercator 6.5.2 is to get the oracle drivers that come with Mercator 6.7.1 rename them to have the same name as the Mercator 6.5.2 drivers and copy them into the Mercator/libs directory. This is a little cheat that will confuse Mercator enough to communicate to the database.

I have not been able to test this, so it's all hearsay. However if somebody wants to try please let me know how it goes