Technical Articles

Technical Oracle Articles

Oracle licensing in Azure

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.

Oracle ULA and how they can help you

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?

Oracle license audit - 3 steps for how to win

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?

ORDS 21.x make sure you have the latest

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';

12.2 upgrade - it can break all your outgoing https calls

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.

Transport Tablespace Testing from Msocial (Sparc) to STS VMWare (x86_64)

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.

Tips to install Oracle 11gr2 RAC on AIX (6.1/7.1)

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.

Create RAID hardware on Sun Sparc T5-2

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.

Solaris 10 - Create software RAID 1

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.

Some tips on installation Oracle 11gr2 on RHEL6

There are some tips when I finished the installation Oracle 11gr2 on RHEL6.
Full documents exits in Oracle documents library, so you can read them first

1. Install the requirement pacakges

[root@spsdev ~]#yum install local compat-libstdc++-33*
[root@spsdev ~]#yum install local libaio-devel-0.*
[root@spsdev ~]#yum install local pdksh-5.*
[root@spsdev ~]#yum install local unixODBC-devel-2.*
[root@spsdev ~]#yum install local sysstat-7.*

Pages

Subscribe to RSS - Technical Articles