RE: Slightly OT: PVCS Tracker 7.0 Backup & Recovery Question

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: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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).