connectStringSpec

Syntax

connectStringSpec::=

Description of the illustration connectstringspec.gif

Purpose

A subclause specifying the username, password, and net service name for connecting to a target, recovery catalog, or auxiliary database. The connection is necessary to authenticate the user and identify the database.

Restrictions and Usage Notes

You must have SYSDBA privileges to connect to a target or auxiliary database.
Do not connect to the recovery catalog database as user SYS.

Keywords and Parameters

Syntax Element	Description
`/`	If you do not specify a user ID or password when connecting to the target database, then a forward slash establishes a connection as user `SYS` by using operating system authentication. For example, enter the following to connect to the target database: % rman TARGET / Note: The forward slash depends on platform-specific environment variables.
`userid`	Establishes a connection to the database for the specified user. If you do not specify a password, RMAN obtains the password interactively by displaying a prompt. The characters will not be echoed to the terminal. You must have `SYSDBA` authority when connecting to the target or auxiliary database, but must not connect as `SYS` to the recovery catalog database. Note: The connect string must not contain any white space, but it can contain punctuation characters such as a forward slash (`/`) and an at sign (`@`).
`/password`	Establishes a connection for the specified user by using a password. If the target database is not open, then a password file must exist.
`@net_service_name`	Establishes a connection to the database through an optional Oracle Net net service name.

Examples

Connecting to a Target Database Without a Recovery Catalog: Example This example connects to the target database by using a password and the Oracle Net service name prod1 in the default NOCATALOG mode:

% rman TARGET SYS/change_on_install@prod1

Connecting to a Target Database and Entering the Password Interactively: Example This example connects to the target database as user SYS but without specifying a password at the command line. Note that you are prompted for a password.

% rman TARGET SYS

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2003, Oracle.  All rights reserved.

target database Password:

Connecting with Operating System Authentication: Example This example starts RMAN and then connects to the target database prod1 by using operating system authentication and the recovery catalog database rcat using a net service name:

% rman

RMAN> CONNECT TARGET /

RMAN> CONNECT CATALOG rman/rman@inst1

Connecting to a Target Database, Recovery Catalog, and Auxiliary Instance: Example This example connects to three different databases from the command line, specifying a username, password, and net service name for each:

% rman TARGET SYS/pwd1@prod1 CATALOG rman/rman@rcat AUXILIARY SYS/pwd2@dupdb