Saturday, January 16, 2010

orapwd file argument, where should be the password file located

Platform: UNIX and Linux
Location: $ORACLE_HOME/dbs/orapwORACLE_SID

Example:
[oracle@rh4 ~]$ ls -l /u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl
-rw-r----- 1 oracle oinstall 1536 Dec 31 08:33 /u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl


Platform: Windows
Location: %ORACLE_HOME%\database\PWDORACLE_SID.ora

Example:
D:\ORACLE\product\11.1.0\db_1\database>attrib
A D:\ORACLE\product\11.1.0\db_1\database\hc_orcl.dat
A D:\ORACLE\product\11.1.0\db_1\database\oradba.exe
A D:\ORACLE\product\11.1.0\db_1\database\oradim.log
A D:\ORACLE\product\11.1.0\db_1\database\PWDorcl.ora
A D:\ORACLE\product\11.1.0\db_1\database\SPFILEORCL.ORA