Re: ORA-01031 while connecting to ASM instance.
Date: Thu, 12 May 2011 02:30:47 +0400
Message-ID: <BANLkTi=emO3C5poXH9WF5D=-5S1AKRN+cw_at_mail.gmail.com>
Thanks for the help so far. I tried all the suggestions, without luck. I'm on 10g, single node RAC. I do not see asm registered when I run crs_stat.
$ crs_stat | grep -i asm
$
ASM is up and running, though.
On Thu, May 12, 2011 at 2:19 AM, Amaral, Rui
<Rui.Amaral_at_tdsecurities.com> wrote:
> Try double quotes around "user/pass as sysdba".
>
>
>
>
>
> From: David Fitzjarrell [mailto:oratune_at_yahoo.com]
> Sent: Wednesday, May 11, 2011 05:34 PM
> To: nadeem.m.khan_at_gmail.com <nadeem.m.khan_at_gmail.com>;
> oracle-l_at_freelists.org <oracle-l_at_freelists.org>
> Subject: Re: ORA-01031 while connecting to ASM instance.
>
> Are there any special characters, such as /, in the password?
>
> David Fitzjarrell
>
>
> ________________________________
> From: Nadeem M. Khan <nadeem.m.khan_at_gmail.com>
> To: oracle-l_at_freelists.org
> Sent: Wed, May 11, 2011 2:31:18 PM
> Subject: ORA-01031 while connecting to ASM instance.
>
> $ sqlplus sys/XXXX_at_ASM1 as sysdba
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Thu May 12 01:27:10 2011
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
> ERROR:
> ORA-01031: insufficient privileges
>
> What could I be missing? This is on Linux. Am not using a password
> file. oracle is part of the dba group. I can tnsping ASM1.
>
> TIA.
> Nadeem.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> NOTICE: Confidential message which may be privileged. Unauthorized
> use/disclosure prohibited. If received in error, please go to
> www.td.com/legal for instructions.
> AVIS : Message confidentiel dont le contenu peut être privilégié.
> Utilisation/divulgation interdites sans permission. Si reçu par erreur,
> prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 11 2011 - 17:30:47 CDT