Koki,
ok, here is the thing - 99.999 % it is your hard drive is full,
and it will be full until you do something about it.
There are several things that you should do, but the first thing is probably making sure that Oracle is responsive.
So, here are some fo the assumptions that I make:
- your disk is full because of archive logs.
- you do not have enough space to move data somewhere else
- you do not care about archive logs
- your number priority is to make sure that CCA is working
- your ODS is on a different Oracle (as Genesys strongly suggests)
- you do not have time to make a backup
- you ar eusing UNIX (as any normal person would
)
Since ODS is on a different Oracle, all your reporting data is not lost and is safely stored in ODS, so we are fine.
1. Let's check disk space first: df -k -- does it say Capacity 100% somewhere?
2. Let's check where your archive logs are:
sqlplus sys/... as sysdba (make sure you are doing it from the machine where ORACLE is running!)
select destination from v$archive_dest;
is the directory where archive logs are the same as where capacity is 100%? If so, proceed, if not, STOP and tell us.
(ONLY IF ARCHIVE LOGS FILLED YOUR SPACE)
3. we want to make sure that ORacle is up and running again, so what we want to do is turn Archiving off
alter system archive log stop;
4. let's delete archive files!
cd to directory shown in step#2
rm * (<-- careful - make sure that only archive files are there. Usually it is in "archive" folder. If it is under archive folder, chance are you are fine, so don't sweat. If you are not, STOP and reply to us
5. deleting will be instanteneous but df -k will not show it for a few minutes, because probably we are talking about gigs of files, so just wait.
6. let's see if you can enter oracle: sqlplus yourlogin/yourpassword@yourinstance (sqlplus genesys/genesys@GENESYS_DM judging by your post)
7. you should then check if your ETL-trans logs : on its next run it should move the data just fine.
Tell us how it went!
