Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

MariaDB centos 7

[root@clusterserver1 ~]# yum -y install mariadb mariadb-server Loaded plugins: fastestmirror Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast base                                                                                                                                                                               | 3.6 kB  00:00:00 epel/x86_64/metalink                                                                                                                                                               | 3.9 kB  00:00:00 epel                                                                                                                                                                               | 4.3 kB  00:00:00 extras                                                                                                                                                                             | 3.4 kB  00:00:00 updates                                                                                                                                                                            | 3.4 kB  00:00:00 (1/4): extras/7/x86_64/primary_db                                                                                                                                                  | 101 kB  00:00:00 (2/4): […]

Snapshot database in SQL Server

What is a database snapshot ?

Database snapshots are an Enterprise only feature which was introduced  in SQL Server 2005.A database snapshot is a view of what the source database looked like at the time when the snapshot was created.

How does a snapshot work:-

a. When you create a snapshot a sparse file is […]

Reset SA Password in Sql Server 2012

Step 1:- Change SQL SA password from a command prompt

Go to the command prompt of the server and type in command prompt osql –L C:\Users\Administrator>osql -L

Servers: localhost

Step 2:- Copy full name of SQL Server and type: OSQL -S <insert_servername_here> -E C:\Users\Administrator>osql -S localhost -E

Step 3:- Execute the following query: sp_password […]

Recover database without control files and redolog files.

 Recover database without control files and redolog files. Scenario:- We are deleting controlfiles from database and would recover database after dropping them.

Database version :- Oracle 11g R2 OS: Rhel 6 Database sid: orcl Archivelog mode: enabled

Step1:- $cd /u01/app/oracle/oradata/orcl $rm -rf *.ctl

$sqlplus / as sysdba SQL>startup ORACLE instance started.

Total System Global Area […]

How to sync standby database which is lagging behind from primary database

How to sync standby database which is lagging behind from primary database Primary Database cluster: cluster1.rmohan.com Standby Database cluster: cluster2.rmohan.com

Primary Database: prim Standby database: stand

Database version:11.2.0.1.0

Reason:- 1. Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to […]

How to start/stop oracle database from linux command prompt

How to start/stop oracle database from linux command prompt How to start/stop oracle database from linux command prompt:- [oracle@configsrv1 ~]$vi /etc/oratab #

# This file is used by ORACLE utilities.  It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database.

# A colon, ‘:’, is used as […]

CentOS 7 used rpm install MySQL 5.7

$  wget http://repo.mysql.com/mysql57-community-release-el7-7.noarch.rpm

$ rpm -ivh mysql57-community-release-el7-7.noarch.rpm

[root@cluster1 ~]# rpm -ivh mysql57-community-release-el7-7.noarch.rpm warning: mysql57-community-release-el7-7.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing…                ########################################### [100%] 1:mysql57-community-relea########################################### [100%]

$  yum install mysql-server

So far, mysql57 has been successfully installed. Now try to log on to use the root mysql, an error ERROR 1045 (28000): Access denied […]

allow NFS access on Centos 7 and RHEL 7

Enable NFS server systemctl enable nfs-lock.service systemctl enable nfs-server.service systemctl start nfs-lock.service systemctl start nfs-server.service cat >/etc/firewalld/services/mountd.xml <<EOD <?xml version=”1.0″ encoding=”utf-8″?> <service> <short>mountd</short> <description>Mount Lock Daemon</description> <port protocol=”tcp” port=”20048″/> <port protocol=”udp” port=”20048″/> </service> EOD cat >/etc/firewalld/services/rpc-bind.xml <<EOD <?xml version=”1.0″ encoding=”utf-8″?> <service> <short>rpc-bind</short> <description>Remote Procedure Call Bind</description> <port protocol=”tcp” port=”111″/> <port protocol=”udp” port=”111″/> </service> EOD restorecon […]