How to change internal password on Windows NT with Oracle Server Version
8.1.5 or 8.1.6.
INSTRUCTIONS:
- Shut down the database either NORMAL or IMMEDIATE (not ABORT!).
- Check where your password file is located.
- Run the Windows NT Registry editor by clicking Start on the desktop
and
then click Run.
- In the Open box, type:regedt32.
- Go to HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE.
- The correct location of the password file for each database appears
in the
right-hand pane of the Registry editor. The format appears as
ORA_<SID>_PWFILE, followed by the password file location where <SID>
is
the name of the Oracle database. The default
location
is $ORACLE_HOME/database.
7. Rename your old PWD<SID>.ora file in the NT operation system.
8. Create a new password file with ORAPWD.EXE at a command prompt:
C:\> orapwd file=<fname> password=<password> [entries=<users>]
where: <fname> is the name of password file -- MANDATORY
<password> is the password for SYS and INTERNAL -- MANDATORY
<entries> is the maximum number of distinct DBA and OPERs
-- OPTIONAL
There are no spaces around the equal-to (=) character.
FOR EXAMPLE:
C:\> orapwd file=passwd.ora password=oracle entries=10
will create a password file named passwd.ora in the root directory
(C:\),
the internal password will be 'oracle', and there will be 10 possible
entries for SYSDBA or SYSOPER users.
After you have created the password file, you can relocate it as you
choose. After relocating the password file, you must reset the
appropriate environment variables to the new pathname (check
ORA_<SID>_PWFILE in registry).
9. Reboot your NT server.
Notes:
- If you receive the file full error (ORA-1996) when you try to grant
SYSDBA or SYSOPER system privileges to a user, you must create a
larger
password file and re-grant the privileges to all of the users.
- In 8.1.5 str<SID>.cmd file doesn't exist anymore and just one service
handles all database actions, like Automatic startup, shutdown,
pfile,
etc.
- By default in 8.1.x, a new database will use Windows NT Native
Authentication by having the following already set in the sqlnet.ora
file:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
This will allow any privileged user defined in the NT user group
(named
ORA_<sid>_DBA) to login to database without providing a password. To
disable this feature and force all users to provide a password,
simply
comment out the above in the sqlnet.ora file:
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
Please see Appendix D in Oracle8i Getting Started for Windows NT for
further details.
>From: Jack Silvey <JSilvey_at_XOL.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Autostart at boottime-Oracle8
>Date: Thu, 06 Jul 2000 08:37:17 -0800
>
>I did not see the startsid.cmd file from my 8i installation either. I
>wonder
>how the OracleStartSID service knows the internal password now?
>
>Jack Silvey
>
>-----Original Message-----
>Sent: Thursday, July 06, 2000 11:07 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>This file was created when I created 8.0 database but it is not created for
>8.1.6.(at least not in my istallation). I do not think that you will have
>this problem with 8.1. For 8.0 you can recreate the instance with oradim80
>or manually change this file.
>
>Alex Hillman
>
>-----Original Message-----
>
>Sent: Thursday, July 06, 2000 9:27 AM
>To: Multiple recipients of list ORACLE-L
>
>
>you will have to change the password in the strtsid.cmd file which is on
>\orant\database\ directory
>edit this file you will see the password which uses the internal password
>of
>
>the password file
>it should work
>
> >From: "Ravi Babu" <lravibabu_at_hotmail.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Autostart at boottime-Oracle8
> >Date: Thu, 06 Jul 2000 02:25:27 -0800
> >
> >Hello,
> >For security reasons i have changed the internal password with the help
>of
> >ORAPWD80. After that whenever i restart the server, oracle is not auto
> >started and i have to start it explicitly. I am using Oracle8 ver 8.0.5
>on
> >NT 4.0. I have checked the registry but not finding any variable to set
>for
>
> >autostart at boot. What should i try to make it autostart at bootime.
> >Please
> >help.
> >Bye
> >Ravi.
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
><http://www.hotmail.com>
> >
> >--
> >Author: Ravi Babu
> > INET: lravibabu_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
><http://www.hotmail.com>
>
>--
>Author: ARUN K C
> INET: arun_k_c_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Author: Jack Silvey
> INET: JSilvey_at_XOL.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Thu Jul 06 2000 - 11:52:05 CDT
