You are currently browsing the archives for the Oracle category.
Got this error in the emoms.trc log and thousands of .xml files in the recv directory. 2009-12-22 18:13:37,659 [XMLLoader0 30000031529.xml] ERROR emdrep.XMLLoaderContext flushTableStatements.1587 – Error while flushing insert statementjava.sql.SQLException: ORA-14400: inserted partition key does not map to any partition The fix was found on metalink as [ID 317046.1] Problem: Many Ora-14400 Errors Showing In Management [...]
While upgrading OEM from 10.2.0.4 to 10.2.0.5 I got the following error:[Text: Required RDBMS package: DBMS_AQ doesnt exist on this database. This package is needed for the proper functioning of the EM product. Please contact Oracle support to diagnose the RDBMS and once resolved, retry EM install.] This was caused by the sys password not [...]
Many people run Oracle RMAN scripts from crontab and an OS shell script. We prefer to run all of our RMAN backups via OEM and the database scheduler instead of from a specific server or instance. There are many benefits OEM/database scheduler backups a few of which are: Centralized administration makes it easy to manage [...]
EM can automatically connect to Metalink to check for required patches for each target database and download them to a software library. Over the next few months I will add monitoring, alerts, admin accounts, developer user accounts (so they can get their own ADDM (statspack) results), and groups. I will also work to add every [...]
Recovery example SQL> select status, enabled, online_time, name from v$datafile order by name; STATUS ENABLED ONLINE_TI ——- ———- ——— NAME ——————————————————————————– RECOVER READ WRITE 13-AUG-07 +DATA01/cp04/datafile/bb_bb60_indx.281.630546303 ONLINE READ WRITE 13-AUG-07 +DATA01/cp04/datafile/bb_bb60_stats_data.282.630546385 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining [...]
This little at job performs a full backup and sends the output of the log file to me via email. I use this for incidental one-time backups of databases for releases and migrations. I like to schedule these early enough that I can get the results of the logfile and create another backup if this [...]
FYI – The new Daylight Saving Time changes that started in March 2007 will soon be changing back to Standard Time on November 4th, 2007 . Year DST Begins DST Ends 2007 March 11 November 4 2008 March 9 November 2 2009 March 8 November 1 [...]
Here is a simple way to syncronize schema passwords from one Oracle database to another. On the source database run the following sqlplus command: SQL> select ‘alter user ‘ || username || ‘ identified by values ”’|| password ||”’;’from dba_users where username in (‘GMADMIN’,’GM_0′,’GM_0_REPORT’,’GM_0_STATS’); That will produce the following output which you can run on [...]
I ran into this issue on one of our RAC clusters. The error is:The user “oracle” does not have user equivalence setup on nodes. Please setup the user equivalence before proceeding. PRKC-1044 : Failed to check remote command execution setup for node dbserver-010 using shells /usr/local/bin/ssh and /usr/bin/rsh dbserver-010: Connection refused. The fix was to [...]
Database resident connection pool will help the scalability of PHP applications by creating a connection pool on the server. This will require a special PHP connection driver which is yet to be released.
Here is the place for some apex examples for tiny pieces of apps
While running dbca I got the following errors: ORA-00119: Invalid specification for system parameter LOCAL_LISTENERORA-00132: Syntax error or unresolved network name LISTENER_<sid>ORA-1078: Failure in processing system parameters. There is a metalink note with a nice workaround here Note:433817.1
To unsecure the EM agent run the following command:$EMHOME/bin/emctl unsecure agentOracle Enterprise Manager 10g Release 10.2.0.1.0.Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.Checking Agent for HTTP… Done.Agent successfully stopped… Done.Unsecuring agent… Started.Agent is now unsecured… Done.Unsecuring agent… Ended.Agent successfully restarted… Done.
As a user of Oracle Enterprise Manager (OEM) I know that sometimes the wait for the browser refresh can be tough. One thing the new document suggests is that you can run multiple instances of the OMS on the same host and use a load balancer to spread the requests to the multiple instances. We [...]
On a new install of Enterprise Manager 10.1 we would get random failures caused by the dbsnmp account getting locked(timed) due to failed login attempts exceeding the default profile’s setting of ten. This is caused by the dbsnmp user connecting with the wrong password more than 10 times in a row which forces an account [...]
Two of our DBA’s will be attending Collaborate ’07 this year. We will be focusing on the core RDBMS, RMAN, Streams, Data Guard and Oracle Fusion/Apps server. Wrap all that into Enterprise Management best practices and were ready to go. I’m looking forward to meeting up with all my friends there and continue the geek-fest [...]
It is easy to see why I am so excited about Oracle. It just keeps getting better and better. Below is a snip from the press release. This will definately increase opportunities in the BI field. The Internet is fresh and new again! Oracle Buys Enterprise Performance Management Leader Hyperion 12,000 companies use Hyperion software [...]
I had an agent install fail for some reason and could not get the agent to re-install. I had to start the installer (in GUI mode) and click on “Installed Products” and remove the oracle agent by selecting the agent home. Then I was able to re-run the install and it completed successfully.
One of the new features of 10g that we really like is Flashback Database. We had just enabled this feature on a development database and a few days later one of our developers reported that a table had been dropped accidentally. Wow, in the past this would have been a lot of work to recover [...]
The enterprise manager installation can not use symbolic links for the repository directory. I ran into this problem while installing using the “Complete install” option on a single host. The fix was to use the full real path for the parent of the oracle homes.
