Page=AubitOracle Aubit Computing Ltd.
C o m p u t i n g   L t d
Client Extranet
Home | Services | Products | Contact | Clients |
Home
LINUX4AUBIT4GL4ORACLE

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)

 

 


Copyright 2004-2012 © Aubit Computing Limited