how to compile database oracle

[Giada Bonfà]

Hi,
We need to install the ODBC driver for oracle 8.1.7.
After that installation is it necessary to recompile oracle?

We think that exist a relink command or procedure, is it true? How does it work?

thank you

[James Specht]

If I am reading this correctly you have installed ODBC drivers on the client side, I'll assume for Windows. If that is the case you do not have to do anything else on the server side. Just install the ODBC drives from the Oracle CD in the same place as your client side software is installed, NT server or novell server I would also assume. Once installed you will just have to configure the client to use the driver. it should be sqaora32.dll. Once you have a single system set up with the correct drivers and support steal the reg entries and the data source files to install on other systems.

If you need help on the client side, let me know. It is pretty straght forward in Windows. But if you would like I can shoot a copy of a batch file I wrote to force the ODBC drivers onto a Windows system along with the reg entries and Data source files.

[Steven E. Protter]

log on as the user that owns the oracle database.

for us, user oracle

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk install

As to whether to do it, don't know.

To get good executables, you'll need to be current on December 2002 Patches and recommended oracle patches above and beyond that.

SEP

[Steven E. Protter]

Corrected text.

log on as the user that owns the oracle database.

for us, user oracle

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk install

cd $ORACLE_HOME/bin

./relink all

As to whether to do it, don't know.

To get good executables, you'll need to be current on December 2002 Patches and recommended oracle patches above and beyond that.

SEP

[Indira Aramandla]

From you question I understand that you have installed oracle 8.1.7 on the Server. Now you need to install the ODBC drive for oracle 8.1.7 on the client side to establish a connection to the database.

So all you need to do is install the ODBC driver for oracle 8.1.7., define the data source. And test it by trying to connect to the database via ODBC driver.