Voilà ce que j'ai quand je fais sqlplus system :
$ sqlplus system
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Il y a quelque chose que j'ai mal fais mais je ne sais pas comment chercher ( et réparer cette erreur ). libsqlplus.so ce trouve à l'emplacement suivant : /usr/lib/oracle/11.1/client64/lib/libsqlplus.so
Voilà mon tnsnames.ora
$ cat /etc/oracle/tnsnames.ora
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = BlackPearl)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
et un tnsping XE
$ tnsping XE
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 16-MAY-2009 15:19:23
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = BlackPearl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)
et mon /etc/sysconfig/httpd
cat /etc/sysconfig/httpd
# Configuration file for the httpd service.
#
# The default processing model (MPM) is the process-based
# 'prefork' model. A thread-based model, 'worker', is also
# available, but does not work with some modules (such as PHP).
# The service must be stopped before changing this variable.
#
#HTTPD=/usr/sbin/httpd.worker
#
# To pass additional options (for instance, -D definitions) to the
# httpd binary at startup, set OPTIONS here.
#
#OPTIONS=
#
# By default, the httpd process is started in the C locale; to
# change the locale in which the server runs, the HTTPD_LANG
# variable can be set.
#
#HTTPD_LANG=C
export LD_LIBRARY_PATH=/usr/lib/oracle/11.1/client64/lib
export NLS_LANG=FRENCH_FRANCE.AL32UTF8
export TNS_ADMIN=/etc/oracle
Voilà où j'en suis.