SYSDBA

How to Resolve ORA-39087: directory name is invalid

by Ed Chen
May 11, 2023May 12, 2023

ORA-39087 Saw errors ORA-39087 and ORA-39070, when tried to export data AS SYSDBA through data pump expdp. [oracle@test ~]$ expdp \"/ as sysdba\" full=y directory=BACKUP_DUMPS… Read More »

How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

by Ed Chen
March 10, 2023February 15, 2023

ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »

How to Resolve ORA-65175: cannot grant SYSDBA privilege locally in the root

by Ed Chen
December 7, 2022May 9, 2023

ORA-65175 Tried to grant SYSDBA privilege to SYSTEM, but it failed with ORA-65175. SQL> show user USER is "SYS" SQL> grant sysdba to system; grant… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021June 2, 2023
2 Comments

ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »

How Oracle Purge RecycleBin

by Ed Chen
November 21, 2020March 15, 2023

In this post, we'll talk about the following topics. Feature of Recyclebin Prerequisite of Using Recyclebin Ways to Purge Recyclebin Feature of Recyclebin Since 10g,… Read More »

How to Resolve SP2-0382: The SHOW PDBS command is not available

by Ed Chen
April 3, 2019February 4, 2021

SP2-0382 SP2-0382 means that the connected user are not privileged as SYSDBA, so SQL*Plus SHOW PDBS command is not available to the user. SQL> conn… Read More »

How to impdp AS SYSDBA without Password

by Ed Chen
May 13, 2016April 11, 2021

impdp AS SYSDBA Like I talked about expdp as sysdba in the previous post, we usually use system who has sufficient privileges to perform data… Read More »

SYSDBA vs SYSOPER Privileges

by Ed Chen
October 13, 2012February 3, 2023

SYSDBA vs SYSOPER According to Oracle documentation about administrative accounts and privileges, I compared their privileges between SYSDBA and SYSOPER as below: Allowed Actions SYSDBA… Read More »

Who has SYSDBA Privilege?

by Ed Chen
October 13, 2012December 11, 2022

SYSDBA Privilege SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012December 11, 2022

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 »

JavaScript is not enabled. Please enable it and reload the page.