Development

Step 6 & 7: Setup OMS for EM13c in VMware ESXi 6.0.0

Arun Bavera - Mon, 2016-04-11 14:44
Step 6: Install and Configure the OMS on omsserver1.bavera.net and omsserver2.bavera.net
clip_image002
Unzip all the files, and run em13100_linux64.bin which unzips the other files…into Disk<> folders.
clip_image004
clip_image006
If you want to run pre-Req check this:
./em13100_linux64.bin -silent EMPREREQ_KIT=true  EMPREREQKIT_PROPERTY_FILE=/oracle/stage check.rsp -J-Djava.io.tmpdir=/oracle/stage
http://docs.oracle.com/cd/E63000_01/EMADV/install_em_exist_db_slnt.htm#EMADV109
From <http://www.redstk.com/saving-you-15-minutes-em13-1-blog-blitz-em-upgrade-pre-reqs/>
Also Refer:
https://oracle-base.com/articles/13c/cloud-control-13cr1-installation-on-oracle-linux-6-and-7
http://dbakevlar.com/2016/01/installing-a-new-enterprise-manager-13c-environment/
http://www.oracle.com/technetwork/oem/install-upgrade/pr-install-em13-2835293.pdf
https://oemgc.wordpress.com/2015/12/27/upgrade-em12c-to-em13c-this-is-what-i-did/
http://www.gokhanatil.com/2015/12/how-to-upgrade-oracle-enterprise-manager-cloud-control-12c-to-em13c.html
clip_image008
clip_image010
clip_image012
clip_image014
clip_image016
clip_image018
clip_image020
clip_image022
clip_image024
clip_image026
We ran into space issue where it required more disk space:
Allocate or resize disk size in Vsphere Client:
clip_image028
Reboot machine and login as Root:
fdisk -l
Create new Physical partition from the new space 10B added to previous 30GB.
fdisk /dev/sda
Command (m for help): n
Partition type:
p primary (2 primary, 0 extended, 2 free)
e extended
Select (default p): p
Partition number (3,4, default 3):
First sector (62914560-83886079, default 62914560):
Using default value 62914560
Last sector, +sectors or +size{K,M,G} (62914560-83886079, default 83886079):
Using default value 83886079
Partition 3 of type Linux and of size 10 GiB is set
Type:t choose:3
Choose: 8e to convert type Linux LVM
Changed type of partition 'Linux' to 'Linux LVM'
Choose:p
Save by choosing : w
http://www.howtogeek.com/howto/36568/what-is-logical-volume-management-and-how-do-you-enable-it-in-ubuntu/
http://www.howtogeek.com/howto/40702/how-to-manage-and-use-lvm-logical-volume-management-in-ubuntu/
https://www.rootusers.com/how-to-increase-the-size-of-a-linux-lvm-by-expanding-the-virtual-machine-disk/
clip_image030
Reboot the Machine:
We will use : pvcreate, vgextend , lvextend and xfs_growfs to add this to our root partition '/'
clip_image032
#lvdisplay
clip_image034
clip_image036
clip_image038
clip_image040
clip_image042
On 4/3/2016 available plugins:
clip_image044
clip_image046
clip_image048
clip_image050
clip_image052
clip_image054
clip_image056
Now Make sure the ports are according to ports you have configured in F5 LieRate Load Balancer
clip_image058
clip_image060
clip_image062
clip_image064
clip_image066
clip_image068
clip_image070
clip_image072
clip_image074
clip_image076
clip_image078
clip_image080
This completes installation on node1: omsserver1.bavera.net
Note: Enable all the HTTP Listen ports for Managed Server, Admin Server, BIP Server as we are using HTTP ports for Load Balancing.
Step:1 Enable HTTP ports using the Admin Console:
Step 2: Unlock Console and Upload port using emctl commands
emctl status oms -details
[oracle@omsserver1 ~]$ emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host : omsserver1.bavera.net
HTTP Console Port : 7788
HTTPS Console Port : 7803
HTTP Upload Port : 4889
HTTPS Upload Port : 4900
EM Instance Home : /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://omsserver1.bavera.net:7803/em
Upload URL: https://omsserver1.bavera.net:4900/empbs/upload
WLS Domain Information
Domain Name : GCDomain
Admin Server Host : omsserver1.bavera.net
Admin Server HTTPS Port: 7102
Admin Server is RUNNING
Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: omsserver1.bavera.net
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up
BI Publisher Server Information
BI Publisher Managed Server Name: BIP
BI Publisher Server is Up
BI Publisher HTTP Managed Server Port : 9701
BI Publisher HTTPS Managed Server Port : 9803
BI Publisher HTTP OHS Port : 9788
BI Publisher HTTPS OHS Port : 9851
BI Publisher is locked.
BI Publisher Server named 'BIP' running at URL: https://omsserver1.bavera.net:9851/xmlpserver
BI Publisher Server Logs: /u01/app/oracle/em13c/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log : /u01/app/oracle/em13c/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
[oracle@omsserver1 ~]$
=====================================================================================
Step 7: Register the SLB, Unlock HTTP upload and Console
We will use Self Signed Certificate:
openssl req -x509 -nodes -sha256 -days 3650 -newkey rsa:2048 -keyout em13c.bavera.net.key -out em13c.bavera.net.crt
openssl rsa -in em13c.bavera.net.key -text > em13c.bavera.net.key.pem
openssl x509 -inform PEM -in em13c.bavera.net.crt > em13c.bavera.net.crt.pem
openssl x509 -noout -text -in em13c.bavera.net.crt
Note: Same Certificate has been imported in SSL Profile for LineRate Load Balancer
[oracle@omsserver1 ~]$ emctl secure oms -host em13c.bavera.net -secure_port 4900 -slb_port 4900 -slb_console_port 443 -slb_jvmd_http_port 7202 -slb_bip_http_port 8080 -trust_certs_loc /home/oracle/em13c.bavera.net.crt.pem
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Securing OMS... Started.
Enter Enterprise Manager Root (SYSMAN) Password :
Enter Agent Registration Password :
Securing OMS... Successful
Restart OMS
[oracle@omsserver1 ~]$
emctl secure oms -unlock_upload -unlock_console
emctl secure unlock -console -upload
[oracle@omsserver1 ~]$ emctl secure unlock -console -upload
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
OMS Console is unlocked. HTTP ports too can be used to access console.
BI Publisher is unlocked. HTTP ports too can be used to access BI Publisher.
Agent Upload is unlocked. Unsecure Agents may upload over HTTP.
Restart OMS.
emctl stop oms -all;emctl start oms
Verify the Load Balancer and Certificates:
emctl secdiag openurl -url https://em13c.bavera.net/empbs/upload
-------------------------------------------------------------------------------------------------------------------------------------------
[oracle@omsserver1 config]$ emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host : omsserver1.bavera.net
HTTP Console Port : 7788
HTTPS Console Port : 7803
HTTP Upload Port : 4889
HTTPS Upload Port : 4900
EM Instance Home : /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1/sysman/log
SLB or virtual hostname: em13c.bavera.net
HTTPS SLB Upload Port : 4900
HTTPS SLB Console Port : 443
HTTP SLB JVMD Port : 7202
Agent Upload is unlocked.
OMS Console is unlocked.
Active CA ID: 1
Console URL: https://em13c.bavera.net:443/em
Upload URL: https://em13c.bavera.net:4900/empbs/upload
WLS Domain Information
Domain Name : GCDomain
Admin Server Host : omsserver1.bavera.net
Admin Server HTTPS Port: 7102
Admin Server is RUNNING
Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: omsserver1.bavera.net
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up
BI Publisher Server Information
BI Publisher Managed Server Name: BIP
BI Publisher Server is Up
BI Publisher HTTP Managed Server Port : 9701
BI Publisher HTTPS Managed Server Port : 9803
BI Publisher HTTP OHS Port : 9788
BI Publisher HTTPS OHS Port : 9851
BI Publisher HTTPS SLB Port : Not Set
BI Publisher HTTP SLB Port : 8080
BI Publisher is unlocked.
BI Publisher Server named 'BIP' running at URL: https://em13c.bavera.net:9851/xmlpserver
BI Publisher Server Logs: /u01/app/oracle/em13c/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log : /u01/app/oracle/em13c/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
[oracle@omsserver1 config]$
--------------------------------------------------------------------------------------------------------------------------------
clip_image082
Resecure/Unsecure the Agents with this new Load Balancer Host and HTTP Repository URL:
Cd $AGENT_HOME
./emctl secure agent -emdWalletSrcUrl https://em13c.bavera.net:4900/empbs/wallets/emd
If you want to Unsecure
./emctl unsecure agent
Goto sysman/config -> open emd.properties change the
REPOSITORY_URL= http://em13c.bavera.net:4889/empbs/upload/
Restart agent
Step:11 Add additional OMS on server omsserver2.bavera.net
Refer: http://docs.oracle.com/cd/E63000_01/EMBSC/install_addln_oms.htm#EMBSC177
Add the additional Agent on server2:
clip_image084
clip_image086
clip_image088
Add the Additional OMS using the "Add Oracle Management Service" Deployment Procedure (preferred method)
From <http://docs.oracle.com/cd/E63000_01/EMADV/ha_setup.htm#EMADV14396>
http://docs.oracle.com/cd/E63000_01/EMBSC/install_addln_oms.htm#EMBSC171
clip_image090
clip_image092
clip_image094
(Current OMS Count + 1) x Processes Parameter Value Per OMS for the Current Deployment Size
SMALL, then the Processes parameter value to be set is computed this way: (1 + 1) x 300 = 600.
PROCESSES = 600
SESSIONS = (1.1 * PROCESSES) + 5
TRANSACTIONS = 1.1 * SESSIONS
alter system set processes = 600 scope = spfile;
alter system set sessions = 660 scope = spfile;
alter system set transactions = 726 scope = spfile;
shutdown immediate;
startup;
clip_image096
clip_image098
clip_image100
clip_image102
clip_image104
clip_image106
clip_image108
clip_image110
clip_image112
Note: I had allocated 1GB RAM for this VM, which would have caused delay in deployment. I eventually increased it to 10GB
clip_image114
clip_image116





















































































































































































































































