Oracle Fusion Middleware & Application Server

Monday, March 18, 2019

Enterprise Manager 13c - Resolve Pending Status of Systems Infrastructure Server Components

From time to time you can observe, that some Systems Infrastructure Server Components are turning into a "Pending Status". Mostly the reason for this status change is not clear, a restart of the underlying Oracle Agents also doesn't resolve this pending state.


 The simplest solution to get rid of the pending state is to remove the Systems Infrastructure Server Component and to re-add it.

For this just connect with the oracle user to your server on which your Oracle Cloud Control 13c is running and perform following emcli commands:

# At first login with sysman to your emcli
oracle@server> emcli login -username=sysman
Enter password :

Login successful

# Perform a sync
oracle@server> emcli sync
Synchronized successfully

# Remove the Systems Infrastructure Server Component which is in pending state
oracle@server> emcli delete_target \
                  -name="<yourserver>.<domainname>/server" \
                  -type=oracle_si_server_map

# For example:
oracle@server> emcli delete_target \
                  -name="dbserver1.mydomain.com/server" \
                  -type=oracle_si_server_map

Target "dbserver1.mydomain.com/server:oracle_si_server_map" deleted successfully

# Add the above remove Systems Infrastructure Server Component once again
oracle@server> emcli add_target -name='<yourserver>.<domainname>/server' \
                  -type='oracle_si_server_map' \
                  -host='<yourserver>.<domainname>' \
                  -access_point_name='<yourserver>.<domainname>/server_os' \
                  -access_point_type=oracle_si_server_os \
                  -properties='dispatch.url!local://localhost' \
                  -subseparator=properties='!'

# For example:
oracle@server> emcli add_target -name='dbserver1.mydomain.com/server' \
                  -type='oracle_si_server_map' \
                  -host='dbserver1.mydomain.com' \
                  -access_point_name='dbserver1.mydomain.com/server_os' \
                  -access_point_type=oracle_si_server_os \
                  -properties='dispatch.url!local://localhost' \
                  -subseparator=properties='!'

Target "dbserver1.mydomain.com/server_os:oracle_si_server_os" added successfully

After that wait some moments and check once again the status of your Systems Infrastructure Server Component in Enterprise Manager 13c and you will see that the status turned to be ok.



Thursday, February 21, 2019

Oracle XE 18.4.0.0.0 (18c) for Windows

The Oracle Database Express Edition (XE) 18.4.0.0.0 (18c) is since yesterday available for Windows x64 on Oracle Technology Networks:


For the download of the latest Oracle XE 18c for Windows x64 checkout following link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html




Happy Download ...

Tuesday, January 8, 2019

Enterprise Manager 13.3 - Customize Login Page

Since Oracle Enterprise Manager 13.3 you have the option to customize the Login Page with your own logo image (size of the image is fixed with width of 200px and height of 70px) and a free text field.

In order to customize your login page you have to perform following steps.

At first you will need to activate the http port for your WebLogic Admin Server of your Enterprise Manager 13.3 environment.

Connect with a browser to your WebLogic Server Console, normally https://<yourserver>:7102/console and login with the weblogic user.

Select your EMGC_ADMINSERVER under the Domain Structure "GCDomain/Environment/Servers"


Go to the "Configuration/General" and activate under the Change Center the Lock & Edit button


Set the checkbox in front of "Listen Port Enabled", leave the defined http port to the pre-filled value of 7001 and click the "Save" button to save your changes.


Finally click in the Change Center the "Active Changes" button, there is no restart required, the http port 7001 will be immediately available.


As next you will have to create on the server hosting your Enterprise Manager 13.3 a directory for your image file (possible formats are: jpeg, jpg, png and gif) and a simple web.xml file.

# Create the required directory for your image file
mkdir -p /u00/app/oracle/admin/oms/logo/WEB-INF

# Place your image file into the folder /u00/app/oracle/admin/oms/logo
# Create under /u00/app/oracle/admin/oms/logo/WEB-INF a web.xml
# with following content

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" 
"http://java.sun.com/j2ee/dtds/web-app_2_3.dtd">
<web-app>
</web-app>

Get back to your WebLogic Console and navigate in the Domain Structure to "GCDomain/Environment/Deployments" and click in the Change Center the "Lock & Edit" button.


Click the "Install" button in order to install the above create folder structure as application


Place under Path your above created directory, which contains the image file and the subdirectory WEB-INF with the web.xml, in my case /u00/app/oracle/admin/oms/logo and click the "Next" button


In the next deployment screen leave the defaults and click the "Next" button.


In the following deployment screen choose the EMGC_ADMINSERVER as deployment target and proceed with the "Next" button.


In the following deployment screen leave the defaults and finish the deployment with the "Finish" button.
Hint: the context of your deployment will the same as your created directory name, in my case "logo"


To activate the deployment click under the Change Center the "Activate Changes" button.


Now you have to validate if your deployment is already active or still in prepared state, under the list of deployments scroll down to your deployment, in my case it's named logo (derived from the directory name you have created.

Normally the state will be "prepared", so click on the deployed application


Navigate to the "Control" tab, set the checkbox in front of logo and start the application

After a successful start of your application you should see the state as Active.


Now you can test if you can access with a browser the image file under your deployed application.

http://<yourserver>:7001/logo/<your_image_file>

Next step is to set with the emctl utility the property oracle.sysman.core.uifwk.loginPageLogo, login to your server hosting the Enterprise Manager 13.3 and execute following command:

emctl set property -name oracle.sysman.core.uifwk.loginPageLogo –value 'http://<yourserver>:7001/<context>/<image_file>' -sysman_pwd <sysman_password>

# For example
emctl set property -name oracle.sysman.core.uifwk.loginPageLogo –value 'http://oraem13c.domain.com:7001/logo/logo.png' -sysman_pwd Oracle13c

After the above command is no restart of your OMS required.

In case you want to set the free text for your login page you will need to execute following command on your server hosting the Enterprise Manager 13.3 to set the property oracle.sysman.core.uifwk.loginPageInformationText

emctl set property -name oracle.sysman.core.uifwk.loginPageInformationText -value 'You are connected to the Demo Cloud Control 13c (13.3)'

When you access your Enterprise Manager 13.3 Login Page now, you will see on the top left your logo image and beside the Login Button your defined free text field.