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.

Oracle LazyDBA home page