You know, not to cause you to worry but I have had issues with
Tracker databases. In one case I could not export fully successfully.
I worked with Oracle for about a week to try and get to the
cause (I don't think I had their brightest working with me). Finally,
Oracle said to rebuild the database. I am like "How, I can't export
the f*n data." Turns out I got enough out of it that I was ok.
Manually reproduced the rest.
-----Original Message-----
Bruce (CALBBAY)
Sent: Wednesday, February 06, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L
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: Kimberly Smith
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).
