1,600 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 5 months
seen yesterday

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.


Apr
15
comment How to check if Oracle DB process is running in Unix and where Oracle DB is installed
The ps commands would only tell you if a database was running, it wouldn't tell you if the software was installed if a DB wasn't up. You can investigate the locate or find commands to search for common files, e.g. sqlplus, but you're probably better off just asking the DBA for the settings to use.
Apr
9
comment Oracle schema import is not importing all the tables present in the schema dump file
Showing the export and import logs might be helpful, or at least edited versions excluding the tables that did transfer; that will at least confirm the tables were exported and if so might indicate why they didn't import. You might also want to consider using data pump rather than the old exp/imp utilities.
Mar
27
comment SYSDBA password in Oracle DB
@user2065083 - they're stored within the DB, the exact location depends on version; but they're stored hashed (of course) so you're not going to be able to get the actual passwords in plaintext (without a lot of time and effort anyway).
Mar
27
comment Oracle insert through dblink performance issue
As far as I can tell from some testing, driving_site is ignored by the insert anyway. MOS note 825677.1 suggests this too: 'a distributed DML statement must execute on the database where the DML target resides. The DRIVING_SITE hint cannot override this', as does not-a-bug 5517609. So, worth investigating, but doesn't work *8-)
Mar
27
comment Oracle insert through dblink performance issue
@andreybavt - it depends which table you give as an argument. If you did insert /*+ driving_site(MARS_SUPERVISORS_PUB) */ ... then yes, it would push it all to the remote side. If you gave it the local table (or one of the aliases in this case) then it might keep it local. That's if it does anything in this case, and if the aliases form the subquery are meaningful to the insert...
Mar
27
answered ORA-01435: user does not exist
Mar
27
comment Oracle insert through dblink performance issue
You could see if the driving_site hint affects the plan; I'm not sure on insert...
Mar
27
answered SYSDBA password in Oracle DB
Mar
11
awarded  Revival
Feb
28
comment Root cause for Invalid arguments in call (ORA-17068)
Large object - An Oracle data type designed to hold large amounts of data. Doesn't appear obviously relevant here.
Feb
28
comment Root cause for Invalid arguments in call (ORA-17068)
Please add things like that to the question, not as comments. Which JDBC driver version are you using? The only reference I can see to ORA-17068 on MOS is a JDBC error, but that is LOB related; still, making sure you're on the latest 11gR2 driver might make it go away. Phil's right though, you should really ask Oracle, or at least ask the DBAs to check the logs if you can't.
Feb
20
revised Oracle create user with privileges to grant references
Added least-privilege stuff.
Feb
20
comment Root cause for Invalid arguments in call (ORA-17068)
Are you sure it's coming from a connection being established? Might be helpful to show the stack trace and the code that identifies?
Feb
20
answered Oracle create user with privileges to grant references
Feb
8
awarded  Yearling
Dec
19
comment More than 4000 chars gives string literal too long error on oracle
The string literal you're passing as an argument is still too long; your call is in an SQL context, not PL/SQL, so it's limited to 4000 rather than 32767 charecters.
Dec
19
comment More than 4000 chars gives string literal too long error on oracle
Yes, but are you trying to pass more than 4000 chars as a string as the argument to the procedure call, or are you passing in a CLOB, or something else? Can you add the call to the question?
Dec
19
comment More than 4000 chars gives string literal too long error on oracle
How are you passing the value to the procedure? Are you sure it's the procedure that's failing, rather than the way you're calling it?
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