Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: connect sys/manager as sysdba
Most likely you have your remote_login_password_file parameter in
init<SID>.ora set to none or there is no parameter, which means it is none.
With this setting only internal is being capable of using SYSDBA. With the
parameter set to shared both internal and SYS are capable. Set to exclusive
you can grant SYSDBA to any user.
The remedy is start setting the variable to shared, ie edit init<sid>.ora
and bounce the database.
Hth,
--
Sybrand Bakker, Oracle DBA
SJWNet <scottjw_at_my-deja.com> wrote in message
news:83gmkf$tat$1_at_nnrp1.deja.com...
> At the SVRMGR command line I am connect using "connect sys/manager".
> That connection is fine. When I try to connect "connect sys/manager as
> sysdba", I am getting an Oracle-01017 error message (invalid
> username/password; logon denied). I am tring to connect as sysdba to
> do a shutdown immediate, then create a database from the SVRMGR command
> line. I am using Oracle8 Personal Edition (8.0.4.0.0) and Oracle8
> Navigator. How is the SYSDBA privelege granted to the user sys in this
> instance? When I attempt to grant the SYSDBA privelege to the user sys
> in the Oracle8 Navigator, I get the ORA-01031 error message
> (insufficient priveleges). I want to approace this from SVRMGR and
> Oracle8 Navigator. What is the remedy/cure to this approach?
>
> --
> SJWNet
> NT Novice
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Dec 18 1999 - 15:41:32 CST
![]() |
![]() |