第24次：2014-08-14-sqlplus1.sql

botang

1. Connected.
   
2. SQL> conn / as sysdba
   
3. Connected.
   
4. SQL> show parameter service
   
5. 
   
6. NAME                                     TYPE         VALUE
   
7. ------------------------------------ ----------- ------------------------------
   
8. service_names                             string         orcl.example.com
   
9. SQL> alter system set service_names='orcl.example.com','serv1';
   
10. 
    
11. System altered.
    
12. 
    
13. SQL> exit
    
14. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
15. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
16. and Real Application Testing options
    
17. [oracle@station90 ~]$ lsnrctl services
    
18. 
    
19. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-AUG-2014 20:02:40
    
20. 
    
21. Copyright (c) 1991, 2011, Oracle.  All rights reserved.
    
22. 
    
23. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=1521)))
    
24. Services Summary...
    
25. Service "+ASM" has 1 instance(s).
    
26.   Instance "+ASM", status READY, has 1 handler(s) for this service...
    
27.     Handler(s):
    
28.       "DEDICATED" established:101 refused:0 state:ready
    
29.          LOCAL SERVER
    
30. Service "orcl.example.com" has 1 instance(s).
    
31.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
32.     Handler(s):
    
33.       "DEDICATED" established:0 refused:0 state:ready
    
34.          LOCAL SERVER
    
35. Service "orclXDB.example.com" has 1 instance(s).
    
36.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
37.     Handler(s):
    
38.       "D000" established:0 refused:0 current:0 max:1022 state:ready
    
39.          DISPATCHER <machine: station90.example.com, pid: 7069>
    
40.          (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=59787))
    
41. Service "serv1.example.com" has 1 instance(s).
    
42.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
43.     Handler(s):
    
44.       "DEDICATED" established:0 refused:0 state:ready
    
45.          LOCAL SERVER
    
46. The command completed successfully
    
47. [oracle@station90 ~]$
    

复制代码