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

use the orapwdxx
where xx is version

to create a new password file. Move theexisting one or back it up first. It should be
in $ORACLE_HOME/database or /dbs on NT and called orapwdSID (may have .ora on the end on NT)

Just type in orapwdxx to find out the parameters

Dan
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:935264778.6601.0.pluto.d4ee154e_at_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 - 15:20:56 CDT