14,133 reputation
12350
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 3 years
seen 1 hour ago

Oracle DBA, Unix admin.

Available for employment! ;)


Jan
20
comment Oracleasm deletedisk failed Unable to clear disk
I'd be tempted to ask Oracle support about this - could cause trouble down the line
Jan
20
comment load_file() doesn't work but load data local infile works
Oh, right. I guess it won't work if it tries any kind of seeking....
Jan
20
comment load_file() doesn't work but load data local infile works
What is a non-regular file? Minority?
Jan
17
comment ORA-03137: TTC protocol internal error
@kupa you have some patching to do then....
Jan
17
comment ORA-03137: TTC protocol internal error
What specific patch are you on? There are bugs that are fixed in later patchsets
Jan
16
comment How can I set a field when original lookup is NULL or isn't in the list?
Use an outer join
Jan
16
comment Please suggest my.cnf configuration based upon mysqltuner findings
How much memory does the host box have?
Jan
16
comment ADD Column ON UPDATE TIMESTAMP
It's annoying :/ Though whacking the version number after Oracle is usually ok...
Jan
16
comment ASM drop disk hangs (STATE DROPPING)
You're supposed to do "oracleasm scandisks" on the 2nd node, not recreate. Also, your disk string doesn't look right. Shouldn't it be something like '/dev/oracleasm/disks/*' ?
Jan
15
comment Recovering Oracle Database using RMAN
Unix or Windows? Do you have any experience with Oracle? Is it a disaster recovery scenario with a backup and a new server or is everything already there on the server? Talk us through the situation....
Jan
14
comment Select query to retrieve values even if are null
Which RDBMS are you using?
Jan
14
comment Select query to retrieve values even if are null
Oracle has NVL()
Jan
13
comment Oracle Transaction recovery: lock conflict caught and ignored
@kupa it's a known bug then. Patch your databases! Search Metalink and you'll find the relevant article
Jan
12
comment How to determine if an Oracle table is locked or not?
@Selahattin Are you talking about an application level lock? Oracle does not generally perform table locking due to its serialisation level and design
Jan
10
comment How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
Never ever EVER use SYS for this type of thing. Create another user and give it the privs it needs.
Jan
10
comment Is Oracle's dbms_utility.get_hash_value algorithm documented do reverse engineered anywhere?
I can't find anything that says it's anything other than proprietary ...
Jan
10
comment Oracle Transaction recovery: lock conflict caught and ignored
What version? There are bugs relating to this
Jan
10
comment Database creation fails with ORA-12560
Go through the Oracle for Solaris install doc and double check you've met all of the prerequisites: docs.oracle.com/cd/E11882_01/install.112/e24346/pre_install.htm - pay particular attention to the kernel params, shell limits and required packages. Go through the entire thing from the start carefully, you may have missed something (assuming you read it in the first place)
Jan
10
comment Database creation fails with ORA-12560
What's in the DBCA log and the alert log of the partially created database? Have you previously successfully created a database on this machine?
Jan
9
comment Making data from one schema available to another schema
Good job @JustinCave. +1 for your answer