I was doing a schema import last night, over a database link. Lack of sleep had set in and I was getting the following error Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [INDEX:”SCHEMA_OWNER”.”TABLE2″] ORA-02396: exceeded maximum idle time, please connect again ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95 ORA-06512: at “SYS.KUPW$WORKER”, line 11259 …
Category Archive: Oracle
Aug 07
RMAN-20036: invalid record order
Trying to register a database with my rman catalog I was getting the following error $ rman target sys/xxx@DB01 catalog=RMAN_DB01/xxx@rmancat Recovery Manager: Release 11.2.0.4.0 – Production on Mon Aug 7 11:42:37 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DB01 (DBID=114156133) connected to recovery catalog database RMAN> …
Feb 20
Targets.xml was rejected: loaded with a wrong agent token
I noticed an agent on one of my database servers was down this morning. Agents crash from time to time, no big deal. I will just restart it $ ./emctl start agent Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved. Starting agent ………… failed. Target Manager …
Feb 03
Oracle OEM 13c LDAP error
My new OEM 13c system has been having lots of issues, I have multiple bugs registered with oracle. This one is particularly odd, trying to create a new user I get an LDAP error The user actually does get created, but when I try to assign additional privileges to the user I get the error …
Jun 17
Mind your spaces
I am trying to export a database, everything except for a single table. I need to send a copy of the database to the vendor, but they don’t need a table that takes up %90 of the space in the database due to it storing a massive number of BLOBs and CLOBs This should be …
Jun 08
Rushing = Stupid Mistakes
I am currently being asked to refresh a database. The end users are pissed because they asked for the database to be refreshed at noon yesterday, this was the first they had asked for it, and they were doing “really important things” and by 3pm were pissed that I hadn’t responded to them, let alone …
Mar 29
ASM du -s
one of my biggest complaints about ASM is the lack of the ability to do the equivalent of “du -hs *” to view the size of all the directories. I found a little piece of shell script that does just this. It is extremely slow but it is very helpful! dg=RECO; for dir in $(asmcmd …
Mar 08
HOTSOS In Texas!
I am currently in Texas at the HOTSOS Symposium. I look forward to this conference every year. There are some brilliant people here, and it is a great place to learn new things. Kerry Osborn did a great live presentation yesterday, can’t wait to get home and try some of this stuff out. Also saw …
Feb 08
DBSNMP By Way Of EMCLI
Currently I am changing passwords in several hundred databases, not that uncommon of a task for any DBA. Unfortunately it is time to rotate the dbsnmp password. Usually I would log into OEM after changing the password and manually update the password in the monitoring configuration for each and every database. This is fine if …
Recent Comments