Oracle Parameter SESSIONS, How and Whyby Ed ChenMay 31, 2023June 1, 2023In this post, we'd like to talk about the following topics for you to manage SESSIONS parameter better. Default Value of SESSIONS How to Check… Read More »Oracle Parameter SESSIONS, How and Why
NLS_DATE_FORMAT, How and Whyby Ed ChenApril 14, 2023April 26, 2023NLS_DATE_FORMAT defines the display format of a datetime string, which can be set at various levels to meet business requirements. That is to say, NLS_DATE_FORMAT… Read More »NLS_DATE_FORMAT, How and Why
How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in useby Ed ChenDecember 23, 2022May 12, 2023ORA-32001 ORA-32001 means that the database cannot write SPFILE at this moment, you should make sure that it has been using by the instance. Let's… Read More »How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use
How to Resolve ORA-65040: operation not allowed from within a pluggable databaseby Ed ChenNovember 18, 2022October 25, 2022ORA-65040 Tried to do something on all PDB, but it failed with ORA-65040. Alter Pluggable Database All SQL> alter pluggable database all open instances=all; alter… Read More »How to Resolve ORA-65040: operation not allowed from within a pluggable database
How to Resolve ORA-01109: database not openby Ed ChenJune 5, 2021June 2, 20232 CommentsORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »How to Resolve ORA-01109: database not open
How to Resolve ORA-00059: maximum number of DB_FILES exceededby Ed ChenNovember 2, 2019May 15, 2023ORA-00059 Found ORA-00059 when adding a new datafile to an existing tablespace, creating a new tablespace or a pluggable database, it told us that the… Read More »How to Resolve ORA-00059: maximum number of DB_FILES exceeded
Connect-Time Failover to Standby Databaseby Ed ChenMay 11, 2019January 29, 20218 CommentsWe're going to introduce 3 ways that can failover to a standby database at connect-time in this post. Using a Persistent Service Name Using a… Read More »Connect-Time Failover to Standby Database
Alter System Scope, SID and Containerby Ed ChenApril 6, 2016October 23, 2022ALTER SYSTEM SET When we issue ALTER SYSTEM SET to modify parameter, some scope clauses can be used to specify how new value is applied… Read More »Alter System Scope, SID and Container
How to Resolve ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)by Ed ChenMarch 25, 2014December 11, 2022ORA-12519 in Enterprise Manager Found ORA-12519 when trying to connect to the database by using dbconsole