berikut solusi dari metalinkharap membantu Problem Summary:
================
ORA-01092 starting up Oracle RDBMS database.
Problem Description:
====================
When you startup your Oracle RDBMS database, you receive the following error:
ORA-01092: ORACLE instance terminated. Disconnection forced.
Problem Explanation:
====================
Oracle cannot write to the alert_<SID>.log file because the
ownership and/or permissions on the BACKGROUND_DUMP_DEST directory
are incorrect.
Solution Summary:
=================
Modify the ownership and permissions of directory BACKGROUND_DUMP_DEST.
Solution Description:
=====================
To allow oracle to write to the BACKGROUND_DUMP_DEST directory (contains
alert_<SID>.log), modify the ownership of directory BACKGROUND_DUMP_DEST
so that the oracle user (software owner) is the owner and make the
permissions on directory BACKGROUND_DUMP_DEST 755.
Follow these steps:
1. Determine the location of the BACKGROUND_DUMP_DEST parameter
defined in the init<SID>.ora or config<SID>.ora files.
2. Login as root.
3. Change directory to the location of BACKGROUND_DUMP_DEST.
4. Change the owner of all the files and the directory to the
software owner.
For example:
% chown oracle *
5. Change the permissions on the directory to 755.
% chmod 755 .
Solution Explanation:
=====================
Changing the ownership and permissions of the BACKGROUND_DUMP_DEST
directory, enables oracle to write to the alert_<SID>.log file.
--- On Fri, 27/6/08, Wahyudinata Herry <[EMAIL PROTECTED]> wrote:
From: Wahyudinata Herry <[EMAIL PROTECTED]>
Subject: Re: [indo-oracle] ora-01092
To: [email protected]
Date: Friday, 27 June, 2008, 2:50 PM
haloo
apabila saat start up muncul Ora-01092,
bisa disebabkan oracle tidak bisa me, write alert_<SID>. log file karena
ownership / permission di BACKGROUND_DUMP_ DEST directory incorrect
coba dimodify ownership dan permissions directory BACKGROUND_DUMP_ DEST
regards
hery
--- On Fri, 6/27/08, musisi musisi <tc2681_2006@ yahoo.com. sg> wrote:
From: musisi musisi <tc2681_2006@ yahoo.com. sg>
Subject: [indo-oracle] ora-01092
To: "Indo oracle" <indo-oracle@ yahoogroups. com>
Date: Friday, June 27, 2008, 2:21 AM
para master oracle,
mohon pencerahan solusi untuk error ORA-01092 Oracle instance terminated,
disconnection forced.
tolong bantuannya
terima kasih
Get your preferred Email name!
Now you can @ymail.com and @rocketmail. com
http://mail. promotions. yahoo.com/ newdomains/ sg/
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
New Email addresses available on Yahoo!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/sg/
[Non-text portions of this message have been removed]
