The specific error message is as follows. The database cannot be shut down normally, indicating a missing database file:
SQL> shutdown immediate;
ORA-01116: error in opening database file 6
ORA-01110: data file 6: '/data/oracle/product/11.2.0/db_1oradata …
Oracle Startup Error: ORA-00845 MEMORY_TARGET Not Supported on This System Fix
ORA-00845: MEMORY_TARGET not supported on this system：
The cause is that the Oracle MEMORY_TARGET size was previously set, but the shm size on this system is insufficient, resulting in startup failure.
Solution: vi /etc/fstab Find: tmpfs …
1. Switch to the Oracle user directory #su – oracle
[oracle@localhost ~]$ sqlplus / as sysdba
SQL> @?/rdbms/admin/awrrpt
It asks for the report format here; the default is HTML, so just press Enter (as shown in the image above).
In the image above, directly enter: 1 , which generates a snapshot report for recent days. …
Introduction:
MHA (Master High Availability) is a relatively mature solution for MySQL high availability, developed by youshimaton from DeNA Japan (now at Facebook). It is an excellent high-availability software for failover and master-slave promotion in MySQL high-availability environments. …
— Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.
mysqldump -uroot -pxxxxx –all-databases > all.sql
When exporting databases with mysqldump, MySQL shows “– Warnin …
Oracle User Login Prompt: ORA-28000: the account is locked
Solution: sqlplus / as sysdba
sql>alter user username account unlock;
User altered.
By default, the database locks the user after 10 failed login attempts:
1. Check FAILED_LOGIN_A …
Oracle installation stuck at the Perform Prerequisite Checks step, as shown below:
Cause: The /etc/security file does not have access permissions. Grant temporary access to resolve this.
chmod -R 755 /etc/security
After installation, you can restore stricter permissions:
chmod -R 600 /etc/security …
1、SHOW Command:
Display RMAN configuration: RMAN> show all;
2、REPORT Command:
2.1、RMAN> report schema Report the physical structure of the target database;
2.2、RMAN>report need backup days=3; Report dat …
Today, while setting up Redis Sentinel, I got stuck on -sdown sentinel and couldn’t get automatic master-slave failover to work.
Configuration is as follows: port 26379
daemonize yes
logfile "/home/redis/logs/sentinel.log"
sentinel announce-ip 192.168.0.201 …
Redis Cluster Startup Error:
[ERR] Node 192.168.0.201:7001 is not empty. Either the node already knows other nodes (check with CLUSTER NODES) or contains some key in database 0.
Using my 3.2.6 as an example …
