Oracle Parameter SESSIONS, How and Why
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 »Oracle Parameter SESSIONS, How and Why
ALTER SYSTEM SET
NLS_DATE_FORMAT, How and Why
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 »NLS_DATE_FORMAT, How and Why
How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use
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-32001: write to SPFILE requested but no SPFILE is in use
How to Resolve ORA-65040: operation not allowed from within a pluggable database
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-65040: operation not allowed from within a pluggable database
How to Resolve ORA-01109: database not open
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-01109: database not open
How to Resolve ORA-00059: maximum number of DB_FILES exceeded
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 »How to Resolve ORA-00059: maximum number of DB_FILES exceeded
Connect-Time Failover to Standby Database
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 »Connect-Time Failover to Standby Database
Alter System Scope, SID and Container
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 »Alter System Scope, SID and Container
How to Resolve ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)
ORA-12519 in Enterprise Manager Found ORA-12519 when trying to connect to the database by using dbconsole