More Oracle Blogs

I just thought I'd mention that I've added a bunch more Oracle related blogs to the list down the right hand side of the page. I recommend that you give them a read. If you know of any others I should be reading (if only I had the time to read more) then feel free to comment here.

Comments

Post a Comment

Popular posts from this blog

Preventing record deletion

This entry is partly an aide memoire for me, partly to try to get something that has been keeping me awake for the past hour or so out of my brain so I can sleep and partly in the hope that someone can suggest a way forward. A quick bit of background. Until April 06 most of our major systems were looked after by an external Faccilities Management company. In April 06 IT was kind of outsourced to a joint venture company, support of the systems transferred to that company and a couple of the DBAs transferred in as well under TUPE. A reccurring problem on one of the systems is that the users keep deleting records which, by law, they must not delete so we (actually one of the DBAs who transferred in who is responsible for that system) has to restore from backup to another machine and copy the deleted records over (she's tried using LogMiner but finds it too unwieldy). The core problem is that the application is faulty and lets the users delete the records when it shouldn't. The...
Read more

Does Oracle cache the SYSDBA password?

I was just having a play around on one of my test/sandpit databases ("small database on a low power machine that I use for testing out scripts &c, no live data and if the database gets destroyed I just have to wipe out the files and create a new one" type of thing). I'd forgotten the SYSDBA password (for sandpit systems I use the SID as the SYSDBA password so don't bother to write it down, for some reason this time I didn't) but needed it (I'm installing HTMLDB to try it out on that machine) so wanted to change it. I had been getting 1 : SQL> conn sys/sbtest@sbtest as sysdba ERROR: ORA-01017: invalid username/password; logon denied as you might expect. I used orapwd to change the password $ cp orapwsbtest orapwsbtest.20060629.bak $ orapwd file=orapwsbtest password=sbtest entries=16 OPW-00005: File with same name exists - please delete or rename $ rm orapwsbtest $ orapwd file=orapwsbtest password=sbtest entries=16 and thought I would be good to go....
Read more

Solution to Dreaded ORA-07445 error

Finally got a response from Oracle, turned out they had put it with their US office who don't start work until 13:00 our time. The eventual response was: 23-MAY-06 14:49:43 GMT DATA COLLECTED =============== On alert.log we can see some: ORA-07445: exception encountered: core dump [00000001009B0B04] [SIGSEGV] [Address not mapped to obj ect] [0x000000000] [] [] Trace file uploaded shows: /opt/oracle/app/oracle/admin/dchr/udump/dchr_ora_5662.trc Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production JServer Release 9.2.0.6.0 - Production *** SESSION ID:(37.1317) 2006-05-18 15:34:04.409 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1009b0b04, 00000001009B0B04] *** 2006-05-18 15:34:04.410 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [00000001009B0B04] [SIGSEGV] [Address not mapped to object] [0x000000000 ] [] [] Current SQL statement for this session: select all count(dm_type.r_object_id) "the_cou...
Read more