Hi Diego
If you would use SYSDBA or SYSOPER user, you must in
init<SID>.ora set remote_login_passwordfile = exclusive
After shutdown and startup instance (if you change init file it is
necessary)
...
grant sysdba to normal_user (internal default has SYSDBA)
...
username and password SYSOPER and SYSDBA user Oracle keep in two places: in
database (normal) and in external file pwd<sid>.ora
Before startup instance ORACLE uses external file.
Diego Peroni napisał(a) w wiadomości: <75l8aj$gt$1_at_sharon.cilea.it>...
>Anyone can help me to logon in Oracle 8.0.4 as SYSDBA or SYSOPER ?
>I'm able to connect as normal user without big problems, but i can't shut
>down or start up Oracle istance (mount, no mount, open) as normal user.
>
>In Enterprice Manager File|Preference I've changed my role to SYSDBA but
>when I try to connect as SYSDBA it's impossible
>
>In Security Manager I've given all privileges to the normal user ....but
>nothing
>
>I've changed the pass to the SYS user but nothing to do when I try to
>connect.... I can connect as SYS user just as normal user......WHY?
>
>Please Help me
>Thanks,
>Diego
>
>
>
>
Received on Mon Dec 21 1998 - 10:02:09 CST
