LOCAL=NO是非本地连接

首先通过远程登陆(监听)
sqlplus scott/tiger@192.168.6.11:1521/test 
执行下面会看到

点击( 此处 )折叠或打开

1. [ root@Test11g ~ ] # ps - ef | grep LOCAL = NO | grep - v grep
   

2. oracle 24319 1  0 01 : 35 ? 00 : 00 : 00 oracletest ( LOCAL = NO )

干掉这个进程

点击( 此处 )折叠或打开

1. kill - 9 `ps - ef | grep LOCAL = NO | grep - v grep | awk '{ print $2}' `

然后连接中断

点击( 此处 )折叠或打开

1. [ oracle@Test11g ~ ] $ sqlplus scott/tiger@192 . 168 . 6 . 11 : 1521/ test
   

2. 
   

3. SQL * Plus : Release 11 . 2 . . 3 . 0 Production on Fri Jul 10 01 : 35 : 58 2015
   

4. 
   

5. Copyright ( c ) 1982 , 2011 , Oracle . All rights reserved .
   

6. 
   

7. 
   

8. Connected to :
   

9. Oracle Database 11g Enterprise Edition Release 11 . 2 . . 3 . 0 - 64bit Production
   

10. With the Partitioning , OLAP , Data Mining and Real Application Testing options
    

11. 
    

12. 01 : 35 : 59 SQL > select * from tab ;
    

13. select * from tab
    

14.                  *
    

15. ERROR at line 1 :
    

16. ORA - 03113 : end - of - file on communication channel
    

17. Process ID : 24319
    

18. Session ID : 48 Serial number : 621
    

19. 
    

20. 
    

21. Elapsed : 00 : 00 : 00 . 35