Note: For Redis installation and startup, we use the user jjzb here. Please create the relevant user in advance. The installation path is /home/jjzb/redis; you can modify it according to your situation.
1.Compile and install [root@localhost ~]#yum -y install gcc gcc-c++ libstdc++-devel tcl wget vim …
Here are the issues encountered during today’s performance testing, summarized below.
1. Problem
While testing a certain interface, it was found that the keyspace_misses in Redis kept increasing, meaning the number of cache misses was continuously rising.
2. Troubleshooting and Analysis Process
1) The number of keys returned by the DBSIZE command was greater than the count obtained from KEYS *, indicating…
After a recent server migration, some views and stored procedures in the new server’s Oracle database became garbled. PL/SQL Developer was used during the process. Below is the export and import procedure using PL/SQL Developer, shared for your reference.
1. Export:
Open the PL/SQL tool, click …
When installing Oracle 11g on Oracle Linux, there are certain requirements for the OS shared memory (/dev/shm) — its size must not be less than the memory allocated for Oracle use
[root@localhost ~]# cat /etc/fstab | grep shm
tmpfs …
SQL> alter database open; #The command fails with the following error: ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data fi …
ORACLE Startup Error:
ORA-00401: the value for parameter compatible is not supported by this release
Cause:
The database version in the spfileorcl.ora file does not match the actual version. Fix it by editing: vi /data/oracle/product/11.2.0/db_1/db …
Error Symptoms:
ORA-00211: control file does not match previous control filesORA-00202: control file: '/data/oracle/flash_recovery_area/orcl/control02.ctl'
#My Oracle installation path is under /data
Cause …
Error Symptom: ORA-01078: failure in processing system parameters
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system …
Using file /data/oracle/product/11.2.0/db_1/dbs/initdb1.ora
Start with command:
startup pfile='/data/oracle/product/11.2.0/db_1/dbs/initdb1.ora';
Startup error:
ORA-01506: missing or illegal database nam …
1.Solution 1
Active Data Guard (Oracle 11g Data Guard)
Prior to Oracle 11g, a primary-standby relationship typically consisting of two data mirror nodes was used to achieve rapid database switchover and disaster recovery, which we call Data Guard. Active Data Guard …
