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
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
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
Installation Guide on Windows for All Releases of Oracle Database
In this post, we collect installation guides on Windows for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »Installation Guide on Windows for All Releases of Oracle Database
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