Archive Log Files Created With Permission Bit 440 Instead Of 640 [ID 458901.1]
Archive Log Files Created With Permission Bit 440 Instead Of 640 [ID 458901.1] | To Bottom |
Modified:Jun 19, 2010Type:PROBLEMStatus:ARCHIVEDPriority:3 |
|
In this Document
Symptoms
Cause
Solution
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4This problem can occur on any platform.
Symptoms
All the Oracle archive log files are created with permission bit 440 instead of 640.
-r--r----- 1 oracle dba 524287488 Sep 10 15:17 PROD_1275.arc
The umask has been set to 022(default value) before starting the database.
Cause
VERITAS 4.1.20.00 ODM Library, Version 1.1 is running on this system as indicated by the following entry in the alert.log:
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Oracle instance running with ODM: VERITAS 4.1.20.00 ODM Library, Version 1.1
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
When ODM is initialized it alters the file permissions of archive logs and places them in read only
mode.
Solution
Disable the Veritas ODM feature so that the permissions of the archive log files are not altered and remain with the correct permission mode as per the umask setting.How to Enable/Disable the Veritas ODM for Oracle database [ID 755159.1] | To Bottom |
Modified:Dec 19, 2011Type:HOWTOStatus:PUBLISHEDPriority:3 |
|
In this Document
Goal
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7 - Release: 9.2 to 11.1Information in this document applies to any platform.
Goal
This document describes the procedures for Enable/Disable Oracle Disk Manager driverSolution
We assume Veritas ODM driver is installed, mounted and available.
The following steps to enable/disable ODM for Oracle database (note that with different versions of the Solaris OS, the path may change to the ODM files).
Enable ODM
i) Shutdown the database
ii) Change directories:
$ cd $ORACLE_HOME/lib
iii) Take a backup of existing original ODM library
PA systems
$ mv $ORACLE_HOME/lib/libodm10.sl $ORACLE_HOME/lib/libodm10.sl.org
IA systems
$ mv $ORACLE_HOME/lib/libodm10.so $ORACLE_HOME/lib/libodm10.so.org
(* Note 9i library name ie libodm9.so,10g is libodm10.so and 11g is libodm11.so)
iv) create a soft link to veritas ODM library
PA systems
ln -s /opt/VRTSodm/lib/libodm.sl $ORACLE_HOME/lib/libodm10.sl
IA systems
ln -s /opt/VRTSodm/lib/libodm.so $ORACLE_HOME/lib/libodm10.so
iv) Start the database and check
Once the database instance is enabled with ODM, the following message is displayed in the Oracle alert log:
Example :-
âÃÂÃÂOracle instance running with ODM: VERITAS 4.1 ODM Library, Version 1.1âÃÂÃÂ
Disable ODM
Log in as oracle user.
i) Shutdown the database
ii) Change directories:
$ cd $ORACLE_HOME/lib
iii) Remove the softlink
$ cd $ORACLE_HOME/lib
PA systems
$ rm libodm10.sl
IA systems
$ rm libodm10.so
iv) Copy the orginal $ORACLE_HOME/lib/libodm10.sl or libodm10.so file back to disable the ODM library.
PA systems
$ cp $ORACLE_HOME/lib/libodm10.sl.org $ORACLE_HOME/lib/libodm10.sl
IA systems
$ cp $ORACLE_HOME/lib/libodm10.so.oracle $ORACLE_HOME/lib/libodm10.so
v) Start the database
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8242091/viewspace-753418/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to config (no)archivelog mode and manage archive log files by RMANHive
- Error: Permission denied @ apply2filesErrorAPP
- log_archive_dest與log_archive_dest_n區別Hive
- Checking for Oracle archive log corruption [ID 1268590.1]OracleHive
- 【轉】詳解log_archive_dest與log_archive_dest_n區別Hive
- 關於 log_archive_dest與log_archive_dest_n a的區別Hive
- Windows 下備份 archive logWindowsHive
- archive log 歸檔日誌Hive
- alter system archive log current noswitch!!Hive
- alter system archive log current / all / switch logfileHive
- Scripts to resize standby redolog files
- Archive Log模式下Redo Log、Check Point和Switch LogHive模式
- logminer工具對redo log或archive log的挖掘Hive
- ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DESTHive
- standby_archive_dest和log_archive_dest_n區別Hive
- Managing multiple archive log destinations with RMAN (Doc ID 443814.1)Hive
- 使用LOGMNR工具分析Oracle Redo Log和Archive Log教程Oracle RedoHive
- LOG_ARCHIVE_DEST_n詳解Hive
- oracle archive log 歸檔日誌OracleHive
- Archive log mining steps(logminer to html)HiveHTML
- alter system archive log current和alter system switch logfileHive
- Enabling Archive Log mode in OracleHiveOracle
- Oracle archive log 歸檔日誌管理OracleHive
- db_writer_processes-log_archive_max_processesHive
- DROP AND RECREATE ONLINE REDOLOG FILES
- restore archive logs toalternative location they already reside on disk_399894.1RESTHiveIDE
- LOG_ARCHIVE_DEST_n 中的各屬性 (包括valid_for等)Hive
- alter system switch log file 與 archive log current/all 區別Hive
- Android permission許可權Android
- 測試log_archive_dest_1與log_archive_format對生成的歸檔檔名的影響HiveORM
- 【Android】Permission denied (missing INTERNET permission?)異常踩坑Android
- archive log 歸檔模式 啟動關閉Hive模式
- Recover physical standby database after loss of archive log(2)DatabaseHive
- oracle 引數LOG_ARCHIVE_FORMAT 的格式OracleHiveORM
- [LeetCode] 937. Reorder Log FilesLeetCode
- 10 Awesome Examples for Viewing Huge Log Files in UnixView
- setuid-setgid-sticky-bitUI
- SUID/SGID以及sticky bitUI