Re: INTERNAL password, Oracle 7.3, Windows NT

From: Mike Lynch <web-tech_at_us.oracle.com>
Date: 1996/10/20
Message-ID: <54cag7$d8b@inet-nntp-gw-1.us.oracle.com>#1/1

The information contained herein is derived from the Oracle7 Server Administrator's Guide version 7.3, which comes with Oracle Enterprise Server.

First of all, to grant others the SYSDBA (or SYSOPER) privileges you must have the REMOTE_LOGIN_PASSWORDFILE parameter (in your INITsid.ORA file in the {oracle home}/database subdirectory) set to EXCLUSIVE. It will not be possible if this parameter is set to NONE or SHARED. Then after stopping and starting the database service (to set the new parameters) create a password file. Here's an example that creates a password file named acct.pwd that allows up to 30 privileged users with different passwords. The file is initially created with the password SECRET for users connecting as INTERNAL or SYS:

ORAPWD73 FILE=acct.pwd PASSWORD=secret ENTRIES=30

I'm not sure if you'll have to stop the service and startup once again?
At this point INTERNAL can grant SYSDBA (and/or SYSOPER). Here's the example in SQLDBA:
CONNECT INTERNAL
GRANT SYSDBA TO SCOTT
DISCONNECT
CONNECT SCOTT/TIGER AS SYSDBA Please be careful and use discretion in granting the two most powerful privileges on the database!
I think that this example (notice the AS SYSDBA - key!) will answer your questions sufficiently. Please refer to the documenation I referred to above, pages 1-4 through 1-16.

I hope this helps,
Mike Lynch
Oracle Corporation

Disclaimer: The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

---

ptmoore_at_sequent.com (Peter Moore) wrote:

>Dear All,
 

>I thought I knew what I was doing as a DBA on VMS and Unix, but now
>I've been landed with an NT box with a pre-installed database and I
>haven't got the foggiest...
 

>Can anyone answer me the following:
 

>1) How do I change the 'INTERNAL' user password?
> 'ALTER USER internal ...' doesn't work as there's no such user!
> And I can't shutdown the database to change some params because
> the INTERNAL password is neither manager nor change_on_install.
 

>2) What do I do to allow me to log in as SYSDBA? There is mention of
>an orapwd73 utility, but this doesn't seem to allow for having two
>instances on the same box with different passwords...
 

>If anyone can point me to exactly where to look for this... The
>online docs are next to useless and there are *no* paper docs, so I'm
>at a loose end on this one.
 

>Thanks in advance,
 

>PT
 

>--
>Peter Moore.
>DBA, IS Ops,
>Sequent Computer Systems Ltd, Weybridge, UK.
>"I never forget a face, but in your case I'll be happy to make an exception"
Received on Sun Oct 20 1996 - 00:00:00 CDT