Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect internal

Re: connect internal

From: Tommy <tcusan_at_yahoo.com>
Date: 1998/10/19
Message-ID: <362BCD3C.5D5284EF@yahoo.com>#1/1

Hi,
This is the step-by-step instructions for recreating a password file on Windows NT. This can be necessary if you are unable to connect to your database using the internal password (ORA-1031) or, if you need to change the internal password for security reasons.

Note:  If your database version is 8.0.x, SVRMGRXX = SVRMGR30
                                          ORAPWDXX = ORAPWD80
       If your database version is 7.3.x, SVRMGRXX = SVRMGR23
                                          ORAPWDXX = ORAPWD73
************************************************************************

  1. Check the value for parameter REMOTE_LOGIN_PASSWORDFILE.

    This can be accomplished by checking the parameter setting     in your INIT%SID%.ORA or by querying the database.

    To query the database, connect through SVRMGRXX using a dba     account such as SYSTEM. Enter command:

         SHOW PARAMETER REMOTE_LOGIN_PASSWORDFILE 2. If the value of this parameter is EXCLUSIVE then you must shutdown

    your database before recreating the password file.

    If the value of this parameter = SHARED then you may proceed     with password file creation - Step 3.

3. Delete the current password file %ORACLE_HOME%\DATABASE\PWD%SID%.ORA.

    If you can't find this file it may have a hidden attribute which     is preventing you from accessing it. Set your Windows NT Explorer     VIEW > OPTIONS to SHOW ALL FILES.

4. To create a new password file, enter the following from a command

    prompt:

    ORAPWDXX FILE=%ORACLE_HOME%\DATABASE\PWD%SID%.ORA PASSWORD=%NEW PASSWORD% 5. If your database autostarts when you reboot, you will need to

    change the value of the password file in the command file that     is used to start your database. Use Notepad to edit     %ORACLE_HOME%\DATABASE\STRT%SID%.CMD. Change the value     following parameter -USRPWD with the new internal password.

Brian Yan wrote:

> I just installed Oracle8 on NT4.0 (stand-alone). However, when I try to
> connect internal in srvmgr30, I was asked to input the password. I don't
> remember I set up a password during the installation, so what the passwd
> is supposed to be? How to connect internal? Thank you for helps!!
>
> Brian Yan
Received on Mon Oct 19 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US