a bag of spanners

Doug quite rightly commented on this page and it's numerous errors, which start I should warn you with a security certificate from the wrong domain.

It doesn't get better really, it's a FAQ which addresses some issues. Included are

Q:

How do I backup my database.

A:

use exp.

Q:

How do I create a user?

A:

sqlplus '/as sysdba' <<EOF

create user ccm identified by ccm_xyz
default tablespace medium_data
temporary tablespace temp profile default
quota unlimited on medium_data;

grant connect,resource,query rewrite, ctxapp, javasyspriv to ccm;

revoke unlimited tablespace from ccm;

alter user ccm quota 2000m on medium_data;

EOF

which has the following great problems in just 4 statements.

set an unlimited quota in the script and revoke it 2 lines later in favour of a different value?

connect, resource roles being granted, together with some specifics.

Q:

How do I see what SQL query a UNIX process is running?

A:

Change the previous query to join against v$process

select s.username, s.status, q.sql_text
from v$sql q, v$session s, v$process p
where s.sql_address = q.address
and s.sql_hash_value = q.hash_value
and s.paddr = p.addr
and s.status = 'ACTIVE'
and p.spid = [UNIX process id];

which at least for me doesn't work.

SQL> select s.username, s.status, q.sql_text
from v$sql q, v$session s, v$process p
where s.sql_address = q.address
and s.sql_hash_value = q.hash_value
and s.paddr = p.addr
and s.status = 'ACTIVE'
and p.spid = [UNIX process id];
2 3 4 5 6 7 and p.spid = [UNIX process id]
*
ERROR at line 7:
ORA-00936: missing expression

but my biggest concern isn't actually the individual errors, but the list of organisations who have signed up to this garbage. They include, but are not limited to.

# Atos Origin - Web Site: http://www.atosorigin.com
# Bull - Web Site: http://www.bull.com/
# Charles University Prague - Web Site: http://nenya.ms.mff.cuni.cz/
# France Telecom R&D - Web Site: http://www.rd.francetelecom.com/
# French Ministry of Interior - Web Site: http://www.interieur.gouv.fr
# Mandriva - Web Site: http://www.mandriva.com/
# MySQL - Web Site: http://www.mysql.com
# Red Hat - Web Site: http://www.redhat.com/
# SUSE LINUX - Web Site: http://www.suse.com/
# Thales - Web Site: http://www.thalesgroup.com/
# Universidade de Fortaleza - Web Site: http://www.unifor.br/
# University College London - Web Site: http://www.cs.ucl.ac.uk/

So that would be universities, major open source suppliers and major consultancies.

The last named author of the page is "a member of the Red Hat Global Professional Services team" according to his bio.

So these are industry leading organisations who

don't know what a backup is<
don't appear to know what various roles do.
don't appear to understand autoextend.

and so on.

I'm thinking of a career change, after all all a plumber needs is a bag of spanners right?