Dedicated 접속 후 확인
SQL> !ps -ef|grep oracle | grep LOCAL=NO | grep -v grep
C:\Users\2000515>sqlplus system/oracle123@tggo
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Sep 14 19:43:27 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
PL/SQL procedure successfully completed.
TODAY_YYYYDDMMHH24MISS_COL
----------------------------------
TGGO_20121409_19_43_30
SQL>
SQL> !ps -ef|grep oracle | grep LOCAL=NO | grep -v grep
oracle 15846 1 0 19:43 ? 00:00:00 oracleTGGO (LOCAL=NO
***** 참고 tnsnames.ora 샘플
TGGO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.38.138)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TGGO)
)
)