Showing posts with label Files`that need to use in Oracle Database administration. Show all posts
Showing posts with label Files`that need to use in Oracle Database administration. Show all posts

Thursday, June 25, 2015

Files`that need to use in Oracle Database administration

Useful Files In Linux

 Path    
 Description
 /etc/passwd
 User Settings
 /etc/group
  Group settings for users.  
 /etc/hosts
 Host name lookup information
 /etc/sysctl.conf                   
 Kernel parameters for Linux.                
 /var/log/messages
 Check System and error logs and messages
 /etc/oratab
  Oracle Registered instance (DBCA) 
 /etc/fstab
Files to check for File System entries
 /home/oracle/.bash_profile
Oracle user profile setting file in Linux.
 /proc/meminfo      
To determine To determine the RAM size
/etc/redhat- release
get the OS release information
 /etc/security/limits.conf
 Specify process and open files related limits 
 /etc/selinux/config
Enable or disable security feature.

Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...