Categories
Company
Local Language
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
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
Community
Resources
Forums
Blogs
- 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
тАО12-08-2004 06:29 AM
тАО12-08-2004 06:29 AM
But today for the first time, the database decided to shutdown. Can anybody tell me if there are any log files on why this happened and more importantly who.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 06:39 AM
тАО12-08-2004 06:39 AM
Re: Oracle8
Anil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 06:47 AM
тАО12-08-2004 06:47 AM
Re: Oracle8
If your version is 8.1.6 then change the 8.1.7 to 8.1.6
This is based on standards set by oracle.
if your instance name is datafile:
/oracle/product/8.1.7/rdbms/alertdatafile.log
Don't do any database operations as root. Do them as the user of the binaries.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 07:03 AM
тАО12-08-2004 07:03 AM
Re: Oracle8
$cd $ORACLE_HOME/rdbms/log
Take a look at the file named alert_
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 07:16 AM
тАО12-08-2004 07:16 AM
Re: Oracle8
Is there any more logs?
THanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 07:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 07:31 AM
тАО12-08-2004 07:31 AM
Re: Oracle8
If you have found the log and there is nothing in it, I'd suggest looking for core dumps.
Lastly, I'd check the filesystems oracle is sitting its data on. If they are full, this may be as simple as adding some filesystem space.
Something caused it to fail, but it depends on the issue whether or not you can just boot the server and move along.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 07:48 AM
тАО12-08-2004 07:48 AM
Re: Oracle8
I have noticed in the logs that the following is mentioned
Alter Database backup controlfile to trace
Time stamp
Completed: alter database backup controlfile to trace
just before each night when the backup goes in.
The above is also mentioned when the database went down. Does that mean somebody has run our backup script and realised what they had done?
Can we tell what user has shutdown the db?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 08:09 AM
тАО12-08-2004 08:09 AM
Re: Oracle8
Alter database backup controlfile to trace;
is not a destructive statement - you can run this at anytime to create a text version of your controlfile contents - it is part of most standard backup scripts though.
If a normal cold backup procedure was run you should see something similar to
"ALTER DATABASE CLOSE NORMAL" in the log as well. This would tell you that the db was intentionally shut down.
If you found the alert_
The ORACLE_BASE environment variable is usually set to the login directory for the oracle account - but it could be anywhere.
Check your sulog to find out if another user did a switch to the oracle account - also check with any user who is part of the same group id as the oracle account ( usually DBA ) they would have permission to shutdown the database.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2004 08:13 AM
тАО12-08-2004 08:13 AM