User: [Email Address Removed] as sysdba
Password: your_password
Mit freundlichen Grüßen
i. V. Volker Schoen
INPLAN RUHR
Informationstechnik GmbH
Tel.: +49 208 / 65 91 - 950
Fax: +49 208 / 65 91 - 980
E-Mail: mailto:v.[Email address protected]
http://www.inplan.de
-----Ursprüngliche Nachricht-----
Von: jsf [mailto:oracledba-ezmlmshield-x93427291.[Email address protected]
Gesendet: Dienstag, 5. Juli 2005 18:11
An: LazyDBA Discussion
Betreff: Re: Conn / as sysdba
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
>
--------
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