1 2 Previous Next 16 Replies Latest reply: Apr 16, 2014 5:02 AM by tvCa-Oracle Go to original post RSS
      • 15. Re: Change Oracle Applications R12.1.1 SYS account default password
        Hussein Sawwan-Oracle

        Using a TNS string combined with "as sysdba" doesn't really work ..

        This will never work (I think), even if the password is actually correct, because TNS authentication does not allow to pass:

         

        sqlplus sys/change_on_install@r12erp as sysdba

         

        It does work for me.

         

        Thanks,

        Hussein

        • 16. Re: Change Oracle Applications R12.1.1 SYS account default password
          tvCa-Oracle

          You're both right, there's a related issue, but it's just a bit different :

           

           

           

          [oracle@server ~]$ sqlplus /@VIS as sysdba

           

          SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 16 11:42:01 2014

           

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

           

          ERROR:

          ORA-01017: invalid username/password; logon denied

           

           

          Enter user-name:

          ERROR:

          ORA-01017: invalid username/password; logon denied

           

           

          Enter user-name:

          ERROR:

          ORA-01017: invalid username/password; logon denied

           

           

          SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

          [oracle@server ~]$ sqlplus apps/apps@VIS

           

          SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 16 11:42:45 2014

           

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

           

           

          Connected to:

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

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

           

          SQL> exit

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

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

          [oracle@server ~]$

          1 2 Previous Next