Feed aggregator

ADF on Docker - Java Memory Limit Tuning for JVM

Andrejus Baranovski - Wed, 2018-03-28 03:46
It might look like a challenge to run Java in Docker environment, by default Java is not aware of Docker memory limits. Check this article for example - Java inside docker: What you must know to not FAIL.  I was able to run WebLogic and ADF (Essential WebLogic Tuning to Run on Docker and Avoid OOM) on Docker previously without Java memory issues, using JAVA_OPTIONS=-XX:+UnlockCommercialFeatures -XX:+ResourceManagement -XX:+UseG1GC. However after Docker upgrade to latest version, these settings didn't help anymore. I did't want to hardcode memory setting with -Xmx.

Java started to consume all available memory in Docker and eventually was killed. You can see this from chart below - memory is growing, killed and after restart growing again:


To solve this behaviour, I have applied settings from Java Platform Group, Product Management Blog - Java SE support for Docker CPU and memory limits. I have replaced JAVA_OPTIONS=-XX:+UnlockCommercialFeatures -XX:+ResourceManagement -XX:+UseG1GC set previously with JAVA_OPTIONS=-XX:+UnlockExperimentalVMOptions -XX:+UseCGroupMemoryLimitForHeap -XX:+UseG1GC.

JAVA_OPTIONS=-XX:+UnlockExperimentalVMOptions - XX:+UseCGroupMemoryLimitForHeap -XX:+UseG1GC did the job - JVM stays in Docker memory limits sharp:


This chart shows Java memory behaviour before and after settings were applied. From March 27th - Java memory is a straight line with JAVA_OPTIONS=-XX:+UnlockExperimentalVMOptions - XX:+UseCGroupMemoryLimitForHeap -XX:+UseG1GC:

Log Switches and log file sync

Tom Kyte - Wed, 2018-03-28 01:46
Hello Tom, I currently have 6 log groups of 1 2GB member. These six groups are on the same mount point in a virtual environment. There is a log switch every hour. During peak times, however, the log file sync wait seems to be an issue for us. The ...
Categories: DBA Blogs

Shrink SYSAUX

Tom Kyte - Wed, 2018-03-28 01:46
I shrinked a tablespace SYSAUX but I have got segments towards the end of the datafile, the resize command will failed. I checked type segment names and it type this query: select file_id, block_id, block_id + blocks - 1 end_block,...
Categories: DBA Blogs

system statistics

Tom Kyte - Wed, 2018-03-28 01:46
Hi Tom, Recently with the help of your valuable answers to my questions regarding system statistics, I have put "system statsitics" into production system after testing and results are wonderful. It saved my more than 50% of execution time. My que...
Categories: DBA Blogs

Materialized view refresh in case of DDL on base table, like truncate, drop and recreate

Tom Kyte - Wed, 2018-03-28 01:46
Hi Tom, I was trying to prepare materialized view against some table which are periodically dropped and recreated. I did not find an option to automatically refresh the materialized view in this case. Refresh FAST ON COMMIT is not working, and REF...
Categories: DBA Blogs

Query transformation - Remote database

Tom Kyte - Wed, 2018-03-28 01:46
Hi, I have a query that fetches data from a remote database and this data is not what i was expecting (less data or no data). I did try to understand what is causing the issue and noticed the query was being transformed while run on the remote db....
Categories: DBA Blogs

Richard Foote Consulting Seminars At Your Workplace !!

Richard Foote - Wed, 2018-03-28 00:04
If you have 6 or more people in you organisation who would be interested in attending a seminar, please contact me at richard@richardfooteconsulting.com. I currently run my highly acclaimed “Oracle Indexing Internals and Best Practices” seminar as public events, which has now been run in some 18 countries. I’m also at work on developing an […]
Categories: DBA Blogs

Oracle Redefines the Cloud Database Category with World’s First Autonomous Database

Oracle Press Releases - Tue, 2018-03-27 16:30
Press Release
Oracle Redefines the Cloud Database Category with World’s First Autonomous Database Delivers industry-leading performance, security capabilities, and availability at half the cost of Amazon Web Services

