I have recently taken over our Systems Management team and we have several vacancies for people used to working with the HP toolset. I know my blog is read almost entirely by DBAs but I am sure some of you work with Systems management teams and hopefully you can pass a link on to anyone you think might be interested.
The main tools used are
- HP Service manager 9.x
- HP Operations manager for Windows, (more...)
My team has a permanent vacancy which almost anyone could apply for.
We are looking for a good DBA with RAC, RMAN and Dataguard skills
We are thinking that we might wish to take on a Junior DBA who has some skills but maybe not all three listed above.
We would also consider someone who has no real experience – maybe has used RDBMS at University
Whoever we take-on will get a broad experience of (more...)
There is a standard for SQL code known as ANSI-92 which is adopted by many of the main RDBMS vendors. However each vendor has its own differences from the standard.
Oracle are currently taking votes on a proposal to add the CREATE ASSERTION statement to Oracle SQL on the OTN community page https://community.oracle.com/ideas/13028
Here are two examples of how the statement could be used
This SQL statement creates an assertion to demand that (more...)
This isn’t directly Oracle related but it did come to light within an Oracle context
We had a problem with a password file in a RAC cluster and whilst they appeared to be the same on both nodes of a cluster there were issues. I knew we needed to check the size of the files and ensure they were the same but I could not remember the (l)Unix command.
I knew it was to do (more...)
Security asked to determine when certain passwords were last changed and I used the ptime column in user$ table to find out.
set lines 120 set pages 60
col name form a30
col Last_Changed form a12
SELECT name,ptime "Last_Changed"
FROM sys.user$ a, dba_users b
order by 1;
I am sure every DBA has used a kill session script before, although a lot probably use OEM as much now as individual scripts.
However I had not realised there was an option to add a 3rd parameter, the instance _id to the command
For example to kill any DBSNMP connections across all nodes of a RAC database
select 'alter system kill session ''' || sid || ', ' || serial# || ', @' || (more...)
After upgrading to SQL Developer 22.214.171.124 a number of users noticed that some connections in the left hand pane were greyed out. I had the same experience for myself. There did not seem to be any pattern as to why specific connections were chosen and not others. Once greyed out they remained greyed out permanently – the selection did not change
I have not been able to find out an answer as (more...)
My colleague John Evans sits next to me and after hearing another grumble encountered while using the 12c OEM AWR Repository I asked him to write-up some of the issues he had come across and their fixes / workarounds. It does appear to me that the idea is fantastic but it is not been given sufficient exposure to sites that would be wanting to put a lot of data into it from various sources (more...)
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 210,000 times in 2015. If it were an exhibit at the Louvre Museum, it would take about 9 days for that many people to see it.
Click here to see the complete report.
I have looked at the ORAchk tool before and thought that I must do something with it and I have now had a more detailed review of what it offers.
Firstly the history, it started off as RACchk and then morphed into ORAchk with a sibling called EXAchk. The recent release version is 126.96.36.199.5 which is available for MoS Doc_Id 1268927.2
It can perform an ever-growing list of checks against (more...)