- EZConnect
- TWO_TASK
- TNS_ADMIN
- LDAP
$sql barry/oracle@localhost:1521/orcl
SQLcl: Release 4.1.0 Beta on Fri Feb 20 10:15:12 2015
Copyright (c) 1982, 2015, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
SQL>
$export TWO_TASK=localhost:1521/orcl
TNS_ADMIN
Local Naming resolves a net service name stored in a tnsnames.ora file stored on a client. We can set the location of that in the TNS_ADMIN variable.
$export TNS_ADMIN=~/admin
An example tons entry is shown here below.
$cat tnsnames.ora
BLOG =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521) )
(CONNECT_DATA=
(SERVICE_NAME=orcl) ) )
we can then use the entry to connect to the database.
$sql barry/oracle@BLOG
SQLcl: Release 4.1.0 Beta on Fri Feb 20 10:29:14 2015
Copyright (c) 1982, 2015, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
SQL>
LDAP
We've already written about LDAP connections here. Here's a quick review.
set LDAPCON jdbc:oracle:thin:@ldap://scl58261.us.oracle.com:389/#ENTRY#,cn=OracleContext,dc=ldapcdc,dc=lcom
$export LDAPCON=jdbc:oracle:thin:@ldap://scl58261.us.oracle.com:389/#ENTRY#,cn=OracleContext,dc=ldapcdc,dc=lcom
$sql /nolog
SQLcl: Release 4.1.0 Beta on Fri Feb 20 10:37:02 2015
Copyright (c) 1982, 2015, Oracle. All rights reserved.
SQL> connect barry/oracle@orclservice_test(Emily's Desktop)
Connected
SQL>
If we have more types to add, then they will appear here. Let us know what you want to see.
View comments