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 ...
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: ============================= ...
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 ...
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 ...
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 ...
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 ...
i am using this update command, and getting the following error:UPDATE (select a.IDX old_idx, b.idx new_idxfrom TEMP_FC_INTER a, TEMP_FC b where a.ORIG_IDX=b.ORIG_IDX)SET old_idx = new_idxi am getting the following error:Oracle/PLSQL: ORA-01779 ErrorBest ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
/*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 ...
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 ...
From yesterday, ORA-00600 error happened very often. After this error, oracle instances will be shutdown automatically. Following is from alert_ag9sp.log: Errors in file /opt/oracle/admin/ag9sp/bdump/ag9sp_smon_8638.trc:ORA-00600: internal error code, arguments: [25012], [0], [632], [], [], [], [], ...
I am using Oracle 9i Enterprise Edition Release 9.2.0.1.0 with Windows 2000 Server. I have just upgrade my database from 8i to 9i. I am facing this problem in a lot of queries in my application after upgrade. I tried to searched out but unable to find the reason yet. Is there any parameter which i s ...
How can i simulate de ORA-01801 error?ORA-01801:date format is too long for internal bufferI need to know why my application generate this error some times.the NLS_DATE_FORMAT parameter is set to "DD/MM/YYYY" and the Oracle database is 10g release 10.1.0.1Tank's ...
Seen quite a few of these but going through the steps provided has given me no joy so far..Running: 9.2.0.4.0 client (full install)Installed as: Administrator on c:MDAC: 2.8Server: win2000 Advanced serverConnecting to: remote serverIssue: I'm trying to connect to another dbserver via a webserive, th ...
we have following 4 tables the last table ERROR_INSTANCE_CONTEXT has got index on forerign key referencing to ERROR_INSTANCE table getting following errrORA-20001: Unable to insert context for "$filename" with value "ARES20010131.SND with Oracle error = -60 message ORA-00060: deadlock detected while ...
In have been facing with ORA-00060 Error Message popping up Everyday once or twice in one of our new Branch office.This causes the database to hang and the user has to restart the database because of this.My questions are :The same application is running in 7 other branches for the past 3-4 yrs with ...
I have a created 2 custom coordinate systems in 10g. They are the same except #1 is defined with Meter units and #2 is defined with Millimeter units. To create #1 I had to:Insert some SDO_COORD_OP_PARAM_VALS recordsInsert a SDO_COORD_OPS recordInsert a SDO_COORD_REF_SYSTEM recordTo create #2 I had t ...
Hi, i have an ORA-13346 error problem...I created a table and inserted these rows:CREATE TABLE cola_markets (mkt_id NUMBER PRIMARY KEY,name VARCHAR2(32),shape MDSYS.SDO_GEOMETRY);INSERT INTO cola_markets VALUES(3,'cola_c',MDSYS.SDO_GEOMETRY(2003, -- 2-dimensional polygonNULL,NULL,MDSYS.SDO_ELEM_INFO ...
Our Oracle version is 10.2.0.4 and we have physical standby db (DR) to PROD.We have views created in PROD and trying to access the same in DR and getting below error on DR environment.I am running simple select on DRselect * from v_temp_testl; ORA-00604: error occurred at recursive SQL level 1ORA-16 ...
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 ...
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 ? ...
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: ...
I've seen numerous posts of people talking about accessing tables over a database link, but very few about the famous ORA-904 error. Lucky for me, this will be the first one about both.I have a PL/SQL region with the source containing simply a cursor selecting some information from a two-table join ...
Hai..While i am executing the below query in toad, i am facing the "ORA-01861:literal does not match format string" error.select a.N_ID,a.FK_ID,a.CALL_DIR,substr(a.ERR_VAL,1,23),count(*) from table1 awhere a.START_DATE < TO_DATE('20070601' ,'YYYYMMDD')group by a.N_ID,a.FK_ID,a.CALL_DIR,substr(a.E ...