Redwood Shores, Calif.—Mar 27, 2018

At an Oracle event today, Oracle Executive Chairman and CTO Larry Ellison announced the availability of the first service based on the revolutionary new Oracle Autonomous Database. The world’s first self-managing, self-securing, self-repairing database cloud service, Oracle Autonomous Data Warehouse Cloud, uses machine learning to deliver industry-leading performance, security capabilities, and availability with no human intervention, at half the cost of Amazon Web Services.

“This technology changes everything,” said Ellison. “The Oracle Autonomous Database is based on technology as revolutionary as the Internet. It patches, tunes, and updates itself. Amazon’s databases cost more and do less.”

Oracle Autonomous Data Warehouse Cloud delivers all of the analytical capabilities, security features, and high availability of the Oracle Database without any of the complexities of configuration, tuning, and administration—even as warehousing workloads and data volumes change. The autonomous database is an entirely new class of offering which requires zero operational administration on the customer’s part, enabling cloud data warehousing that is:

  • Easy. The industry’s first one-step warehouse provisioning spins up a secure data warehouse with automatic backup, encryption, and a high availability architecture in mere seconds. Migration to cloud is simple due to full compatibility with existing on-premises databases.
  • Fast. Industry-leading query performance with no tuning required. Oracle Autonomous Data Warehouse Cloud is so fast that Oracle guarantees the same workload at half the cost of Amazon Web Services[i].
  • Elastic. Independent, online scaling of compute and storage. The ability to dynamically grow or shrink resources enables true pay-per-use, dramatically lowering costs.

The world’s most popular data warehouse database is now the world’s simplest and safest. Leveraging decades of experience and technology leadership to transform how companies benefit from database services, Oracle Autonomous Data Warehouse Cloud is the first of many Oracle Autonomous Database Cloud services. Other services in development include Oracle Autonomous Database for Transaction Processing, Oracle Autonomous NoSQL Database for fast, massive-scale reads and writes (commonly demanded by the Internet of Things), and Oracle Autonomous Graph Database for network analysis. Each of these offerings is tuned to its specific workload, and shares the defining characteristics of Oracle Autonomous Database services:

  • Self-managing. Eliminates human labor and human error to provision, secure, monitor, backup, recover, troubleshoot, and tune the database. Automatically upgrades and patches itself while running.
  • Self-securing. Protects from external attacks and malicious internal users. Automatically applies security updates while running to protect against cyberattacks, and automatically encrypts all data.
  • Self-repairing. Provides automated protection from all planned and unplanned downtime with up to 99.995 percent availability, resulting in less than 2.5 minutes of downtime per month, including planned maintenance.

The Oracle Autonomous Data Warehouse is built on Oracle Database 18c, the first release in Oracle’s new annual database software release model. A hotbed of innovation with over 100 new features, Oracle Database 18c is now available on Oracle Cloud Services, Oracle engineered systems, and livesql.oracle.com.

Today’s announcement follows on the heels of Oracle’s recently announced expansion of its Oracle Cloud Platform Autonomous Services. During this calendar year, Oracle plans to deliver Oracle Autonomous Analytics, Oracle Autonomous Mobility, Oracle Autonomous Application Development and Oracle Autonomous Integration services.

[i] Oracle will cut your Amazon bill in half when you run the same data warehouse workload on Oracle Autonomous Data Warehouse Cloud Service as compared to running on Amazon AWS. The minimum workload is one hour for this offer. Offer valid through May 31, 2019. Terms and conditions apply. See http://www.oracle.com/guaranteed.

Contact Info
Nicole Maloney
Oracle
650.506.0806
nicole.maloney@oracle.com
Jessica Moore
Oracle
650.506.3297
jessica.moore@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation.

Talk to a Press Contact

Nicole Maloney

  • 650.506.0806

Jessica Moore

  • 650.506.3297

Oracle’s Revolutionary New Database Automates Key Functions for Enterprise Customers

