Administration

What Oracle Command-line Utilities Need Authentication - Oracle

by Ed Chen
January 11, 2013December 11, 2022

Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »

How to Resolve ORA-00845: MEMORY_TARGET not supported on this system

by Ed Chen
January 2, 2013April 1, 2018

If you are planning to install additional database by DBCA on a Linux server, you should notice not only the limitation of semaphores, but also… Read More »

BYTE vs CHAR in NLS_LENGTH_SEMANTICS

by Ed Chen
December 12, 2012March 21, 2023

BYTE vs CHAR in NLS_LENGTH_SEMANTICS Most of databases set NLS_LENGTH_SEMANTICS as BYTE by default, but there are some databases in Non-English country will take CHAR… Read More »

How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid

by Ed Chen
December 9, 2012December 11, 2022

When you ALTER SYSTEM to modify an initialization parameter, it sometimes fails with ORA-02097 ORA-02097: parameter cannot be modified because specified value is invalid Reproduce… Read More »

How to Archive Redo Logs to Respective Local Destinations of RAC

by Ed Chen
December 4, 2012March 29, 2018

For a RAC database, we may want to archive the redo logs to local destinations of instances rather than ASM. That is, put instance #1,… Read More »

How to Startup a Misconfigured Database ORA-00837

by Ed Chen
October 26, 2012May 31, 2023

A misconfigured database is a database which was set with wrong values of initialization parameters in SPFILE, it will prevent the database from startup. Let's… Read More »

How to Map Timestamp to SCN or Vice Versa

by Ed Chen
October 24, 2012February 20, 2023

If you are trying to do an incomplete recovery (also called Point-In-Time Recovery, PITR), you may want to know a System Change Number (SCN) using… Read More »

How to Check Current System Change Number (SCN)

by Ed Chen
October 23, 2012February 8, 2023

System Change Number Some DBAs will schedule a cron job to capture System Change Number (SCN) periodically to save as a Timestamp/SCN mapping reference. To… Read More »

« Previous
1
…
9
10
11

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