Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connect internal
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 ************************************************************************
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