easy connect

CONNECT username/[email protected]/service_name

 验证后面带的是service_name,而不是SID
[[email protected] ~]$ ps -ef | grep smon
oracle   18866     1  0 Jul10 ?        00:00:01 ora_smon_orcl
oracle   27967 23120  0 12:49 pts/0    00:00:00 grep smon

[[email protected] ~]$ sysresv 

IPC Resources for ORACLE_SID "orcl" :
Shared Memory:
ID		KEY
4489220 	0x6fe60f10
Semaphores:
ID		KEY
16580609	0x7b8d3258
16613378	0x7b8d3259
16646147	0x7b8d325a
16678916	0x7b8d325b
16711685	0x7b8d325c
16744454	0x7b8d325d
16777223	0x7b8d325e
16809992	0x7b8d325f
16842761	0x7b8d3260
Oracle Instance alive for sid "orcl"


[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 11 12:50:04 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show p