1,535 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 2 months
seen 9 hours ago

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.


Nov
18
comment User can't stop Oracle listener (TNS-01190)
Changing permissions on an Oracle-installed binary, or messing with the installation at all unless under direction from Oracle Support, isn't generally a good idea. Apart from anything else, the binary might be relinked by a patch. I was thinking more of a setuid wrapper, possibly just restricted sudo. Just out of interest, what are you changing in the listener.ora?
Nov
14
revised User can't stop Oracle listener (TNS-01190)
Added note about deprecation
Nov
14
comment User can't stop Oracle listener (TNS-01190)
@Phil - it is supported (or was, it's deprecated from 11gR2), but I originally had a comment querying why you'd want to do this, which I removed because I'd worded it unintentionally harshly. Agree that the security implications need to be given serious thought, but that's true for everything of course...
Nov
12
answered User can't stop Oracle listener (TNS-01190)
Oct
30
comment How to set an Oracle user's default schema?
Yes - e.g. with dbms_session.is_role_enabled. If applications have different roles defined, this makes it easy to change the 'default' schema for each within the same trigger, without having to maintain a separate look-up mechanism which might have to span the applications. I prefer this over synonyms, especially public ones.
Oct
30
comment How to set an Oracle user's default schema?
You can make the database logon trigger role-based as well; though I guess that is technically taken from a table at some level.
Oct
25
comment Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”
How are you accessing it - would be helpful to see the URL you're using, but are you specifying https?
Oct
17
comment Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?
Hardly definitive, but this article says 'SQL Developer has extended pldoc into DB Doc', and the pldoc documentation seems to include the elements you've already found. Seems odd though that there doesn't seem to be any reference (or credit) to pldoc, so maybe it was just inspiration rather than included; and even odder than Oracle haven't documented the functionality at all.
Oct
16
comment Tablespace and userid info
@Haglis - that sounds odd, I'm not aware of any clients that would present headings when there's no data. Anyway, I think you should ask about finding and extracting this function as a new question, including the reference you got from the user DDL and any queries you ran with their output.
Oct
15
comment Tablespace and userid info
@Haglis - select owner, object_type, object_name from dba_objects where object_type = 'FUNCTION' and lower(object_name) = 'user_function' will show if the function exists, which schema owns it, and if you're using the wrong case.
Oct
15
comment Tablespace and userid info
@Haglis - you should be able to see it like this, but maybe it's in a different schema (which you can specify with the third parameter to get_ddl)? Can you see it in dba_objects? Also check you're using the right case for the function name.
Oct
12
answered Tablespace and userid info
Sep
11
comment Would existing constraints and indexes applied to an old table, apply to a new table renamed like the old one after it's dropped?
Unless the column you're changing is vital to the indexes or something similar, I'd think about adding a new column, setting/updating that from the old one, and when you're happy swap them over with a couple of alter table ... rename column ... commands, and at some point drop the original (now renamed) column. Seems slightly less messy than doing it at table level.
Aug
29
comment Oracle 11g .DMP viewer
Do you have NLS_LANG set? How did you receive the file - it's a binary format so it it possible it's been corrupted by an ASCI FTP or similar? Does running imp with show=y give you anything?
Jul
24
comment Stuck with Oracle 9i
Why are you learning on 9i - why not something slightly more modern, or at least supported?
Jul
20
answered Is it possible to do a datapump import with a different user than did the export?
Jul
20
revised Is it possible to do a datapump import with a different user than did the export?
Formatting
Jul
20
suggested suggested edit on Is it possible to do a datapump import with a different user than did the export?
Jul
20
comment Is it possible to do a datapump import with a different user than did the export?
Does the DUMP_DIR exist? Is it writable by the user you're running the impdp as? Does the log file already exist, and can you specify a different one on the command line?
Jul
13
comment steps for creating a domain in web logic server 10.3.5
What has Forms got to do with WebLogic Server?