Re: NT4 & Oracle 8.0.4: Install (as SYSDBA) problem.

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 21 Aug 1999 21:45:51 +0200
Message-ID: <935264778.6601.0.pluto.d4ee154e@news.demon.nl>

Hi Stephen,
The behavior depends on the setting of remote_login_passwordfile in init.ora (I might have missed an underscore, I never remember) There are three values:
none : only the user internal will have sysdba privilege shared: the user internal and SYS will have sysdba privilege. Note: this doesn't work if their passwords are different. exclusive: SYSDBA privilege can be granted to any user. My (educated) guess: the default of that parameter is none(that I know to be true) and you forgot to change it.

Hth,

Sybrand Bakker, Oracle DBA

Stephen Hurrell <hurrells_at_baynet.net> wrote in message news:37BEF280.EC4EF816_at_baynet.net...
> Hello.
>
> I have installed Oracle 8.0.4 for NT4Wks. I can connect as system or sys
> as normal and do most things..
>
> However I am unable to connect as SYSDBA/SYSOPER in order to
> shutdown/startup the database.
> "connect internal" ask for a passwd which is different behavior that
> I've seen on other instances.
>
> When I use svrmgrl or OEM to login as sysdba/sysoper I get ORA-01017:
> invalid username/password; logon denied
>
> Why can I login as system or sys as normal and do work but not as
> SYSOPER?SYSDBA.
>
> Thanks in Advance...
> STeve
>
Received on Sat Aug 21 1999 - 14:45:51 CDT