By Mouhamadou Diaw In this previous blog, we have installed Dbvisit standby for Windows on both servers. We suppose that the database is created and that the standby is configured (see this blog). The steps are the same that on Linux except that the command is launched on a traditional DOS terminal or a PowerShell. We will not describe these…
By Mouhamadou Diaw In a previous blog we described how to install dbvisit standby in a Linux box. In this article I am going to describe the installation on a Windows machine. We are using dbvisit 8 and windows server 2016. The name of my servers are winserver1 and winserver2. The first thing you will have to do is to…
By Franck Pachot . Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition, and you should set MAX_PDBS to prevent that. 12cR1 In 12.1 Standard Edition, when you try to create more than…
By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World: 12cR2 Single-Tenant: Multitenant Features for All Editions from Franck Pachot I’ll give the same session in French, In Geneva on November 23rd at Oracle Switzerland. Ask me if you want an…
Ausgangslage Wie gut lässt sich mit Oracle Standard Edition unter Windows eine Hochverfügbarkeitslösung aufbauen? Die Basis, zwei Windows Server 2012 R2, Oracle Standard Edition und Dbvisit Standby. Die eingesetzte Version Dbvisit Standby 7.0.48.15006. Die eingesetzte Oracle Version 12.1.0.2.0. Installation Die Windows Installation ist Standard, nur die beiden Server müssen, zwecks Namensauflösung im Hosts File(C:\Windows\System32\drivers\etc\hosts) unter Windows eingetragen werden. 192.168.198.129 node01.localdomain node01…
By Franck Pachot . From 12.1.0.2 the Standard Edition – now called Standard Edition 2 – has a few limitations that were not there in SE and SE1. One of them is the limitation to 16 threads. Let’s see how it behaves when running 32 sessions working in CPU. Installing 12.1 SE2 on a 32 CPU host. What to provision…
By Franck Pachot . A previous blog post explaining what happens for those in ‘Standard Edition One’ had a “don’t worry” in the title because you can upgrade to SE2 with minimal additional cost – except when you have to buy new NUPs – and get only small additional limitation. I didn’t made such a post for people in Standard…
By Franck Pachot . Do you think that online operations are available only on Enterprise Edition? That changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and a very important feature for performance tuning: invisible indexes. Example I’ll show it from the SCOTT schema where I’ve added…
By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 – more than one year after the release of the patchset for Enterprise Edition. It’s a new name – SE2 in short – and new rules. Let’s have a look at it. We waited for it after those rumors from July, and as expected…
By Franck Pachot . The Oracle Database Appliance is really interresting for small enterprises. It’s very good hardware for very good price. It’s capacity on demand licensing for Enteprise Edition. But small companies usually go to Standard Edition for cost reasons. Then does it make sense to propose only Enterprise Edition to the small companies that are interrested by ODA?…
By Franck Pachot . You are using an Oracle Enterprise Edition and thinking about downgrading to the Standard Edition? In this case, you must be sure that your applications are compatible. It’s not something easy to check. Here are a few ideas. Why? Why do you want to downgrade to the Standard Edition? For licensing costs, of course. Today, it…
By Franck Pachot . At dbi services, we really like Lighty for Oracle, a tool which helps exploring performance statistics whether they originate from AWR (available only in Enterprise Edition with Diagnostic Pack option) or from Statspack (available via Standard Edition). As a matter of fact, we like it so much that we have became Orachrome Partner. If you want…
