low disk space error ora 9i [message #336364] |
Fri, 25 July 2008 22:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balamurugan_edp
Messages: 19 Registered: May 2007
|
Junior Member |
|
|
sir,
Im using ora 9i, in win 2000 server (sp2).
i installaed 9i in d:\ having partition size of 11.7 GB. now all the oracle folders size is nearing 11.5 GB. and only minimum space is available in d:\.
The undotbs01.dbf file is about 5 GB.
and i created many .dat files (which sized abt 4.58 GB).
As of yesterday, system working fine with only 2MB of data left.
Now,the oracle didnt startup. it says,
ORA-01034-ORACLE not available
ora-27101 Shared memory realm does not exist.
I try to startup the database (manually) by using sys as sysdba.
But it produces following....
Database mounted.
ora-03113 end-of-file on communication channel.
I know it may be the error of low disk space.
pls kindly let me know,
i) how to delete an existing tablespace.
ii) how to clear the UNDOTBS01.DBF file with minimum size.
I attached my ALRT.LOG FILE.
i backup the data before 3 days .
Pls help me to solve this error.
Thanks in advance.
Balamurugan.M.
Ramana neeye thunai.
|
|
|
|
Re: low disk space error ora 9i [message #336429 is a reply to message #336365] |
Sat, 26 July 2008 13:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balamurugan_edp
Messages: 19 Registered: May 2007
|
Junior Member |
|
|
Sir, thnks 4 your reply.
Pls diagnosis the following and give the possible ways to load oracle.
I have ora9i with win2000 server.
I have low disk space in my oracle drive.
oracle installed in d:\oracle (drive capacity 11.5GB)
now all the oracle file folder size equals to ~(11.3 GB)
(only some 100MB size free)
and My ORACLE is not loading....
It gives the following err when i try to open it using, system/manager in(sqlplusw),
ora-01034 oracle not available.
ora-27101 shared memory realm does not exist
and when i try to open it with sys as sysdba, the following error comming,
database mounted.
ora - 03113 end-of-file on communication channel.
Here with i attachmed my alert.log file in BDUMP folder.
my service name : ORASRV
system name : server
ipconfiguration :192.168.0.1
host name : htgserver
I will attach the trace file in BDUMP folder in the next msg.
Pls let me know how to load my oracle
thnkz
Bala
|
|
|
|
|
Re: low disk space error ora 9i [message #336449 is a reply to message #336364] |
Sat, 26 July 2008 22:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>ORACLE V9.0.1.1.1
Running 1 of the most bug ridden version ever released.
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcbzpb_1], [8569613], [4], [1], [], [], [], []
Corrupt block relative dba: 0x0082c30d (file 2, block 181005)
Bad header found during preparing block for write
From Metalink Subject: ORA-600 [kcbzpb_1]
Doc ID: Note:139011.1
|
|
|
|
|
Re: low disk space error ora 9i [message #336549 is a reply to message #336462] |
Mon, 28 July 2008 02:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balamurugan_edp
Messages: 19 Registered: May 2007
|
Junior Member |
|
|
Sir, thnks for your reply.
I will change my oracle version. But how to backup the data from existing system.
I cant able to login using sqlplus and i cant able to startup the database manually using sys as sysdba (startup)
it gives the following errord
c:\sqlplus sys as sysdba
sql>startup
oracle instance started.
Total system Global area 118255568 bytes
Fixed size 282576 bytes
Varible size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database Mounted
ORA-03113: end-of-file on communication channel.
I tried to install a new oracle server with the same name (ORASRV).
but i dont know how to connect the existing server's database files to the new server.
Please Help me to backup the data
Balamurugan
|
|
|
|
Re: low disk space error ora 9i [message #336569 is a reply to message #336554] |
Mon, 28 July 2008 03:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
balamurugan_edp
Messages: 19 Registered: May 2007
|
Junior Member |
|
|
Thanks for your advice michel sir. thanks for showing the importance of DB.
But i cant hire a person due to my economy.
Shall u provide some help on this.
I need the data importantly.
Kindly help me to take the data safely.
I know, im in a worst stage in my career.
pls kindly help me.
Thanks
Balamurugan.
|
|
|