In order to startup an Oracle database, we need to have an Oracle password file or on Operating system authentication.
If the init.ora parameter remote_login_passwordfile is set to exclusive or shared, Oracle will search for a password file to do the authentication.
If the init.ora parameter remote_login_passwordfile is set to exclusive or shared, Oracle will search for a password file to do the authentication.
The default location for an Oracle password file is the %ORACLE_HOME%/database on Windows and $ORACLE_HOME/dbs on Unix flavours.
On windows, the filename should be: PWD%ORACLE_SID%.ora
On Unix, the filename should be: orapw$ORACLE_SID
On windows, the filename should be: PWD%ORACLE_SID%.ora
On Unix, the filename should be: orapw$ORACLE_SID
You can use the orapwd command to create a new password file.
Usage: orapwd file= password= entries= force=
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA,
force - whether to overwrite existing file (opt),
There are no spaces around the equal-to (=) character.
No comments:
Post a Comment