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
OSDBA
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
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 PRVF-7566 : User "oracle" does not belong to group "oper" on node
PRVF-7566 or PRVF-07566 Saw an error PRVF-7566 when Oracle Universal Installer (OUI) 19c perform a prerequisite check. PRVF-7566 : User "oracle" does not belong to… Read More »How to Resolve PRVF-7566 : User "oracle" does not belong to group "oper" on node
Usermod Add Group to User
Add Group to User Let's print current id of the user. [root@primary01 ~]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba) In this case, we would like to… Read More »Usermod Add Group to User
RunInstaller 19c Silent Mode
By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »RunInstaller 19c Silent Mode
How to Connect Idle, Nomount or Restricted Database Remotely
Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »How to Connect Idle, Nomount or Restricted Database Remotely