sqlplus

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 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 »

How to Resolve rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

by Ed Chen
January 30, 2023March 13, 2023

After restoring the operating system of an Oracle database server from tape, we saw something wrong. Could not load program sqlplus [oracle@test oracle]$ sqlplus /… Read More »

SQLPlus Connect and Disconnect

by Ed Chen
December 16, 2022February 22, 2023

SQLPlus Connect To connect a database, we usually use sqlplus, a text-based connection tool provided by Oracle to facilitate clients to connect to a running… Read More »

Oracle Change User Password

by Ed Chen
November 28, 2022February 21, 2023

Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »

Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn username/password@chicago-db-server:1521/ORCL Connected. Or… Read More »

How DBMS_SERVICE.CREATE_SERVICE

by Ed Chen
March 8, 2021November 3, 2022

How to Use DBMS_SERVICE to Create a New Service? The default service name of a database is the DB_UNIQUE_NAME, if we'd like to add some… Read More »

How to Add Service to PDB

by Ed Chen
March 6, 2021January 24, 2023

By default, Container Database (CDB) provides only one service for every Pluggable Database (PDB) for connections, but we can create our own services for various… Read More »

Database States Differentiations in Oracle

by Ed Chen
February 10, 2021January 12, 2023

We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »

How to Find Oracle DBID

by Ed Chen
December 30, 2020July 1, 2022

DBID Database Identifier (DBID) is a unique number that can be identified by RMAN so as to do backup and restore whenever needed. In some… Read More »