I've received following error while trying to perform full database export using datapump to NFS:
Export: Release 10.2.0.4.0 - Production on Tuesday, 31 May, 2011 11:27:50
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.4.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/backup-nfs/testdb/export/exportfull.dmp"
ORA-27086: unable to lock file - already in use
Linux Error: 37: No locks available
Additional information: 10
In this case problem was lying in NFS locking deamons - on most Unix-like (more...)
We are currently in process of replacing our old database servers with new ones. During the evaluation process we’re checking various technical solutions to find the best option in terms of price/performance.
For me, real life experience is the most important when we are talking about database server performance so I’ve posted question on Oracle-L
lists to get some answers about noted servers and performance.
DBA’s from Oracle-L
lists helped me a lot. Thanks guys!
As replay to my question David Robillard
posted answer that is worth publishing on this blog. It is nicely summarized project check list that can (more...)
Colleague reported to me that execution of his query is taking too long. After quick look it was obvious that this was ideal tunning candidate.
I will note my tuning process in this blog post.
Table and column names are changed.
DB: Oracle 10.2.0.2.0
OS: Solaris 9 64-bit
SUM (poz_traj) / 60,2)
SUM (amount) iznos,
COUNT (*) pozivi
FROM usr.ugov@remote_db co,
WHERE 1 = 1
AND co.ugov_id = ci.ugov_id
AND ci.ugov_item_id = np.ugov_item_id
AND NP.kol_id (more...)
You can use Oracle Grid Control for checking policy violations, to keep compliance with company security or configuration standards. Grid Control comes with pre-installed set of policies and recommendations of best practices for databases.
With having that in mind I checked Critical Policy Violations for my database and noticed this critical violations:
Execute Privileges on DBMS_JOB to PUBLIC
Restricted Privilege to Execute UTL_TCP
Restricted Privilege to Execute UTL_HTTP
Restricted Privilege to Execute UTL_SMTP
Execute Privileges on DBMS_LOB to PUBLIC
Execute Privileges on UTL_FILE To PUBLIC
It is recommended to remove excessive privileges from some users to prevent possible attacks for (more...)
I must admit - today I learned new thing about RMAN restore and this is good enough reason for a blog post.
Part of my daily tasks is to perform RMAN backup and recovery scenarios in my test environment (as I said beore), to be familiar with every possible situation that can happen.
So today, very simple task of restoring database to another machine took me over 2 hours...
Environment : Oracle 10.2.0.4 on Linux 64bit
I have backup files of the database:
$ ls -l /oracle/backup/*
Restore controlfile from backup (more...)