| database not starting [message #118815] |
Mon, 09 May 2005 01:13  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai all,
our oracle db server is not up here on monday after restarting the same.we can enter into /nolog but can't get into sys as it gives "can't initialise audit trail file".we have deleted all the old audits even then it is blowing.
while performing dbshut / dbstart , it blows that
/mnt/ora_system/oracle/9.2.0/bin/dbshut: line 83: cannot create temp file for here document: No space left on device
Database "tcms" not shut down.
/mnt/ora_system/oracle/9.2.0/bin/dbstart: line 124: cannot create temp file for here document: No space left on device
Database "tcms" NOT started.
kindly help out in this issue asap as the production is frozen now.
regards
bala
|
|
|
|
| Re: database not starting [message #118836 is a reply to message #118815] |
Mon, 09 May 2005 03:39  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
|
check out the space utilization of the system. The error clearly states " No space left on device". There shdn't be a disk partition, where oracle operates, with 100% utilization on the system. Free space there and then the issue shd get resolved on its own.
|
|
|
|
| Re: database not starting [message #118890 is a reply to message #118836] |
Mon, 09 May 2005 10:15 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
i have deleted some unwanted datafile through the OS cmd
as rm <xx.dbf> and made the file offline and made the oracle started up.this was done to free some space in OS.however the filesystem diskusage df -h displays
[oracle@localhost oracle]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p2 133G 126G 34M 100% /
/dev/cciss/c0d0p1 97M 15M 77M 17% /boot
none 503M 0 503M 0% /dev/shm
so , here only 34M is available for the usage which may end up with in the short period and make the same scenario to occur.in addition to that , linux GUI is also opening.
plz help out with complete reference as it is the production dependent.it is now working transiently.
regards
bala
|
|
|
|
|
|
| Re: database not starting [message #118904 is a reply to message #118891] |
Mon, 09 May 2005 10:57 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai mahesh,
no doubt oracle is in root
/mnt/ora_system/oracle/9.2.0
but we didn't expect this much space constraints in Linux that too we have used on friday with good free space.
what happened is that the some write error in the Linux file causes the tragedy.so even though we delete some dump files it won't help for run..is nt it..?then linux GUI is also not opening.so what we do..?plz help out in this issue with the complete reference.
regards
bala
|
|
|
|
| Re: database not starting [message #118960 is a reply to message #118904] |
Tue, 10 May 2005 00:27 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
As Mahesh pointed, first do clean up the bdump/cdump locations.. Do remove all unwanted files, or do take a backup of all these files before removing, for future refernce.
Then do check for the log files for listener and sqlnet. Again do check the size here and either remove these altogether or take backup and then remove for future reference.
Also do check for the size of file containing all system messages.. and also check for any dump file created on system.
Linux GUI may not be opening due to this same 100% disk utilization. Do free space on this disk and then try.
Regds
Girish
|
|
|
|
| Re: database not starting [message #119065 is a reply to message #118960] |
Tue, 10 May 2005 08:42 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai ,
i have deleted some unwanted files from bdump/cdump and arch also leaving space of about 3 GB now and the db is up now.
shall we restart the linux server so that it also attains GUI..?
regards
bala
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
