Re: how to start oracle services without password file

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 12 Nov 1999 16:35:18 -0800
Message-ID: <382CB246.27469F66@vnl.nl>

jeremycdba_at_my-deja.com wrote:

> I can't start the OracleStartSID service on NT 4. The OracleServiceSID
> starts ok but the other service comes back with the message 'Please
> enter a password for the DBA account'. I want to start the db using the
> start service after a cold backup.
>
> I'm not using a password file, but have set up ORA_SID_DBA and
> ORA_SID_OPER groups and a local oracle user which along with other
> settings allows me to connect to server manager without a password.
>
> I've got a feeling that the start service is looking for a password?
>
> Any help appreciated...
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

From the Getting Started doc:
Connecting as INTERNAL Without a Password

This section describes how to connect as INTERNAL without a password. To do this, you must create one of the following new local Windows NT user groups and add a Windows NT operating system local or domain user to that group:

Local Group

                   This Local Group Includes All...
 ORA_DBA
                   SYSDBA database privileges. This group is applicable for

all SIDs.
ORA_SID_DBA

                   SYSDBA database privileges. This group is applicable

only for the SID specified in the name.

This enables you to log into a local computer or a Windows NT domain. In the domain, your Oracle8 database is just one of many resources to which you have access. Once you access this domain, you are automatically validated as an authorized DBA who can access the Oracle8 database without a password.

Note::

The Oracle8 database does not support setting the registry DBA_AUTHORIZATION parameter to the value of

BYPASS. Server Manager uses the value of DBA_AUTHORIZATION as a password for INTERNAL to retry a

failed login attempt when no password is provided.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Nov 12 1999 - 18:35:18 CST