3 Replies Latest reply: Sep 27, 2013 12:43 AM by EasonBryant RSS

    "sqlplus / as sysdba" and "sqlplus /nolog;conn / as sysdba"

    7f6f98e1-f516-40b1-b28b-6c1dde70f972

      Hi,

      What is the difference between "sqlplus / as sysdba"

      and

      "sqlplus /nolog;conn / as sysdba"?

       

      when "sqlplus / as sysdba", it could not "alter user system identified by password;

      when "sqlplus /nolog;conn / as sysdba", it could "alter user system identified by password"

      why??

       

      Thanks.

        • 1. Re: "sqlplus / as sysdba" and "sqlplus /nolog;conn / as sysdba"
          Anar Godjaev

          Hi

           

          sqlplus /nolog

          > sqlplus /nolog

           

          SQL*Plus: Release 9.2.0.6.0 - Production on Wed Sep 14 10:26:21 2011

           

          Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

           

          SQL> show user

          USER is ""

          • Not connecting to any user

          • Not connecting to any instance/database

          sqlplus /as sysdba

          > sqlplus "/as sysdba"

           

          SQL*Plus: Release 9.2.0.6.0 - Production on Wed Sep 14 10:29:25 2011

           

          Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

           

          Connected to:

          Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

          With the Partitioning option

          JServer Release 9.2.0.6.0 - Production

           

          SQL> show user

          USER is "SYS"

          • Connected to user “SYS”

          • Connected to database with the ORACLE_SID environment variable and sysdba authority

           

          Thank you

          • 2. Re: "sqlplus / as sysdba" and "sqlplus /nolog;conn / as sysdba"
            Paul M.

            What is the difference between "sqlplus / as sysdba"

            and

            "sqlplus /nolog;conn / as sysdba"?

            No difference.

            when "sqlplus / as sysdba", it could not "alter user system identified by password;

            when "sqlplus /nolog;conn / as sysdba", it could "alter user system identified by password"

            why??

            Don't know what you mean :

            $ sqlplus /nolog

             

            SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 25 15:31:58 2013

             

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

             

            SQL> conn / as sysdba

            Connected.

            SQL> alter user system identified by manager;

             

            User altered.

             

            SQL> exit

            Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

            With the Partitioning, OLAP, Data Mining and Real Application Testing options

            $ sqlplus / as sysdba

             

            SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 25 15:32:20 2013

             

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

             

            Connected to:

            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

            With the Partitioning, OLAP, Data Mining and Real Application Testing options

             

            SQL> alter user system identified by manager;

             

            User altered.

             

            SQL>

            • 3. Re: "sqlplus / as sysdba" and "sqlplus /nolog;conn / as sysdba"
              EasonBryant

              Thank u, I try it again, no difference.