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
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: 64132
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
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.
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: 64132
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: Thu Dec 08 01:55:49 CST 2016

Total time taken to generate the page: 0.09304 seconds