ORA-01534 rollback segment 'R1' does not exist
Advertisement
November 30
Greetings
HELP!! We are using oracle 8.0.5 ...
The database will not open because it says the system
rollback segment does not exist.
The database mounts but won't open. from the file system checks,
the dbf file that contains the system rollback segment appears to
be fine.
Is there anyway to recreate the sys rb seg ? any way to correct
whatever is causing it to think it doesn't exist?
or if it is just hosed, is there any way to retrieve the data in
the data dbf files through another oracle installation or another
oracle database??
Thanks for any input!
null
Advertisement
Replay
Check your init<SID>.ora file. Check the parameter
rollback_segments. If its value contains R01, delete R01. After
that, save the file and startup again.
Robert Xu
Laurie (guest) wrote:
: Greetings
: HELP!! We are using oracle 8.0.5 ...
: The database will not open because it says the system
: rollback segment does not exist.
: The database mounts but won't open. from the file system
checks,
: the dbf file that contains the system rollback segment appears
to
: be fine.
: Is there anyway to recreate the sys rb seg ? any way to
correct
: whatever is causing it to think it doesn't exist?
: or if it is just hosed, is there any way to retrieve the data
in
: the data dbf files through another oracle installation or
another
: oracle database??
: Thanks for any input!
null
View 2 Replies
October 11
Hi All, I am encountering table or view does not exist error while publishing using the api. Below is the code: try { consolidatorManager.openConnection("MOBILEADMIN","PASSWORD", ADMIN_JDBC_URL); mobileResourceManager = new MobileResou
View All Replies
October 11
Hi Friends, SunOS 5.10 Generic_137112-06 i86pc i386 i86pc , 64 Bit Oracle 10.2.0.1.0 While I am doing a startup, getting following error. SQL> startup; ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2122544 bytes Variab
View All Replies
October 11
Hi i can't succeed connectivity test with netmgr Initializing first test to use userid: scott, password: tiger Attempting to connect using userid: scott The test did not succeed. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not
View All Replies
October 11
Hi all I have a problem related to sap xi-7.0 server. when I start server than dispature is not started . and the trans file show these problem , i am past the this trans file , so plz solve this probl
View All Replies
October 11
Hi Geeks, I have encountered an issue while starting up my database on 12c RAC. Till mount it goes fine but when i attempt to open it throws me an error. Total System Global Area 1.5400E+10 bytes Fixed Size 4737560 bytes Variable Siz
View All Replies
November 30
Dear Gurus, Im getting this error while submitting the personal information (while updating & submitting). I am using custom security profile at Security leavel. If i remove that security profile it works fine. Can anybody give me a solution for this
View All Replies
November 30
{color:#0000ff}Receiving the following error message in the "Submit Expense Report - Expense Allocation" page: "Error : Line 1 Error - Value 120 for the flexfield segment Company does not exist in the value set XX_GL_COMPANY" This erro
View All Replies
November 30
While calling dbms_stats.seed_col_usage I got the following error. Can someone help me on how to resolve it sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 14 14:37:38 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-
View All Replies
October 11
Hi i have logged into my schema and trying to access the database "DAD" which has the table name "SCHOOL" i wrote a function which should give me new_sno when i give it the old_sno and i have this errors , pls help CREATE OR REPLACE FU
View All Replies
November 30
Hi everyone, I'm having a weird issue. I've got some GL data that I want to report on in three different grains: Quarter To Date, Year To Date and Entire Year. For the first two measures, I've setup a time dimension and I'm using the ToDate function.
View All Replies
November 30
Hi Chris, This is wrt the thread : Unable to create CacheGroup. I have configured Oracle_DB[11.2.0.3.0] for timesten, installed timesten[11.2.2.7.0], configured cache_DB. So the Oracle database has user TIMESTEN(cache user) and TTENADMIN(cache admin
View All Replies
November 30
Hi everybody, please help!!!!! I have a problem on my ERP, whe the users run reports called ZSD01, ZSD07 these programs exeed the lifetime period of 600 seconds and cause an ABAP - runtime error by time out. using the TX ST22 I get a report indicatin
View All Replies
October 11
Hi everyone, i have a target source 'U_BCK' that cointains some Oracle table. I have also created a target schema 'BCK_OWNER' where i create some dimensions and cubes with mappings. My mappings connect some table from U_BCK with dimension or cube fro
View All Replies
October 11
I am getting currently getting an error when I try and insert into a table from a different schema from my Stored Procedure: Error(20,22): PL/SQL: ORA-00942: table or view does not exist I am explicitly calling the table with the schema name infront
View All Replies
October 11
I have a WebService which is invoked , the request is routed through the mideator to the DBAdapter .DBAdapter interacts with the database and replies the result. I send in the CreditCardNumber in the request and recieve its Status (VALID,INVALID). i
View All Replies
October 11
HI ALL, After the oracle has installed on a solaries server successfully, i am unable to login into oracle database. Below are the errors messages : 1) ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No su
View All Replies
November 30
Hi, I am trying to create a table using a execute immeidate in PL/SQL it is giving table or view does not exists. Where as same create table sql is running fine outside the PL/SQL. g_sql := ' CREATE TABLE '||l_tmptable1||' as '|| ' SELECT decode(gsis
View All Replies
October 11
Error: u201CORA-00942: table or view does not existu201D Source & Target Datastores in same Oracle DB but different User/Schemas. I set up the Data Services Tutorial Source & Target Data bases in ONE Oracle DB using a separate User/Schema for the
View All Replies
November 30
Hello every one, I have a procedure to load the learning management data history through API. I get error that the table or view does not exists which I don't know why. Here is my procedure: CREATE OR REPLACE PROCEDURE OLM_CLASS_HISTORY AUTHID CURREN
View All Replies