Categories: Development

Step 5: Install the OMR Database12c for EM13c

Arun Bavera - Mon, 2016-04-11 14:43
Step 5: Install and Configure the OMR using DB Templates
Download: http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/db-templates-2767916.html
Install Document: http://docs.oracle.com/cd/E63000_01/EMBSC/appdx_seed_db_template.htm#EMBSC242
Create the clone of VM from omsserver2 and save as "192.168.50.50 emrep.bavera.net emrep"
clip_image002
clip_image004
clip_image006
clip_image008
clip_image010
clip_image012
clip_image014
clip_image016
clip_image018
clip_image020
clip_image022
clip_image024
clip_image026
Use the DB Template downloaded from OTN to create the OMR Database.
Extract the 12.1.0.2.0_Database_Template_for_EM13_1_0_0_0_<platform>.zip file to the following location on the database host.
$<DB_HOME>/assistants/dbca/templates
For example,
/u01/software/oracle/database/dbhome_1/assistants/dbca/templates
clip_image028
clip_image030
clip_image032
clip_image034
clip_image036
12.1.0.2.0_Database_Template_for_EM13_1_0_0_0_Small_deployment.dbc
Database Components Component Selected Oracle JVM true Oracle Text true Oracle Multimedia true Oracle OLAP true Oracle Spatial true Oracle Label Security true Sample Schemas false Oracle Application Express true Oracle Database Vault true
Initialization Parameters Name Value audit_file_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump audit_trail DB cluster_database FALSE compatible 12.1.0.2.0 control_files ("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl") db_block_size 8192 db_name diagnostic_dest {ORACLE_BASE} dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB) open_cursors 300 parallel_max_servers 8 parallel_min_servers 0 pga_aggregate_target 1000000000 processes 300 remote_login_passwordfile EXCLUSIVE session_cached_cursors 200 sga_target 3000000000 undo_tablespace UNDOTBS1
Character Sets Name Value Database Character Set WE8MSWIN1252 National Character Set AL16UTF16
Data Files Name Tablespace Size(M) {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/mgmt_ad4j.dbf MGMT_AD4J_TS 200 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/mgmt_depot.dbf MGMT_ECM_DEPOT_TS 40 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/mgmt.dbf MGMT_TABLESPACE 1300 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf SYSAUX 680 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf SYSTEM 1020 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf UNDOTBS1 1150 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf USERS 5 {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/temp01.dbf TEMP 2318
Control Files Name {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl {ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl
Redo Log Groups Group Size(K) 1 296960 2 296960 3 296960
clip_image038
clip_image040
clip_image042
clip_image044
clip_image046
clip_image048
clip_image050
clip_image052
Note: remember to choose UTF8
clip_image054
clip_image056
clip_image058
clip_image060
clip_image062
clip_image064
clip_image066
clip_image068
clip_image070
clip_image072
clip_image074
clip_image076
clip_image078
Afte the install make sure firewall is disabled as it is lab or enable 1521 manually in firewall rules for required Hosts
# systemctl stop firewalld
# systemctl disable firewalld
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
Removed symlink /etc/systemd/system/basic.target.wants/firewalld.service.
clip_image080
Apply latest DB Patchset: refer Document Version Download link Included in Windows Bundle 21948354.8 12.1.0.2.160119 (Jan 2016) Database Patch Set Update (DB PSU) Patch:21948354 12.1.0.2 Patch 160119
From <https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=91031286431995&id=1924126.1&_afrWindowMode=0&_adf.ctrl-state=jzzx3wr43_94>





























































Categories: Development

Step 3 & 4: Setup Load Balancer LineRate from F5 for EM13c

Arun Bavera - Mon, 2016-04-11 14:36
Step 3: Install and prepare the Load Balancer LineRate from F5 [free product]:
Download: https://linerate.f5.com/try/download
Doc: https://support.f5.com/kb/en-us/products/linerate/versions.2-6-1.html
http://linuxpoison.blogspot.com/2008/09/opensource-load-balancing-software.html
EM12cR5 - http://docs.oracle.com/cd/E24628_01/install.121/e24089/ha_setup.htm#EMADV14386
EM13c - https://docs.oracle.com/cd/E63000_01/EMADV/ha_setup.htm#EMADV11590
clip_image002
clip_image004
clip_image006
clip_image008
clip_image010
clip_image012
clip_image014
clip_image016
clip_image018
clip_image020
Account: admin/changeme
https://192.168.1.89:8443
clip_image022
clip_image024
clip_image026
Put Phone Home Details with your F5 account and resubmit active license:
clip_image028
clip_image030
Change password: type
configure
username admin secret "<password>"
write
Assign the IP address:
clip_image032
Change the Hostname:
LROS(config)# configure
LROS(config)# hostname loadbalancer.bavera.net
*loadbalancer.bavera.net(config)# write
Building configuration...
[OK]
*loadbalancer.bavera.net(config)#show run
Step 4: Configure your Load Balancer for EM13c
From <https://docs.oracle.com/cd/E63000_01/EMADV/ha_setup.htm#EMADV11590> for EM13c
https://192.168.1.89:8443/lrs/api/v1.0/status/app/proxy/stats/data/realServer/ccuc_omsserver1
https://docs.oracle.com/cd/E63000_01/EMADV/ha_setup.htm#EMADV11590
Monitors we will be using: Cloud Control Service TCP Port Monitor Name Type Interval Timeout Send String Receive String Secure Console (when not using SSO) 7799 mon_ccsc https 5 16 GET /em/consoleStatus.jsp HTTP/1.1\r\nHost: \r\nConnection: Close \r\n\r\n Enterprise Manager Console is UP Secure Console (when using SSO) 7799 mon_ccsc https 5 15 GET /empbs/genwallet \r\n GenWallet Servlet activated Unsecure Console (when not using SSO) 7788 mon_ccuc http 5 16 GET /em/consoleStatus.jsp HTTP/1.1\r\nHost: \r\nConnection: Close \r\n\r\n Enterprise Manager Console is UP Unsecure BI Publisher Console 9788 mon_ccucbip http 5 16 GET /xmlpserver/services HTTP/1.1\r\nHost: \r\nConnection: Close \r\n\r\n And now... Some Services Secure Upload 4900 mon_ccsu https 60 181 GET /empbs/upload \r\n Http Receiver Servlet active! Agent Registration 4889 mon_ccar http 60 181 GET /empbs/genwallet \r\n GenWallet Servlet activated Always-On Monitoring Secure Upload 8081 mon_ccaom https 60 181 GET /upload \r\n Always On Monitoring is active
F5 LineRate Equivalent configure CLI commands: configure
health-monitor mon_ccuc
interval 5
timeout 16
server-down "8/10"
server-up "9/10"
type http
request-method GET
request-target "/em/consoleStatus.jsp"
admin-status online
write









configure
health-monitor mon_ccucbip
interval 5
timeout 16
server-down "8/10"
server-up "9/10"
type http
request-method GET
request-target "/xmlpserver/services"
admin-status online
write









configure
health-monitor mon_ccsu
interval 60
timeout 181
server-down "8/10"
server-up "9/10"
type http (value same for https)
request-method GET
request-target "/empbs/upload"
admin-status online
write









configure
health-monitor mon_ccar
interval 60
timeout 181
server-down "8/10"
server-up "9/10"
type http
request-method GET
request-target "/empbs/genwallet"
admin-status online
write









configure
health-monitor mon_ccaom
interval 60
timeout 181
server-down "8/10"
server-up "9/10"
type http (value same for https)
request-method GET
request-target "/upload "
admin-status online
write










clip_image034


Real Servers in F5 LineRate: configure
real-server ccuc_omsserver1
ip address 192.168.50.41 7788
max-connections 1000
admin-status online
attach health-monitor mon_ccuc
service http
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccucbip_omsserver1
ip address 192.168.50.41 9788
max-connections 1000
admin-status online
attach health-monitor mon_ccucbip
service http
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccsu_omsserver1
ip address 192.168.50.41 4900
max-connections 1000
admin-status online
attach health-monitor mon_ccsu
service http (value same for https)
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccar_omsserver1
ip address 192.168.50.41 4889
max-connections 1000
admin-status online
attach health-monitor mon_ccar
service http
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccaom_omsserver1
ip address 192.168.50.41 8081
max-connections 1000
admin-status online
attach health-monitor mon_ccaom
service http (value same for https)
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccuc_omsserver2
ip address 192.168.50.42 7788
max-connections 1000
admin-status online
attach health-monitor mon_ccuc
service http
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccucbip_omsserver2
ip address 192.168.50.42 9788
max-connections 1000
admin-status online
attach health-monitor mon_ccucbip
service http
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccsu_omsserver2
ip address 192.168.50.42 4900
max-connections 1000
admin-status online
attach health-monitor mon_ccsu
attach ssl profile ssl_prof_em13c.bavera.net
service http (value same for https)
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write










configure
real-server ccar_omsserver2
ip address 192.168.50.42 4889
max-connections 1000
admin-status online
attach health-monitor mon_ccar
service http
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write









configure
real-server ccaom_omsserver2
ip address 192.168.50.42 8081
max-connections 1000
admin-status online
attach health-monitor mon_ccaom
service http (value same for https)
keepalive-timeout 3600
response-timeout 60
response-idle-timeout 60
write










clip_image036





Pools we will be using: Cloud Control Services Pool Name Associated Health Monitor Load Balancing Members Secure Console pool_ccsc mon_ccsc Least Connections (member) OMS Host A:7799
OMS Host B:7799
Secure BI Publisher pool_ccscbip mon_ccscbip Least Connections (member) OMS Host A:9851
OMS Host B:9851
Unsecure Console pool_ccuc mon_ccuc Least Connections (member) OMS Host A:7788
OMS Host B:7788
Unsecure BI Publisher pool_ccucbip mon_ccucbip Least Connections (member) OMS Host A:9788
OMS Host B:9788
Secure Upload pool_ccsu mon_ccsu Least Connections (member) OMS Host A:4900
OMS Host B:4900
Agent Registration pool_ccar mon_ccar Least Connections (member) OMS Host A:4889
OMS Host B:4889
Always-On Monitoring Secure Upload pool_ccaom mon_ccaom Least Connections (member) OMS Host A:8081
OMS Host B:8081

F5 LineRate equivalent “real server group” for F5 Pool: configure
real-server group pool_ccuc
members by regex " ccuc_.*"
write


configure
real-server group pool_ccucbip
members by regex " ccucbip_.*"
write


configure
real-server group pool_ccsu
members by regex " ccsu_.*"
write


configure
real-server group pool_ccar
members by regex " ccar_.*"
write


configure
real-server group pool_ccaom
members by regex " ccaom_.*"
write




clip_image038











TCP Profiles we will be using
CLOUD CONTROL SERVICE TCP PROFILE NAME Secure Console tcp_ccsc Secure BIP Console tcp_ccscbip Unsecure Console tcp_ccuc Unsecure BIP Console tcp_ccucbip Secure Upload tcp_ccsu Agent Registration tcp_ccar Always-On Monitoring Secure Upload tcp_ccaom

Persistence Profiles we will be using:
CLOUD CONTROL SERVICE F5 PERSISTENCE PROFILE NAME Type Timeout Expiration Secure Console sourceip_ccsc Source Address Affinity 3600 Not Applicable Secure BIP Console sourceip_ccscbip Source Address Affinity 3600 Not Applicable Unsecure Console sourceip_ccuc Source Address Affinity 3600 Not Applicable Unsecure BIP Console sourceip_ccucbip Source Address Affinity 3600 Not Applicable Agent Registration cookie_ccar Cookie Not Applicable 3600

configure
tcp-options-group tcp_ccuc
write

configure
tcp-options-group tcp_ccucbip
write

configure
tcp-options-group tcp_ccsu
write

configure
tcp-options-group tcp_ccar
write

configure
tcp-options-group tcp_ccaom
write




















Virtual Servers we will be using
Cloud Control Service Virtual Server Name Virtual IP and Port Protocol Profile (Client) HTTP Profile Source Address Translation iRule Defaut Pool Default Persistence Profile Secure Console vs_ccsc443 VIP:443 tcp_ccsc None Automap None pool_ccsc sourceip_ccsc Secure BI Publisher vs_ccscbip5443 VIP:5443 tcp_ccscbip None Automap None pool_ccscbip Sourceip_ccscbip Unsecure Console * vs_ccuc80 VIP:80 tcp_ccuc http Automap None pool_ccuc sourceip_ccuc Unsecure BI Publisher * vs_ccucbip8080 VIP:8080 tcp_ccucbip http Automap None pool_ccucbip sourceip_ccucbip Secure Upload vs_ccsu4900 VIP:4900 tcp_ccsu None Automap None pool_ccsu None Agent Registration vs_ccar4889 VIP:4889 tcp_ccar http Automap None pool_ccar cookie_ccar Always-On Monitoring Secure Upload vs_ccaom8081 VIP:8081 tcp_ccaom None Automap None pool_ccaom sourceip_aom
* These entries are not considered best practice and are not recommended as they provide unsecured and unencrypted access to Enterprise Manager. But we will be using the SSL termination at the Load Balancer, depending upon the Load Balancer security and Firewall and offloading the SSL processing and need for SSL certificate at each components at EM13c.

Management Service Ports Cloud Control Service TCP Port Monitor Name TCP Profile Name Persistence Profile Pool Name Virtual Server Name Virtual Server Port Secure Console 7799 mon_ccsc tcp_ccsc sourceip_ccsc pool_ccsc vs_ccsc443 443 Secure BI Publisher 9851 mon_ccscbip tcp_ccscbip sourceip_ccscbip pool_ccscbip vs_ccscbip5443 5443 Unsecure Console 7788 mon_ccuc tcp_ccuc sourceip_ccuc pool_ccuc vs_ccuc80 80 Unsecure BI Publisher 9788 mon_ccucbip tcp_ccucbip sourceip_ccucbip pool_ccucbip vs_ccucbip8080 8080 Secure Upload 4900 mon_ccsu tcp_ccsu None pool_ccsu vs_ccsu4900 4900 Agent Registration 4889 mon_ccar tcp_ccar cookie_ccar pool_ccar vs_ccar4889 4889 Always-On Monitoring Secure Upload 8081 mon_ccaom tcp_ccaom None pool_ccaom vs_ccaom8081 8081


configure
virtual-ip vs_ccuc80_ip
ip address 192.168.50.80 80
admin-status online
service http
keepalive-timeout 3600
attach tcp-options-group tcp_ccuc
write
exit
configure
virtual-ip vs_ccuc443_ip
ip address 192.168.50.80 443
admin-status online
service http
keepalive-timeout 3600
attach tcp-options-group tcp_ccuc
write
exit
















configure
virtual-ip vs_ccucbip8080_ip
ip address 192.168.50.80 8080
admin-status online
service http
keepalive-timeout 3600
attach tcp-options-group tcp_ccucbip
write
exit









configure
virtual-ip vs_ccsu4900_ip
ip address 192.168.50.80 4900
admin-status online
service http
keepalive-timeout 3600
attach tcp-options-group tcp_ccsu
write
exit









configure
virtual-ip vs_ccar4889_ip
ip address 192.168.50.80 4889
admin-status online
service http
keepalive-timeout 3600
attach tcp-options-group tcp_ccar
write
exit









configure
virtual-ip vs_ccaom8081_ip
ip address 192.168.50.80 8081
admin-status online
service http
keepalive-timeout 3600
attach tcp-options-group tcp_ccaom
write
exit









configure
virtual-server vs_ccuc80
lb-algorithm round-robin
attach virtual-ip vs_ccuc80_ip default
attach real-server group pool_ccuc
service http
persist source-ip
persist source-ip idle-timeout 3600
write
exit
exit
------------------------------
configure
virtual-server vs_ccuc443
lb-algorithm round-robin
attach virtual-ip vs_ccuc443_ip default
attach real-server group pool_ccuc
service http
persist source-ip
persist source-ip idle-timeout 3600
write
exit
exit























configure
virtual-server vs_ccucbip8080
lb-algorithm round-robin
attach virtual-ip vs_ccucbip8080_ip default
attach real-server group pool_ccucbip
service http
persist source-ip
persist source-ip idle-timeout 3600
write
exit
exit











configure
virtual-server vs_ccsu4900
lb-algorithm round-robin
attach virtual-ip vs_ccsu4900_ip default
attach real-server group pool_ccsu
service http

write
exit









configure
virtual-server vs_ccar4889
lb-algorithm round-robin
attach virtual-ip vs_ccar4889_ip default
attach real-server group pool_ccar
service http
persist cookie agent12c
persist cookie agent12c expires 3600
write
exit
exit











configure
virtual-server vs_ccaom8081
lb-algorithm round-robin


attach virtual-ip vs_ccaom8081_ip default
attach real-server group pool_ccaom
service http
write
exit
show run brief











clip_image040


clip_image042



Create Self Signed Certificate and attach it to your Virtual IP’s

openssl req -x509 -nodes -sha256 -days 3650 -newkey rsa:2048 -keyout em13c.bavera.net.key -out em13c.bavera.net.crt
openssl rsa -in em13c.bavera.net.key -text > em13c.bavera.net.key.pem
openssl x509 -inform PEM -in em13c.bavera.net.crt > em13c.bavera.net.crt.pem
openssl x509 -noout -text -in em13c.bavera.net.crt

emctl secure oms -host em13c.bavera.net -secure_port 4900 -slb_port 4900 -slb_console_port 443 -slb_jvmd_http_port 7202 -slb_bip_http_port 8080 -trust_certs_loc /home/oracle/em13c.bavera.net.crt.pem
Step 1: configure Key:
configure
4. Type:
key key_em13c.bavera.net
5. Type:
pem-format
6. Paste the text from the private key file and press Enter.
7. Type:
quit
8. Type:
write











Step 2: Configure Certificate:
Open the primary certificate file in a text editor and copy the text.
2. Type:
configure
3. Type:
certificate cert_em13c.bavera.net
4. Type:
pem-format
5. Paste the text from the certificate file and press Enter.
6. Type:
quit











Step 3: To configure SSL termination:
Type:
configure
2. Type:
ssl profile ssl_prof_em13c.bavera.net
3. Type:
attach key key_em13c.bavera.net
4. Type:
attach certificate cert_em13c.bavera.net
5. Type:
virtual-ip vs_ccsu4900_ip
6. Type:
attach ssl profile ssl_prof_em13c.bavera.net
7. Type:
virtual-ip vs_ccuc443_ip
attach ssl profile ssl_prof_em13c.bavera.net
show virtual-ip vs_ccsu4900_ip
show virtual-ip vs_ccuc443_ip
8. Write






















After the install of OMS2:
clip_image044
























































































































Categories: Development

Step 2: EM13c VM's Setup on VMWare ESXi 6.0.0

Arun Bavera - Mon, 2016-04-11 13:43
Step 2: Plan your network for EM13c Installation:
clip_image002
# Private_Network - eth0 - node RAC interconnect
10.0.0.1 dbserver1-priv.bavera.net dbserver1-priv
10.0.0.2 dbserver2-priv.bavera.net dbserver2-priv
# Public_Network - eth1 - Host IP
192.168.50.11 dbserver1.bavera.net dbserver1
192.168.50.12 dbserver2.bavera.net dbserver2
192.168.50.41 omsserver1.bavera.net omsserver1
192.168.50.42 omsserver2.bavera.net omsserver2
192.168.50.50 emrep.bavera.net emrep
192.168.50.80 em13c.bavera.net em13c #LineRate Load Balancer VIP - Free Load Balancer from F5
192.168.50.90 oem13c.bavera.net em13c #BIG-IP Load Balancer VIP - May be later 90Days license only
# Virtual IP
192.168.50.21 dbserver1-vip.bavera.net dbserver1-vip
192.168.50.22 dbserver2-vip.bavera.net dbserver2-vip
# SCAN
192.168.50.31 dbserver-scan.bavera.net dbserver-scan
192.168.50.32 dbserver-scan.bavera.net dbserver-scan
192.168.50.33 dbserver-scan.bavera.net dbserver-scan
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
Vmware AMT: http://192.168.1.100:16992/ Network Adapter Purpose MAC Address Interface Method 1 To Internet DHCP eth0 DHCP 192.168.1.100
Vmware.bavera.net ( for vSphere Client) Network Adapter Purpose MAC Address Interface Method 1 To Internet DHCP(static) 64:00:6a:61:1b:62 vmnic0 DHCP 192.168.1.101
dbserver1.bavera.net Network Adapter Purpose MAC Address Interface Method IP 1 Private RAC Interconnect- FIXED 00:0c:29:a3:be:2d eth0 Static 10.0.0.1 2 Public /Host IP -FIXED 00:0c:29:a3:be:37 eth1 Static 192.168.50.11 3 To Internet DHCP 00:0c:29:a3:be:41 eth2 DHCP 192.168.1.88
dbserver2.bavera.net Network Adapter Purpose MAC Address Interface Method 1 Private RAC Interconnect- FIXED 00:0c:29:a5:b0:2d eth0 Static 10.0.0.2 2 Public /Host IP -FIXED 00:0c:29:a5:b0:37 eth1 Static 192.168.50.12 3 To Internet DHCP 00:0c:29:a5:b0:41 eth2 DHCP 192.168.1.86
omsserver1.bavera.net Network Adapter Purpose MAC Address Interface Method 1 Public /Host IP -FIXED 00:0c:29:09:1a:f7 eth0 Static 192.168.50.41 2 To Internet DHCP 00:0c:29:09:1a:01 eth1 DHCP 192.168.1.74
omsserver2.bavera.net Network Adapter Purpose MAC Address Interface Method 1 Public /Host IP -FIXED eth1 Static 192.168.50.42 2 To Internet DHCP eth2 DHCP 192.168.1.90
loadbalancer.bavera.net Network Adapter Purpose MAC Address Interface Method 1 Public /Host IP -FIXED em1 Static 192.168.50.80 2 To Internet DHCP em0 DHCP 192.168.1.89
Step 3: Creating your VM inside ESXi 6.0.0
Login using vSPhere Client from your laptop/desktop:
clip_image004
clip_image006
clip_image008
clip_image010
clip_image012
clip_image014
clip_image016
clip_image018
clip_image020
clip_image022
clip_image024
clip_image026
clip_image028
clip_image030
clip_image032
clip_image034
clip_image036
Step 4: Installing Linux in your VM
We will be using Oracle Linux 7 64 bit with EM 13c 13.1.0.0
clip_image038
clip_image040
clip_image042
Browse Datastore and upload this ISO.
clip_image044
clip_image046
clip_image048
clip_image050
clip_image052
clip_image054
clip_image056
clip_image058
clip_image060
clip_image062
clip_image064
clip_image066
clip_image068
clip_image070
clip_image072
clip_image074
clip_image076
clip_image078
clip_image080
clip_image082
clip_image084
clip_image086
Configure your VM for shared disk access and oracle user
/usr/sbin/groupadd -g 54321 oinstall
/usr/sbin/useradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba oracle
mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
mkdir -p /u01/app/oraInventory
chown oracle:oinstall /u01/app/oraInventory
chmod -R 775 /u01/app/oracle
chmod -R 775 /u01/app/oraInventory
chown oracle:oinstall /u01/app
echo "inventory_loc=/u01/app/oraInventory" >/etc/oraInst.loc
echo "inst_group=oinstall" >>/etc/oraInst.loc
mkdir -p /u02/shared; chown -R oracle:oinstall /u02/shared
[root@omsserver1 ~]# service nfs status
Redirecting to /bin/systemctl status nfs.service
● nfs-server.service - NFS server and services
Loaded: loaded (/usr/lib/systemd/system/nfs-server.service; disabled; vendor preset: disabled)
Active: inactive (dead)
Put /etc/hosts entries in omsserver1:
Put /etc/fstab entry for software access:
192.168.50.11:/u02/shared/ /u02/shared/ nfs defaults 0 0
Also, make sure dbserver1 which is the NFS server has allow entry for this server in /etc/exports
[root@dbserver1 ~]# cat /etc/exports
/u02/shared/ 192.168.50.12(rw,sync,no_root_squash)
/u02/shared/ 192.168.50.41(rw,sync,no_root_squash)
/u02/shared/ 192.168.50.42(rw,sync,no_root_squash)
Add or amend the following lines in the "/etc/sysctl.conf" file.
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
Install the following packages if they are not already present.
Amend the "/etc/security/limits.d/90-nproc.conf
# Change this
* soft nproc 1024
# To this
* - nproc 16384
vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=4g 0 0
Add oracle sudoers so that user can sudo as root as this is Test lab:
clip_image088
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/System_Administrators_Guide/sect-Managing_Services_with_systemd-Services.html
http://dbakevlar.com/2016/01/installing-a-new-enterprise-manager-13c-environment/
Install the VMWARE Tools
1. Click VM in the virtual machine menu, then click Guest > Install/Upgrade VMware Tools.
From <https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1018414>
Step 5: Clone your VM to create second VM
Now, the VM is ready for OMS installation, clone it and create omsserver2 from this
copy .vmx and .vmdk files to "omsserver2.bavera.net" folder 
clip_image090
clip_image092
rename the file "omsserver1.bavera.net.vmx" to "omsserver2.bavera.net.vmx" 
clip_image094
Ssh to vmware Host and change the vmdk to omsserver2
cd /vmfs/volumes/SSD/omsserver2.bavera.net
vmkfstools -E omsserver1.bavera.net.vmdk omsserver2.bavera.net.vmdk
[root@vmware:/vmfs/volumes/56e1c821-c906c26c-c53b-64006a611b62/omsserver2.bavera.net] vmkfstools -E omsserver1.bavera.net.vmdk omsserver2.bavera.net.vmdk
[root@vmware:/vmfs/volumes/56e1c821-c906c26c-c53b-64006a611b62/omsserver2.bavera.net] ls -ltr
total 31457288
-rw------- 1 root root 2896 Mar 27 16:11 omsserver2.bavera.net.vmx
-rw------- 1 root root 32212254720 Mar 27 16:11 omsserver2.bavera.net-flat.vmdk
-rw------- 1 root root 538 Mar 27 16:19 omsserver2.bavera.net.vmdk
Add this "vmx" file to inventory using vSphere Client:
clip_image096
Now, edit Settings for this new VM, remove the old harddsk and add the copied vmdk as new harddisk
clip_image098
clip_image100
Add new Harddisk:
clip_image102
clip_image104
Note: For EM13c 30GB on root partition is not enough if you are going to have Linux OS also on the same mount:
Minimum CPU, RAM, Heap Size, and Hard Disk Space Requirements Per OMS Evaluation or Simple Installation Advanced Installation (SMALL) Advanced Installation (MEDIUM) Advanced Installation (LARGE) Deployment Size Evaluation or Simple Small Medium Large Configuration 1 OMS, <100 Targets, <10 Agents, <3 Concurrent User Sessions 1 OMS, <1000 Targets, <100 Agents, <10 Concurrent User Sessions 2 OMSes, >=1000 but <10,000 Targets, >=100 but <1000 Agents,>=10 but <25 Concurrent User Sessions 2 OMSes, >=10,000 Targets, >=1000 Agents, >=25 but <=50 Concurrent User Sessions 4 OMSes, >=10,000 Targets, >=1000 Agents, >=25 but <=50 Concurrent User Sessions CPU Cores/Host
(Can be shared with other processes)
2 4 6 12 6 RAMFoot 1
(With Oracle BI Publisher and JVMD Engine)
10 GB 10 GB 12 GB 24 GB 12 GB Hard Disk Space
(With Oracle Software Library, Oracle BI Publisher, and JVMD Engine)
24 GB 24 GB 24 GB 24 GB 24 GB Temporary Directory Hard Disk Space 10 GB 10 GB 10 GB 10 GB 10 GB Oracle WebLogic Server JVM Heap Size 1 GB 1.7 GB 4 GB 8 GB 4 GB
Footnote 1 The physical memory mentioned here includes .5 GB of RAM required for Oracle BI Publisher. At the time of installation, if you choose not to configure Oracle BI Publisher, then the actual physical memory required can be .5 GB less than what is mentioned here.
From <https://docs.oracle.com/cd/E63000_01/EMBSC/preinstall_req_hw.htm#EMBSC124>
clip_image106
Note, down the MAC address for each network card, as it was cloned we have to change it later:
clip_image108
Change the hostname in /etc/hostname ( Linux 7.2) for Linux 6 use /etc/sysconfig/network
Also, disable the selinux in /etc/sysconfig/selinux
Goto /etc/sysconfig/network-scripts change the ip address , also you can use network setting to change the ip
clip_image110
clip_image112
=============================================================================













































































































































































Categories: Development

Step 1: Setup VMware ESXi 6.0.0

Arun Bavera - Mon, 2016-04-11 13:04
     
    My intention was to setup a personal EM13c lab using affordable hardware and software but application infrastructure and topology as much as similar to Production grade.
    Technorati Tags: ,
    Dell PowerEdge T20 - Xeon E3-1225 @3.2 Ghz
    28GB RAM, 500GB SSD+1TB HDD
    VMWare ESXi 6.0.0.
    Oracle Linux 7.2 for OMS 13c and Database12c
    F5 LineRate Precision Load Balancer 2.6.1


    1. Get the cheap server you can afford, look for deals at slickdeals.net. I bought a DELL-T20 and additional 500GB SSD and extra RAM.
    2. Enable AMT ( ctrl+P) admin user: http://192.168.1.100:16992/index.htm?
    3. Use Rufus 2.7 to write the ISO image, other tools didn’t work
    4. https://www.vmware.com/support/developer/vcli/
    5. Make sure the machine boots from your ISO disk and install Vmware ESXi
    clip_image001
    clip_image002
    clip_image003
    clip_image004
    clip_image005
    clip_image006
    clip_image007
    clip_image008








Categories: Development

Open Source Machine Learning for Oracle Developers

Gerger Consulting - Mon, 2016-04-11 01:32
Attend the webinar by Christy Maver and Scott Purdy and learn how you can apply Numenta's open source machine intelligence technology to fraud detection, anomaly detection, IT monitoring, geospatial data and more.

More than 110 people have already signed up. Register at this link.

Listen to Numenta's story from Jeff Hawkins:

Categories: Development

Two Amazing Men Discovered Evolution by Natural Selection!

FeuerThoughts - Thu, 2016-04-07 10:09
Most everyone knows about Darwin, and what they think they know is that Charles Darwin is the discoverer of Evolution through Natural Selection. And for sure, he did discover this. But the amazing thing is....he wasn't the only one. And whereas Darwin came to this theory pretty much as a Big Data Scientist over a long period of time (mostly via "armchair" collection of data from scientists and naturalists around the world), The Other Guy developed his theory of Natural Selection very much in the field - more specifically, in the jungle, surrounded by the living evidence. 

His name is Alfred Russel Wallace, he is one of my heroes, and I offer below the "real story" for your reading pleasure. 

One of the things I really love about this story is the way Darwin and Wallace respected each other, and did right by each other. We all have a lot to learn from their integrity and compassion.

Alfred Russel Wallace and Natural Selection: the Real Story 
By Dr George Beccaloni, Director of the Wallace Correspondence Project, March 2013

http://downloads.bbc.co.uk/tv/junglehero/alfred-wallace-biography.pdf

Alfred Russel Wallace OM, LLD, DCL, FRS, FLS was born near Usk, Monmouthshire, England (now part of Wales) on January 8th, 1823. Serious family financial problems forced him to leave school aged only fourteen and a few months later he took a job as a trainee land surveyor with his elder brother William. This work involved extensive trekking through the English and Welsh countryside and it was then that his interest in natural history developed.

Whilst living in Neath, Wales, in 1845 Wallace read Robert Chambers' extremely popular and anonymously published book Vestiges of the Natural History of Creation and became fascinated by the controversial idea that living things had evolved from earlier forms. So interested in the subject did he become that he suggested to his close friend Henry Walter Bates that they travel to the Amazon to collect and study animals and plants, with the goal of understanding how evolutionary change takes place. They left for Brazil in April 1848, but although Wallace made many important discoveries during his four years in the Amazon Basin, he did not manage to solve the great ‘mystery of mysteries’ of how evolution works.

Wallace returned to England in October 1852, after surviving a disastrous shipwreck which destroyed all the thousands of natural history specimens he had painstakingly collected during the last two and most interesting years of his trip. Undaunted, in 1854 he set off on another expedition, this time to the Malay Archipelago (Singapore, Malaysia and Indonesia), where he would spend eight years travelling, collecting, writing, and thinking about evolution. He visited every important island in the archipelago and sent back 110,000 insects, 7,500 shells, 8,050 bird skins, and 410 mammal and reptile specimens, including probably more than five thousand species new to science.

In Sarawak, Borneo, in February 1855, Wallace produced one of the most important papers written about evolution up until that time1. In it he proposed a ‘law’ which stated that "Every species has come into existence coincident both in time and space with a pre-existing closely allied species". He described the affinities (relationships) between species as being “...as intricate as the twigs of a gnarled oak or the vascular system of the human body” with “...the stem and main branches being represented by extinct species...” and the “...vast mass of limbs and boughs and minute twigs and scattered leaves...” living species. The eminent geologist and creationist Charles Lyell was so struck by Wallace’s paper that in November 1855, soon after reading it, he began a ‘species notebook’ in which he started to contemplate the possibility of evolution for the first time.

In April 1856 Lyell visited Charles Darwin at Down House in Kent, and Darwin confided that for the past twenty years he had been secretly working on a theory (natural selection) which neatly explained how evolutionary change takes place. Not long afterwards, Lyell sent Darwin a letter urging him to publish before someone beat him to it (he probably had Wallace in mind), so in May 1856, Darwin, heeding this advice, began to write a ‘sketch’ of his ideas for publication.

Finding this unsatisfactory, Darwin abandoned it in about October 1856 and instead began working on an extensive book on the subject.

The idea of natural selection came to Wallace during an attack of fever whilst he was on a remote Indonesian island in February 1858 (it is unclear whether this epiphany happened on Ternate or neighbouring Gilolo (Halmahera)). As soon as he had sufficient strength, he wrote a detailed essay explaining his theory and sent it together with a covering letter to Darwin, who he knew from earlier correspondence, was deeply interested in the subject of species transmutation (as evolution was then called).

Wallace asked Darwin to pass the essay on to Lyell (who Wallace did not know), if Darwin thought it sufficiently novel and interesting. Darwin had mentioned in an earlier letter to Wallace that Lyell had found his 1855 paper noteworthy and Wallace must have thought that Lyell would be interested to learn about his new theory, since it neatly explained the ‘law’ which Wallace had proposed in that paper.

Darwin, having formulated natural selection years earlier, was horrified when he received Wallace’s essay and immediately wrote an anguished letter to Lyell asking for advice on what he should do. "I never saw a more striking coincidence. If Wallace had my M.S. sketch written out in 1842 he could not have made a better short abstract! ... So all my originality, whatever it may amount to, will be smashed." he exclaimed2. Lyell teamed up with another of Darwin's close friends, Joseph Hooker, and rather than attempting to seek Wallace's permission, they decided instead to present his essay plus two excerpts from Darwin’s writings on the subject (which had never been intended for publication3) to a meeting of the Linnean Society of London on July 1st 1858. The public presentation of Wallace's essay took place a mere 14 days after its arrival in England.

Darwin and Wallace's musings on natural selection were published in the Society’s journal in August that year under the title “On the Tendency of Species to Form Varieties; And On the Perpetuation of Varieties and Species by Natural Means of Selection”. Darwin's contributions were placed before Wallace's essay, thus emphasising his priority to the idea4. Hooker had sent Darwin the proofs to correct and had told him to make any alterations he wanted5, and although he made a large number of changes to the text he had written, he chose not to alter Lyell and Hooker’s arrangement of his and Wallace’s contributions.

Lyell and Hooker stated in their introduction to the Darwin-Wallace paper that “...both authors...[have]...unreservedly placed their papers in our hands...”, but this is patently untrue since Wallace had said nothing about publication in the covering letter he had sent to Darwin6. Wallace later grumbled that his essay “...was printed without my knowledge, and of course without any correction of proofs...”7

As a result of this ethically questionable episode8, Darwin stopped work on his big book on evolution and instead rushed to produce an ‘abstract’ of what he had written so far. This was published fifteen months later in November 1859 as On the Origin of Species: a book which Wallace later magnanimously remarked would “...live as long as the "Principia" of Newton.”9

In spite of the theory’s traumatic birth, Darwin and Wallace developed a genuine admiration and respect for one another. Wallace frequently stressed that Darwin had a stronger claim to the idea of natural selection, and he even named one of his most important books on the subject Darwinism! Wallace spent the rest of his long life explaining, developing and defending natural selection, as well as working on a very wide variety of other (sometimes controversial) subjects. He wrote more than 1000 articles and 22 books, including The Malay Archipelago and The Geographical Distribution of Animals. By the time of his death in 1913, he was one of the world's most famous people.

During Wallace’s lifetime the theory of natural selection was often referred to as the Darwin- Wallace theory and the highest possible honours were bestowed on him for his role as its co- discoverer. These include the Darwin–Wallace and Linnean Gold Medals of the Linnean Society of London; the Copley, Darwin and Royal Medals of the Royal Society (Britain's premier scientific body); and the Order of Merit (awarded by the ruling Monarch as the highest civilian honour of Great Britain). It was only in the 20th Century that Wallace’s star dimmed while Darwin’s burned ever more brightly. 

So why then did this happen?

The reason may be as follows: in the late 19th and early 20th centuries, natural selection as an explanation for evolutionary change became unpopular, with most biologists adopting alternative theories such as neo-Lamarckism, orthogenesis, or the mutation theory. It was only with the modern evolutionary synthesis of the 1930s and ’40s that it became widely accepted that natural selection is indeed the primary driving force of evolution. By then, however, the history of its discovery had largely been forgotten and many wrongly assumed that the idea had first been published in Darwin’s On the Origin of Species. Thanks to the so-called ‘Darwin Industry’ of recent decades, Darwin’s fame has increased exponentially, eclipsing the important contributions of his contemporaries, like Wallace. A more balanced, accurate and detailed history of the discovery of what has been referred to as “...arguably the most momentous idea ever to occur to a human mind” is long overdue.

ENDNOTES

1. Wallace, A. R. 1855. On the law which has regulated the introduction of new species. Annals and Magazine of Natural History, 16 (2nd series): 184-196.

2. Letter from Darwin to Charles Lyell dated 18th [June 1858] (Darwin Correspondence Database, http://www.darwinproject.ac.uk/entry-2285 accessed 20/01/2013).

3. These were an extract from Darwin’s unpublished essay on evolution of 1844, plus the enclosure from a letter dated 5th September 1857, which Darwin had written to the American botanist Asa Gray.

4. Publishing another person’s work without their agreement was as unacceptable then as it is today. Publishing someone’s novel theory without their consent, prefixed by material designed to give priority of the idea to someone else is ethically highly questionable: Wallace should have been consulted first! Fortunately for Darwin and his supporters, Wallace appeared to be pleased by what has been called the ‘delicate arrangement’.

5. In a letter from Joseph Hooker to Darwin dated 13th and 15th July 1858 (Darwin Correspondence Database, http://www.darwinproject.ac.uk/entry-2307 accessed 20/01/2013), Hooker stated " I send the proofs from Linnæan Socy— Make any alterations you please..."

6. In a letter from Darwin to Charles Lyell dated 18th [June 1858] (Darwin Correspondence Database, http://www.darwinproject.ac.uk/entry-2285 accessed 20/01/2013), Darwin, who was referring to Wallace's essay, says "Please return me the M.S. [manuscript] which he does not say he wishes me to publish..." and in a letter from Darwin to Charles Lyell dated [25th June 1858] (Darwin Correspondence Database, http://www.darwinproject.ac.uk/entry-2294 accessed 20/01/2013), Darwin states that "Wallace says nothing about publication..."

7. Letter from Wallace to A. B. Meyer dated 22nd November 1869 cited in Meyer, A. B. 1895. How was Wallace led to the discovery of natural selection? Nature, 52(1348): 415.

8. See Rachels, J. 1986. Darwin's moral lapse. National Forum: 22-24 (pdf available at http://www.jamesrachels.org/DML.pdf)

9. Letter from Wallace to George Silk dated 1st September 1860 (WCP373 in Beccaloni, G. W. (Ed.). 2012. Wallace Letters Online www.nhm.ac.uk/wallacelettersonline [accessed 20/01/2013])

OTHER NOTES

Please cite this article as: Beccaloni, G. W. 2013. Alfred Russel Wallace and Natural Selection: the Real Story. <http://downloads.bbc.co.uk/tv/junglehero/alfred-wallace-biography.pdf>
This article is a slightly modified version of the introduction by George Beccaloni to the following privately published book: Preston, T. (Ed.). 2013. The Letter from Ternate. UK: TimPress. 96 pp.
Categories: Development

My Presentation at APEX Connect 2016

Denes Kubicek - Wed, 2016-04-06 12:12
On 28th of April I will be presenting at APEX Connect in Berlin. The topic is Integration of APEX with HERE Maps. If you are interested to see how you can integrate APEX with Maps (HERE or Google or some other) please join the presentation. The best thing is that this integration ist done using APEX Plugins only. I will try to show as many functionalities as possible including Routing, Tracing, Positioning and a combination of all the features together.

Categories: Development

Machine Learning for Oracle Developers

Gerger Consulting - Mon, 2016-04-04 03:51
Oracle doesn't offer any solutions for machine learning. It is time for Oracle developers to look elsewhere.

If you don't know where to start, attend our webinar and find out how you can apply Numenta's open source machine learning technology to real world enterprise IT problems.



Categories: Development

Machine Intelligence for Enterprise IT

Gerger Consulting - Wed, 2016-03-30 01:59
The need to gain actionable insights from ever increasing data sets is a huge problem for BI professionals. Attend our webinar presented by Numenta, a machine intelligence company founded by Jeff Hawkins (the founder of Palm Inc.), and learn how machine intelligence can help you solve real world enterprise IT problems.

Watch the short video about Numenta's story and the importance of their approach to machine learning:



If you want to learn how to use machine intelligence for analytics, this is the webinar to attend.






Categories: Development

My Demo Application

Denes Kubicek - Tue, 2016-03-29 00:34
If you experience a problem accessing My Demo Application (old and new version) at apex.oracle.com, that means there is a reason for that. One of the users deleted all the applications in my workspace and installed some of his own. I don't think this was intended but it is still a lot of work and I am trying to geta all the important stuff back online. After that I will need to rethink the way of accessing the workspace. It happened for the second time within the last four months.

Categories: Development

Calling REST Services from Application Builder Cloud Service

Shay Shmeltzer - Mon, 2016-03-21 16:33

One of the frequent requests we get when we demo ABCS is - can I invoke some external functionality that is exposed as a REST service and pass parameters to it.

Well, with a minimal amount of JavaScript coding you can do it in the current version. 

I recorded the demo below that shows you how to do that.

I'm leveraging a public REST API that github exposes to get a list of repositories for a user. The service is available at https://api.github.com/users/oracle/repos

I then design an ABCS page that has a parameter field, a button that invokes the REST/JSON call, and a placeholder for results. It looks like this: 

In addition the video also shows some other techniques that are useful, including:

  • How to create a new blank data entry page
  • How to add custom component that renders HTML content
  • How to add a button that calls a REST service
  • How to pass a parameter to the JavaScript custom code
  • How to set a page to be the default page of the app
  • How to stage your application for external testing

&amp;amp;amp;amp;lt;span id=&amp;amp;amp;amp;quot;XinhaEditingPostion&amp;amp;amp;amp;quot;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;

It seems that right now you are restricted to accessing REST services that are secured over HTTPS protocol (which is a good thing).

Note that you of course don't have to stage the app to see it run, you can just go into live mode, or run it to see it working. I just wanted to make sure I have a demo out there that shows how staging works.

The JavaScript snippet I'm using in the video is: 

$.getJSON("https://api.github.com/users/"+ +"/repos", function(result){

$.each(result, function(i, field){

$('[name="myOutput"]').append(field.name + " ");

});

        });

resolve(); 

If you'll actually add a

$('[name="results"]').empty(); 

as the first link, it will clear the field for you each time you re-press the button. 

Categories: Development

Monitor Oracle with Zabbix

Gerger Consulting - Mon, 2016-03-21 06:09
We've got a webinar tomorrow. Attend our webinar and learn how you can monitor your Oracle Database instances with the open source monitoring tool Zabbix. Sign up at this link. More than 125 people have already signed up!




Categories: Development

Something Amiss

Greg Pavlik - Thu, 2016-03-17 00:02
Looks like this curious non-review of the novel Laurus seems to have been referring to "Brahmins" as "Brahman" - I suppose republished to correct the mistake:
​Russian Brahman by Alan Jacobs | Articles | First Things
www.firstthings.com/article/2016/04/russian-brahman
First Things
Russian Brahman. by Alan Jacobs April 2016. Laurus by eugene vodolazkin translated by lisa hayden oneworld, 384 pages, $24.99. Eugene Vodolazkin's ...
​Russian Brahmin by Alan Jacobs | Articles | First Things
www.firstthings.com/article/2016/04/russian-brahmin
First Things
Russian Brahmin. by Alan Jacobs April 2016. Laurus by eugene vodolazkin translated by lisa hayden oneworld, 384 pages, $24.99. Eugene Vodolazkin's ...

Whatever his grasp of Hindu concepts, it's obvious Jacobs knows little to nothing about the tradition of Russian yurodivy, which makes this review overall kind of silly at best. Interested readers can refer to the hagiographies of Xenia of Petersburg or Feofil of the Kiev Caves Lavra to become acquainted with some of the conceptual background to the novel, both published by the monastery press in Jordanville, NY in English. As a complement the Pavel Lungin movie Ostrov is worth watching carefully - the film is based partly on Feofil, though like the life of St Xenia, it explores the theme of vicarious repentance. (It was not until the third time I saw the film that I fully grasped it - the visuals are stunning and in many respects a distraction.)

All of that aside, what continues to trouble me in general is the fact that most of the reviews of Laurus that I've seen have been oriented toward theological critiques - endorsements or arguments revolving around the reviewer's reading of what the author might want us to think about religion. And yet it is obvious that Vodolazkin did not write a religious apologetic (Jacobs invokes Karamazov, which is simultaneously a religious argument and a humanistic work - but Laurus is anything but the former). Laurus deserves a review as a work of notable - even great - world literature: which is to say first and foremost an exploration of what Vodolazkin is attempting to accomplish as a writer and what that has produced as a work of literature. The lack of serious analysis is particularly puzzling given the devices Vodolazkin uses to deal with language, identity, personality, relationship, and - yes - time. We could do with a few less sermons and a bit more thought.

OTN Interview about Application Development with Oracle

Shay Shmeltzer - Tue, 2016-03-15 14:34

A few weeks ago, I set down with Bob from OTN for an interview that covered some of the key products our group works on.

I covered the various frameworks (ADF, JET, MAF), what we are doing with cloud based development (DevCS) and our tools for citizen developers (ABCS).

In case you are interested in any of these acronyms here is the video:

Note that things move really fast at Oracle, and since this interview we already released a new version of Oracle JET and also made it open source, we released an update to Developer Cloud Service, and Application Builder Cloud Service has gone production.

Categories: Development

Monitoring Oracle Database with Zabbix

Gerger Consulting - Mon, 2016-03-14 08:14

Attend our free webinar and learn how you can use Zabbix, the open source monitoring solution, to monitor your Oracle Database instances? The webinar is presented by Oracle ACE and Certified Master Ronald Rood.


About the Webinar:

Enterprise IT is moving to the Cloud. With tens, hundreds even thousands of servers in the Cloud, monitoring the uptime, performance and quality of the Cloud infrastructure becomes a challenge that traditional monitoring tools struggle to solve. Enter Zabbix. Zabbix is a low footprint, low impact, open source monitoring tool that provides various notification types and integrates easily with your ticketing system. During the webinar, we'll cover the following topics:

  • Installation and configuration of Zabbix in the Cloud
  • Monitoring Oracle databases using Zabbix
  • How to use Zabbix templates to increase the quality and efficiency of your monitoring setup
  • How to setup Zabbix for large and remote networks
  • How to trigger events in Zabbix
  • Graphing with Zabbix
  • Categories: Development

    WINDOW NOSORT STOPKEY + RANK()

    XTended Oracle SQL - Fri, 2016-03-11 18:23

    Recently I found that WINDOW NOSORT STOPKEY with RANK()OVER() works very inefficiently: http://www.freelists.org/post/oracle-l/RANKWINDOW-NOSORT-STOPKEY-stopkey-doesnt-work
    The root cause of this behaviour is that Oracle optimizes WINDOW NOSORT STOPKEY with RANK the same way as with DENSE_RANK:

    rnk1

    create table test(n not null) as 
      with gen as (select level n from dual connect by level<=100)
      select g2.n as n
      from gen g1, gen g2
      where g1.n<=10
    /
    create index ix_test on test(n)
    /
    exec dbms_stats.gather_table_stats('','TEST');
    select/*+ gather_plan_statistics */ n
    from (select rank()over(order by n) rnk
                ,n
          from test)
    where rnk<=3
    /
    select * from table(dbms_xplan.display_cursor('','','allstats last'));
    drop table test purge;
    

    [collapse]
    Output
             N
    ----------
             1
             1
             1
             1
             1
             1
             1
             1
             1
             1
    
    10 rows selected.
    
    PLAN_TABLE_OUTPUT
    -----------------------------------------------------------------------------------------------------------------------
    SQL_ID  8tbq95dpw0gw7, child number 0
    -------------------------------------
    select/*+ gather_plan_statistics */ n from (select rank()over(order by
    n) rnk             ,n       from test) where rnk<=3
    
    Plan hash value: 1892911073
    
    -----------------------------------------------------------------------------------------------------------------------
    | Id  | Operation              | Name    | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
    -----------------------------------------------------------------------------------------------------------------------
    |   0 | SELECT STATEMENT       |         |      1 |        |     10 |00:00:00.01 |       3 |       |       |          |
    |*  1 |  VIEW                  |         |      1 |   1000 |     10 |00:00:00.01 |       3 |       |       |          |
    |*  2 |   WINDOW NOSORT STOPKEY|         |      1 |   1000 |     30 |00:00:00.01 |       3 | 73728 | 73728 |          |
    |   3 |    INDEX FULL SCAN     | IX_TEST |      1 |   1000 |     31 |00:00:00.01 |       3 |       |       |          |
    -----------------------------------------------------------------------------------------------------------------------
    
    Predicate Information (identified by operation id):
    ---------------------------------------------------
    
       1 - filter("RNK"<=3)
       2 - filter(RANK() OVER ( ORDER BY "N")<=3)
    

    [collapse]

    As you can see, A-Rows in plan step 2 = 30 – ie, that is the number of rows where

    DENSE_RANK<=3

    but not

    RANK<=3

    The more effective way will be to stop after first 10 rows, because 11th row already has RANK more than 3!
    But we can create own STOPKEY version with PL/SQL:

    PLSQL STOPKEY version
    create or replace type rowids_table is table of varchar2(18);
    /
    create or replace function get_rowids_by_rank(
          n          int
         ,max_rank   int
       ) 
       return rowids_table pipelined
    as
    begin
       for r in (
          select/*+ index_rs_asc(t (n))  */ rowidtochar(rowid) chr_rowid, rank()over(order by n) rnk
          from test t
          where t.n > get_rowids_by_rank.n
          order by n
       )
       loop
          if r.rnk <= max_rank then
             pipe row (r.chr_rowid);
          else
             exit;
          end if;
       end loop;
       return;
    end;
    /
    select/*+ leading(r t) use_nl(t) */
       t.*
    from table(get_rowids_by_rank(1, 3)) r
        ,test t
    where t.rowid = chartorowid(r.column_value)
    /
    

    [collapse]
    In that case the fetch from a table will stop when rnk will be larger than max_rank

    Categories: Development

    Free Oracle Database Monitoring Webinar by Oracle ACE Ronald Rood

    Gerger Consulting - Wed, 2016-03-09 05:19
    Attend our webinar and learn how you can monitor your Oracle Database and cloud infrastructure with Zabbix, the open source monitoring tool.

    The presentation is hosted by Oracle ACE and Certified Master Ronald Rood.

    Learn more about the webinar at this link.


    Categories: Development

    Side by Side comparison: ParalleNew+CMS vs G1GC Java Garbage Collector

    Arun Bavera - Fri, 2016-03-04 17:31
    Side by Side comparison: Left ParalleNew+CMS Right:G1GC
    Verdict: With minimal intervention ParallelNew+ UseConcMarkSweepGC performs well ahead of G1GC.
    Note: This test was done on small Heap size of 90M with JDK 1.7.0.67 using Grinder and AuctionImage test application. This is small heap and application but still we see memory fragmentation with PralleNew+CMS and G1GC seems to work well in this area but performance has to improve.

    Here are test and result screens in ViisualVM and JMC.
    export USER_MEM_ARGS="-Xms90m -Xmx90m -XX:MaxPermSize=256m"
    JAVA_OPTIONS+=" -XX:+UseParNewGC"
    JAVA_OPTIONS+=" -XX:+UseConcMarkSweepGC"
    JAVA_OPTIONS+=" -XX:+UseG1GC"
    JAVA_OPTIONS+=" -XX:+UnlockCommercialFeatures"
    JAVA_OPTIONS+=" -XX:+FlightRecorder"
    Note: All other values default:
    3.3Sec Pause 11.4 Sec Pause
    clip_image002[6]










    Three Grinder Tests with:
    Left ParalleNew+CMS Right:G1Gc
    JAVA_OPTIONS+=" -XX:MaxGCPauseMillis=500"
    8.99Sec Pause 30.14Sec Pause
    clip_image002[10]

    Another three Grind Test:
    export USER_MEM_ARGS="-Xms90m -Xmx90m -XX:MaxPermSize=256m
    JAVA_OPTIONS+=" -XX:MaxGCPauseMillis=500"
    JAVA_OPTIONS+=" -XX:NewRatio=2"
    Left: JAVA_OPTIONS+=" -XX:+UseParNewGC"
    JAVA_OPTIONS+=" -XX:+UseConcMarkSweepGC"
    Right:
    JAVA_OPTIONS+=" -XX:+UseG1GC"
    clip_image002[12]
    Result:
    Left: 8.54 Sec Pause Right: 1m+ 19.9Sec
    JFR for 2 GrindTest:
    clip_image002[14]
    clip_image002[16]
    Memory Overview Left: PrallelNew_CMS Right:G1GC
    clip_image002[18]
    Garbage Collection
    clip_image002[20]
    gcPausetime:
    clip_image002[22]
    GC Configuration:
    clip_image002[24]
    Threads CPU Usage:
    clip_image002[26]
    Lock Instances:
    clip_image002[28]
    Socket Write:
    clip_image002[30]
    System:
    clip_image002[32]
    Code Exceptions:
    clip_image002[34]
    Verdict: With minimal intervention ParallelNew+ UseConcMarkSweepGC performs well ahead of G1GC.
    Note: This test was done on small Heap size of 90M with JDK 1.7.0.67 using Grinder and AuctionImage test application. This is small heap and application but still we see memory fragmentation with PralleNew+CMS and G1GC seems to work well in this area but performance has to improve.






























































    Categories: Development

    Application Builder Cloud Service - Menus, Buttons and Validation

    Shay Shmeltzer - Fri, 2016-03-04 12:11

    Continuing with the exploration of Oracle Application Builder Cloud Service, I've picked up the application I created in the previous blog entry and added a few more things to demo how to:

    • Configure the logo and title
    • Modify and add menu items
    • Define field level validation
    • Add buttons and define their actions

    Check out this short demo:

    Categories: Development

    Pages

    Subscribe to Oracle FAQ aggregator - Development