• Administration
  • Status
  • Session
  • Init Parameters
  • User
  • Roles
  • ASM
  • RAC 10gR2
  • Job Scheduler
  • Advanced Queues
  • Recycle bin
• Structure
  • Tablespace
  • Objects
  • Indexes
  • Files
  • Redo Logs
  • Undo
  • Constraints
  • Materialized view
  • Partitions
  • Triggers
• Performance
  • General
  • Locks DML
  • Locks DDL
  • Waits
  • Statistics
  • Query Tuning
  • Memory
  • Statspack
  • AWR
• Backup
  • DataGuard
  • RMAN
  • Import Export
  • Flashback
  • Datapump
• Miscellaneous
  • Useful UNIX
  • utl_file
• SQL*Net
  • tnsnames.ora
  • listener.ora

SQL*Net - tnsnames.ora

• Sample dedicated connection
  
• Listener entry
  

SCR9 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bloo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = scr9)
    )
  )

LISTENER_+ASM =
  (ADDRESS = (PROTOCOL = TCP)(HOST = bloo)(PORT = 1522))