1,535 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 2 months
seen 9 hours 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.


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
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
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
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?
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...
Jan
28
comment Multiple Oracle TNS error
Well, I can't reproduce information from there. The oerr description of TNS-12518 is: "Cause: The process of handing off a client connection to another process failed. Action: Turn on listener tracing and re-execute the operation. Verify that the listener and database instance are properly configured for direct handoff. If problem persists, call Oracle Support. Comment: The problem can be worked around by configuring dispatcher(s) to specifically handle the desired presentation(s), and connecting directly to the dispatcher, bypassing the listener." So start by tracing?
Jan
27
comment How oracle Oracle Database 10g used index?
@Phil - query 2 is against id_res, not id_res2... but it's not clear if it has the PK or UI against it (since they can't both be there against the same column as written). I mentioned on the SO version that it might have switched from a full index scan to a full table scan because it's selecting r.* in query 2; but awaiting the execution plans to see why query 4 didn't do the same... I'm guessing stats, or because id_res2 is nullable. Maybe.
Jan
27
comment How oracle Oracle Database 10g used index?
Cross-posted on SO.
Jan
27
comment sqlldr: command not found
@MaheswaranRavisankar - the full client does; instant client doesn't. Instant client was just a thought though, and not relevant. I can't remember if the full install process lets you exclude certain executables, but I guess it does. Maybe that was down for some reason.
Jan
27
comment sqlldr: command not found
@user186414 - so what does ls -l $ORACLE_HOME/bin/sqlldr display? If you get 'no such file or directory' then possibly your DBA has removed it; but it may exist and you don't have execute permission. Either way you probably need to talk to your DBA.