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
Windows Server
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-19693: backup piece already included
ORA-19693 We saw error ORA-19693 when we tried to restore some archived logs from backup sets in a newly duplicated database. RMAN> catalog start with… Read More »How to Resolve ORA-19693: backup piece already included
How to Resolve ORA-48140: the specified ADR Base directory does not exist
ORA-48108 ORA-48140 ORA-48187 OSD-00002 Tried to startup a database on Windows, but it failed with several errors like ORA-48140. SQL> startup nomount; ORA-48108: invalid value… Read More »How to Resolve ORA-48140: the specified ADR Base directory does not exist
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
How to Resolve OSD-04002: unable to open file
OSD-04002 In this case, we tried to backup database to a specific location by formatting its path, but it failed with OSD-04002. RMAN> backup database… Read More »How to Resolve OSD-04002: unable to open 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
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
How to Install Oracle Database 21c on Windows
For Oracle database 19c installation on Windows, you may go for it. Extract Oracle DB Home 21.3 Image Since release 18c, all database software installation… Read More »How to Install Oracle Database 21c on Windows
How to Build 19c RAC on Windows - 4 of 4 - Creating a RAC Database
We click on Database Configuration Assistant (DBCA) in the menu to initiate the database creation process. We had better to restart both nodes to verify… Read More »How to Build 19c RAC on Windows - 4 of 4 - Creating a RAC Database