Software Download Address:
http://mirror.cnop.net/oracle/PLSQL_install.zip
or
http://share.cnop.net/file426/1806028-428340587
1. Extract and place this archive in the root directory of the system D drive:
2. Set Environment Variables:
User Variable Settings: Right-click My Computer …
Tablespace Deletion Error:
ERROR at line 1:
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/data/oracle/oradata/xe/admindb01.dbf'
ORA-01203: wrong incarnation of …
How to Create a Read-Only User in Oracle
create user reader identified by reader123456;
grant connect,resource to reader;
grant select on AD_TEST to reader; #Use a PL/SQL tool to log in as the relevant user and grant the AD_TEST table to reader …
Scenario: After downgrading system memory configuration, Oracle fails to restart and throws an error upon startup. The system initially had a larger memory allocation, which was reduced midway. After completing the downgrade, the database cannot start normally and reports the following error:
or
ORA-00845: MEMORY_TARGET not supported on this system… Possible cause: ORACLE MEMORY_TA …
How to Enable Archivelog Mode Settings:
SQL> archive log list; #Check if archivelog mode is available
The archive destination USE_DB_RECOVERY_FILE_DEST defaults to the flash recovery area ($ORACLE_BASE/flash_recovery_area). You can view the flash recovery area info with the following SQL …
When using the EXP tool for backup export or data migration, you may sometimes encounter numerous “EXP-00091: Exporting questionable statistics” errors.
How to Fix:
Set the Linux system’s NLS_LANG environment variable to the database’s character set
1) Query the database’s …
Error Installing Oracle Client:
sqlplus64: error while loading shared libraries: libsqlplus.so …
The cause is that the relevant files were not found.
Fix: Locate the extracted instantclient_11_2 folder and copy the .so files inside to /lib:
cp …
Oracle Connection Error: Cannot Allocate Memory Fix
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 …
