How Srvctl Status VIP
Srvctl Config VIP Before checking the status of VIP by srvctl, we need to know VIP name in this cluster. [grid@primary01 ~]$ srvctl config vip… Read More »How Srvctl Status VIP
How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode
ORA-65054 Tried to open a pluggable database (PDB), but it failed with ORA-65054. Let's see how it happened. SQL> alter session set container=ORCLPDB; Session altered.… Read More »How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode
How to Resolve ORA-30012: undo tablespace does not exist or of wrong type
ORA-30012 Tried to restart a normal database after changing the default undo tablespace, but it failed with ORA-30012. SQL> startup ORACLE instance started. ... Database… Read More »How to Resolve ORA-30012: undo tablespace does not exist or of wrong type
How to Resolve ORA-01536: space quota exceeded for tablespace
ORA-01536 Tried to use CTAS to make a table in a tablespace, but it failed with ORA-01536. SQL> create table t1 tablespace users as select… Read More »How to Resolve ORA-01536: space quota exceeded for tablespace
How to Resolve ORA-00922: missing or invalid option
ORA-00922 Tried to grant some quota on tablespace to an user, but it failed with ORA-00922. SQL> alter user hr quota 100g on tablespace users;… Read More »How to Resolve ORA-00922: missing or invalid option
How to Resolve ORA-01258: unable to delete temporary file
ORA-01258 We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log. SQL> drop tablespace… Read More »How to Resolve ORA-01258: unable to delete temporary file
How to Resolve UDI-00014: invalid value for parameter
UDI-00014 Saw error UDI-00014 when using impdp to import some tables. [oracle@test ~]$ impdp system/password@orclpdb tables=hr.employees remap_table=hr.employees,emp_bak dumpfile=expdp-full.dmp ... UDI-00014: invalid value for parameter, 'remap_table'… Read More »How to Resolve UDI-00014: invalid value for parameter
How to Resolve UDI-28002: operation generated ORACLE error 28002
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 Resolve UDI-28002: operation generated ORACLE error 28002
How to Make a WhiteList for DB Connection
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 WhiteList for DB Connection
How to Make a BlackList for DB Connection
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 Make a BlackList for DB Connection