4 Replies Latest reply on Dec 18, 2019 12:06 AM by SteveCSV

    Oracle DB Developer VM - Unable to connect as sysdba

    jojacob-Oracle

      Hello All,

       

      I just downloaded Oracle DB Developer VM from https://www.oracle.com/downloads/developer-vm/community-downloads.html and loaded in my virtualhost

      Upon bringing up the box, i can connect to the DB as sqlplus system but NOT as "sqlplus / as sysdba" , why so ?

       

      oracle@localhost ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 3 12:58:17 2019

      Version 19.3.0.0.0

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

      ERROR:

      ORA-01017: invalid username/password; logon denied

       

      Enter user-name: ^C

       

      Regards,

      John Jacob

        • 1. Re: Oracle DB Developer VM - Unable to connect as sysdba
          RLH2005

          1.) Try putting the "/ as sysdba" in double quotes. 

          2.) What happens if you remove the "/ as sysdba" string and enter it at the "Enter user-name" prompt?

          3.) Is the oracle user account a member of the "dba" or "oinstall" security group?  Connecting as SQLDBA to a DB has certain OS security constraints.

          • 2. Re: Oracle DB Developer VM - Unable to connect as sysdba
            jojacob-Oracle

            No good..

             

            [oracle@localhost ~]$

            [oracle@localhost ~]$ sqlplus "/ as sysdba"

             

            SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 10 01:18:58 2019

            Version 19.3.0.0.0

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

            ERROR:

            ORA-01017: invalid username/password; logon denied

            Enter user-name: ^C

            [oracle@localhost ~]$ sqlplus

             

            SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 10 01:19:06 2019

            Version 19.3.0.0.0

             

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

            Enter user-name: / as sysdba

            ERROR:

            ORA-01017: invalid username/password; logon denied

             

            Enter user-name: ^C

            [oracle@localhost ~]$  ls -l /u01/app/oracle/product/version/db_1/bin/oracle

            -rwsr-s--x. 1 oracle oinstall 441253072 May 31  2019 /u01/app/oracle/product/version/db_1/bin/oracle

            [oracle@localhost ~]$ id

            uid=1000(oracle) gid=54321(oinstall) groups=54321(oinstall),10(wheel),980(vboxsf),54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

            [oracle@localhost ~]$

            • 3. Re: Oracle DB Developer VM - Unable to connect as sysdba
              RLH2005

              Well, I've spend my knowledge on this as I'm not using Oracle Database 19c or this pre-canned VirtualBox VM.

               

              The error/issue you're encountering is a Oracle DB issue and out of scope for the "Oracle VM Server for x86" community.  I suggest running down some Google searches on the "sqlplus sysdba fail" or "oracle 19 connect sysdba invalid username/password".  Unfortunately, many of the higher results are basically what I suggested.

               

              You may also have better luck in the VirtualBox community.

               

              Sorry I cannot be more help.

              • 4. Re: Oracle DB Developer VM - Unable to connect as sysdba
                SteveCSV

                This worked for me..

                 

                 

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

                 

                 

                Enter user-name: / as sysdba

                ERROR:

                ORA-01017: invalid username/password; logon denied

                 

                 

                 

                 

                Enter user-name: ^C

                 

                 

                [oracle@localhost ~]$

                [oracle@localhost ~]$

                [oracle@localhost ~]$

                [oracle@localhost ~]$ export  TWO_TASK=''

                [oracle@localhost ~]$

                [oracle@localhost ~]$ sqlplus

                 

                 

                SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 17 19:02:31 2019

                Version 19.3.0.0.0

                 

                 

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

                 

                 

                Enter user-name: / as sysdba

                 

                 

                Connected to:

                Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

                Version 19.3.0.0.0

                 

                 

                SQL> select instance_name from  v$instance;

                 

                 

                INSTANCE_NAME

                ----------------

                orclcdb

                 

                 

                SQL>