Databases Reference
In-Depth Information
input_file - name of input password file, from where old user
entries will be migrated (optional).
There must be no spaces around the equal-to (=) character.
[oracle@virtual1 ~]$
There are a lot more options you can specify for the orapwd utility in the Oracle Database 12g release. Of the
twelve options for the orapwd utility, only the file option is mandatory. You can create a simple Oracle password file
using the following syntax:
[oracle@virtual1 ~]$ orapwd file=mydb_pwd
Enter password for SYS:
[oracle@virtual1 ~]$
The
orapwd
command shown here creates the password file named
mydb_pwd.
Once you restart your database
after this, you'll be able to log in as the
sys
user.
Connecting to a Target Database from the Operating System
Command Line
Problem
You want to invoke the RMAN client and connect to the target database from the operating system command line.
Solution
You can make a connection to the target database from the operating system by using the same two methods of
connection you use to connect to a target database from within RMAN. That is, you can use either operating system
authentication or Oracle Net authentication.
Here's an example showing how to connect to a target database from the command line using operating system
authentication:
[oracle@virtual1 ~]$ rman target /
Recovery Manager: Release 12.1.0.0.2 - Beta on Mon Aug 6 09:59:44 2012
Copyright (c) 1982, 2012, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1316762630)
RMAN>
You can also connect to the target database from the command line using Oracle Net password file
authentication, as shown here:
% rman target sys/<sys password>@trgt
