Home » RDBMS Server » Server Administration » doubt in password file
doubt in password file [message #242205] Fri, 01 June 2007 01:17 Go to next message
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

Report message to a moderator

Re: doubt in password file [message #242212 is a reply to message #242205] Fri, 01 June 2007 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

Re: doubt in password file [message #242268 is a reply to message #242205] Fri, 01 June 2007 07:41 Go to previous messageGo to next message
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.

Report message to a moderator

Re: doubt in password file [message #242270 is a reply to message #242268] Fri, 01 June 2007 08:00 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Mar 01 07:43:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.