Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: check_oracle_health

  1. #1

    check_oracle_health

    Hi,

    Has someone installed the oracle client and the plugin check_oracle_health ?

    I have installed oracle client 11.2 + sqlplus + SDK with dpkg -i .deb (i have download the .rmp and use the software Alien to convert the files)
    In ~/.bashrc and /etc/environnement, i have set the ORACLE_HOME environnement
    export PATH=$PATH:/usr/lib/oracle/11.2/client
    export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib
    export TNSADMIN=~
    export ORACLE_HOME=/usr/lib/oracle/11.2/client
    After, i have created the file tnsname.ora and the file "oracle.conf" in /etc/ld.so.conf.d and set "ORACLE_HOME/lib"

    And now, when i launch "sudo ./shinken.sh -p check_oracle_health", the prompt shows a alert message and stop the process :
    you must set the ORACLE_HOME environment variable !
    I search on Internet and don't find an other files which i have to set the variable...

    Thanks
    orygynz
    Ubuntu 10.04.3 LTS on ESXi 4.1
    Shinken 0.8.5

  2. #2
    Shinken project leader
    Join Date
    May 2011
    Location
    Bordeaux (France)
    Posts
    2,131

    Re: check_oracle_health

    What about :

    Code:
    sudo su -
    export PATH=$PATH:/usr/lib/oracle/11.2/client
    export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib
    export TNSADMIN=~
    export ORACLE_HOME=/usr/lib/oracle/11.2/client
    cd /home/shinken/******
    ./shinken.sh -p check_oracle_health
    ?

    So we will be sure that the sudo don't remove env variables.
    No direct support by personal message. Please open a thread so everyone can see the solution

  3. #3
    Senior Member
    Join Date
    Oct 2011
    Posts
    139

    Re: check_oracle_health

    my two cents :
    create a file in /etc/profile.d/oracle.sh
    make it executable
    and write the information in it

    export PATH=$PATH:/usr/lib/oracle/11.2/client
    export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib
    export TNSADMIN=~
    export ORACLE_HOME=/usr/lib/oracle/11.2/client

    logout/login and retry

  4. #4

    Re: check_oracle_health

    First, i try your solution dguenault and it doesn't work or maybe i miss something. I create the file and put the informations. I launch the command : "chmod a+x oracle.sh". Just for information, the owner is root but i think it's not a problem because i launch the command with sudo. After, i have the same error message.

    Then, i have try your solution naparuba and it's work !

    I think now it's not a problem with shinken, i will try to find why my server don't read my informations on .bashrc (ORACLE_HOME, etc...) but if you have an idea.

    Thanks for your help.
    Ubuntu 10.04.3 LTS on ESXi 4.1
    Shinken 0.8.5

  5. #5
    Shinken project leader
    Join Date
    May 2011
    Location
    Bordeaux (France)
    Posts
    2,131

    Re: check_oracle_health

    You're welcome ;D
    No direct support by personal message. Please open a thread so everyone can see the solution

  6. #6

    Re: check_oracle_health

    Mmmmhhhhh

    I have installed the three packages (basic/sdk/sqlplus) but i haven't got the "tnsping" in $ORACLE_HOME/bin.

    But to use some scripts, i must have this command. In my bin, i just have : adrci / genezi / sqlplus

    I know that it's not a shinken's problem, i have post a message on oracle forum but for now, no response... Maybe someone has got the same problem when he installed shinken with this plugin.

    Thanks.
    Ubuntu 10.04.3 LTS on ESXi 4.1
    Shinken 0.8.5

  7. #7

    Re: check_oracle_health

    I have a response on oracle forum :

    No "admin" type tool / client command is included with Instant Client (or other packages built on top, like ODAC). Instead you would have to install a Client home type from one of the full Database Client installation medias.
    So it's normal...
    Ubuntu 10.04.3 LTS on ESXi 4.1
    Shinken 0.8.5

  8. #8
    Shinken project leader
    Join Date
    May 2011
    Location
    Bordeaux (France)
    Posts
    2,131

    Re: check_oracle_health

    Ok, thanks Oracle....
    No direct support by personal message. Please open a thread so everyone can see the solution

  9. #9
    Senior Member
    Join Date
    Oct 2011
    Posts
    139

    Re: check_oracle_health

    naparuba solution will not solve the problem when using the check if the environment variables are not rised when running the plugin.
    but i have found another problem

    it's better to not use the LD_LIBRARY_PATH in profile.d/oracle.sh but add the path to a file in /etc/ld.so.conf.d and then run ldconfig.
    seems that LD_LIBRARY_PATH will be set to late when launching

    i'm gona fix this in install script

  10. #10

    Re: check_oracle_health

    Some news about this problem ?

    Thanks.
    Ubuntu 10.04.3 LTS on ESXi 4.1
    Shinken 0.8.5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •