1,535 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 2 months
seen 2 days 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
awarded  Necromancer
Oct
12
comment oracle sqlplus as sysdba startup error
How much memory is already allocated to the other three instances? How much is free? And what are the memory settings for the instance you're trying to start?
Oct
3
comment How do I debug an Oracle Linux Diskspace Issue?
OK, you don't have a /oradata partition, so it's trying to put it under /, which only has 2.6G free. You can check which partition you're working with and it's size with df -h /oradata/orcl/pdborcl. You could create the file somewhere under /home, or increase the size of /, or add a new partition.
Oct
3
comment How do I debug an Oracle Linux Diskspace Issue?
Where are you trying to create the file? Only /home has enough space? It might be helpful to show the exact command you're issuing and the error you get. (The Oracle tag is for database questions, not for other Oralce products; this is the wrong site for this question anyway).
Sep
24
awarded  Nice Answer
Sep
18
answered Is Oracle free to download?
Jul
30
comment ORA-03113: end-of-file on communication channel Can not connect
Is your D: drive mounted? Does the directory path to the online log files exist? Do the online log files exist?
Jul
22
comment Unable to connect oracle as sysdba tables have been dropped
It looks like your instance is being terminated when you open it; you perform flashback database when it's only mounted (see the previous doc link). That might save you, or still might not work. Sounds like you have exports of specific schemas, which is not the same as a backup. If that is all you have, and flashback doesn't work, then I think your only option may be to recreate the database and all the schemas.
Jul
22
comment Unable to connect oracle as sysdba tables have been dropped
You might be able to flashback database to before the drop script ran, but I suspect there might be be too much damage. You have a backup though, right?
Jul
8
comment sql query - table@string meaning
Not sure why this is being marked as off-topic. Managing database links can be a DBA taks, but knowing what they are and how to use them is a programming topic. (This isn't PL/SQL-specific though, DB links are used in plain Oracle SQL too).
Jul
8
answered sql query - table@string meaning
Jun
25
comment sqlplus consuming 99% CPU
OK, I'm way off base then. Kind of missed that it was client only, and it's happening too early to be at the server end. Sorry, and good luck...
Jun
25
comment sqlplus consuming 99% CPU
So it's spinning rather than hanging, from the 99.2% CPU. How many processes are running under the oracle ID, on both boxes? Can you see the ulimit for nproc?
Jun
25
comment sqlplus consuming 99% CPU
Do you have a lot of idle/stuck processes - you could get this effect if you're hitting the nproc limit; or more likely if oracle is hitting it, since you can run other commands as user. Can you log in as oracle and run (any) processes, and is anything reported in the Oracle logs? (If that doesn't highlight anything, is sqlplus aliased, or a function; what does whence -v sqlplus show? What does ps show while it's hanging?)
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?