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…
Category: Databases
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…
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…
Manual Install Enterprise Manager in Oracle
If you did not install Enterprise Manager, you could install manually DbConsole (Enterprise Manager). You have to execute below commands. If dbsnmp user is locked, you have to do unlock this user. Because dbsnmp user will use for EM installation. Install EM Open Command Prompt set ORACLE_HOME=c:\path\to\oracle\home set ORACLE_SID=DB_SID emca.bat -config dbcontrol db Note :…
RMAN List Command in Oracle
RMAN List Command queries can use for the historical information on the backups. The various options you can use with List command and their uses are discussed below. List Commands Examples RMAN> LIST ARCHIVELOG ALL; RMAN> LIST BACKUP OF ARCHIVELOG ALL; RMAN> LIST BACKUP; RMAN> LIST BACKUP OF DATABASE; RMAN> LIST BACKUP OF DATAFILE 1;…
Show First and Last Value of Data in Oracle
You can show first and last value of data which changes with update. Also you can show all values. Example Select versions_starttime, versions_endtime, salary from employees versions between scn minvalue and maxvalue where last_name=’King’;
Constraint Deferrable Types in Oracle
Constraints’s check time depend on deferrable parameters. If the parameter is set immediate, check time of your query is before the transaction is commit. Also, query will check when you execute query. If the parameter is set deferred, query will check when the transaction is commit; Deferrable initially immediate Deferrable initially deferred