Oracle RU is available

Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches.

To be up to date read the following My Oracle Support Doc-ID’s

Actually I can’t find a FAQ but I think this will come in a few weeks.

Stay tuned :-)

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit , , | Kommentar hinterlassen

Oracle ACE

Vor zwei Jahren als Oracle ACE Associate gestartet, wurde ich nun zum Oracle ACE „befördert“.  Vielen Dank

Two years ago I started as Oracle ACE Associate and now I was „promoted“ to the Oracle ACE status. Many Thanks

 

 

 

 

 

 

Veröffentlicht unter General | Verschlagwortet mit , | Kommentar hinterlassen

Oracle RAC 12.1 Summary Deployment and Admin

If you need a good overview and introduction in Oracle 12.1 RAC take a look to the following document.

RAC-12.1-Deployment-Admin

 

 

 

 

 

Veröffentlicht unter Oracle 12.1 | Verschlagwortet mit , | Kommentar hinterlassen

How to fix ‚PLAN_TABLE‘ is old version

During a lot of SQL Performance activities I saw all the time the following message but why?


Note
-----
- 'PLAN_TABLE' is old version

Yes, I did a few days before an Upgrade from 11.2.0.4 -> 12.1.0.2. Now I start to check out some important SQL Queries but I the „old version“ message


sqlplus

set autotrace traceonly explain

select * from dual;

and again

Note ------

'PLAN_TABLE' is old version

Problem is that this message came up while the plan_table came from the previous version in my case 11.2.0.4. So the solution for this is very easy


In the new environment here 12.1.0.2
SQL> connect sys as sysdba

SQL> drop table plan_table$;

SQL> @?/rdbms/admin/catplan

This shoud fix the problem and if not?

Okay it could be possible that you should drop the plan_table as Schema User  and then run the the SQL again.

 


Here an example output:
Note
-----
- dynamic statistics used: dynamic sampling (level=2)
- automatic DOP: Computed Degree of Parallelism is 8 because of degree limit
- parallel scans affinitized for buffer cache


 

 

 

Veröffentlicht unter General, Oracle 12.1 | Verschlagwortet mit , | Kommentar hinterlassen

40 Years of Oracle Database Innovation

Happy birthday Oracle :-)

 

Veröffentlicht unter Oracle Database | Kommentar hinterlassen

rman auxiliary (for duplicate)

I just do some tests with the Oracle 12.2 Release and while doing tests it is all the time better to have a second database and that is the time for rman. So I looked around and found an easy way to duplicate a database from a Backup. Here the details:

My environment

OL 7.3 with an Oracle 12.2 + DATABASE BUNDLE PATCH: 12.2.0.1.170516 (25862693)

I setup an database via dbca and use Standards including the fast recovery area. Oh yes the FRA is a standard now

Next I did a backup and here I did a few tests with image copied and „backup as copy database“. While doing this I had a full backup on disk and that is the point to start with the duplicate.

What are the steps?

First I created a initdb2.dup

Yes, for testing I create only one controlfile
initdb2.dup
*.audit_file_dest='/u01/app/oracle/admin/db2_s1/adump'
*.audit_trail='NONE'
*.db_name='db2'
*.db_unique_name='db2_s1'
*.control_files='/u01/app/oracle/fast_recovery_area/db2_s1.ctl'
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_recovery_file_dest_size=8G
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.enable_pluggable_database=true
*.large_pool_size=256M
*.sga_target=2G

Next I created a few directories and then I started the new instance


sqlplus / as sysdba

startup nomount pfile=/u01/app/oracle/admin/db2/pfile/initd2.dup'

finally I start the duplicate from „BACKUP LOCATION“

 



rman auxiliary /

RMAN>duplicate database to db2 backup location '/u01/app/oracle/fast_recovery_area';

 

That’s it finished :-)

Keep in mind that I set my environment before starting the rman duplicate and the connection is done against the auxiliary instance. Yes, it is very easy to do a duplicate to a new database when you have a full backup on disc.

 

 

 

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit , | Kommentar hinterlassen

Oracle Engineered Systems Production

I found a old video concerning the „real“ production of an Oracle Engineered System but it’s really good and cool stuff.

https://vimeo.com/46778003

Have fun

 

Veröffentlicht unter Engineered Systems, Exadata, General | Kommentar hinterlassen

neue DOAG Webseite ist online

Die neue DOAG Webseite ist Online.

https://www.doag.org/de/home/

 

 

Veröffentlicht unter General | Kommentar hinterlassen

Let’s start with Oracle Database 12c Release 2

bildschirmfoto-2017-03-02-um-13-40-33

Yes and now Oracle 12.2 is available (Linux x86_64) for download from OTN.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html

Let’s start with Installation and Setup ….

 

 

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit | Kommentar hinterlassen

Oracle DBSAT first experience

dbsat_chart

Last year in October Oracle released the Oracle Database Security Assessment Tool (DBSAT) to analyzes database configurations and security policies to improve the security in your environment.

Real benefits

  • quickly identify security configuration errors in the database environment
  • lauch Security best practices
  • increase the security level of your Oracle Databases
  • reduce the attack and exposure risk

What does DBSAT check

  • User Accounts, Privileges and Roles
  • Authorization Control
  • Data Encryption
  • Fine-grained Access Control
  • Auditing Policies
  • Database Configuration
  • Listener Configuration
  • Operating System*

Installation and Requirements

DBSAT runs on
Solaris x64 and Solaris SPARC
Linux x86-64
Windows x64
HP-UX IA (64-bit)
IBM AIX & zSeries Based Linux

Supported Database Versions
on Oracle Database 10.2.0.5 and later releases.

Download DBSAT
Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

Installation and Setup

create directory on the target System
mkdir -p /home/oracle/dbsat

unzip dbsat.zip
unzip dbsat.zip -d /home/oracle/dbsat

cd /home/oracle/dbsat

Run the Collector

Set your Oracle environment

./dbsat collect „sys/manager as sysdba“ orcl

DBSAT Collector completed successfully.

Calling /u01/app/oracle/product/12.1.0/dbhome_1/bin/zip to encrypt orcl.json…

Enter password:

Verify password:

  adding: orcl.json (deflated 87%)

zip completed successfully

The .json file was created and is the base of the report

Create the report

./dbsat report orcl

Archive: orcl.zip
[orcl.zip] orcl.json password:
inflating: orcl.json
Database Security Assessment Tool version 1.0.2 (October 2016)
DBSAT Reporter ran successfully.

Calling /usr/bin/zip to encrypt the generated reports…

Enter password:
Verify password:
adding: orcl.txt (deflated 76%)
adding: orcl.html (deflated 82%)
adding: orcl.xlsx (deflated 3%)
zip completed successfully.

-rw——-. 1 oracle oracle 63075 Feb 1 22:22 orcl_report.zip

Transfer the files to your local PC

Here an example  I converted the XLS File as PDF

orcl

Start reviewing the security report and fix the critical findings

Summary

  • easy and fast setup
  • really good reports in  different layout (html, csv, etc.)
  • fix real security issues
  • no extra costs if you have a support contract
  • findings are highlighted (green, red, yellow, blue)

Note

While running dbsat in a 12c Multitenant environment you must create the report on every PDB, otherwise you will get only a report from the CDB

Try it and have fun :-)

 

 

 

Veröffentlicht unter General | Verschlagwortet mit | 1 Kommentar