Oracle Press Releases - Tue, 2018-03-27 16:30
Press Release
Oracle’s Revolutionary New Database Automates Key Functions for Enterprise Customers World’s first autonomous database boosts performance and cuts costs for customers

Redwood Shores, Calif.—Mar 27, 2018

Oracle today announced that Oracle Autonomous Data Warehouse Cloud, the first service based on the revolutionary new Oracle Autonomous Database, is available worldwide. At an event today at Oracle headquarters, a group of customers and partners who were given exclusive access to test-drive the new self-driving database spoke about the value of autonomous capabilities. Accenture, Hertz, QMP Health, and Qualex joined Oracle executives on-stage to share the breakthrough results they are already experiencing with Oracle Autonomous Data Warehouse Cloud, including performance advantages, lower costs, and improved security posture of their data and systems.

“Oracle Autonomous Database is a truly transformative technology for our 420,000 global customers and an important breakthrough for the industry,” said Andy Mendelsohn, executive vice president, Database Server Technologies, Oracle. “The self-driving, self-securing and self-repairing capabilities revolutionize how our customers will manage and secure their data. Nothing else like this exists in the market today.”

The first of its kind, Oracle Autonomous Database introduces self-driving, self-securing, and self-repairing capabilities that automate key management and security processes in database systems like patching, tuning and upgrading, all while keeping the critical infrastructure constantly running. With the Oracle Autonomous Database, Oracle can help customers minimize risk and improve the security capabilities of their data and systems. Oracle Autonomous Data Warehouse Cloud is the first of many Oracle Autonomous Database Cloud services that uses machine learning to deliver outstanding performance, unprecedented simplicity and elasticity for data warehouses.

Organizations Test Drive Autonomous Database

“We are at the dawn of the intelligent enterprise era, and having an automated database is a natural progression,” said Paul Daugherty, chief technology and innovation officer, Accenture. “Being able to build a self-driving data warehouse—in some cases, in only a matter of minutes or hours—can dramatically simplify the ability to generate powerful business insights, much faster than previously possible.”

“The flexibility of Autonomous Data Warehouse Cloud in terms of delivering instantaneous, fully elastic scalability is truly outstanding and unique in the market,” said Erik Dvergnes, Architect, Aker BP.

“Our initial tests have shown that Oracle Autonomous Data Warehouse Cloud offers important innovations,” said Manuel Martin Marquez, Big Data Engineer and Data Scientist, CERN. “For instance, Oracle Autonomous Data Warehouse Cloud automatically reduced the storage required by important control systems by a factor of ten.”

Jerry Gearding, CTO, DX Marketing said, “The elastic scalability of the Autonomous Data Warehouse Cloud, where we can easily scale up and down and only pay for processor services when we’re actually using them is a big benefit for DX Marketing.”

“I’ve been really impressed with how Oracle Autonomous Data Warehouse Cloud can take different types and sizes of analytic workloads and get better performance without any fine-tuning,” said Benjamin Arnulf, Director of Business Intelligence and Analytics, Hertz. “It will allow us to reduce costs and re-invest savings into improving customer service, thus rewarding our customers.”

Looker, a cloud-based BI and analytics company, sees a growing need for enterprise-ready but easy-to-use data warehousing. According to Keenan Rice, Vice President of Strategic Alliances, Looker, “We’re seeing a lot of demand from customers for a fully managed experience, and the Autonomous Data Warehouse Cloud makes it a lot easier for Looker’s customers to derive value from their data.”

“We’ve found that the Autonomous Data Warehouse Cloud is very easy to use, very easy to load data, and the performance has been amazing,” said Miles Oustad, Data Integration Team Manager, Minnesota State.

“When you’re dealing with human lives, time is everything,” said Michael Morales, CEO, QMP Health. “Having the Autonomous Data Warehouse Cloud automatically tune and manage itself with no downtime means faster response times and quicker decisions—that’s critical for us and our patients.”

“Oracle Autonomous Data Warehouse Cloud is the perfect solution for 11880.com Solutions AG,” said Christian Maar, CEO, 11880.com. “It requires no administration resources, it delivers great performance, and its flexibility means it can scale as our company grows.”

