Navigation

    Best APM Solution for Oracle WebLogic Server & FMW Product Family
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Download

    Getting “No Response Captured” when configuring SQL script in Dev-Op Mbeans

    General Support & Troubleshooting
    sql mbeans devops oracle weblogic
    2
    2
    1378
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • wlcommunityusers
      wlcommunityusers last edited by

      Hi Team,

      I am using below script to configure in Dev-Op Mbeans but getting “No Response Captured”
      Whereas same script is running fine on Solaris box.

      _dbStatus=0
      
      status=`/usr/sbin/ping $servername`
      
      
      if [ "$status" == "$servername is alive" ]; then
                      _dbStatus=1
                      echo SERVER_STATUS_RUNNING=$_dbStatus
      else
                      _dbStatus=0
                      echo SERVER_STATUS_RUNNING=$_dbStatus
      fi;
      

      Please can you guide me what I am doing incorrect.

      Community Users Case Notes (Diary)

      wlsdmsupport 1 Reply Last reply Reply Quote 0
      • wlsdmsupport
        WLSDM Support @wlcommunityusers last edited by

        Hi,

        This script is endless; you should echo a result for capturing a variable in WLSDM.

        You should use the ping command like i.e. “ping $servername –c 1” then extract output from the ping command.

        We are recommending you to use the script which is available in WLSDM README for pinging database. Please follow the readme link here: http://www.wlsdm.com/docs/README#VI.ConsoleUsage&DevOpsMBean

        Also we are pasting below.

        Step-1 Write Shell Script: Ping database and calculate database response time using WebLogic API (weblogic.jar)

        
        #Variables
        _dbStatus=0 
        #0:DB_DOWN,1:DB_UP
        
        #start DB Ping
        _startTime=$(($(date +%s%N)/1000000))
        _pingResult=`java -cp weblogic.jar utils.dbping ORACLE_THIN $YOUR_USER_NAME $YOUR_PASSWORD $YOUR_IP:$YOUR_PORT/$YOUR_SERVICE_NAME`
        _endTime=$(($(date +%s%N)/1000000))
        _dbResponseTime=`expr $_endTime - $_startTime`
        
        if [[ "$_pingResult" == *"Success!!!"* ]]; then
          _dbStatus=1
          #echo "Database connection SUCCESS!!!"
          #DB_UP
          echo DatabaseStatus=$_dbStatus
        else
          _dbStatus=0
          #echo "Database connection FAILURE!!!"
          #DB_DOWN
          echo DatabaseStatus=$_dbStatus
        fi
        echo DatabaseResponseTime=$_dbResponseTime```

        WLSDM Community Support Team

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        WLSDM: Native WebLogic Monitoring & Diagnostics

        Copyright © 2021 WLSDM Community & Support Portal | WLSDM.COM | WLSDM Blog