Enable RESTful Management Services in Weblogic Server 12c

The Restful management services is one of the important features of Weblogic Server 12c. The Restful management services allows to monitor the running Weblogic Server instances which includes :

  • Applications running in Weblogic Server
  • Data Sources configured in Weblogic Server
  • Servers including Admin Server and Manager Servers
  • Clusters with multiple machines in distributed WebLogic Infrastructure

The RestFul management services allows HTTP GET methods and supports restful formats like XML, JSON and HTML

The Restful management services provides the capability to call through any Restful Client supporting languages like python, cURL , built -in web client and JavaFX application

Pre-requisite for RestFul Management Services

The below configurations are required for RestFul management services

  • Oracle Weblogic Server 12c
  • Python 2.7 +
  • JDK 7+
  • Operating System like Windows, Linux , MacOS

How to enable Restful Management Services in Weblogic Server 12c

The below steps need to be performed to enable the Restful management services in Oracle Weblogic Server 12c

  • Log into Weblogic Server Admin Console
  • Click on Lock &Edit to create new session for making server changes
  • Navigate Home-> Domains -> Configurations-> Advanced
  • Check Enable Restful Management Services

Enable RestFul Management Services

  • Restart the Weblogic Server

How to Enable Restful Management Services usign Weblogic WLST

  • Log in as Weblogic User and start Weblogic Shell Script
[wls@mach01]$ $WL_HOME/common/bin/wlst.sh
  • Connec to Weblogic Server Admin using admin credentials and t3 URL
wls:/offline>connect("wlsadmin","","t3://mach01.domain.local:<port>")
  • Execute the below given WLST commands to enable Restful Services in Weblogic Server 12c
edit()
startEdit()
cd('/RestfulManagementServices/DEV_SOADOMAIN')
cmo.setEnabled(true)
save()
activate()
exit()
  • Restart WebLogic Administration Server and managed servers

How to test Restful Management Services

  • Ensure that the Weblogic Server is restarted with the enablement of Restful Management Services checkbox

Restful Management Services to retrieve Server Health State

http://<host>0:<port>/management/tenant-monitoring/servers
  • The blow details are shown

Test RestFul Management Services

Restful Management Services to retrieve Single Server details

http://localhost:7101/management/tenant-monitoring/servers/DefaultServer

Single Server details using Weblogic Restful Services

Restful Management Services to retrieve Weblogic Data Source details

http://localhost:7101/management/tenant-monitoring/datasources

Data Source details using Weblogic Restful Services

References: 

Oracle WebLogic RESTful Management Services: From Command Line to JavaFX


Oracle EBS R12 Concurrent Request Log and Trace File SQL

The blog provides useful SQL Queries for Identifying the Concurrent Request Log File details and Concurrent Request Trace File details

SQL Query to retrieve Concurrent Request Log File

SELECT  'LOGFILE_NAME=' || logfile_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req
SELECT  'OUTFILE_NAME=' || outfile_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req

SQL Query to retrieve Concurrent Request Log File on a specific Concurrent Manager Node 

SELECT  'LOGFILE_NODE_NAME=' || logfile_node_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req

SELECT  'OUTFILE_NODE_NAME=' || outfile_node_name
FROM    FND_CONCURRENT_REQUESTS
WHERE   request_id = &req

SQL Query to retrieve Concurrent Request Trace File 

COLUMN TRACEID FORMAT A8
COLUMN TRACENAME FORMAT A80
COLUMN USER_CONCURRENT_PROGRAM_NAME FORMAT A40
COLUMN EXECNAME FORMAT A15
COLUMN ENABLE_TRACE FORMAT A12
SET LINES 80
SET PAGES 22
SET HEAD OFFSELECT 'REQUEST ID: '||REQUEST_ID ,
'TRACE ID: '||ORACLE_PROCESS_ID,
'TRACE FLAG: '||REQ.ENABLE_TRACE,
'TRACE NAME:
'||DEST.VALUE||'/'||LOWER(DBNM.VALUE)||'_ORA_'||ORACLE_PROCESS_ID||'.TRC',
'PROG. NAME: '||PROG.USER_CONCURRENT_PROGRAM_NAME,
'FILE NAME: '||EXECNAME.EXECUTION_FILE_NAME|| EXECNAME.SUBROUTINE_NAME ,
'STATUS : '||DECODE(PHASE_CODE,'R','RUNNING')
||'-'||DECODE(STATUS_CODE,'R','NORMAL'),
'SID SERIAL: '||SES.SID||','|| SES.SERIAL#,
'MODULE : '||SES.MODULE
FROM APPS.FND_CONCURRENT_REQUESTS REQ, V$SESSION SES, V$PROCESS PROC,
V$PARAMETER DEST, V$PARAMETER DBNM, APPS.FND_CONCURRENT_PROGRAMS_VL PROG,
APPS.FND_EXECUTABLES EXECNAME
WHERE REQ.REQUEST_ID = &REQUEST
AND REQ.ORACLE_PROCESS_ID=PROC.SPID(+)
AND PROC.ADDR = SES.PADDR(+)
AND DEST.NAME='USER_DUMP_DEST'
AND DBNM.NAME='DB_NAME'
AND REQ.CONCURRENT_PROGRAM_ID = PROG.CONCURRENT_PROGRAM_ID
AND REQ.PROGRAM_APPLICATION_ID = PROG.APPLICATION_ID
AND PROG.APPLICATION_ID = EXECNAME.APPLICATION_ID
AND PROG.EXECUTABLE_ID=EXECNAME.EXECUTABLE_ID;