Oracle Database - Connect Identifier

Card Puncher Data Processing

About

A connect idenfier is the part of the connect string when a users initiate a connection to designate the service to which they want to connect to.

The connect identifier is :

One of the most common connect identifiers is a net service name, a simple name for a service.

Here below a connection with the connect command of SQL Plus (but you can initiate a connection with an other client such as SQL developer of code)

CONNECT username@connect_identifier

Syntax

Connect identifiers used in a connect string cannot contain spaces, unless enclosed within single quotes (') or double quotes (“). In the following examples, a connect identifier and a connect descriptor that contain spaces are enclosed within single quotes:

CONNECT scott/tiger@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)
(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))'
CONNECT scott/tiger@'cn=sales, cn=OracleContext, dc=us, dc=acme, dc=com'

Single quotes (') are required if a double quote (”) is used in a connect identifier. For example:

CONNECT scott/tiger@'sales@Good"Fast"Food.com' 

Likewise, double quotes (“) are required if a single quote (') is used in a connect identifier. For example:

CONNECT scott/tiger@"cn=sales, cn=OracleContext, ou=Mary's Dept, o=acme" 





Discover More
Obiee Connection Pool
OBIEE 10G/11G - Oracle Call Interface (OCI) configuration

This page shows you how to install an OCI driver with OBIEE. To use it you have to install it on the BI Server machine through an Oracle Client installation (for instance an Oracle Database, an...
Obiee11g Bip Security Center Roles
OBIEE 11G - Installation Sample Application version 825

edit the “” Save the file. Login to the EM administration screen using the url Expand 'Business Intelligence' > Coreapplication > Deployment > Repository Click...
Card Puncher Data Processing
Oracle Database - Connect Descriptor (TNS Connect String)

The Connect Descriptor (known also as TNS Connect String) is a type of connect identifier. It defines the parameters that need the Oracle Net Service to connect to a database service : the protocol...
Card Puncher Data Processing
Oracle Database - Connect String (Client Connection Initiation)

Users initiate a connection request to a database service by providing a connect string. A connect string includes: a username and password, along with a connect identifier. A connect identifier...
Oracle Database Net Ldap
Oracle Database - Directory naming method (LDAP-compliant)

A naming method that resolves a database service, net service name, or net service alias to a connect descriptor stored in a central directory server. The directory naming method stores connect identifiers...
Card Puncher Data Processing
Oracle Database - Naming method (naming resolution method)

The Oracle Net Services naming method is resolution method used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service. They...
Card Puncher Data Processing
Oracle Database - SQLNET.ORA

Located on client and database server computers, this file may include: Client domain to append to unqualified service names or net service names Order of naming methods the client should use when...
Edlivery Oracle Bi
PowerCenter - Installation and Configuration (8.6.1 for Windows 32Bit)

This article talk the installation of PowerCenter from Informatica on: Windows 32 bit Oracle Database Oracle Business Intelligence Application version 7.9.6.1 installation The oracle database...
Powercenter 901 Installation License And Directory
PowerCenter - Installation and Configuration (9.0.1 for OEL Linux 64Bit)

Text format: ... Installation Type: Install (and not upgrade) Pre-requisites: Next License and Directory. (Transfer the license file from the client zip file) Pre-Installation Summary: Install...
Card Puncher Data Processing
SQL Plus - Connect

CONNECT is a SQLPlus command that permits to make a connection as a user with a database (instance of). where: logon has the following syntax: username/password@connect_identifier proxy has the...



Share this page:
Follow us:
Task Runner