Industry Analysts Validate Market Leadership

Multiple independent industry analyst reports recently recognized Oracle for its Autonomous Database technology. Following are some of these reports and key findings:

  • Gartner again positioned Oracle highest in “ability to execute” in its *Gartner, “Magic Quadrant for Data Management Solutions for Analytics” by Adam M. Ronthal, Roxane Edjlali, Rick Greenwald, 13 February 2018 report
  • In the February 2018 IDC Perspective Oracle’s Autonomous Database: AI-Based Automation for Database Management and Operations, authors Carl W. Olofson and David Schubmehl wrote, “Oracle is at the vanguard of a movement to make enterprise software easier to deploy, use and administer, using artificial intelligence and machine learning to provide capabilities requiring little or no human intervention to manage software.”
  • KuppingerCole’s Executive View: Oracle Autonomous Database January 2018 report said, “Oracle goes much further than just automation with its newest offering. This approach has immense potential benefits not just for reducing labor and costs for customers, but for dramatically improving database’s resiliency against both human errors and malicious activities, internal or external. Each database is also designed to have security features enabled by default and relevant parameters automatically configured according to the current security best practices.”
 

*Gartner, “Magic Quadrant for Data Management Solutions for Analytics” Adam M. Ronthal, Roxane Edjlali, Rick Greenwald, 13 February 2018.

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Contact Info
Nicole Maloney
Oracle
650.506.0806
nicole.maloney@oracle.com
Jessica Moore
Oracle
650.506.3297
jessica.moore@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Nicole Maloney

  • 650.506.0806

Jessica Moore

  • 650.506.3297

Oracle Statement

Oracle Press Releases - Tue, 2018-03-27 11:59
Press Release
Oracle Statement

Redwood Shores, Calif.—Mar 27, 2018

"The Federal Circuit's opinion upholds fundamental principles of copyright law and makes clear that Google violated the law. This decision protects creators and consumers from the unlawful abuse of their rights."

 
—Dorian Daley, Oracle Executive Vice President, General Counsel and Secretary
Contact Info
Deborah Hellinger
Oracle Corporate Communications
1.212.508.7935
deborah.hellinger@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Deborah Hellinger

  • 1.212.508.7935

Oracle JET Offline Persistence Toolkit - Offline Update Handling

Andrejus Baranovski - Tue, 2018-03-27 09:42
Oracle JET Offline Persistence Toolkit supports offline update, create and delete operations. In this post I will describe update use case. Read previous post related to offline toolkit, where I explain how to handle REST pagination, querying and shredding - REST Paging Support by Oracle Offline Persistence in JET.

This gif shows scenario, where we go to offline mode and then changing data in multiple rows. Data update happens offline and each PATCH request is tracked by offline persistence toolkit:


As soon as we go online (Offline checkbox value is changed in Chrome Developer Tools) - requests executed while offline are replayed automatically against backend server:


We should see, how update flow is implemented in JET in this particular case. Once data is changed, we call submitUpdate function. This function in turn calls JET Model API function save. This triggers PATCH call to back-end to update data. If we are offline, JET offline persistence toolkit, transparently records PATCH request to be able to replay it later while online. There are no specific code changes needed by developer to support offline logic during REST call:


Once we go online, listener is invoked and it calls our function synchOfflineChanges. This function triggers request replay to the backend. This means we can control, when requests are replayed. Besides this, we can control each request which failed to be replayed - this is important, when data conflict happens during update in backend:


Online handler is registered with window.addEventListener in the same module, where persistence manager is defined:


Offline Persistence Toolkit 1.1.1 supports extensive logging. You can update to 1.1.1 version by running: npm install @oracle/offline-persistence-toolkit command:


To enable persistence toolkit logger, add persist/impl/logger module to your target module and call logger.option('level', logger.LEVEL_LOG):


Logger prints useful information about offline update, this helps to debug offline functionality:


Download sample application from GitHub repository.

The WAL segement size becomes changeable in PostgreSQL 11

Yann Neuhaus - Tue, 2018-03-27 09:37

