3 Replies Latest reply: Aug 5, 2011 3:30 PM by 585179 RSS

    Cannot connect TNS-Alias as sysasm

    hqt200475
      Hi,


      I have set the password
      orapwd FILE=$ORACLE_HOME/dbs/orapw+ASM 
      to grid !


      and get the following problem:
      /u01/app/11.2.0.2/grid/network/admin>sqlplus sys/grid@ASM1 as sysasm
      
      
      SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 4 17:29:01 2011
      
      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
      
      ERROR:
      ORA-01031: insufficient privileges
      
      
      Enter user-name:
      /u01/app/11.2.0.2/grid/network/admin>sqlplus sys/grid@ASM1 as sysdba
      
      SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 4 17:29:11 2011
      
      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
      
      
      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      With the Real Application Clusters and Automatic Storage Management options
      
      SQL>
      My Question:
      Why did I have not enough privileg as sysasm? but enough privileg as sysdba?
      regards

      hqt200475
        • 1. Re: Cannot connect TNS-Alias as sysasm
          585179
          hqt200475 wrote:
          Hi,
          Why did I have not enough privileg as sysasm? but enough privileg as sysdba?
          regards

          hqt200475
          it could be because t sys is not granted as sysasm privilege

          run
          SQL > grant sysasm to sys;


          and try again


          Hope this helps


          Cheers
          • 2. Re: Cannot connect TNS-Alias as sysasm
            hqt200475
            Hi Fiedi,

            Thank for your Tip! It works!

            A small problem:
            /home/grid>sqlplus / as sysasm
            
            SQL*Plus: Release 11.2.0.2.0 Production on Fri Aug 5 11:29:16 2011
            
            Copyright (c) 1982, 2010, Oracle.  All rights reserved.
            
            
            Connected to:
            Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
            With the Real Application Clusters and Automatic Storage Management options
            My beginner question:
            As what user does sqlplus start here? (OS-User?) Can I see it in any view ?
            regards

            hqt200475

            Edited by: hqt200475 on Aug 5, 2011 2:44 AM

            Edited by: hqt200475 on Aug 5, 2011 2:59 AM
            • 3. Re: Cannot connect TNS-Alias as sysasm
              585179
              hqt200475 wrote:
              Hi Fiedi,

              Thank for your Tip! It works!

              A small problem:


              My beginner question:
              As what user does sqlplus start here? (OS-User?) Can I see it in any view ?
              regards

              hqt200475
              HI,

              Great if it works now!

              When using sqlplus you're using OS user as the grid owner and when connected to asm you're connecting as sys


              Cheers