Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can't logon as SYSDBA ....
MotoX answer is almost correct.
1 make sure there is a passwordfile on the server (creation is usually done
through the orapwd utility, exact syntax changes from platform to platform)
2 make sure the following line is in your init<sid>.ora
remote_password_file=exclusive
3 bounce the database and connected as internal on the server grant sysdba or
sysoper privileges to the users you wish
4 you can verify this by
select * from v$passwordfile_users
5 I believe the INTERNAL account will disappear with the next release (8i?),
it has been marked obsolete by Oracle.
Hth,
Sybrand Bakker, Oracle DBA
MotoX wrote:
> If my memory serves me right (and *check the docs*) you have to create
> password files on the server for authentication of *remote* sys and
> system users via server manager.
>
> Like I said, check this up in the docs and release notes. I appreciate
> your problem, I hit it to. But it does work once you set it up right.
>
> MotoX.
>
> On Mon, 21 Dec 1998 11:38:25 +0100, "Diego Peroni" <peroni_at_cefriel.it>
> wrote:
>
> >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 - 14:21:35 CST