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. …
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 …
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 …
