Technical Articles
Technical Oracle Articles
Submitted by fredrikfilipsson on Tue, 2022-06-28 08:12
Four Oracle Database License Models.
When choosing an Oracle database license, you should consider the following aspects:
End customer license:
1. Full use license - Normally no restrictions simply follow the license terms and Oracle licensing rules and policies.
Submitted by fredrikfilipsson on Mon, 2022-06-20 18:04
What You Need to Know About Oracle Licensing in Azure
There are a few things you need to know about Oracle licensing in Azure. For example, licensing for HyperThreading is not the same as for CPUs. Oracle licenses software by the number of processors it runs, and that includes virtual CPUs. It is also important to note that Oracle hasn't yet adopted standard rules for virtual CPUs. Oracle's licensing in the cloud applies special Cloud rules, which might make the process more difficult.
Submitted by fredrikfilipsson on Wed, 2022-05-04 04:15
Oracle ULA - Strategies for IT professionals
Oracles unlimited license agreement has a mixed reputation in the market, and I will try to explain why
but also the benefits, drawbacks of the agreement. Then a suggested plan for how to manage the ULA
renewal or when you want to exit the agreement.
What is Oracle ULA?
Submitted by fredrikfilipsson on Wed, 2022-04-06 14:54
Oracle license audits can cost companies millions in avoidable license fees.
Why do I wrote avoidable? - Because in my experience (300+ Oracle license audits)
90% of all out of compliance findings in Oracle license audit reports are
not due to over-usage but simply
a) Misunderstanding Oracle licensing rules
b) Misinterpreting Oracle licensing policies such as virtualization.
How should you "win" an Oracle license audit?
Submitted by John Watson on Mon, 2021-07-05 07:29
ORDS version 21 was released in May, I had it tested and rolled it out in June. But once live, a problem popped up: numerous executions of this statement,
SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'APEX_RELEASE' AND TABLE_NAME = 'APEX_RELEASE';
Submitted by John Watson on Tue, 2018-01-23 11:11
Do you know about multiple domain certificates? If not you may have to learn quickly, because Oracle has changed the way they are handled in release 12.2. This is going to break a lot of applications.
Submitted by trantuananh24hg on Sun, 2016-10-16 23:24
1. Platform
- Msocial: Sparc Solaris 10
- STS_VMWare: x86_64 Solaris platform
2. Utility: RMAN
3. Task list details
3.1. On Source (MSocial)
3.1.1. Create test user schema & generate data in
sys@MSOCIAL> create user msocialtest identified by msocial
2 default tablespace users
3 temporary tablespace temp
4 quota unlimited on users
5 /
User created.
sys@MSOCIAL> grant connect, resource, create session, dba to msocialtest;
Grant succeeded.
Submitted by trantuananh24hg on Wed, 2016-08-24 21:56
AIX is like an Unix environment awesome original, same to HP-Unix, and, if you have a plan to install Oracle RAC, you need to pay attention. I note some tips in this article to help.
1. Checking Operating System Packages
# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte \
xlC.aix61.rte
If not, install on AIX source by smity. It's easy, but remember, some packaged requires your IBM's account to download.
Submitted by trantuananh24hg on Tue, 2016-08-23 04:34
In previous article, I described the task list of configuration software raid on Solaris. And here, I brief the task list of configuration hardware raid on Sun Sparc model T.
Ofcoruse, the first step is connection to the server with serial console cable, assume the new server.
Remember:
data bit = 8
baud rate = 9600
Recommend tool: Sercure CRT, Putty.
Submitted by trantuananh24hg on Tue, 2016-08-23 04:02
I worked on Unix many years ago, however, Solaris, AIX and HP-Unix are the platforms I often did with. I'm DBA, but there are not any System Administrator in my company, and I .. do the System's business at all.
Before ZFS becomes popular, UFS was always the best choice for Solaris, especially in M's series, example: Sun M-3000, M-4000, M-5000 ...etc. The M series does not support Hardware Raid, but only software, and this article do the brief of creating the software raid in. It's one of task list before configuration and installation Oracle in Solaris 10.
Pages
|