Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to grant SYSDBA privilege to user?
Hi,
Here is the solution for UNIX. So sorry I don't realy know NT.
step1 )
Execute the fllowing command to create the orapwd$ORACLE_SID file. cd $ORACLE_HOME/dbs orapawd file=orapw$ORACLE_SID password=sys_password entries=128 step2) Change the init.ora file remote_login_passwordfile=exclusive setp3) shutdown + startup setp4) grant sysoper to sysman ;
Check you documentation for NT change.
--
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg.
Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between
France,Germany and Belgium.
Mike Harrison wrote in article <6mm1kr$s50_at_edrn.newsguy.com>...
> I am having a problem. A consultant recently reinstalled our Oracle
7.3.2.3.1 NT
> server and I can no longer shutdown the database. It says "Insufficient
> privileges" when I try to log on as sysman with SYSDBA. Also, he set a
password
> on the Internal user and didn't tell me what it was? How do I a) get
SYSDBA
> privileges, and b) reset the internal password?
>
> Thanks in advance.
>
> Mike Harrison
> Mike.Harrison_at_bmo.com
>
> ------------------
> Spam free Usenet news http://extra.newsguy.com
>
Received on Wed Jun 24 1998 - 02:57:07 CDT