ALTER SYSTEM SET

NLS_INSTANCE_PARAMETERS, How and Why

by Ed Chen
July 17, 2023June 19, 2023

What is NLS_INSTANCE_PARAMETERS ? NLS_INSTANCE_PARAMETERS is a dictionary view which shows default NLS parameters of an instance. Let's see their values. SQL> set pagesize 1000;… Read More »

Oracle Parameter SESSIONS, How and Why

by Ed Chen
May 31, 2023August 31, 2023

In 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 »

NLS_DATE_FORMAT, How and Why

by Ed Chen
April 14, 2023July 24, 2023

NLS_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 »

How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use

by Ed Chen
December 23, 2022May 12, 2023

ORA-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-65040: operation not allowed from within a pluggable database

by Ed Chen
November 18, 2022October 25, 2022

ORA-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-01109: database not open

by Ed Chen
June 5, 2021June 2, 2023
2 Comments

ORA-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-00059: maximum number of DB_FILES exceeded

by Ed Chen
November 2, 2019May 15, 2023

ORA-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 »

Connect-Time Failover to Standby Database

by Ed Chen
May 11, 2019September 4, 2023
10 Comments

We'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 »

Alter System Scope, SID and Container

by Ed Chen
April 6, 2016October 23, 2022

ALTER 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 »

How to Resolve ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)

by Ed Chen
March 25, 2014December 11, 2022

ORA-12519 in Enterprise Manager Found ORA-12519 when trying to connect to the database by using dbconsole

JavaScript is not enabled. Please enable it and reload the page.