Source your db profile . .SID
enter orapwd
Usage: orapwd file=
entries= force= ignorecase=
nosysdba=
where
file - name of password file
(required),
password - password for SYS will
be prompted if not specified at command line,
entries - maximum number of
distinct DBA (optional),
force - whether to overwrite
existing file (optional),
ignorecase - passwords are
case-insensitive (optional),
nosysdba - whether to shut out
the SYSDBA logon (optional Database Vault only).
There must be no spaces around the
equal-to (=) character.
orapwd
file=$ORACLE_HOME/dbs/orapw$ORACLE_SID entries=5 force=y ignorecase=y
nosysdba=n
Enter password for SYS:xxxxxxx
after completed.
you can see the orapwSID file find in ORACLE_HOME/dbs/orapwSID
shutdown your database and add the entry in your initSID.ora
remote_login_passwordfile='EXCLUSIVE'
to check
select * from v$pwfile_users;
select * from v$pwfile_users;
No comments:
Post a Comment