Re: SYSDBA

Try logging on as oracle before you connect to the database. Then connect / as sysdba.

 You won't have any pwfile users if you don't use a password file. Just a thot...

Ruth

• Original Message ----- From: "Hamid Alavi" <HamidA_at_aimdirect.co.nz> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, November 05, 2000 10:05 PM Subject: SYSDBA

> Lists,
> When i run select * from v$pwfile_users on my solaris machin returns no
> rows(oracle 8.1.5 on solaris), I have tried to connect as sysdba but
> couldn't.
> How can i grant sysdba to sys, any idea appreciate.
> also i have run GRANT SYSDBA to SYS with admin option, but no
> way(insufficent prevelege)
> I can connect as sys/password but not sys/password as sysdba????
> Thanks
>
> Hamid Alavi
> DDI 3610148
> FAX 3610102
> 111 Franklin RD Freemans Bay Auckland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: HamidA_at_aimdirect.co.nz
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Nov 08 2000 - 12:56:42 CST