I found this hilarious
SQL> startup ORACLE instance started. Total System Global Area 1469792256 bytes Fixed Size 2402776 bytes Variable Size 536872488 bytes Database Buffers 922746880 bytes Redo Buffers 7770112 bytes Database mounted. ORA-19821: an intentionally corrupt log file was found
Really ? I intentionally corrupted my log file ? I dont think so !
Another big public username and password leak…
Some good reading on how it was done, and thus ensuring your code isn’t prone to SQL injection here:
Once you get into pluggable database territory, you might need to check your usage of "alter system enable restricted session", because unless you’ve patched, there’s a little bug which lets you enable restricted session, but wont let you get out of it ! :-)
SQL> alter session set container = pdb12; Session altered. SQL> alter system enable restricted session; System altered. SQL> select logins from v$instance; LOGINS ---------- RESTRICTED SQL> alter system disable restricted session; alter system disable restricted session * ERROR at line 1: ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
You can get out of the predicament, by force opening the pluggable database as shown below, but probably best to look at the latest 12c PSU, which contains a fix (unverified)
I had the pleasure of being a guest of the Norwegian User Group for the second year in a row on their famous cruise conference at the start of April. For a relatively ‘small’ conference (around 300-400 people), the array of quality speakers the group manage to get is always astounding. Martin Nash, Cary Millsap, Tim Hall, Bryn Llewellyn, Martin Bach, Jeff Smith, Doug Burns to name just a few. I gave a few talks which (seemed :-)) to be well received by the audience.
The conference runs like clockwork, and Oslo is a beautiful city to spend a day wandering around sampling the cuisine. The only real challenge is the 45min timeslot for papers, whereas as most places I’ve spoken at allow 50-60 mins, so you’re presented with the tough choice of cramming your existing content into 45 mins, or deciding what must be pared out.
Here’s a pet peeve of mine: Customers who don’t read the error messages. The usual symptom is a belief that there is just on error: “Doesn’t work”, and that all forms of “doesn’t work” are the same. So if you tried something, got an error, your changed something and you are still getting an error, nothing changed.
I hope everyone who reads this blog understand why this behavior makes any troubleshooting nearly impossible. So I won’t bother to explain why I find this so annoying and so self defeating. Instead, I’ll explain what can we, as developers, can do to improve the situation a bit. (OMG, did I just refer to myself as a developer? I do write code that is then used by customers, so I may as well take responsibility for it)
Here’s what I see as main reasons people don’t read error messages:
Rose-Marie Davidson, 87, passed away Monday, March 31, 2014 at Manatee Memorial Hospital in Bradenton, FL. She was born April 30, 1926 in New Rochelle, NY, the daughter of Ernest H. and Rose (Bormann) Vogel. She grew up in Larchmont, NY, Fairfield, CT and Fort Wayne, IN, where she graduated from South Side High School. She attended Indiana University and was a member of Alpha Chi sorority. She received her BFA from Cranbrook Academy of Art in Bloomfield Hills, MI.
At Cranbrook she met her future husband, Robert Edwin Davidson, and they were married December 20, 1947. Robert’s career as a painter and art professor took them to Oregon, Canada, western New York and Mexico, and they raised four children along the way. In 1975 they moved to Redington Beach, FL, so that Rose-Marie could care for her elderly mother. After her husband’s death in 2000, Rose-Marie lived in Madeira Beach and Seminole before moving to her son’s home in Palmetto in 2006.