Oracle After patch: ORA-19554: error allocating device, device type: SBT_TAPE

I applied the patch for Bug on Version 11.1.0.7.0
and after that my HOT RMAN backup is failing on tapes...any idea what could be the reason and solution?
If anybody more interested it was for bug: 7185872 for Streams

Output Log

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Mar 24 23:57:57 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to target database: NGDEV (DBID=281821359)

RMAN>
connected to recovery catalog database

RMAN>
echo set on

RMAN> configure controlfile autobackup on;
starting full resync of recovery catalog
full resync complete
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'SBT_LIBRARY=/ora00/app/oracle/product/11/db1/lib/libobk.so1';
4> send 'NSR_ENV=(NSR_SERVER=corpntw01.amhc.amhealthways.net,
5> NSR_DATA_VOLUME_POOL=UNIX Daily)';
6> allocate channel 'dev_1' type 'sbt_tape'
7> parms 'SBT_LIBRARY=/ora00/app/oracle/product/11/db1/lib/libobk.so1';
8> send 'NSR_ENV=(NSR_SERVER=corpntw01.amhc.amhealthways.net,
9> NSR_DATA_VOLUME_POOL=UNIX Daily)';
10> backup incremental level 0
11> format 'CORPNG03_RMAN_HOT_%s:%t:%p.dbf'
12> database;
13> backup
14> format 'CORPNG03_RMAN_HOT_%s:%t:%p.dbf'
15> current controlfile;
16> release channel dev_0;
17> release channel dev_1;
18> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on dev_0 channel at 03/24/2009 23:58:17
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 3820

Oracle Getting ORA-19554: error allocating device, device type: DISK, device name:

