March 2016
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
28293031  

Categories

March 2016
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
28293031  

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 […]

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 […]