Databases Reference
In-Depth Information
Resolving Connection Permission Issues
Problem
You're trying to log in to RMAN from the command prompt, and you receive the following message:
$ rman target /
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
Solution
If you're attempting to use operating system authentication (not supplying a username and password) when starting
RMAN, you need to ensure your OS user account is part of a privileged DBA OS group. If you're not using OS
authentication, you need to make sure you have correctly enabled a password file.
Using OS Authentication
In Linux/Unix, the privileged OS group is usually named
dba
. This is the group you specified when installing the
Oracle software. To verify that your OS account belongs to the proper group, use the Linux/Unix
id
command:
$ id
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
In a Windows environment use this process to verify that your OS user is part of the Oracle DBA group:
1.
Go to Control Panel, and then go to Administrative Tools.
2.
Click Computer Management.
3.
Click Local Users and Groups, then click Groups.
You should see a group named
ora_dba
; double-click it.
4.
5.
Make sure your OS user is a member of the Oracle DBA group.
Using a Password File
If you're not using OS authentication, then you must supply a username and password combination that is recorded
in the password file that has appropriate privileges:
$ rman target <username>/<password>
If you don't supply a correct username and password, you'll get an
ORA-01031
“insufficient privileges” error. Ensure
that you use a correct username and password when using a password file.
■
Tip
recipe 2-1 has complete details on how to use os authentication and also how to implement a password file.