Up to PostgreSQL 10 the wal segment size was fixed once PostgreSQL was compiled and installed. When you wanted to have something else than the default you needed to tell that to the configure command when building from source, e.g.

postgres@pgbox:/home/postgres/postgresql/ [PGDEV] ./configure --with-wal-segsize=64MB

For PostgreSQL 11 two commits landed (1 and 2) which change this. Lets have a look.

When you check the current development documentation for initdb you’ll notice a new parameter called “–wal-segsize”. This allows to change the WAL segment size from the default of 16MB when you initialize you new cluster:

postgres@pgbox:/home/postgres/ [PGDEV] initdb --wal-segsize=32 /var/tmp/aa
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locales
  COLLATE:  en_US.utf8
  CTYPE:    en_US.utf8
  MESSAGES: en_US.utf8
  MONETARY: de_CH.UTF-8
  NUMERIC:  de_CH.UTF-8
  TIME:     en_US.UTF-8
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /var/tmp/aa ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg_ctl -D /var/tmp/aa -l logfile start

Btw: You can also use pg_controldata to get the size of the WAL segments:

postgres@pgbox:/home/postgres/ [PGDEV] pg_controldata | grep "Bytes per WAL segment"
Bytes per WAL segment:                33554432
postgres@pgbox:/home/postgres/ [PGDEV] echo "33554432/1024/1024" | bc
32

The other commit added the same option to pg_resetwal.

postgres@pgbox:/home/postgres/ [PGDEV] pg_resetwal -D /var/tmp/aa/ --wal-segsize=64
Write-ahead log reset
postgres@pgbox:/home/postgres/ [PGDEV] pg_controldata | grep "Bytes per WAL segment"
Bytes per WAL segment:                67108864
postgres@pgbox:/home/postgres/ [PGDEV] echo "67108864/1024/1024" | bc
64

So, hopefully this September when PostgreSQL 11 should be released, you do not need to install additional binaries for changing the WAL segment size. This will also allow major upgrades with pg_upgrade to a new cluster with a different WAL segment size. Nice, makes things easier.

 

Cet article The WAL segement size becomes changeable in PostgreSQL 11 est apparu en premier sur Blog dbi services.

Oracle Integration Cloud: Customer Managed & Patching

Jan Kettenis - Tue, 2018-03-27 07:54
Currently the Oracle Integration Cloud (OIC) only comes as "customer managed". Among others this means that you as a customer have access to management consoles. It also means that you determine when to apply patches, as Oracle does not do that for you. The following describes how easy that is.

Oracle Cloud solutions can come in two flavors: Oracle Managed and Customer Managed. The first means that maintenance, including patching is done by Oracle. You don't have to ask for nor to initiate it as it all happens "automatically", typically during non-business hours (like Friday evening). It also means that you don't have any control over it. Now that probably is exactly what you want. However, in case of OIC that currently only comes as Customer Managed. This means that you have access to the Weblogic Service Console and the Fusion Middleware Console (although not with all the features that you for example would have with the on-premise version of the BPM Suite). I expect these consoles not to be available in the Oracle Managed flavor to come soon.



Another difference will be the way it is provisioned. With the Customer Managed flavor you have to provision a Storage Cloud yourself, and - depending on the type of template you use - also the Database Cloud.

With Oracle Managed I expect this to happen in one blow but that is yet to be seen. With Customer Managed you also have to think about how to configure the Stack that you want to use. A Stack is based on a Stack Template, which specifies the amount of nodes, OCPU's, memory, database version and edition of a node (and a few other things). A Stack is a provisioned instance of a template. After provisioning you cannot change the instance or use another template. However you can provision more instances based on the same stack. Another thing to point out is that with the Customer Managed flavor you need to indicate if and how you want it to be backed up.

Apart from some complexity but also flexibility that comes with determining your Stack Template, after provisioning there is little difference with the Oracle managed flavor. You can use it the same way, and if you have it configured to automatically do backups you don't have to think about that either. You do have to keep a keen eye on patches that may have become available, though.

If a patch is available, that will be shown on the Service Console:


