meta user
network profile
| bio | website | stackexchange.com/users/98359 |
|---|---|---|
| location | United Kingdom | |
| age | 41 | |
| visits | member for | 2 years, 3 months |
| seen | 3 hours ago | |
| stats | profile views | 61 |
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 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 20 |
comment |
Unable to recover database 1.9G doesn't sound very big; what was the value before you changed it? Did you just blindly copy the value from that article, or did you understand what it would do and actually make sure you were increasing it? And did you bounce the instance after changing it? |
|
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 |
|
Feb 8 |
awarded | Yearling |