Trying to clone the database through RMAN and these are the steps I am performing..RMAN> run {2> allocate auxiliary channel t1 type 'disk';3> allocate auxiliary channel t2 type 'disk';4> set until time "to_date('04/18/2007 12:10','MM/DD/YYYY HH24:MI')";5> set newname for datafile 1 to ...

Oracle ORA-19554: error allocating device, device type: SBT_TAPE

Running HP DataProtector 6.0. Attempting to configure an Oracle 9i database for backup. Receive the following errors.RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ============================= ...

Oracle Can't Restore - ORA-19554: error allocating device, device type: SBT_TAPE,

All: I am having problems restoring a disaster recovery database because Rman is looking for backup sets on tape rather than disk. Here is the situation:1. I have a production database on one server.2. I do a daily full backup to tape. The retention policy is 30 days. 3. I do a daily full backup to ...

Oracle "ORA-19554: error allocating device, device type: SBT_TAPE, device name: "

why I can not delete obsolete?I have this error:"ORA-19554: error allocating device, device type: SBT_TAPE, device name: "but I haven't any tape. How I can remove this from my rman config?many thanks, as usual.cheers,Lain RMAN> show all;   RMAN configuration parameters are: CONFIGURE RETENTI ...

Oracle Delete Obsolete gives Error Allocating Device

This is 10.2.0.4I use RMAN to make scheduled backups to Disk. Never to tape.Today, when I ran RMAN> delete obsolete; I got 2 errors:ORA-19554: error allocating device, device type: SBT_TAPE, device name:ORA-27211: Failed to load Media Management LibraryI'm not sure what I can do to get around thi ...

Oracle Getting ORA-03113 error during DML transations on procedure

I have a form with DML data target type as Procedure. I have defined a procedure for insert which takes Table of records as argument. I am getting FRM-40735: INSERT-PROCEDURE trigger raised unhandled exception ORA-03113.(Procedure is in the database). Please help me out in resolving this. ...

Oracle getting ORA-03113 error message

I have created view of 56 columns.when I do select from the view, I got following error message.select count(*) from local_daily_dom_intl_view_0_b*ERROR at line 1:ORA-03113: end-of-file on communication channelI am not sure why I am getting this error.null ...

Oracle VPD, ora-28100 error

I am trying to learn the VPD. I created two schema, s1,s2 and a tabel t1 in s1.Then I created the policy package owned by s1 with a policy function pf_security return varchar2.The function always returns '1=1'.Then I add the policy by login as SYS. The policy is to s1 schema and t1 object for "SELEC ...

Oracle Getting ORA-12203 Error

I have a connection problem. Here are the detailsI’m trying to connect from a outside client to our Oracle 8.1.5 server running on Windows NT 4.0. We created a alias IP address and open 1521 port for connection. When I’m trying to configure a TNS entry from client I’m not able to c ...

Oracle Getting ORA-01858 error on DBMS_SQL.FETCH from a DEFINE_ARRAY

Everytime, I run this procedure I get a ORA-01858 a non-numeric character was found where a numeric was expected. I have tried everything from trying to convert the value into a number and to a CHAR. Does anyone know what I am doing wrong? thanks Chris Procedure COLUMN_FIND IS -- -- To modify this t ...

Oracle Getting ORA-01858 error on DBMS_SQL.FETCH from a DEFINE_ARRAY

Everytime, I run this procedure I get a ORA-01858 a non-numeric character was found where a numeric was expected. I have tried everything from trying to convert the value into a number and to a CHAR.Does anyone know what I am doing wrong?thanksChris Procedure COLUMN_FIND IS---- To modify this templa ...

Problem Creating an Object Store brings down Oracle with ORA-12505 Error

Hi, I have installed the Content Engine and the Process Engine successfully (keeping versions to 4.0.0 for now as I've had the same problem with 4.0.2) When I create an Object Store is creates successfully however when I reboot the Machine Oracle is failing with a ORA-12505: TNS:listener does not cu ...

Oracle Getting Ora -01043 error

I'm getting ORA-01043 error, while executing my PRO*C executable which tries to open a Cursor declared, prepared in that Pro*C file ? I'm unable to figure why this error is popping in ? Can anyone help me out ? ...

Oracle Tablespace - ORA-00604: error occurred at recursive SQL level 1

I just installed 9i. I tried to use the installer but it kept hanging so I did the database creation by hand. Anyway does any one have an idea of what is wrong?SQL> create tablespace cps datafile '/u02/cps' size 1024M;create tablespace cps datafile '/u02/cps' size 1024M*ERROR at line 1:ORA-00604: ...

Oracle logs ORA-25228 error messages

I am running Oracle )i Release2 and am using Java/JMS to dequeue messages and PL/SQL to enqueue messages. Everything works great, but when I look in the "udump" catalog on the machine where Oracle is running, I see 20-30 files generated each day containing error messages like:*** 2002-10-08 10:24:00 ...

Oracle raise ora-03113 error when create index in large partitioned table

my database is oracle 9i,and i have a large table(1.6G) which contain a geometry column.i first partitioned the table with 8 part ,and then import the data in it,it's ok.and then i want creating a spatial index,in this stepi got the trouble,when it execute the create index sql the system always repo ...

Oracle Getting ORA-03111 error

I m running a proC pogram in which i have opened a cursor and i m writting the records into file. I can able to write almost all records but at one particular record oracle was giving the error ORA-03111.I dont know why? Can any body explain me why the error is coming ...

Oracle meet ora-01041 error when I create tablespace

I'm new to oracle. when I create tablespace,I meet an error like below: ORA-01041 internal error. hostdef extension doesn't existwhat cause it and how I can do?can help me? ...

Oracle re:ORA-12705 error

I have been trying to load Oracle9.2 onto Linux 9 (a new OS for me) and having little success, and yes i've followed all the instructions from various websites so please dont direct me to anymore.Basically when trying to connect to Oracle i get the error ORA-12705 NLS parameter problems, BUT WHAT?Ca ...

Oracle re:ora-12545 error

Can anyone shed some light on this... I have just installed red hat linux 9 and have been trying install Oracle 9.2 (i have followed many instructions from sites and have done all the export cmds etc...). But i keep getting a ORA-12545 error when trying to connect (no target host found)i have looked ...

Oracle re:ORA-12545 error (host target)

Can anyone shed some light on this... I have just installed red hat linux 9 and have been trying install Oracle 9.2 (i have followed many instructions from sites and have done all the export cmds etc...). But i keep getting a ORA-12545 error when trying to connect (no target host found)i have looked ...

Oracle Trap Ora-03113 error??

I have PL/SQL program, which gets "ORA-03113: end-of-file on communication channel" after processing data (in between). How do we trap this offensive sql statement?Let me know your thought.Ram ...

Oracle WHY ORA-01426 ERROR IS RAISED

/*According to the Oracle Library'However, when a BINARY_INTEGER calculation overflows, no exception is raised if the result is assigned to a NUMBER variable.'*/DECLAREv_BinInt BINARY_INTEGER;v_Number NUMBER;BEGINv_BinInt := 2147483647;v_Number := v_BinInt + 1;DBMS_OUTPUT.PUT_LINE(v_Number);END;/*Wh ...

Oracle ORA-31083: error while creating SQL type

Our Oracle 10g installation has started acting up. We've been able to register and deregister a load of schemas for some time now but today the process failed for some reason with the message:ORA-31083: error while creating SQL type "COSMOS"."DeliveryPoint2407_T"ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT ...

Oracle Catching ORA-02291 error

I am trying to trap a ORA-02291 (Foreign key constraint error), like as follows:CREATE OR REPLACE TRIGGER trg_nameINSTEAD OF INSERT ON VW_NAMEDECLAREerr_fk_violated EXCEPTION;PRAGMA EXCEPTION_INIT(err_fk_violated, -2291);BEGIN...When inserting, violated key constraintEXCEPTIONWHEN err_fk_violated TH ...

Oracle Getting ORA-01400 error unexpectedly

i am getting a strange error in my application based on Oracle 9i AS. In one of the forms in one particular machine, there is a ORA-01400 error coming which should not be coming & additionally, it is coming on one machine & not on other machine.I hope, my question is clear. Please help in so ...

Oracle Imp ORA-02248 error

I have no idea what is going on here. I'm importing from a full dump and getting a weird message in return. Has anyone seen this?C:\oracle\product\10.1.0\db_1\BIN>imp userid=MYUSER@MYDB file=C:\proj\EXPDATA.dmp   Import: Release 10.1.0.2.0 - Production on Tue Apr 26 14:47:17 2005   Copy ...

Oracle Help: ORA-12154 error when trying to log on.

I have installed 9i personal edition for XP on my desktop successfully.When I try to sign on I get error ORA-12154.This is my TNSNAMES file:-# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.EXTPROC_CONNECTION_DATA =(DESCRI ...

Oracle [Q] ORA-30510 error while doing full database import

We have ORACLE 9.2.0.6 on Redhat LINUX AS 3.4. while we doing "full database import" there has ORA-30510 come out. I searched Metalink and Google, but not found much information. The error messages on import are:. importing OUTLN's objects into OUTLN. importing SYSTEM's objects into SYSTEM. importin ...