13,584 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 6 months
seen Jul 17 at 21:05

Oracle DBA, Unix admin.

Available for employment! ;)


Jul
16
comment Oracle Export using EXPDP gives ORA-06512 SYS.UTL_FILE error on Windows 7
Does the Oracle service have permission to write to that directory?
Jul
2
comment How to model ski rental equipment
In rent_detail I'd have a date_due and date_returned - that way you can model late items.
Jul
2
comment Find out which client IP and Query using highest network Bandwidth from SQL Server
This question appears to be off-topic because it is about networking
Jul
1
comment Table income and expense is better to have it together or apart
They HAVE to be separate. Google for T-based accounting or accrual vs accounting
Jun
29
comment Insufficient space at Installing Oracle 11g in fedora
You need more disk space. Even if you allocate just enough to get the software installed, you'll need more space for the database datafiles. Add another virtual disk with 4-5Gb of disk, mount it on /u01, then install there
Jun
28
comment How i can solve “ORA-03113” error when i startup oracle 11G database?
It should be recover database;
Jun
27
comment Unable to create Central Inventory
oinstall usually owns the inventory, I think
Jun
27
comment ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
Reboot, then restart everything. What OS are you running on (I realise Windows, but what version?)?
Jun
27
comment Oracle Enterprise Manage “CPU utilization” is confusing
Very well explained. +1
Jun
27
comment Trying to run a shell script from dbms_scheduler . Throws error no matter what the script is?
What Oracle version? Are you patched up to the latest patch set (11.2.0.4, for example)? If not, patch. The ORA 600 lookup tool on My Oracle Support should then be the next thing to use. If that's no help, open a support request with Oracle.
Jun
26
comment The best way to query a partitioned table in Oracle
The optimiser should automatically do partition pruning if your partitioning strategy is sound. Shouldn't need to code around it.
Jun
26
comment SQLNET.ALLOWED_LOGON_VERSION=12 and JDBC thin client
Your best bet is to open a support ticket with Oracle, to be honest
Jun
25
comment Oracle Partition Table Space Issue
You have to actually resize the tablespace datafile itself, which might actually not be possible if there is data at the end of the file - you can check on DBA_EXTENTS.
Jun
25
comment Why does second instance of database not open?
Hang on, you're trying to use the same files as the other database (while it is running!), and all you did was create a new controlfile to start a 2nd database trying to use the same files (you didn't copy them?)?
Jun
23
comment Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?
The distribution of Linux doesn't matter, it's the MySQL versions on the hosts that does
Jun
22
comment How can I enable audit on selected accounts only to know where they logged on from?
The first requirement is easily done with a login trigger and a table.
Jun
22
comment How different is Oracle 12c from Oracle 11g or 10g
It depends how you're going to use it going forward. The whole container DB thing is a paid option (1 cdb is free), and many won't adopt the new model - it's an installation option that opens a new world, essentially. Apart from that, there's not much of significance that's changed
Jun
21
comment A issue on DB link between Postgres and Oracle?
Could also happen if one of the RDBMSes is 64-bit and the other 32-bit
Jun
21
comment Error Creating Foreign Key in Oracle
I just noticed the PRODDB schema name in the error message. Is that the user you're logged in as, or is there a public synonym for the object? If so, explains the error
Jun
19
comment How to dump data from Oracle to MySql
The question doesn't mention SQL Server!