copy Basic Copy [root@test ~]# cp -R /olddirectory/ /newdirectory/ -R parameter mean that copy all subfiles and subdirectories Copy directories and files with permissions [root@test ~]# cp -R -pf /olddirectory/ /newdirectory/ blkid blkid have been using for show uuid of disk partitions. You can use uuid to add in /etc/fstab file. fstab For show all…
Give Sudo Permission to User on Oracle Linux
Linux has a robust permissions system. As it enables a clear separation of roles among users, especially between the root user and your average user. Sometimes, though, you might want your average user to have some or all of root’s privileges. You can give this permissions with sudo. Give Sudo Permission [root@test ~]# visudo Note…
Oracle 11g Session Timeout Problem
Oracle 11g has a problem that is session timeout problem. You can add a row to sqlnet.ora file and listener.ora file to resolve session timeout problem. sqlnet.ora Note : Add this line to below of sqlnet.ora file. INBOUND_CONNECT_TIMEOUT=3600 listener.ora Note : Add this line to below of listener.ora file. INBOUND_CONNECT_TIMEOUT_LISTENER=3600
Oracle and Grid User bash_profile Example on Linux
bash_profile for Oracle user # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs if [ $USER = “oracle” ]; then if [ $SHELL = “/bin/ksh” ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi…
Create Oracle Asm Disks on Oracle Linux
I will create three asm disks for GRID, FRA and DATA on Oracle Linux 6.3 on VMware. Asm disks will be GRID sdc, DATA sdd, FRA sde. Partition the Disks List Disks [root@test01 dev]# ls sd* sda sda1 sda2 sdb sdb1 sdc sdd sde For 1. Disk [root@test01 dev]# fdisk /dev/sdc Device contains neither a…
SSH Connectivity Configuration For Cluster Nodes on Oracle Linux
SSH connectivity configuration provides connection among nodes without using password. If you configure ssh, nodes can connect with ssh without password. SSH configuration parameters are in path which is /home/username/.ssh/ . You have to make SSH configuration in connection user’s home directory. For example if you use oracle user for ssh connection, you have to…
Redundancy Level of Disk Group in Oracle
For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). Specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY to use storage array protection features. Various…
Ethernet Bonding on Oracle Linux 6
Bonding technology provides an additional benefit in that with multiple network interfaces effectively supporting the same communications channel, a fault within a single network interface in a bonded group does not stop communication. For example, you have a bonded setup with four network interfaces providing a single interface channel between two DRBD servers. If one…
Data Guard Protection Modes in Oracle
In some situations, a business cannot afford to lose data. In other situations, the availability of the database may be more important than the loss of data. Some applications require maximum database performance and can tolerate some small amount of data loss. The following descriptions summarize the three distinct modes of data protection. Maximum availability…
MsSQL Server 2008 R2 Failover Cluster Installation on Windows Server 2008 R2 Enterprise x64 on VMware
Failover Cluster System Benefits Protection at the instance level through redundancy Automatic failover in the event of a failure (hardware failures, operating system failures, application or service failures) Support for a broad array of storage solutions, including WSFC cluster disks (iSCSI, Fiber Channel, and so on) and server message block (SMB) file shares. Disaster recovery…