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
OS Authentication
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
Connect to PDB as SYSDBA by ORACLE_PDB_SID
Connect as SYSDBA We usually connect to the database by / as SYSDBA without providing any password for maintenance works, such as startup, shutdown and… Read More »Connect to PDB as SYSDBA by ORACLE_PDB_SID
How to expdp PDB as SYSDBA without Password
Expdp PDB as SYSDBA If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get… Read More »How to expdp PDB as SYSDBA without Password