After a nice Lower Cost talk by Mark Townsend and the new Sun Oracle Exadata and Database Machine by Chris Baker, I attended ‘Upgrade to 11g – Best Practices’ by Mike Dietrich, ‘Consolidate on Low-Cost Server and Storage Grids’ by John Abrahams, ‘Oracle’s Maximum Availability Architecture’ also by John Abrahams & Lucas Jellema, CTO AMIS and ‘DBA 2.0’ by Ed Bangma.
It was nice to see our Whitehorses logo in the main presentation at the Oracle Netherlands 25 years sheet!
More on Oracle ASM Cluster File Management, Dynamic Volume Manager, RAC One Node, Grid Plug ‘n Play, Server Pools, Cluster Health Monitor and Electronic Sudoku Devices… Continue reading
Last week I created a new database (Oracle 9.2) and got the following message when the ‘create database’ script was almost finished: ORA-01991: invalid password file.
OK, the database instance existed before, so I created a new password file with orapwd. Trying to open the database after this gave me the following message: ORA-01403: no data found. Continue reading
When getting the following message using JInitiator: “Unable to verify the certificate – code will be treated as unsigned.”, please check “Control Panel > JInitiator > Cache”, to which location Java will store the ‘Oracle Jar Cache’ and JInitiator settings (like the ‘Grant Always’ setting and ‘Oracle Jar Cache’ directory) in <USERHOME>\.jinit\properties<jinit version> and jpicerts<jinit version>.
Java will get the USERHOME path from the Windows registry [HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders\Desktop] when looking for the Desktop path setting and truncates the ‘Desktop’ part. Most of the time this will result in the correct USERHOME directory, but when this setting is changed to a network path where users are not granted write access, Java is not able to store the Cache and JInitiator settings.
Ofcourse, this can be one of a few problems, but if you suspect a case like this, there might be a solution… Continue reading
Yesterday I had my first experience with Oracle DUL.
A customer had major disk damages on his RAID 5 system, but the backups he made daily were (sadly) never tested (lesson!). Recovery gave lots off errors on UNDO segments in the system table space. Only a 10 months old export was available.
Together with a consultant from Oracle we tried to get data from two damaged databases. For one DB, DUL could read the dictionary from the system data file, but could not read all the data from the user data files. The other DB also had a corrupt system data file, which meant that DUL was unable to read the dictionary and was unable to locate data from user data files. Continue reading
When you play a movie on some sort of multimedia system, it shows you the time remaining or some progress bar, but why not show you the real end time?!
“When you play this movie now, it will be finished at 23:15.”
Did you notice that when you install Windows Desktop Search, it replaces the Search Companion in the Windows Explorer? Probably you did…
If you want to change this back, for whatever reason, change the following registry entries:
Just for you:
[HKCU\Software\Microsoft\Windows Desktop Search\DS]
For all users:
[HKLM\SOFTWARE\Microsoft\Windows Desktop Search\DS]
Ever had the “wrong authentication protocol” error when using Xming and xhost+ still did not work?
When you are on a private network, you can try using the “-ac” option when starting Xming. Use this only on private trusted networks, because it gives access to everyone.
For mote information on Access Control in Xming and X-Forwarding with PuTTY and SSH, check the Xming troubleshoot guide.
Using updates with joins is something that does not work the first time. I’ve been using Oracle, MSSQL and other DB’s before I became Oracle DBA and I always had to check resources to get it done. Now I add an other resource….
Yesterday I had a developer at my desk who accidentally dropped a few tables. Time for the Recycle Bin thingy!
Today the Agent Configuration Assistant (Agent on 64bit Windows Server 2003, Grid Control on 32bit Windows XP) failed in running the last optional step. It hang for a long time, too long (a hour or so). After canceling this last step, checking the [configToolFailedCommands] showed the [oracle.sysman.emcp.agent.AgentPlugIn] was messing up the set-up.