Ed Chen Logic

How to Resolve UDI-28002: operation generated ORACLE error 28002

by Ed Chen
November 4, 2022November 6, 2022

UDI-28002 Saw error UDI-28002 when using expdp or impdp to migrate data. UDI-28002: operation generated ORACLE error 28002 ORA-28002: the password will expire within 7… Read More »

How to Make a WhiteList for DB Connection

by Ed Chen
November 3, 2022November 18, 2022
2 Comments

Database Whitelist If there's only a few clients that use the database, we can make a whitelist to explicitly accept those clients. We take 2… Read More »

How to Make a BlackList for DB Connection

by Ed Chen
November 2, 2022November 18, 2022

Database Blacklist Unexpected connections may be seen in your listener log, we can make a blacklist to explicitly block those clients. We take 2 steps… Read More »

How to Resolve ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

by Ed Chen
November 1, 2022October 17, 2022

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

How to Resolve PRCT-1562 : The startup of instances for database are still in progress

by Ed Chen
October 31, 2022November 2, 2022

PRCT-1562 or PRCT-01562 Saw an error PRCT-1562 or PRCT-01562 when I tried to start a RAC database. [oracle@primary01 ~]$ srvctl start database -d orclcdb -o… Read More »

How to Resolve ORA-01432: public synonym to be dropped does not exist

by Ed Chen
October 28, 2022October 17, 2022

ORA-01432 Tried to drop a public synonym, but it failed with ORA-01432. SQL> drop public synonym country; drop public synonym country … Read More »

How to Resolve ORA-01434: private synonym to be dropped does not exist

by Ed Chen
October 27, 2022October 17, 2022

ORA-01434 Tried to drop a private synonym, but it failed with ORA-01434. SQL> show user USER is "OE" SQL> drop synonym country; drop synonym country… Read More »

How to Enable AUTOTRACE

by Ed Chen
October 26, 2022October 17, 2022

Enable AUTOTRACE To get full AUTOTRACE feature in your session, you should take the following steps. Need PLAN_TABLE table to be accessed in user's schema.… Read More »

How to Install PLUSTRACE Role

by Ed Chen
October 25, 2022October 23, 2022

To enable AUTOTRACE feature in your session, you not only need to create PLAN_TABLE table, but also need PLUSTRACE role, which is not native in… Read More »

How to Install PLAN_TABLE Table

by Ed Chen
October 24, 2022October 23, 2022

To enable AUTOTRACE feature in your session, you not only need PLUSTRACE role to be installed, but also need to create PLAN_TABLE table, which is… Read More »