RE: Granting sysdba to a user

Do you have a password file ? ( $ORACLE_HOME/dbs/orapw$ORACLE_SID ) You may have reached the max # of SYSDBA users ( default is 5 ), so recreate this file with a higher number of users :

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=<password> users=10 ( or more )

> ----------
> From: raman.yagna_at_db.com[SMTP:raman.yagna_at_db.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, June 27, 2000 09:34
> To: Multiple recipients of list ORACLE-L
> Subject: Granting sysdba to a user
>
> Hi all,
> Sorry for the previous mail. Clicked the wrong icon (send) .
>
> My environment is
> ORacle 8.1.6 .
> Aix 4.3.2
> What should i do to grant SYSBDA to user created .
> Now its failing with the following error ,
>
> ORA-01994: GRANT failed: cannot add users to public password file
>
> I connect as ,
>
> sqlplus /nologs
> connect / as sysdba
>
> regards,
> Raman
>
>
> ---------------------- Forwarded by Raman Yagna on 27/06/2000 14:24
> ---------------------------
>
>
> To: ORACLE-L_at_fatcity.com
> cc:
>
> Hi all,
> I'm new to DBA related jobs. My boss wants to grant sysdba to a
> user .
>
> regards,
> Raman
>
>
>
>
> --
> Author:
> INET: raman.yagna_at_db.com
>
> 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 Tue Jun 27 2000 - 04:01:03 CDT