Cloud Security with Oracle’s Identity SOC

By | Oracle
Databases are high value targets. 76% of organizations have experienced a security incident.[i] Add that to the semi-novelty and porosity of the cloud, and it’s no wonder you’re a little nervous about security. If you’re not concerned, you’re not paying attention. But the best products out there are designed to help reduce your workload and bring peace of mind. Oracle’s cloud security protocols do just that. The innovative Security Operations Center gives you visibility, control and intelligent detection with less oversight. Oracle’s SOC Oracle’s Identity Security Operations Center (SOC) is comprised of several offerings to create a comprehensive security system for cloud, on-premises and hybrid environments. It takes Oracle CASB Cloud Service, Oracle Identity Cloud Service, Oracle Security and Monitoring Analytics Cloud Service, and Oracle Configuration and Compliance Cloud Service and rolls them into one package. Let’s look at some key features. Identity-Based – Network-centric security just doesn’t cut it anymore with the rapidly diversifying landscape of platforms and users. With more and more people accessing SaaS from mobile devices, you need a more intelligent way to monitor threats. Identity-based security uses machine learning and AI to detect patterns in user activity and target potential threats. Oracle’s Security Operations Center (more…)

3 Reasons to Consider Oracle EPM Cloud

By | Oracle
As a business leader, it’s up to you to make some big decisions about your data and processes. It can be tricky to figure out which platform is right for your company. There are no clear answers, except to find out what’s right for you. If your current system has room for improvement, you may want to consider Oracle’s EPM Cloud. The comprehensive data solution streamlines your business processes, providing innovation, flexibility and state-of-the-art security. Innovation In a recent survey conducted by Oracle, 81% of finance leaders reported their top-rated benefit of using Oracle’s EPM Cloud was consistent access to innovative technology. With Oracle’s EPM Cloud you are always at the front of new innovations and technology. Most groundbreaking tech is being released on the cloud, and it pays to take advantage of the platform. Cutting-edge analytics, like Machine Learning and AI, can analyze your data and detect patterns that human eyes would never catch. With this advanced analysis you can make more strategic decisions. Always up-to-date technology also means more options for automation. This saves you time and money and reduces the likelihood of errors. This newfound time can be better spent in strategy than in rote tasks. Flexibility (more…)
Database Support

What’s the Deal with Oracle 18c? (part 2)

By | Oracle
Last week we introduced Oracle’s database 18c, and focused on the new release structure and its increased accessibility on cloud environments.  If you missed this article, here’s a link to go check it out now before heading back over for part 2.  – What’s the Deal with Oracle 18c (part 1) This week we are focusing on more specific feature enhancements to those areas you have come to expect in an Oracle product.  Starting with security and moving on to platform architecture we are looking at how this newest release helps simplify your data management.  We will discuss key features from Database 12c that get exciting upgrades in this new release. Stability – Several new features increase the platform stability, including Real Application Clusters, Recovery Manager and Flashback.  Oracle takes advantage of the multi-server architecture to deliver enhanced backup and recovery features, and reduced downtime for scheduled activities. Security Enhancements – Oracle has always prioritized security and this newest version builds upon that foundation.  With simplified and optimized security protocols, this database will help you prepare for more stringent security requirements coming up in the General Data Protection Regulation (GDPR).  Here are just a few ways Oracle emphasizes security in (more…)
Security

What’s the Deal with Oracle 18c? (part 1)

By | Oracle
Oracle’s newest release, 18c, is out, and I know what you’re thinking: what happened to 12.2.0.2?  Is it really time for a whole new version?  Well rest assured, this is not really a whole new version. It’s an entirely new method of naming that more accurately reflects what has been going on for years.  The old model of multiple release versions and patch sets wasn’t doing justice to the database.  The multiple release model led many to shy away from adopting any first release database for go-live workloads.  But honestly, for years the patch sets have been full releases in all but name. So now Oracle has decided to change its release schedule, and each annual release will be named after the last two digits of the year.  The plan is to speed the release of smaller changes while avoiding the massive overhauls that used to come with first releases.  What would have been database 12.2.0.2 is now 18c, and 12.2.0.3 will instead be 19. They have also gotten rid of the Patch Set Updates and Proactive Bundle Patches.  Instead we will now get Release Updates (RU) and Release Update Revisions (RUR).  So now that we understand the new release (more…)
Server Data Migration

