ORACLE_SID

How to Resolve ORA-12162: TNS:net service name is incorrectly specified

by Ed Chen
March 29, 2023March 20, 2023

ORA-12162 To know how to solve ORA-12162 depends on where the database is. A local database? or an external database? Local Database A local database… Read More »

How to Install Oracle Database 19c on Linux

by Ed Chen
March 2, 2023June 1, 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 Check if Oracle Database is Running

by Ed Chen
January 26, 2023March 13, 2023

To make sure that an Oracle database is alive, we can use a piece of shell script to check it. [oracle@test ~]$ vi check_database_alive.sh #!/bin/bash… Read More »

How to Install Oracle Database 19c on Solaris

by Ed Chen
January 24, 2023March 13, 2023

There're 2 phases of the installation of Oracle database 19c (19.3) as below. OS Configuration Installation Please note that, if you want your database server… Read More »

Where is DBCA Log Location

by Ed Chen
December 31, 2021April 22, 2022

DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »

How to Resolve TNS-01201: Listener cannot find executable

by Ed Chen
October 11, 2021June 8, 2022

TNS-01201 After adding a static service to the local listener, I tried to start the listener, but it failed with TNS-01201. [oracle@test ~]$ vi $ORACLE_HOME/network/admin/listener.ora… Read More »

How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect

by Ed Chen
March 20, 2021June 30, 2022

ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »

How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 23, 2021October 24, 2021

In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »

How to Change DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 20, 2021July 12, 2021

In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »

How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.

by Ed Chen
December 23, 2020March 16, 2021

ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… Read More »

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