.bash_profile

How to Install Oracle Database 21c on Linux

by Ed Chen
July 7, 2023August 31, 2023

We supposed that you already have installed Oracle Linux 8, Red Hat Enterprise Linux 8 or its derivatives like AlmaLinux for your database server. There're… Read More »

Enable Non-Oracle User Run SQL*Plus

by Ed Chen
June 29, 2023September 6, 2023

Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »

How to Install Oracle Database 19c on Linux

by Ed Chen
March 2, 2023June 22, 2023
2 Comments

We supposed that you already have installed Oracle Linux 8, Red Hat Enterprise Linux 8 or its derivatives like AlmaLinux for your database server. There're… Read More »

How to Install Oracle Instant Client 19c on Linux

by Ed Chen
March 1, 2023February 15, 2023

Suppose that you have known the differences between Oracle client and Oracle instant client, and decide to install Oracle instant client for your machine. On… Read More »

SSH Remote "Command not found"

by Ed Chen
December 27, 2022January 2, 2023

Remote: command not found Tried to execute a command on a remote server simply by using SSH tunnel, but it failed with "command not found".… Read More »

How to Clone Oracle Home

by Ed Chen
December 19, 2022February 13, 2023

Cloning Database Home Cloning an Oracle database home to another place by clone.pl might be more complicated than you thought, especially in a RAC environment.… Read More »

How to Resolve opatchauto must run from one of the homes specified

by Ed Chen
September 30, 2020September 14, 2020
2 Comments

opatchauto must run from one of the homes specified Met an error when I tried to apply a patch by root. [root@primary01 ~]# opatchauto apply… Read More »

How to Resolve WebLogic Slow Startup

by Ed Chen
March 15, 2019December 10, 2022

WebLogic Startup Slow After long WebLogic installation, I found that every time I startup WebLogic Server, it looked stuck and took about 10 to 15… Read More »

How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers

by Ed Chen
December 15, 2018June 22, 2023
4 Comments

For 19c, you may refer to: How to Build 19c RAC - 1 of 4 - Preparing Two Database Servers. Network Design for RAC Let's… Read More »

How to expdp AS SYSDBA without Password

by Ed Chen
May 13, 2016August 15, 2023
8 Comments

expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at… Read More »

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