Ed Chen Logic

How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it

by Ed Chen
February 3, 2023January 5, 2023

ORA-01647 Tried to move a table to another tablespace, but it failed with ORA-01647. SQL> alter table employees move tablespace example; alter table employees move… Read More »

How to Resolve ORA-00372: file cannot be modified at this time

by Ed Chen
February 2, 2023February 4, 2023

ORA-00372 Tried to update a table, but it failed with ORA-00372 and ORA-01110. SQL> show user USER is "HR" SQL> update employees set first_name =… Read More »

How to Resolve ORA-39109: Unprivileged users may not operate upon other users' schemas

by Ed Chen
February 1, 2023January 5, 2023

ORA-39109 Saw error ORA-39109 when we tried to export someone's data from the database. C:\Users\Administrator>expdp ERPAPP@APPDB1 schemas=FINAPP dumpfile=FINAPP-export.dmp logfile=FINAPP-export.log ... ORA-31631: privileges are required ORA-39109:… Read More »

How Oracle Check User Default Role

by Ed Chen
January 31, 2023March 20, 2023

User Default Role Making roles default to a user has some advantages, it automatically enables all privileges in the default roles when the user logs… Read More »

How to Resolve rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

by Ed Chen
January 30, 2023March 13, 2023

After restoring the operating system of an Oracle database server from tape, we saw something wrong. Could not load program sqlplus [oracle@test oracle]$ sqlplus /… Read More »

How to Check DB Status by Script

by Ed Chen
January 27, 2023January 5, 2023

To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »

How to Check if Oracle Database is Running

by Ed Chen
January 26, 2023March 13, 2023

To make sure that an Oracle database is alive, we can use a piece of shell script to check it. [oracle@test ~]$ vi check_database_alive.sh #!/bin/bash… Read More »

How to Patch Oracle Database 19c on Solaris (DBRU 19.17)

by Ed Chen
January 25, 2023March 4, 2023

Here are steps to apply Database Release Update (DBRU) 19.17 (p34419443) on Oracle database 19.3 on Solaris. Upload Patches Update Opatch utility Backup Oracle Home… Read More »

How to Install Oracle Database 19c on Solaris

by Ed Chen
January 24, 2023March 13, 2023

There're 2 phases of the installation of Oracle database 19c (19.3) as below. OS Configuration Installation Please note that, if you want your database server… Read More »

How to Resolve PRVF-7573 : Sufficient swap size is not available on node

by Ed Chen
January 23, 2023January 17, 2023

PRVF-7573 or PRVF-07573 Saw an error PRVF-7573 when Oracle Universal Installer (OUI) 19c perform a prerequisite check. PRVF-7573 : Sufficient swap size is not available… Read More »