- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle File System is full. How to come out of...
Operating System - HP-UX
1748216
Members
4064
Online
108759
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2007 06:25 PM
тАО06-27-2007 06:25 PM
Oracle File System is full. How to come out of it?
We have our Application runing on HP-UX with Oracle9i. The space alloted for Oracle File system is 15GB. When our application was running, it was observed that the File System %usage increased by 1% every day and now reached 100% now. Due to some reasons, we had to reboot the server and now we are unable to start 'dbstart' and 'sqlplus'.
With dbstart the following message is observed:
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jun 27 13:44:14 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> ERROR: ORA-09817: Write to audit file failed.
HPUX-ia64 Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device
SQL> ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device
SQL>
Database "ECDBAZE" warm started.
And with 'sqlplus' the following message is observed:
$ sqlplus ecscada/scada
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jun 27 13:42:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory.
Can any one help to come out of this problem as it is very urgent? Is it any thing to do with the audit files created in the '$ORACLE_HOME/rdbms/audit' folder or with the files created in the '$ORACLE_HOME/rdbms/log' folder. And if any log files are being created, how to disable the creation of log files and how to delete the existing log files so as to free the file system logical volume.
Later the Global Database by which we are identifying our database was deleted using 'dbca' - the Database Configuration Assistant. We could delete the database but I am not able to create a new database as it is mentioned that the space on the logical volume is less than what is required.
With dbstart the following message is observed:
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jun 27 13:44:14 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> ERROR: ORA-09817: Write to audit file failed.
HPUX-ia64 Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device
SQL> ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device
SQL>
Database "ECDBAZE" warm started.
And with 'sqlplus' the following message is observed:
$ sqlplus ecscada/scada
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jun 27 13:42:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory.
Can any one help to come out of this problem as it is very urgent? Is it any thing to do with the audit files created in the '$ORACLE_HOME/rdbms/audit' folder or with the files created in the '$ORACLE_HOME/rdbms/log' folder. And if any log files are being created, how to disable the creation of log files and how to delete the existing log files so as to free the file system logical volume.
Later the Global Database by which we are identifying our database was deleted using 'dbca' - the Database Configuration Assistant. We could delete the database but I am not able to create a new database as it is mentioned that the space on the logical volume is less than what is required.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2007 06:33 PM
тАО06-27-2007 06:33 PM
Re: Oracle File System is full. How to come out of it?
Hi,
It seems that your dump destination directory is full. Observe the spfile and find the parameter .audit_file_dest, this is where the audit files are written or just type bdf and paste it. It is possible that some core dump are eating you space, usually they are big.
It seems that your dump destination directory is full. Observe the spfile and find the parameter .audit_file_dest, this is where the audit files are written or just type bdf and paste it. It is possible that some core dump are eating you space, usually they are big.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2007 10:15 PM
тАО06-27-2007 10:15 PM
Re: Oracle File System is full. How to come out of it?
Hey
check for large file in your oracle home. maybe there are some core files
#find $ORACLE_HOME -name core
if you have deleted your database so you can also delete the log- and auditfiles.
are you sure you have deleted your database because generally when you delete the whole database (datafiles, archivelogs,...) there should be enough space...
check with "bdf" the available space for your oracle mount point.
Regards
don't forget to assign points, also in your other threads
check for large file in your oracle home. maybe there are some core files
#find $ORACLE_HOME -name core
if you have deleted your database so you can also delete the log- and auditfiles.
are you sure you have deleted your database because generally when you delete the whole database (datafiles, archivelogs,...) there should be enough space...
check with "bdf" the available space for your oracle mount point.
Regards
don't forget to assign points, also in your other threads
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2007 10:26 PM
тАО06-27-2007 10:26 PM
Re: Oracle File System is full. How to come out of it?
hi Srinivas,
The problem that you are having is related to the file system when Oracle is trying to create the log files.
Verify your cdump, udump and bdump directories. You may have to do some purging over there.
Also review the file system where you keep your oracle data files.
As someone also mentioned, search for the core dumps and delete them to free up space.
You must also analyse the growth is it data or just log/trace files that are linked to errors being reported by the database (check your alert.log)
hope this helps!
kind regards
yogeeraj
The problem that you are having is related to the file system when Oracle is trying to create the log files.
Verify your cdump, udump and bdump directories. You may have to do some purging over there.
Also review the file system where you keep your oracle data files.
As someone also mentioned, search for the core dumps and delete them to free up space.
You must also analyse the growth is it data or just log/trace files that are linked to errors being reported by the database (check your alert.log)
hope this helps!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP