Home » RDBMS Server » Server Administration » low disk space error ora 9i (ora 9i, win 2000 server)
low disk space error ora 9i [message #336364] Fri, 25 July 2008 22:44 Go to next message
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.

Report message to a moderator

Re: low disk space error ora 9i [message #336365 is a reply to message #336364] Fri, 25 July 2008 22:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

No file was attached.

You posted nothing of substance to diagnose root cause.
There should be 1 or more trace files based upon errors reported.

Report message to a moderator

Re: low disk space error ora 9i [message #336429 is a reply to message #336365] Sat, 26 July 2008 13:42 Go to previous messageGo to next message
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

Report message to a moderator

Re: low disk space error ora 9i [message #336432 is a reply to message #336364] Sat, 26 July 2008 13:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

No file was attached.

You posted nothing of substance to diagnose root cause.
There should be 1 or more trace files based upon errors reported.

Report message to a moderator

Re: low disk space error ora 9i [message #336448 is a reply to message #336432] Sat, 26 July 2008 22:30 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
sorry , i didnt see the max file size. so that the file is not attached. i attached a part of TRACE FILE in bdump folder
pls let me know how to solve this error.

Report message to a moderator

Re: low disk space error ora 9i [message #336449 is a reply to message #336364] Sat, 26 July 2008 22:57 Go to previous messageGo to next message
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

Report message to a moderator

Re: low disk space error ora 9i [message #336460 is a reply to message #336449] Sun, 27 July 2008 04:38 Go to previous messageGo to next message
balamurugan_edp
Messages: 19
Registered: May 2007
Junior Member
Sir, thnks for your reply. Let me know what is the err. and
How to fix this error.

Pls do the needful.

Bala

Report message to a moderator

Re: low disk space error ora 9i [message #336462 is a reply to message #336460] Sun, 27 July 2008 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
from Ana
From Metalink Subject: ORA-600 [kcbzpb_1]
Doc ID: Note:139011.1

Nothing more to say without being outlaw.
If you have no valid CSI, you have no right to get the workaround.

But the most obvious way is to upgrade your version and goes very far away from this 9.0 no more supported and full of bugs.

Also, don't use IM speak.

Regards
Michel

Report message to a moderator

Re: low disk space error ora 9i [message #336549 is a reply to message #336462] Mon, 28 July 2008 02:12 Go to previous messageGo to next message
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

Report message to a moderator

Re: low disk space error ora 9i [message #336554 is a reply to message #336549] Mon, 28 July 2008 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Due to your lack of experience, I advice you to hire a senior before you definitively lose your database.

Regards
Michel

Report message to a moderator

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
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.

Report message to a moderator

Previous Topic: alter database backup controlfile to trace as 'j:\ctl.txt' ;
Next Topic: Enable row movement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 23:32:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.