How to Add User to OSDBA Group
OSDBA Group In the previous post, we have talked about how to enable an user other than administrator (Windows) or oracle (Linux) to use SQL*Plus… Read More »How to Add User to OSDBA Group
Linux
How to Check Group of OSDBA
OSDBA or OSOPER OSDBA and OSOPER are just a symbol name defined by Oracle database, users belonged to either group are natively granted to use… Read More »How to Check Group of OSDBA
How to Resolve ORA-31640: unable to open dump file
ORA-31640 Tried to import data into the database from a dump file, but it failed with ORA-31640. Linux [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp… Read More »How to Resolve ORA-31640: unable to open dump file
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
Which Process Listening to Specific Port
To check which process is listening to a specific port on Linux or AIX, we use commonly supported command netstat to know it: Check Port… Read More »Which Process Listening to Specific Port
Installation Guide on Linux for All Releases of Oracle Database
In this post, we collect installation guides on Linux for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »Installation Guide on Linux for All Releases of Oracle Database
How to Resolve DBT-06006: Unable to create directory
DBT-06006 Saw error DBT-06006 when we tried to create a database by Database Configuration Assistant (DBCA). [FATAL] [DBT-06006] Unable to create directory: (/oradata/ORCLCDB/). CAUSE:… Read More »How to Resolve DBT-06006: Unable to create directory
How to Install Oracle Instant Client 19c on Linux
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 Install Oracle Instant Client 19c on Linux
Where is oraInst.loc Location
oraInst.loc oraInst.loc stores Oracle product inventory path and installation group. For different OS, the location of oraInst.loc could vary. Here is the list to show… Read More »Where is oraInst.loc Location