[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): […]
|
||||||
|
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 […] 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. 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 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:- [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 […] $ 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 […] 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 […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments