you could also login as follows:
sqlplus /nolog
connect /as sysdba

| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: oliver
[mailto:oracledba-ezmlmshield-x45796285.[Email address protected]
Sent: Friday, July 08, 2005 9:48 AM
To: LazyDBA Discussion
Subject: Re: Conn / as sysdba

Hi,
you could login to sqlplus as sysdba also like this:
Run sqlplus from command line.
User name: sys as sysdba (if it didn't work try capitals 'sys as SYSDBA')
Password: *****

That's it. Bye.

Filip Oliva

jsf napsal(a):

>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
>
>
>__________ Informace od NOD32 1.1162 (20050706) __________
>
>Tato zprava byla proverena antivirovym systemem NOD32.
>http://www.nod32.cz
>
>
>
>
>



--------
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