Oracle Database Management: Oracle 11g Active Data Guard
How to Build a High-Availability Oracle 11g Active Data Guard Environment
Category: Database
Oracle DataGuard Three Protection Modes Feature Summary
Oracle Data Guard provides three data protection modes. Here is a summary of the characteristics of each mode.
1. Maximum Protection Mode
1) This mode offers the highest level of data protection;
2) The primary database cannot commit a transaction until at least one physical standby database has received the redo log;
3) …
Oracle ORA-00439 Feature Not Enabled: Real Application Clusters Fix
This error occurs because RAC is not linked to the RDBMS home.
You can check whether RAC is linked to the RDBMS home by following these steps:
(1) Navigate to $ORACLE_HOME/rdbms/lib cd $ORACLE_HOME/rdbms/lib(2) Run the following command: nm -r …
Oracle Database Import and Export Methods
Export:
[root@localhost ~]# su oracle
[oracle@localhost root]$ exp loanadmin/123456@orcl file=/home/oracle/160926.dmp
loanadmin is the username, 123456 is the database password, orcl is the instance name (default is orcl), and file= specifies the export …
MySQL Restart Error: PID File Could Not Be Found Fix
How to Fix “MySQL Server PID File Could Not Be Found” Error
Possible causes are as follows:
1. An existing process is already running:
ps -ef|grep mysqld or ps -ef|grep mysql
kill -9 process_id
The specific service name can be adjusted according to your actual situation …
Redis Master-Slave Configuration Guide
I. Software Installation
Here we assume the master server IP is 192.168.1.100, and the slave server is 192.168.1.200
yum -y install redis Start on boot:
chkconfig –add redis chkconfig redis on
Add firewall rules:
/sbin/iptables -I INPUT -p tcp –dpo …
How to Enable Remote Connections for MySQL Database
Log into MySQL
mysql -u root -p123456
After logging into MySQL, execute the following commands: MySQL>use mysql;
MySQL>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRAN …
mysql_connect(): The mysql extension is deprecated and will be removed in the fu
php 5 versions, 5.2, 5.3, 5.4, 5.5. For fear of falling behind the times, I went straight to 5.5 on the new server, but the program threw the following error: Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or …
SQL Server 2005 Backup Set Database Differs From Existing Database Fix
I’ve always used SQL Server 2000 before, but now, keeping up with the trends and since the requirements specify using SQL Server 2005, I’m using it in the current project. There are a few things to watch out for with SQL Server 2005. For instance, when restoring a database, it doesn’t clearly separate the database and files like 2000 did …
How to Set a Non-1433 Port for SQL Server 2008
In SQL Server Configuration Manager, double-click “TCP/IP” and under TCP/IP settings, only configure the TCP port for IPALL at the bottom. Click OK and restart the SQL Server service. Open SQL Server Management Studio, and in the Server name field, enter 127.0.0.1,port number — the port number being the one you just configured …