Last week we released a new cloud service - the Oracle Application Builder Cloud Service.
(I'll refer to is as ABCS here to keep it short).
ABCS is built for the non-professional developer, what some call the citizen developer, giving them a solution to very quickly build and publish applications that can address immediate business needs. As you'll see in the demo below, a UI first approach makes development very simple.
I recorded a quick demo to show you just the basics of app development and wet your appetite.
As you'll see ABCS makes it dead simple to create Web apps, define business objects that you want to track (implemented as tables in an Oracle cloud database instance), and fine tune the UI creating multiple forms. The underlying UI technology of both ABCS and the apps that it creates is Oracle JET.
Note that in this video I didn't cover the steps to actually stage and then publish your application so other users can access it - another thing that ABCS makes simple. On these and other capabilities in future blogs...
Phone Home feature for Engineered System View the ASR Demo Video.
ASR resolves problems faster by automatically opening service requests for Oracle's qualified server, storage, and Engineered Systems when specific faults occur.
Note: From EM13c onwards ASR is integrated directly.
How to use ASR
1. ASR can be installed in External system Linux or Solaris. (Small RPM package) We can install it in our OMS box.
2. Requires communnication between ExaData Assets where ASR monitoring is valid.
4.15.1 ASR Port Usage http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD193
3. Requires Communication to transport.oracle.com:443
4. ASR can send same SR Creation info to Omnibus via SNMP Trap.
4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:
ASR Manager systems require Oracle Java 7 - JDK 7 (JDK 1.7.0_13) or later JDK 7 updates or Oracle Java 8 (1.8.0_25 or later).
Oracle Linux 5.3 or later. Red Hat Enterprise Linux 6.3 or later.
For IPv6, the ASR Manager server needs to be enabled for dual stack IPv6/IPv4
Test from designated ASR Manager server below:
telnet transport.oracle.com 443
1. Set-up firewall rules to allow bi-directional SNMP/UDP traffic to traverse between ASR Assets and the ASR Manager.
2. Ensure that ASR assets can send SNMP telemetry data out on port 162 to the ASR Manager. ( test using OneCommand)
3. Ensure that the ASR Manager can communicate with Service Tags on ASR asset, via http, using port 6481.
4. If your environment requires SNMP v3 to use the Oracle ASR service, you will need to configure both ASR Manager and any ASR Assets. See
Configuring ASR Manager for SNMP v3 and Optional ILOM Setup: SNMP v3 for ASR Assets for more information in Chapter 2.http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#CHDBAEEA
5. Verify Telemetry on each component valid for ASR monitoring -http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch1_asr_overview.htm#CEGFGDBG
6. Verify MOS account: MOS accont and SupportIdentifier How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1):
7. Install ASR Manager - http://docs.oracle.com/cd/E37710_01/doc.41/e26747/toc.htm
Install ASR Manager -
Register ASR with Oracle Support:
asr> test_connection ( /opt/asrmanager/bin/asr test_connection)
service asrm stop
tar -cvf db.tar.bz /var/opt/asrmanager/db
tar -cvf configuration.tar.bz /var/opt/asrmanager/configuration
service asrm start
asr> send_deactivations -a
asr> send_activations -a
asr> disable_asr_manager <1 48="" hours="" to="">
asr> disable_asset -i IP_address
asr> enable_asset -i IP_address
asr> send_test -i IP_address
asr> send_test -h host name
asr> deactivate_asset -i IP_address
rpm -e asrmanager;rm -rf /var/opt/asrmanager/
asr> set_property snmp.receiver.port 1162
asr> get_property snmp.receiver.port
service asrm restart
8. Configure ASR Assets - http://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm
Activate Exadata Assets.--http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch3_asr_assets.htm#BEIDCBAI
Check the Service Tag: http://asr_system_hostname:6481/stv1/agent/
9. Pre-check Engineered Systems ASR Configuration Check via ASREXACHK (Doc ID 1450112.1) to verify the ASR deployment.
10. Approve ASR assets refer
How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1)
11. Audit log at /var/opt/asrmanager/log/auditlog
12. Check ASR Email
13. Create Test Alert - ILOM - Refer http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD171
14. Check Ports: -4.15.1 ASR Port Usage
15. Configure ASR to send SNMP traps to Command center: 4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:
asr> set_notification_trap [-i ipAddress -p port -c community] [-h hostname -p port -c community]
asr> set_notification_trap -i 127.0.0.1 -p 162 -c public
asr> delete_notification_trap -i 127.0.0.1
asr> send_test [-i ipAddress] [-h hostname]
The SUN-ASR-NOTIFICATION-MIB file is located at:
16. Troubleshooting: http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD202
Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide 5.5.1
Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide
tar -zcvf /opt/app/oracle/BACKUP/AIA_MSERVER.tar.gz --exclude='core.*' --exclude='*.log*' --exclude='*.out*' --exclude='*ConsumeFaultMessage*.dat' /opt/app/oracle/fmw_domains/aia_domain/mserver/aia01_domain
tar -zcvf /opt/app/oracle/BACKUP/AIA_ASERVER.tar.gz --exclude='core.*' --exclude='*.log*' --exclude='*.out*' --exclude='*ConsumeFaultMessage*.dat' /opt/app/oracle/fmw_domains/aia_domain/aserver/aia01_domain
Here is the way to get it:
Create a OS JOB in EM12c with following text and execute on all interested hosts. Assuming you have common shared mount on all these hosts.
Otherwise you can create Metric Extension to collect this info and query repository using Configuration Manger or directly to get this info.
echo -e `echo '\n';hostname --l;echo '\n=====================================\n';nfsstat -m;echo '\n=====================================\n';exit 0` >> /nfs_software/nfs_info_PROD.txt
Since I wrote those blog entries, we released a new version of JDeveloper (12.2.1) that added deeper integration with the Developer Cloud Service functionality for tracking tasks/issues. In parallel Developer Cloud Service also added various features with one of the new areas being covered is managing sprints and an agile development processes.
I thought it might be interesting to show some of the new features of both products working togethers.
In the video below you'll see how to:
- Connect to DevCS and its projects from inside JDeveloper
- Leverage the Team view in JDeveloper (tasks, builds, and code repositories)
- Interact with Tasks/Issues in JDeveloper
- Handle Git transactions
- Associate code commits with specific tasks
- Monitor team activity in the Team Dashboard
- Create Agile boards and manage sprints in Developer Cloud Service
One other interesting feature I'm not showing above is the ability to do code reviews on your code by team members - before those are merged into your main code line.
If you want to try Developer Cloud Service out, just get a trial account of the Oracle Java Cloud Service - and you'll get an instance of the Developer Cloud Service that you can use to test this new way of working.
At that time I gave two alternative approaches; by using JQuery or SQL, but it looks like I didn't do those posts yet, till somebody reminded me. This post is about using SQL to highlight something in a report.
Let's say we want to highlight negative numbers in a report (as in the previous post):
when amount < 0
end as class
order by id
Our core community consists of Oracle professionals, so we’ll start with Oracle related topics and branch off from there to other areas.
Benefits of ProHuddle for You
It’s free Attending conferences can be expensive. ProHuddle brings you high quality presentations for free.
Content DiscoveryYou miss a lot of content you might enjoy, simply because you never hear about it. ProHuddle curates presentations, surfaces the best ones and notifies you about them. You’ll have access to presentations from all over the world, connecting you to the experts from everywhere.
Easy to Attend Attending conferences can be time consuming. You can attend ProHuddle webinars from the comfort of your home or your office, on any device.
More Engaging Presentations have time constraints. At ProHuddle, there is no next presentation to catch or to clear the room for. The presenter has as much time as she needs to deliver her message, answer questions and interact with the audience (which is to me the best part of all).
If you are a curious, open minded person, with an interest in new people, ideas, products and technologies, sign up at www.prohuddle.com. We are launching in February 2016!
within the cave it is perpetually night
(I find my vision gets dimmer with age
- when we are alleged to see more sharply -
in the low light of a single candle flame
it is getting much harder to read
year by year)
there is a form I barely am able to perceive.
I wonder if it is better here than the open air
where my eyes would surely be closed against the sun
where all forms find their origin in the one.
For Weblogic 11g:
EM12c: How to Monitor WebLogic Server Health Status in Enterprise Manager 12c Cloud Control (Doc ID 1984804.1)
"This API should deliver a couple of different SQL statements for an interactive report. There are several possible requirements I can think of:
1. IR query including visible columns and filter values - actual SQL for the user session,
2. IR query including all columns and the original SQL,
3. get column names of an IR with or without column alias,...
Having this SQL we should be able to run it as EXECUTE IMMEDIATE, without having to replace any binds.
This feature could be included in the actions menu and available as a plugin for dynamic actions - new dynamic action feature (action)."
Please, feel free to go there and vote for it.