You can start patching by clicking the link, which brings you to the Patch tab. In my case this gives a warning that I have no backup configured. It is a trial-only instance so I did not bother to do so. For a Production instance you should have done that (obviously). I don't know if I can still change that for my instance, but I don't think so. On the right-hand side there is a menu with two options: Precheck and Patch.


With the Precheck option you can let OIC verify if your instance is ready to apply the patch to. In my case it is.


With the Patch option from the menu you initiate the actual patching. In my case the patch can be done rolling what means with the instance up-and-running. As a matter of fact, the patch cannot be applied with one or more instances being shut down.


There also was a patch for the DB instance available, which required a restart. I could only apply that after shutting down the OIC instance, but that is indicated clearly.


Just for the fun of it I did the precheck of the patch after applying it. It failed, what I expected because it was already applied. The results were not very clear though.


Automating procedure testing which returns cursors

Tom Kyte - Tue, 2018-03-27 07:26
Hi Team, In my project we have testing suite built for PL/SQL and it tests basic test cases like input/output comparision. So in the tool if I configure procedure P1 (p_in IN number, P_out OUT number) with input and and expected output, the too...
Categories: DBA Blogs

Extracting 500 Million Rows from Oracle DB -- Pro*C OR PL/SQL UTL_FILE? Deep Dive into WHY?

Tom Kyte - Tue, 2018-03-27 07:26
Hi Tom, The question is simple. I need 500 Mil rows to offload from oracle, what should I choose to to develop an application with ? PRO*C or PL/SQL UTL_FILE? and why ? I have gone through the debated topics on which approach between PRO*C o...
Categories: DBA Blogs

Extracting execution plan for PL/SQL block

Tom Kyte - Tue, 2018-03-27 07:26
<code>Hi Tom, Need help extracting execution plan for any anonymous PL/SQL block . I am able to extract execution plan for SQL using explain plan but it doesn't work for pl/sql block EXPLAIN PLAN FOR select * from dual; select *...
Categories: DBA Blogs

Difference in parallel hints.

Tom Kyte - Tue, 2018-03-27 07:26
Hi Tom, What is difference in following two scenarios? I am using parallel hints like - 1. select /*+ parallel(e,4) parallel(d,4)*/ e.eid,d.did from emp e, dept d where e.did = d.did; 2. select /*+ parallel(4)*/ e.eid,d.did from e...
Categories: DBA Blogs

customizing the SQLprompt

Tom Kyte - Tue, 2018-03-27 07:26
Hello Tom, I notice in the Oracle Magazine that you have your SQL prompt displaying "user@instance". Please tell me how you accomplish this. I can get it to display the username OR the instance name but not both. Thanks! -Lisa
Categories: DBA Blogs

Lorain County Community College Increases Enrollment and Student Success with Oracle Cloud

Oracle Press Releases - Tue, 2018-03-27 07:00
Press Release
Lorain County Community College Increases Enrollment and Student Success with Oracle Cloud Leading two-year college in Ohio using Oracle Cloud Applications to improve operational efficiency and deliver a modern student experience

Redwood Shores, Calif.—Mar 27, 2018

Oracle today announced that Lorain County Community College  (LCCC) will be using Oracle Cloud Applications to fuel enrollment, efficiency and foster student success.

LCCC has a strong commitment to empowering a thriving community. Working in close partnership with the local high schools and universities, LCCC labors to ensure every student in the area has the opportunity to achieve their goals through education. To help foster this mission, the college needed to modernize and simplify its IT infrastructure with solutions that could improve efficiency amongst its staff and deliver a modern student experience.

With limited IT resources, LCCC looked to the cloud to help meet its objectives. Today, the college is starting to reap the benefits of Oracle Student Engagement and Oracle Student Recruiting and is currently implementing Oracle Enterprise Resource Planning (ERP) Cloud, Oracle Enterprise Performance Management (EPM) Cloud and Oracle Human Capital Management (HCM) Cloud services.

