WHAT I DONE FOR “LINUX à AUBIT4GL à ORACLE”
ü Install
Oracle 10.2.0.1.0 with client Linux-Oracle à $ORACLE_HOME/lib/libsqora.so.10.1
ü $ORACLE_HOME/network/admin/listener.ora
:
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = metal3))
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC
=
(GLOBAL_DBNAME = hostname.)
(ORACLE_HOME = /oracle)
(SID_NAME
= metal3)
)
)
ü Install
“qt-devel”
ü Disinstall
(if they exist) unixODBC and unixODBC-devel
ü Create
an user (for me “aubit”) with this profile (ex.: .bash_profile ):
# FOR AUBIT4GL
export
AUBITDIR=/home/aubit/aubit4glsrc
export AUBITDIR_SRC=/home/aubit/aubit4glsrc
export
A4GL_INIFILE=/home/aubit/aubit4glsrc/etc/aubitrc
export AWK=gawk
export
DBSCREENOUT=/tmp/${USER}.out
export A4GL_PRINTSCRKEY=CONTROL-P
export
A4GL_PRINTSCRFILE=+$DBSCREENOUT
export ODDOPTIONS=N
export FORCE_CLOSE=Y
export BINDDBDATE=Y
export CACHESCHEMA=Y
export DATE_AS_CHAR=Y
export NO_UPDATE_TABLE=Y
export FIXUPDATE=Y
export A4GL_SQLTYPE=unixodbc
export DBDATE=DMY4/
export SQLUID=xxx
export SQLPWD=yyy
export
PATH=$PATH:/home/aubit/aubit4glsrc/bin:/usr/local/unixODBC/bin
export NODATETIMES=Y
export A4GL_ALLOWCOMMAINDECIMAL=Y
export LOGODBCSQL=N
export A4GL_NUMERIC=,.
export DATE_AS_ISO_DATE_STRING=Y
export USEREALTABLEFORREP=Y
export
LD_LIBRARY_PATH=/usr/local/unixODBC/lib:/lib:/lib/esql:/usr/local/lib:/home/aubit/aubit4glsrc/lib
# FOR ORACLE
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle
export ORACLE_OWNER=oracle
export ORACLE_SID=metal3
export
TNS_ADMIN=/oracle/network/admin
export
PATH=$PATH:/oracle/bin:/usr/local/java/bin
export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/oracle/lib:/usr/lib:/oracle/oraclient
export
NLS_DATE_FORMAT="DD-MM-YY"
# FOR UNIXODBC
export
ODBCDM_HOME=/usr/local/unixODBC/etc
export
ODBCINI=/usr/local/unixODBC/etc/odbc.ini
export
ODBCINSTINI=/usr/local/unixODBC/etc/odbcinst.ini
ü Install
unixODBC-2.2.12.tar.gz (with simple user)
tar
xvfz unixODBC-2.2.12.tar.gz
./configure
--prefix=/usr/local/unixODBC
make
su
make install
Configuration files:
/usr/local/unixODBC/etc/odbc.ini
:
[hsmetal3]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle 10g ODBC driver
DSN = OracleODBC-10g
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = metal3
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
UserID =
/usr/local/unixODBC/etc/odbcinst.ini
:
[ODBC]
Trace
= No
TraceFile = /tmp/sql.log
[Oracle 10g ODBC driver]
Description
= Oracle ODBC driver for Oracle 10g
Driver
= /oracle/lib/libsqora.so.10.1
Setup
=
FileUsage
=
CPTimeout
=
CPReuse
=
ü Install
aubit4glsrc.x.xx.xx.tar.gz
tar
xvfz aubit4glsrc.x.xx.xx.tar.gz
./configure
--with-unixodbc=/usr/local/unixODBC --prefix=/home/aubit/aubit4gl
make
(no
make install)