OraFAQ Forum: Server Administration » doubt in password file

Home » RDBMS Server » Server Administration » doubt in password file

Fri, 01 June 2007 01:17

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

hi i am new to oracle and i have doubt why we use password file, what is it purpose can any one please guide me

thanks

Fri, 01 June 2007 01:38

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Administrator's Guide, Chapter 1 Overview of Administering an Oracle Database, section "Database Administrator Authentication", subsection "Selecting an Authentication Method"

Regards
Michel

Fri, 01 June 2007 07:41

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

thanks, and when we are exporting a database or doing RMAN when creating a catalog file why we have to use passwordfile.

Fri, 01 June 2007 08:00

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You only need it for SYS* connnections.
So:
- to export database, you don't need it
- to use RMAN, you have to connect "as sysdba"

Regards
Michel

Previous Topic:	Oracle 8.1.7 on windows 2003 64Bit
Next Topic:	Re: Temp Tablespace not being flushed automatically

Goto Forum:

]

Current Time: Fri Sep 20 10:21:24 CDT 2024