service_names string baseline
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string
remote_listener string
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
F:\app\ibsadmin\product\11.2.0\dbhome\NETWORK\ADMIN>notepad tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irdeto-IBSvm)(PORT = 1521))
)
(CONNECT_DATA =
)
)
F:\app\ibsadmin\product\11.2.0\dbhome\NETWORK\ADMIN>sqlplus queuedata/queuedata@orcl
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 18 11:03:52 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
摘自 henrybai的专栏