ORA-00600 6856
ORA-00600 6856 APPLIES TO Oracle Database - Enterprise Edition - version 11.2.0.4.0 SYMPTOMS 数据库异常宕机重新启动后，实例自动关闭无法拉起，告警日志 alert_orcl.log 出现以下错误： time='2022-01-15T17:37:25.255 08:00' org_id='oracle' comp_id='rdbms'type='UNKNOWN' level='16' host_id='localhost.localdomain'host_addr='::1' pid='53213'ORACLE Instance xxxxx (pid = 25) - Error 607 encountered while recovering transaction (37, 8) on object 5341044.time='2022-01-15T17:37:25.255+08:00' org_id='oracle' comp_id='rdbms'type='UNKNOWN' ...
ORA-01152
ORA-01152 APPLIES TO Oracle Database - Enterprise Edition - version 11.2.0.4.0 SYMPTOMS Open resetlogs has an error with ORA-01152: file 1 was not restored from a sufficiently old backup RMAN> alter database open resetlogs;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of alter db command at 03/05/2013...
ORA-12547
ORA-12547 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4.0 Oracle Grid Infrastructure - version 11.2.0.4.0 SYMPTOMS dbca 建库时，弹出 ORA-12547 报错。 CAUSE 操作系统缺少 baio 依赖包。 SOLUTION 安装完后，重新执行 dbca 建库。 ~]$ yum -y install baio~]$ rpm -qa | grep baiolibaio-devel-0.3.109-13.el7.x86_64libaio-0.3.109-13.el7.x86_64
ORA-27302
ORA-27302 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 12.1.0.2.0 Oracle Grid Infrastructure - version 12.1.0.2.0 SYMPTOMS 节点 2 alert_+ASM2.log 日志文件持续出现如下错误: Tue Mar 29 07:31:25 2022skgxpvfynet: mtype: 61 process 4632 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4)Errors in file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_m000_4632.trc (incident=179220):ORA-00603: ORACLE server ...
ORA-17503
ORA-17503 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4.0 Oracle Grid Infrastructure - version 11.2.0.4.0 SYMPTOMS GI 群集正常，ASM 磁盘挂载正常，启动数据库报错： ORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DATA/coco/spfilecoco.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/coco/spfilecoco.oraORA-12547: TNS:lost contact CAUSE Oracle binary should have permission of 6751. To correct the permissio...
Configure MySQL to start on boot with systemd
Configure MySQL to start on boot with systemd Add a systemd service unit configuration file with details about the MySQL service $> cd /usr/lib/systemd/system$> touch mysqld.service$> chmod 644 mysqld.service Add this configuration information to the mysqld.service file [Unit]Description=MySQL ServerDocumentation=man:mysqld(7)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=my...
How to reset root password
How to reset root password MySQL 5.7.6 and later Modify /etc/my.cnf, append skip-grant-tables. sed -i '/[mysqld]/a skip-grant-tables' /etc/my.cnf Restart mysql server, update root password. select user,host,authentication_string from mysql.user;update mysql.user set authentication_string=password('Jove!123') where user='root';flush privileges; MySQL 5.7.5 and earlier Modify /etc/my.cnf, append skip-grant-tables. sed -i '/[mysqld]/a skip-grant-tables' /etc/my.cnf Restart mysql server, updat...
Installing MySQL on Linux Using YUM Repository
Installing MySQL on Linux Using YUM Repository 5.7 # Adding the MySQL YUM Repository.sudo yum localinstall mysql57-community-release-el7-{version-number}.noarch.rpmsudo yum-config-manager --enable mysql57-community# Disabling the Default MySQL Module.sudo yum module disable mysql# Installing MySQL.sudo yum install mysql-community-server# Starting the MySQL Server.sudo systemctl enable mysqld --now# Get root temporary password in the error log file.sudo grep 'temporary password' /var/log/my...
SQLServer AlwaysOn Database Cannot Shrink Log File
SQLServer AlwaysOn Database Cannot Shrink Log File SQLServer - 2016 After the AlwaysOn database transaction log is truncated, the log file cannot be shrink, resulting in a large amount of disk space occupied by the log file. Solution If you have scheduled T-Log Backup on alwaysOn Database, After completion of T-Log Backup check the log_reuse_wait_desc of database using query select name,log_reuse_wait_desc from sys.databases where name like 'Name Of Database'; If column log_reuse_wait_des...
Orphaned Users of SQLServer
Orphaned Users of SQLServer Detect orphaned users. SELECT dp.type_desc, dp.sid, dp.name AS user_nameFROM sys.database_principals AS dpLEFT JOIN sys.server_principals AS sp ON dp.sid = sp.sidWHERE sp.sid IS NULL AND dp.authentication_type_desc = 'INSTANCE'; Resolve an orphaned user. CREATE LOGIN <login_name>WITH PASSWORD = '<use_a_strong_password_here>',SID = <SID>;ALTER USER <user_name> WITH Login = <login_name>;ALTER LOGIN <login_name> WITH PASS...
