Administration

How to Resolve ORACLE_HOME_LISTNER is not SET

by Ed Chen
February 4, 2018January 1, 2023

ORACLE_HOME_LISTNER is not SET dbstart Got this error when I used dbstart to startup all required instances: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle… Read More »

Where is Oracle PFILE Location

by Ed Chen
September 9, 2017December 11, 2022

If we were trying to change parameters in an unfamiliar database that was handed over from other DBA, we have to figure it out whether… Read More »

How Oracle Change Character Set

by Ed Chen
March 25, 2017December 11, 2022

Assuming that you have exported all the data to dump files for later processes. Database Character Set Check current setting on character sets. SQL> column… Read More »

How to Suspend an Oracle Session

by Ed Chen
July 9, 2016February 14, 2023

Given a session which was consuming lots of resource on Oracle database server, what should we do about the session? Killing the session might be… Read More »

How to Check Archive Log Size

by Ed Chen
June 30, 2016January 24, 2023

In this post, I will talked about the following 3 topics. How to Define Archive Log Size? Are all Archive Logs the Same Size? How… Read More »

How to Know Everything about an Unfamiliar Database

by Ed Chen
June 14, 2016February 2, 2023

In an unfamiliar environment, if there's only oracle or grid account is available for DBA to use, how can he to know everything about the database… Read More »

SQL Developer Change Language

by Ed Chen
May 28, 2016December 22, 2022

SQL Developer English UI SQL Developer automatically apply the default language of your Windows environment when every start of itself, but sometimes, English interface is… Read More »

Why Should I Know DBID of a Database

by Ed Chen
May 19, 2016September 24, 2021

Different database has their own DBID that can make recovery catalog distinguish which is which, but in the same data guard infrastructure, the database, either… Read More »

What Symbols are Used in Oracle Database

by Ed Chen
May 5, 2016October 29, 2021

Several symbols that are used in Oracle might represent different meanings in different place. Question mark ? ORACLE HOME ? (a Question Mark) in a… Read More »

You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...

by Ed Chen
May 4, 2016March 29, 2018

According to SQL syntax of Oracle database, you can't resize the data files by using ALTER TABLESPACE except the tablespace was created as BIGFILE, but… Read More »