1,635 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 6 months
seen Aug 19 at 22:12

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.


Jun
16
comment What happens when we create index
The Oracle documentation explains how indexes work and are stored.
Jun
7
comment Oracle remove and place (re-install) database on 10g
... as long as you're really sure you have a good and complete dump of everything you'll need. You'd also need to recreate the user with all its non-table privileges before running the import. You should look at datapump expdp/impdp rather than the older exp/imp though, since you're on 10g.
Apr
30
comment Why Oracle Database trigger can became DISABLED
@evgenyl - well, I said it was very unlikely, but easy to rule out 8-). Happening on several instances still sounds like a security sweep is possible to me; might be done remotely so not necessarily something installed on the DB. But probably only the client can figure that out, at least until you get the trigger audit records back. I would think the DBAs would at least be aware of that happening though, so maybe not.
Apr
30
comment Why Oracle Database trigger can became DISABLED
Is it shown as disabled in dba_triggers, or just doesn't fire? It sounds extremely unlikely but there is a hidden init parameter, _system_trig_enabled, which could stop it firing, but it would have other effects that you or the DBAs ought to be aware of. Much more likely that someone is doing it deliberately, as APC says. One possibility is that the client has a security audit tool that doesn't like it and is disabling it automatically, but then that ought to be logged somewhere; just a wild guess...
Apr
17
comment Exporting and importing a database
Host credentials are for an operating system account (e.g. oracle). SYS is a database account and has to be connected AS SYSDBA (not as 'normal' in the drop-down role when you log in to EM). The message doesn't seem to tally with what you say you're doing?
Apr
16
comment How to disable oracle's MAX_ENABLED_ROLES limit
The 10gR2 docs you linked to say it is deprecated too. But the 11g docs also have this, which suggests it isn't really deprecated, as OS_ROLES isn't. Maybe the answer is to set OS_ROLES=FALSE?
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