Oracle Course

Administration Workshop I

Chapter VI — Configuring the network environment

To connect locally (at the database server) you only have to type:

[oracle@curso ~]$ sqlplus hr

SQL*Plus: Release Production on Tue Apr 16 12:05:49 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password: 

Conectado a:
Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options


To connect from a networked envorinment, you'll have to specify the following args:

user/pw @ host : listener_port / SID


sqlnet.ora o o
listener.ora o

Listener control tools:

[oracle@curso admin]$ . oraenv
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle

[oracle@curso admin]$ lsnrctl
LSNRCTL for Linux: Version - Production on 16-APR-2013 12:28:23

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.


Oracle listener naming methods:

Oracle could delegate its listener control by one of the following methods:

  • EZ connect (tcp/ip)
  • tnsnames.ora or local naming.
  • LDAP, active Directory, etc.
  • External other NS