ORADIM Create Services and Registries
ORADIM In an active/passive cluster, we usually install Oracle software and configure listener in the redundant server, then stop. This is because we don't need… Read More »ORADIM Create Services and Registries
ORACLE_SID
How to Install Oracle Database 21c on Linux
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 Database 21c on Linux
Enable Non-Oracle User Run SQL*Plus
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 »Enable Non-Oracle User Run SQL*Plus
How to Resolve ORA-12162: TNS:net service name is incorrectly specified
ORA-12162 To know how to solve ORA-12162 depends on where the database is. A local database? or an external database? Local Database (ORACLE_SID) A local… Read More »How to Resolve ORA-12162: TNS:net service name is incorrectly specified
How to Install Oracle Database 19c on Linux
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 Database 19c on Linux
How to Check if Oracle Database is Running
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 Check if Oracle Database is Running
How to Install Oracle Database 19c on Solaris
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 »How to Install Oracle Database 19c on Solaris
Where is DBCA Log Location
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 »Where is DBCA Log Location
How to Resolve TNS-01201: Listener cannot find executable
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 TNS-01201: Listener cannot find executable
How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
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 Resolve ORA-12505: TNS:listener does not currently know of SID given in connect