Multitenant database in Oracle 12c

By | Blog, Oracle Tips, Technology Tips & Tricks
One of the new features of Oracle 12c is multitenant databases. Multiple databases can be plugged in a big container database. Container database (CDB) is the primary database that comprises 0, 1 or many pluggable databases (PDB). This holds the controlfiles, datafiles, undo, tempfiles, redo logs and also the data dictionary for those objects that are owned by the root container. It is also called CDB$ROOT Pluggable Database (PDB) – these are the databases stored within the primary container database. Each PDB is a set of schemas, objects and non-schema objects. PDB is made up of only datafiles and tempfiles to handle its own objects which includes its own data dictionary containing information about only those objects specific to the PDB. PDBs appear to the end users as a non-CDB database. Seed PDB – A default PDB that the system uses as a template to provision other user-created PDBs. It is called PDB$SEED   Advantages of Multitenant database architecture Multitenant architecture reduces the requirement to create multiple instances. It offers the ability to have 252 PDBS per multitenant CDB. This increases hardware utilization and so reduce capital expenses. Upgrade and patching is made very simple. All underlying databases inside it (more…)
Data Migration Support

Invisible Columns in Oracle 12c

By | Oracle Tips, Technology Tips & Tricks
Invisible column is a new feature in Oracle 12c.  Invisible columns provide a convenient way to change a table’s structure without having to edit the existing applications using that table.   Invisible columns can be created at the time of table creation using CREATE TABLE command                                 SQL> create table inviscol_test                                 2  (compno number,                                 3  compname varchar(20),                                 4  compcode varchar(10) invisible);                                 Table created.   existing visible columns can be modified to invisible using ALTER TABLE command                                 SQL> alter table inviscol_test modify (compname invisible);                                 Table altered.   How does it work?   The insert statement where we don’t specify the column names will fail.                                 SQL> insert into inviscol_test values (101,'ABCD','A101');                                 insert into inviscol_test values (101,'ABCD','A101')                                 *                                 ERROR at line 1:                                 ORA-00913: too many values                                 Explicit column names should be included in the insert statement.                                 SQL>  insert into inviscol_test(compno, compname, compcode) values                                 (101,'ABCD','A101');                                 1 row created.   If invisible columns are not listed in the insert statement they are set to NULL                                 SQL>  insert into inviscol_test values (201);                                 (more…)
Oracle

Oracle 12c New Feature – Multiple Indexes On The Same Column Or Set of Columns

By | Oracle Tips, Technology Tips & Tricks | No Comments
Starting with Oracle 12c, multiple indexes on same column or same set of columns can be created, as long as only one index is visible, and the indexes are physically different. It is not possible to create two bitmap indexes on the same column or set of columns. Example: Create a table ind_test1 SQL> create table ind_test1(id number, dept  varchar(20), start_dt date); Table created. Insert rows SQL>  insert into ind_test1 values(111, 'TEST', to_date('01/01/2000','mm/dd/yyyy')); 1 row created. SQL>  insert into ind_test1 values(222, 'DEVL',  to_date('10/25/2011','mm/dd/yyyy')); 1 row created. SQL>  insert into ind_test1 values(333, 'TEST',to_date('05/22/1999','mm/dd/yyyy')); 1 row created. Select * from ind_test1 table SQL> select * from ind_test1; ID DEPT                 START_DT ---------- -------------------- --------- 111 TEST                 01-JAN-00 222 DEVL                 25-OCT-11 333 TEST                 22-MAY-99     Create the first index on start_dt column. By default, Oracle creates B-tree index. SQL>  create index idx1_ind_test1 on ind_test1(start_dt); Index created.   Now, create a second invisible index on the same column SQL> create index idx2_ind_test1 on ind_test1(start_dt) invisible; create index idx2_ind_test1 on ind_test1(start_dt) invisible * ERROR at line 1: ORA-01408: such column list already indexed   Index failed because these 2 are the same type of indexes. You can create a bitmap index on the same column. SQL>  (more…)

