Oracle 8.1.5 and NT: Automatic Login???

From: Klemens Funke <Klemens.Funke_at_gmx.de>
Date: 28 Mar 2000 07:29:30 +0000
Message-ID: <m1hfdr363p.fsf@goofy.nodomain.home>

After some experience with Oracle 7.3.3 I am migrating to Oracle 8.1.5 and experiencing problems with automatic login (OS authetication).

Could anyone please help me with the following problems?

1.) Setting

    remote_login_passwordfile = none
    in the init.ora I can't startup my database (see below).

F:\>svrmgrl

Oracle Server Manager Release 3.1.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. Alle Rechte vorbehalten.

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

• Output ---- -- "translation" -- SVRMGR> connect Benutzername: internal (user) Kennwort: (Password Verbindung aufgebaut. (connected) SVRMGR> startup nomount pfile=f:\database_pvsr\initpvsr.ora ORA-01031: insufficient privileges SVRMGR>

2.) On a new installation of Enterprise Edition (Standard, Standard-DB) I am not able

    to connect without a password (neither as normal user nor as sysdba / sysoper).  

SVRMGR> connect /
ORA-01004: default username feature not supported; logon denied SVRMGR> connect / as sysoper
ORA-01031: insufficient privileges
SVRMGR> connect / as sysdba
ORA-01031: insufficient privileges
SVRMGR>       The corresponding NT-user is Administrator who belongs to ORA_DBA and ORA_ORCL_DBA     (created ad installation and using Oracle Administration Assistant for Windows NT,     resp.)

Any help appreciated
Klemens    Received on Tue Mar 28 2000 - 01:29:30 CST