“The success of our students is paramount,” said Jonathan Volpe, vice president for Administrative Services & Treasurer, Lorain County Community College. “To best serve their needs, we had to enhance both our back-end and front-end systems to deliver more efficiency amongst our staff and a better experience for our students. When we reviewed systems, the ROI of Oracle Cloud was clear. With the intelligence and agility of these offerings, we are able to put a renewed energy and focus on recruiting the next generation of learners.”

LCCC will have the automated tools and intelligence they need to help enhance recruiting and deliver a personalized, modern student experience. For example, the college can more effectively identify and engage prospective students outside of their traditional recruiting areas using social interaction, email communications and targeted advertising.

Coupled with Oracle Cloud Applications for Oracle ERP Cloud , Oracle EPM Cloud and Oracle HCM Cloud, LCCC will have the foundation they need to further enhance student recruitment, strategic planning, and financial and talent management with new levels of efficiency and insight.   

“Higher education is at a crossroad and entities need to evolve and modernize to meet the needs of 21st-century students,” said Vivian Wong, group vice president, Higher Education Development, Oracle. “With Oracle Cloud, Lorain County has the technology needed to support their entire organization, from how they manage their finances and people, to how they engage, recruit and retain students.”

Oracle Consulting Services and Oracle PartnerNetwork (OPN) Gold-level member, Navigator Management Partners are core to managing the successful implementation of these solutions.

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.415.856.5145

The same MAC address for two interfaces on the same host?

Yann Neuhaus - Mon, 2018-03-26 23:50

Yes, sounds strange, but exactly this is what we faced today. In the end it is clear and not strange anymore but for a moment we really thought we are hitting a bug in the operating system, which was RedHat 7.4. For the little demo for this post I’ll use CentOS 7.4 but this should not really matter. Lets go.

The situation we faced looked like this:

root@:/etc/sysconfig/network-scripts/ [] ip a
1: lo:  mtu 65536 qdisc noqueue state UNKNOWN qlen 1
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: enp0s3:  mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:d6:95:ab brd ff:ff:ff:ff:ff:ff
    inet 10.0.2.15/24 brd 10.0.2.255 scope global dynamic enp0s3
       valid_lft 86295sec preferred_lft 86295sec
    inet6 fe80::a00:27ff:fed6:95ab/64 scope link 
       valid_lft forever preferred_lft forever
3: enp0s8:  mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:5c:b0:e5 brd ff:ff:ff:ff:ff:ff
    inet 192.168.22.99/24 brd 192.168.22.255 scope global enp0s8
       valid_lft forever preferred_lft forever
    inet6 fe80::a00:27ff:fe5c:b0e5/64 scope link 
       valid_lft forever preferred_lft forever
4: enp0s9:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
5: enp0s10:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
6: bond0:  mtu 1500 qdisc noqueue state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
    inet 192.168.22.223/24 brd 192.168.22.255 scope global bond0
       valid_lft forever preferred_lft forever
    inet6 fe80::a00:27ff:fe85:2d8/64 scope link tentative 
       valid_lft forever preferred_lft forever

As you can see the interfaces enp0s8 and enp0s10 have exactly the same MAC address. In addition to that the bonding interface bond0 has the same mac address as well:

4: enp0s9:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
5: enp0s10:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
6: bond0:  mtu 1500 qdisc noqueue state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
    inet 192.168.22.223/24 brd 192.168.22.255 scope global bond0
       valid_lft forever preferred_lft forever
    inet6 fe80::a00:27ff:fe85:2d8/64 scope link tentative 
       valid_lft forever preferred_lft forever

This was not so scary as we knew that the bonding interface will get one of the mac addresses of the slave interfaces. But both slaves had the same mac address, how that? It all depends on the bonding options. In our case:

root@:/etc/sysconfig/network-scripts/ [] cat ifcfg-bond0 
DEVICE=bond0
TYPE=Bond
BONDING_MASTER=yes
BOOTPROTO=static
IPADDR=192.168.22.223
NETMASK=255.255.255.0
GATEWAY=192.168.22.1
ONBOOT=yes
BONDING_OPTS="mode=active-backup miimon=100"

