At the moment I am trying to travel to Edinburgh for a week of Exadata Prove of Concept.
The basic idea was to leave Vienna on sunday evening and arrive in Edinburgh on sunday night.
As I tried to do an online checkin on Saturday evening - I discovered the flights where shifted to monday evening. - That was not my initial plan as one day missing on a 5 days PoC is not so (more...)
Oracle Databases has a powerful set of grants and permissions. One of the easy philosophies behind it is just to hide anything a user is not allowed to see. Technically this leads to an error message
ORA-00942: table or view does not exist
More precisely it should give a text like
table or view does not exist or you are not allowed to access it
For an ordinary user/schema separation there might be no big difference: If user A
can not read table B.TAB
it's of no value for user A
whether the object does not exist or is just not (more...)
In this post I try to show what's going on if a local listener dies in a 11gR2 RAC environment. My basic question is: When does (a) SCAN-Listener
knows the local Listener disappeared?
My testcase (a sandbox):
In the Oracle DBA World at the moment CVE-2012-1675
is a great issue. Oracle announced some methods
how to secure existing systems. But these are sometimes not that easy, and there is no backport for older systems.
As I investigated the problem how to secure a connection manager
I was hinted at Note:1455068.1
The solution is somewhat easy: Only allow incoming connections to your
systems. e.g. (rule=(src=*)(dst=10.220.8.114)(srv=*)(act=accept))
In a well designed environment where you can separate your DB Servers from others at low network layers, a set of CMAN (more...)