1,535 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 2 months
seen Apr 17 at 16:39

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
2
comment Oracle RAC not starting up after reboot of system
Maybe you should put the details of what you found and did as an answer? Not sure I can useful convert my vague hints into anything coherent or helpful to future visitors...
Apr
2
comment Oracle RAC not starting up after reboot of system
And it shows free space now? It sounds like it think's it's full. How did you delete the archived logs? Are there any other full mount points?
Apr
2
comment Oracle RAC not starting up after reboot of system
OK, so is your resized archive destination mounted, and is it still owned by the Oracle user?
Apr
2
comment Oracle RAC not starting up after reboot of system
What is in the alert log, particularly at the point you get the ORA-03113? Why was a hard reboot necessary?
Mar
18
revised maximum number of interval partitions in Oracle 11g
Added note about maximum value
Mar
18
comment maximum number of interval partitions in Oracle 11g
Isn't your interval(1) clause the deciding factor here, once the fixed range partitions have been counted? The legal intervals are determined by that combination, even if the interval partitions are only theoretical at this point - they don't really exist until data is inserted. But yes, it's an important distinction, that the number of intervals and the interval size effectively constrain the maximum value allowed in the partition key column.
Mar
18
awarded  oracle
Mar
17
answered maximum number of interval partitions in Oracle 11g
Mar
3
comment I have mistakenly deleted Datafiles.
Did you actually restore the files, and to the right place? The messages suggest that they maybe still don't exist where expected, or have the wrong ownership. Recovery doesn't magically reinstate the deleted files, it makes the database consistent (hopefully) once you have put an old copy back, by reapplying redo logs. If this is new to you, try not to make things worse by experimenting. But, does 'the files are not important' mean that you don't care about the data in the tablespaces the specific deleted files relate to?
Feb
28
comment Startup NOMOUNT and Startup MOUNT on dataguard oracle
@DevYudh - pretty sure; it goes through these stages on a normal startup. Is there a reason you think there is a difference?
Feb
22
comment EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware
Don't post it here; read it, see what it says is wrong, see if it has more detail than the dialog, and then decide how to proceed...
Feb
22
comment EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware
It gives you the full path to the log file in the error dialog. Your netstat output is not useful, you're not looking for active connections, you're looking for ports with LISTEN. I think netstat -a -n -o will show you the ports and the PID of the process listening, which you can find in task manager. You only care about port numbers in the ranges showed in the error. Don't post it here, investigate it on your machine, the only place the numbers are relevant. If they're used by something else you might just need to pick different ports for emca.
Feb
22
answered Startup NOMOUNT and Startup MOUNT on dataguard oracle
Feb
22
comment EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware
SYSDBA is not a user, it's a role. Do sqlplus /nolog, then from the SQL> prompt, connect / as sysdba. Please read at least the 2-day DBA guide for the basics. Your dbca/emca error suggests those ports are already in use; do you already have a database running on this VM?
Feb
10
comment exporting oracle tables on command line as sql files
I'd also suggest this sounds backwards. You seem to want the schema and data in your database to be the 'master'. It would be simpler to keep your DDL and DML (presumably for initial base data) statements in files that you maintain outside the database, and check those in; and make changes to your DB using those files. Making ad hoc changes and then trying to track them afterwards sounds painful. But, just my opinion of course.
Feb
10
comment exporting oracle tables on command line as sql files
Well, here's a list of reasons this isn't simple, and here's Tom Kyte's view; that has some attempts at generating the statements dynamically, but I'd be very careful about checking anything you find like this works for all your data *8-)
Feb
10
comment exporting oracle tables on command line as sql files
No, you'd need to write your own extract scripts. You can get the DDL with the dbms_metadata package, but you'll need to generate your own insert statements. (Or find an automated dynamic example on the 'net somewhere). What's wrong with a binary dump file though?
Feb
8
awarded  Yearling
Jan
29
comment Oracle DB Shutdown issue
@PhilSumner - yeah, it's just habit, not sure if it was ever advised but I've been doing it since at least 7. I don't do it often enough to have investigated if there was actually any benefit - I suspected not!
Jan
29
comment Oracle DB Shutdown issue
From the docs, with immediate: "Current client SQL statements being processed by the database are allowed to complete". I don't know if there's any real basis for this, but if I ever have to shutdown abort, I tend to do a startup followed by ` shutdown immediate` - gives me a bit more confidence that everything is OK, even if it doesn't really add anything...