Bruce,
The version of Oracle we are running is 7.3.4.0.1 on Sun Unix server
version 5.5.1. We are able to establish a connection, but we're not able
to startup the instance. The alert log says : ORA-01194: file 1 needs more
recovery to be consistent.
From the unix server-side, the hard disk array connected to the
JukeBox Server crashed because the Hard Disk Array ran out of space.
As a quick solution we're looking to add new hard disks.
Thanks,
David Harris
Web Technology
Verizon Communications
"Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
@fatcity.com on 02/06/2002 08:08:18 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
David,
Can simple suggestions initially that may isolate the problem:
Does the database run on Sun or on something else?
- I'm willing to learn but I only knew of the lite version on NT.
Can you connect to the database using SQLPlus and a DBA user and specifying
the SID (ie a Net8 connection)
If so, what does select * from v$version tell you - this will confirm the
Oracle version
If so, can you select from application tables within the database
If a Net8 connection doesn't work, (assuming the DB is on Unix) can you
telnet to the Unix box, set your oracle_sid and then try to connect
If this works but the Net8 connection didn't maybe there is a listener
issue.
You mention the alert log - it would be useful to see the last 30 or so
lines in the alert log
If you can connect to the database, the command show parameter dump should
tell you the location of the alert log (parameter name
background_dump_dest)
show parameter dump will also tell you the user dump destination (parameter
user_dump_dest) - are there any new files in the user dump directory and if
so what do they contain
You mention you ran out of disk space - has that been fixed now?
Depending on what the above finds, maybe the database might need to be
restarted or maybe the listener.
I'm sure others will have many suggestions.
HTH,
Bruce Reardon
-----Original Message-----
Sent: Thursday, 7 February 2002 11:19
Hi List,
My work group is using PVCS Tracker tool version 7.0 from Merant
which tracks development defects, and runs on a lite version of Oracle 8i.
Currently all users who login to PVCS receive the message: "User cannot
retrieve data records". We believe that a possible cause could be that we
ran out of disk space, which may have caused a data integrity violation.
This software is running on a Sun Unix server.
Any suggestions such as viewing the Alert file would be helpful.
Please be easy, I'm a first timer and I've only taken the PL/SQL and Admin
and Architecture classes.
Thanks,
David Harris
Web Technology
Verizon Communications
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