What you need to know is that there is another parameter/option called fail_over_mac. The default value for this option (as we did not explicitly set it we are using the default) is 0/none which means all slave interfaces will use the same MAC address. The original MAC addresses can be seen here:

root@:/etc/sysconfig/network-scripts/ [] cat /proc/net/bonding/bond0 
Ethernet Channel Bonding Driver: v3.7.1 (April 27, 2011)

Bonding Mode: fault-tolerance (active-backup)
Primary Slave: None
Currently Active Slave: enp0s9
MII Status: up
MII Polling Interval (ms): 100
Up Delay (ms): 0
Down Delay (ms): 0

Slave Interface: enp0s9
MII Status: up
Speed: 1000 Mbps
Duplex: full
Link Failure Count: 0
Permanent HW addr: 08:00:27:85:02:d8
Slave queue ID: 0

Slave Interface: enp0s10
MII Status: up
Speed: 1000 Mbps
Duplex: full
Link Failure Count: 0
Permanent HW addr: 08:00:27:e4:1c:63
Slave queue ID: 0

When we change that to 1/active and restart the network:

root@:/etc/sysconfig/network-scripts/ [] sed -i 's/BONDING_OPTS="mode=active-backup miimon=100"/BONDING_OPTS="mode=active-backup miimon=100 fail_over_mac=active"/g' ifcfg-bond0 
root@:/etc/sysconfig/network-scripts/ [] systemctl restart network

… we will have different MAC addresses:

4: enp0s9:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
5: enp0s10:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:e4:1c:63 brd ff:ff:ff:ff:ff:ff
6: bond0:  mtu 1500 qdisc noqueue state UP qlen 1000
    link/ether 08:00:27:e4:1c:63 brd ff:ff:ff:ff:ff:ff
    inet 192.168.22.223/24 brd 192.168.22.255 scope global bond0
       valid_lft forever preferred_lft forever
    inet6 fe80::a00:27ff:fee4:1c63/64 scope link tentative 
       valid_lft forever preferred_lft forever

The downside of this approach is that the MAC address will change when the active interface goes down. The currently active interface is enp0s9 with the following MAC address:

root@:/etc/sysconfig/network-scripts/ [] cat /proc/net/bonding/bond0 | grep -i active
Bonding Mode: fault-tolerance (active-backup) (fail_over_mac active)
Currently Active Slave: enp0s9
root@:/etc/sysconfig/network-scripts/ [] ip a | grep -A 1 enp0s9
4: enp0s9:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff

The bonding interface has the same MAC address:

root@:/etc/sysconfig/network-scripts/ [] ip a | grep -A 1 bond0
4: enp0s9:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
5: enp0s10:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:e4:1c:63 brd ff:ff:ff:ff:ff:ff
6: bond0:  mtu 1500 qdisc noqueue state UP qlen 1000
    link/ether 08:00:27:85:02:d8 brd ff:ff:ff:ff:ff:ff
    inet 192.168.22.223/24 brd 192.168.22.255 scope global bond0
       valid_lft forever preferred_lft forever

When we bring the currently active interface (enp0s9) down the MAC address of the bonding interface will switch to the MAC address of enp0s10 (which then becomes the active interface):

root@:/etc/sysconfig/network-scripts/ [] ifdown enp0s9
Device 'enp0s9' successfully disconnected.
root@:/etc/sysconfig/network-scripts/ [] ip a | grep -A 1 bond0
5: enp0s10:  mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000
    link/ether 08:00:27:e4:1c:63 brd ff:ff:ff:ff:ff:ff
6: bond0:  mtu 1500 qdisc noqueue state UP qlen 1000
    link/ether 08:00:27:e4:1c:63 brd ff:ff:ff:ff:ff:ff
    inet 192.168.22.223/24 brd 192.168.22.255 scope global bond0
       valid_lft forever preferred_lft forever

The third an last option for fail_over_mac is 3/follow which will change the MAC address of the slave to the bonding’s MAC address when it becomes active. Documentation here.

 

Cet article The same MAC address for two interfaces on the same host? est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator