💡 While running the database error following error occurred: ERROR: RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channe l at 08/16/2018 04:53:13 ORA-19504: failed to create…
Xử lý như sau sqlplus sys/sysdba as sysdba 1. SQL> startup mount; 2. SQL>show parameter undo NAME TYPE VALUE ———————————— ———– —————————— undo_management string AUTO undo_retention integer 900 undo_tablespace string…
💡 Khi resize datafile để giải phóng datafile bị thừa thì xuất hiện lỗi ORA-03297: file contains used data beyond requested RESIZE value 🚚 Solution Chạy câu lệnh sau để…
💡 Ổ cứng bị đầy check log file bị nhiều cần xóa bớt đi ta dùng adrci 1. Start ADRCI: -bash-4.3$ . oraenv ORACLE_SID = [+ASM1] ? +ASM1 The Oracle…
1. Câu lệnh: dd if=/dev/zero of=/dev/sda bs=512 count=1 conv=notrunc dd if=/dev/zero of=/dev/sda wipefs -a /dev/sda
Cài trên server 1 – installing unixodbc on zabbix server yum -y install unixODBC unixODBC-devel 2- installing instant client packages <https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html> # rpm -ivh oracle-instantclient12.1-basic-12.2.0.1.0-1.x86_64.rpm # rpm -ivh oracle-instantclient12.1-odbc-12.2.0.1.0-1.x86_64.rpm…
Gia hạn thêm 180 ngày To extend the evaluation license follow the below procedure. Open an elevated command prompt. Type following command **slmgr -dlv** or **cscript.exe %windir%\system32\slmgr.vbs /dlv** you…
1) Kiểm tra trước trong Source database: Step 1 : Kiểm tra kích thước cơ sở dữ liệu trong SOURCE: select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select…
🚚 When trying to connect to an Oracle database, you might run into this error: ORA-01045: user xxx lacks CREATE SESSION privilege; logon denied The reason is that the…
1. Câu lệnh: umount -l /PATH/OF/BUSY-DEVICE umount -f /PATH/OF/BUSY-NFS (NETWORK-FILE-SYSTEM)