Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: DBI::Oracle - fails on apache ( ORA-12154) - but works fine local

by marto (Cardinal)
on Apr 16, 2014 at 10:08 UTC ( [id://1082476]=note: print w/replies, xml ) Need Help??


in reply to DBI::Oracle - fails on apache ( ORA-12154) - but works fine local

"Oracle-Home"

You should probably post the environment variables, those names look wrong. E.G. ORACLE_HOME rather than Oracle-Home. http://www.orafaq.com/wiki/ORACLE_HOME. If in doubt contact your system/database admin.

Replies are listed 'Best First'.
Re^2: DBI::Oracle - fails on apache ( ORA-12154) - but works fine local
by Yaerox (Scribe) on Apr 16, 2014 at 10:26 UTC

    Ohh, missunderstanding here ^^ ofc my environment variables are called: ORACLE_HOME, TNS_ADMIN, ORACLE_BASE and so on ... I just wrote it the other way here ;-)

        Here my environment variables printed with:
        perl -e 'use CGI ":all";print header;print "<pre>\n";map { print "$_ $ENV{$_}\n" } sort keys %ENV;print "</pre>\n";'

        ALSA_CONFIG_PATH /etc/alsa-pulse.conf AUDIODRIVER pulseaudio COLORTERM 1 CONFIG_SITE /usr/share/site/i686-pc-linux-gnu CPU i686 CSHEDIT emacs FROM_HEADER GPG_TTY /dev/pts/3 G_BROKEN_FILENAMES 1 HISTSIZE 1000 HOME /root HOST linux-vj3v HOSTNAME linux-vj3v HOSTTYPE i386 INPUTRC /etc/inputrc JAVA_BINDIR /usr/lib/jvm/jre/bin JAVA_HOME /usr/lib/jvm/jre JAVA_ROOT /usr/lib/jvm/jre JRE_HOME /usr/lib/jvm/jre LANG POSIX LC_CTYPE de_DE.UTF-8 LD_LIBRARY_PATH /usr/lib/mpi/gcc/openmpi/lib:/usr/lib/oracle/12.1/clie +nt/lib LESS -M -I -R LESSCLOSE lessclose.sh %s %s LESSKEY /etc/lesskey.bin LESSOPEN lessopen.sh %s LESS_ADVANCED_PREPROCESSOR no LOGNAME root LS_COLORS no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd= +40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.c +om=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31: +*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00; +31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;3 +1:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.xz=00;31:*.avi=0 +1;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.m +ng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35: +*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01; +35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00 +;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32: LS_OPTIONS -A -N --color=tty -T 0 MACHTYPE i686-suse-linux MAIL /var/mail/root MANPATH /usr/lib/mpi/gcc/openmpi/share/man:/usr/share/man:/usr/local/m +an:/usr/local/share/man MINICOM -c on MORE -sl NNTPSERVER news ORACLE_BASE /usr/lib/oracle ORACLE_HOME /usr/lib/oracle/12.1/client OSTYPE linux PAGER less PATH /usr/lib/oracle/12.1/client:/usr/lib/mpi/gcc/openmpi/bin:/sbin:/u +sr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/b +in/X11:/usr/X11R6/bin:/usr/games PROFILEREAD true PWD /root PYTHONSTARTUP /etc/pythonstart QEMU_AUDIO_DRV pa QT_SYSTEM_DIR /usr/share/desktop-data SDL_AUDIODRIVER pulse SHELL /bin/bash SHLVL 1 SSH_CLIENT 192.3.1.173 56662 22 SSH_CONNECTION 192.3.1.173 56662 192.3.1.214 22 SSH_TTY /dev/pts/3 TERM xterm TNS_ADMIN /usr/lib/oracle/12.1/client USER root WINDOWMANAGER /usr/bin/startkde XCURSOR_THEME DMZ XDG_CONFIG_DIRS /etc/xdg XDG_DATA_DIRS /usr/share XDG_RUNTIME_DIR /run/user/0 XDG_SESSION_ID 13 XKEYSYMDB /usr/X11R6/lib/X11/XKeysymDB XNLSPATH /usr/share/X11/nls _ /usr/bin/perl

        Edit: Btw. I'm using an Oracle Instantclient (v12.1) and I don't got a sqlnet.ora file anywhere ... Is there no need by using the instantclient? Im not sure about this.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1082476]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2024-03-29 15:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found