Monday, August 31, 2015

Grant SYSDBA role to SYSTEM user on Oracle

SYSTEM user by default is not a dba, and this is an issue when you are trying to do Installations with  Oracle tools such as RCU.

Being the DBA just connect with sqlplus as sysdba

/home/omurillo$ sqlplus / as sysdba

SQL*Plus: Release Production on Mon Aug 31 09:39:23 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> grant sysdba to system;
Grant succeeded.

And you are done.

Post a Comment