Dobler Consulting Recognized by Inc5000 as Top IT Services Company in Tampa Bay

By | Company News, General Announcements, What's New | No Comments
For the first time in its company history, Dobler Consulting was featured in the prestigious Inc5000 listing. The class of 2017 named 79 companies from the Tampa Bay area among the nation’s fastest growing companies. To join the ranks of Tampa Bay’s fastest growing companies on the national stage is a great honor. We know how hard it is to achieve growth and success on an accelerated path. Congratulations to our fellow neighbors and Inc5000 honorees from the Tampa Bay. The Tampa Bay Times published a prominent article and quoted; “Among the 11 IT services firms ranked here, Tampa’s 55 employee Dobler Consulting Services landed at the highest spot at No. 1002 on the Inc.5000 with a growth rate of 432 percent. Peter Dobler founded the business in 2008.” We’ve been working hard to build an organization modeled on providing critical services to companies around the globe who are in need of database management, design, support and migration. As part of our accelerated growth and dedication to supporting any database platform, we added Microsoft Gold Partner (Data) and an Oracle Gold Partner to our list of achievements. Being featured on the Inc5000 list is not just a huge honor, but (more…)
sybase recovery services

In-Memory Databases vs Intel NVMe NUMA

By | Blog, Database Technology Trends, SAP HANA, Sybase | No Comments
For the past few years, the hot topic for database vendors was the in-memory database. The general belief was and maybe still is, that server memory is getting cheaper and density will continuously improve. For the most part, this has been the case, maybe not as extreme as predicted. However, the data storage needs for databases increased at a much faster pace during the same time, which created another problem. Going beyond 1TB of memory in a single server will quickly become very expensive. A 1TB database used to be called very large. This attribute is now applied to the 5-10 TB databases servers. In-memory databases are needed where read and write performance are equally important. Traditional databases improve read performance by caching data in memory, but there is no way to improve write performance. To be ACID (Atomic, Consistent, Isolated and Durable) compliant, data must be written to persistent storage. An in-memory database achieves this by writing every transaction in parallel to a high-performance storage. In many cases this is a flash drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory (RAM) to be ACID compliant. There are many (more…)
Oracle Gold Partner

Dobler Consulting Becomes Oracle PartnerNetwork Gold Level Partner

By | Press Releases | No Comments
July 17, 2017 – Dobler Consulting Services LLC, a database services and solution company, today announced that it has achieved Gold Partner status in Oracle PartnerNetwork (OPN). By attaining Gold Level membership, Oracle has recognized Dobler Consulting for its commitment to establish Oracle related knowledge in delivering professional services to its Oracle clients and for uniquely addressing the challenges of joint customers migrating into the Oracle Cloud.   “Thanks to our recent growth, we’ve been able to diversify our services while still maintaining the highest levels of expertise,” said Peter Dobler, CEO and Founder of Dobler Consulting, LLC. “As an Oracle Gold Partner, we have created a new department which is dedicated to Oracle service delivery, focusing on cloud deployment.”   With its Gold status, Dobler Consulting receives the benefit of being able to start developing specializations that will allow them to grow their business, increase their expertise, reach higher levels of customer retention, and create differentiation in the marketplace. Gold members also become eligible to resell all Oracle Technology products and can apply to resell Oracle Applications and Industry Solutions. In addition, they receive access to Oracle account representatives and My Oracle Support updates for all products, discounts on (more…)