Thank you Adalberto, but isn't there any way of connecting as sysdba just
issuing "sqlplus" and filling the 'login' and 'password:' fields?
How about the first question? Does anybody have an idea of what could be
the ploblem?
Thanks a lot!
Juliano
>
> Hi Juliano,
>
> Try sqlplus "/ as sysdba"
>
> Bye
>
> Adalberto Fiorini
>
> ----- Original Message -----
> From: "jsf" <oracledba-ezmlmshield-x66898237.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Tuesday, July 05, 2005 12:43 PM
> Subject: Conn / as sysdba
>
>
>> Hi there,
>>
>> 2 questions:
>>
>> 1) I'm logging in linux as the 'oracle' user but when trying to 'connect
>> /
>> as sysdba' it gives me 'insufficient privileges' error...
>> All environment variables (ORACLE_SID, ORACLE_HOME, etc) are set, and
>> the
>> param REMOTE_LOGIN_PASSWORDFILE = exclusive.
>> Shouldn't I be able to login using '/ as sysdba' wher logged in OS with
>> the 'oracle' user? The manager said 'conn / as sysdba' used to work, but
>> another DBA did something wrong and it doesn't work anymore... Any ideas
>> about what to check and how could I fix it?
>>
>>
>> 2) This should be easy but I don't know how to connect as sysdba without
>> issuing 'sqlplus /nolog' -> 'conn / as sysdba'
>> Ex:
>>
>> c:\> sqlplus
>> LOGIN: <what do I put here to login as sysdba?>
>> PASSWORD: <what do I put here to login as sysdba?>
>>
>> I hope you can help me. Thanks so much!
>>
>> Juliano Freitas
>>
>>
>>
>>
>>
>>
>> --------
>> website: http://www.LazyDBA.com
>> Please don't reply to RTFM questions
>> Oracle documentation is here: http://tahiti.oracle.com
>> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>> To subscribe: see http://www.lazydba.com
>> By using this list you agree to these
>> terms:http://www.lazydba.com/legal.html
>>
>>
>
>
> As informações contidas neste e-mail e nos arquivos anexados podem ser
> informações confidenciais ou privilegiadas. Caso você não seja o
> destinatário correto, apague o conteúdo desta mensagem e notifique o
> remetente imediatamente.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
Oracle LazyDBA home page