Re: Operating system authentication for DBA

From: Mukesh Singh <mksingh72_at_yahoo.com>
Date: 11 Feb 2002 06:08:05 -0800
Message-ID: <5d671409.0202110608.6e2b7639@posting.google.com>

Hi,

Here is error messages and the commands i tried.

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Feb 11 08:51:08 2002

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE. SQL> !id
uid=1129(dwloder) gid=255(dba) groups=1(staff),324(prism),247(ftpdata)

SQL> conn /
Connected.
SQL> show parameter password

NAME                                 TYPE    VALUE
------------------------------------ ------- ------------------------------
remote_login_passwordfile            string  NONE

SQL> connect internal;
Enter password:
ERROR:
ORA-01031: insufficient privileges

SQL> quit

$ uname -a
AIX s0dwaf1n5 3 4 006009814C00

$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning and Parallel Server options JServer Release 8.1.7.2.0 - Production

SVRMGR> connect internal;
Connected.
SVRMGR> !id
uid=1129(dwloder) gid=255(dba) groups=1(staff),324(prism),247(ftpdata) SVRMGR> quit
Server Manager complete.

Hope this helps. Please let me know if any other information is required.

Thanks,
Mukesh

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:<c7J98.569$6R3.508676243_at_newssvr13.news.prodigy.com>...
> Mukesh,
>
> Make sure you are not doing that:
> $ sqlplus / as sysdba
>
> You are going to get an error for sure. Instead do either:
>
> $ sqlplus /nolog
> SQL> conn / as sysdba
> or
> $ sqlplus ' / as sysdba'
>
> Next time list the exact syntax of the commands you are trying to run an das
> Sybrand pointed out your OS and DB version.
>
> Hope that helps,
>
> Trifon Anguelov
> Senior Oracle DBA
>
> --------------------------------
> Join the new Oracle DBA forums at:
> http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
>
> "Mukesh Singh" <mksingh72_at_yahoo.com> wrote in message
> news:5d671409.0202091406.4bbe06fe_at_posting.google.com...
> > Hi,
> >
> > I came across a very strange problem. I login as a user who is a
> > member of DBA group on unix machine. I am not able to connect as
> > sysdba from sqlplus but able to connect as internal using svrmgrl. I
> > have checked there is no password file. Can please somebody explain
> > what could be the reason ?
> >
> > Thanks,
> >
> > Mukesh.
Received on Mon Feb 11 2002 - 08:08:05 CST