[chalie]

Dear All,

I've oracle 9i Ver.9.2.0.1.0 , running on aix 5L Ver.5.2
My question :
1. How to check password file already created ?
2. If not already created, how create password file on specific directory ?
3. How to change REMOTE_LOGIN_PWDFILE=EXCLUSIVE ?

Thanks for advance

regards,
chalie

[anacedent]

>1. How to check password file already created ?

ls -l

>2. If not already created, how create password file on specific directory ?

orapwd

>3. How to change REMOTE_LOGIN_PWDFILE=EXCLUSIVE ?

vi

[The_Duck]

you obviously have not read the documentation.
it is very concise and answers all your questions:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1227

[chalie]

Hi Duck n anacement,

Thanks for your info, i've read this articel but still not enough for me,
I don't know password file name, so how can I search the file using
#find $ORACLE_HOME -name "xx.xx" -print ?
also using ls command
# ls -al |grep xx.xx ?
Any other way to check ?

After confirm the password file not available, I will create the password file into specific directory (Example : /miscellaneous).
If I use PWORA utility, this utility just set the file name, password and maximum user, not set specific directory. How create password file into /miscellaneous ?

rgd,
chalie

[osy45]

$ORACLE_HOME/dbs/orapw<SID>.ora