How to Avoid Common Flaws and Errors Using Passwordfile
(Doc ID 185703.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Server - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 9.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 22-Sep-2012
This bulletin discusses:
- most common passwordfile issues (ora-199x) and their causes/solutions
- some hints when migrating, (re)creating controlfile/database, import/export with password files
Some information specific to currently desupported versions was retained for historical purposes, for example, 'connect internal' was deprecated and administrative connections should now use the 'connect AS SYSDBA' syntax.
How to generate a password file is explained in the following notes:
- <Note 1029539.6> - UNIX: How to Set up the Oracle Password File
- <Note 114384.1> - WIN: Checklist for Resolving CONNECT AS SYSDBA Issues
Setup for remote startup/shutdown using Oracle Enterprise Manager is explained in :
<> - How to Startup/Shutdown a Remote Database Through EM
Before proceeding read the following notes:
<Note 18089.1> - UNIX: Connect INTERNAL / AS SYSBDA Privilege on Oracle 7/8
<Note 50507.1> - SYSDBA and SYSOPER Privileges in Oracle
<Note 184696.1>- Adding Users to Passwordfile Using Passwordfile Authentication
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!