Re: Insufficient Privileges (svrmgrl)

Roar,

Hi there.
You need to make sure that you are logged in (to your operating system) AS the DBA user recognized by your Oracle installation. THEN when you run svrmgrl, and do a connect internal, it won't give you that problem.

For example, we are using Oracle 8.0.4 on a SUN Solaris 2.6 machine. The Oracle DBA login to the UNIX system is "oracle". When I need to run svrmgrl or lsnrctl, I login into the SUN as "oracle".

Then the "connect internal" works fine.

However, EVEN IF I were to login to the UNIX system as the "root", or super-user, then even then, I would STILL get denied access to the svrmgrl upon connect internal.

Hope that helps.
You need t find out which user-id on your system is recognized by the Oracle server to be it's DBA user id.

That should take care of your problem.

Good luck...
--
James Arvigo

• SQL Server & Oracle DBA
• Software & Intranet Developer
• Thrifty Call, Inc. via The Maxim Group
• Austin, Texas *----------------------------------------------------------
• EMAILS:
• Work: JamesA -AT- ThriftyCall.com
• Home: JArvigo -AT- Hotmail.com *
• ( Sorry I had obfuscate the emails... *sigh* )

  ---

  Roar Pettersen wrote:

> We've got a couple of instances running Oracle 7.3.4 on
> an SGI/IRIX workstation. Today one of the databases
> had stopped (unknown for what reason), and when we tried
> starting it again using svrmgrl and "connect internal",
> it asked for a password. It's never done that before!?!
> After trying two times, it gives the following message:
>
> ORA-01031: insufficient privileges
>
> Well, as the incredibly intelligent creatures we are, we
> decided to boot the workstation, because we suspected
> some memory problems after someone had been fiddling with
> shared memory. This only resulted in the exact same error
> on the other instance (that was running just fine before
> the boot)
>
> Now I've got two databases down, and I can't get them up.
> What do I do? (I've searched DejaNews, and some people have
> suggested creating a new userid with dba-group, but that
> doesn't help. Somebody also suggested unsetting TWO_TASK...
> same result)
>
> Is there some way to disable this "password asking"?
>
> --
> Roar Pettersen
> roarp_at_bigfoot.com
Received on Wed Jul 29 1998 - 10:04:37 CDT