Ed Chen Logic

How to Resolve ORA-3136 Inbound Connection Timed Out

by Ed Chen
October 11, 2012February 7, 2023
2 Comments

ORA-3136 At times, some users complained about connection timeout, and you saw error messages ORA-3136 in sqlnet.log as such: Fatal NI connect error 12170. … Read More »

Search Order of Parameter File for Startup

by Ed Chen
October 10, 2012December 11, 2022

Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And I think you… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012December 11, 2022

Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »

How RMAN Set NLS_DATE_FORMAT

by Ed Chen
October 9, 2012April 23, 2023

NLS_DATE_FORMAT for RMAN After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log,… Read More »

3 Ways to Set RMAN Log Location

by Ed Chen
October 9, 2012December 11, 2022

RMAN Log Location RMAN is a client side utility like sqlplus used to interoperate with DB, we usually compose a script file or a batch… Read More »

When RMAN met Resource Manager

by Ed Chen
October 9, 2012June 20, 2023

Users notified DBA that they found AP responded longer than normal starting from 22:00 everyday, especially when a period of running RMAN on the host,… Read More »

How to Set Password for Listener

by Ed Chen
September 29, 2010November 24, 2021

Earlier databases like 9i should set password for listeners, otherwise, they could be accidentally stopped by someone unknown. Here in this post, I will introduce… Read More »

How Oracle Enable ARCHIVELOG Mode

by Ed Chen
September 25, 2010December 11, 2022

What is Archivinglog Mode? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which… Read More »

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