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.


Jan
6
comment Oracle partition by interval using persian calendar
Well, it's a month, not 30 days; but the point is that it's always using the Gregorian equivalent of the Persian date in the P0 partition to calculate the intervals for future partitions. So the automatic interval partitions don't align with the Persian calendar.
Jan
2
comment How to rollback last executed sql script fired as sysdba
@user3154598 - Second David's comment about being extremely careful about what you drop or change when trying to undo this; you don't want to end up in this situation by dropping something crucial, and pretty much everything owned by SYS is crucial. If you are not the DBA I suggest you get advice and sign-off from them before doing anything else.
Jan
2
answered web interface port for oracle 11g
Jan
2
comment web interface port for oracle 11g
Is the first dbcontrol instance still port 1158 by default? I can't remember how to check that off-hand... apart from stopping and starting it from the command line, which I think displays the URL.
Dec
27
comment why archived log size is small but fast recovery area still has a lot free space
How much space do you have in the filesystem(s) where your online redo logs live? It's complaining about where it wants to restore the file, not where it's archived.
Dec
17
comment Oracle installation fails due to ORA-00443
Is there an alert log, or any trace files for the failing processes?
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?)