课程第22次：2020-03-21星期六

botang

1 以GRID用户CREATE第二个磁盘组
1.1 图形界面asmca





2 以ORACLE用户CREATE RAC数据库

1. [oracle@server4 ~]$ ps aux |grep ora_smon
   
2. oracle    13165  0.0  1.9 2161696 134340 ?      Ss   21:48   0:00 ora_smon_racdb_2
   
3. oracle    15195  0.0  0.0  12108  1028 pts/0    R+   22:14   0:00 grep --color=auto ora_smon
   
4. [oracle@server4 ~]$ vim .bash_profile
   
5. # .bash_profile
   
6. 
   
7. # Get the aliases and functions
   
8. if [ -f ~/.bashrc ]; then
   
9.         . ~/.bashrc
   
10. fi
    
11. 
    
12. # User specific environment and startup programs
    
13. export ORACLE_BASE=/u01/app/oracle
    
14. export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
    
15. export PATH=$ORACLE_HOME/bin:$PATH
    
16. export LANG=en_US.UTF-8
    
17. export ORACLE_SID=racdb_2
    
18. ~
    
19. ~
    
20. ~
    
21. ~
    
22. ~
    
23. ~
    
24. ~
    
25. [oracle@server4 ~]$ . .bash_profile
    
26. [oracle@server4 ~]$ sqlplus /nolog
    
27. 
    
28. SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 21 22:15:06 2020
    
29. 
    
30. Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
31. 
    
32. SQL> conn  / as sysdba
    
33. Connected.
    
34. SQL> alter user sys identified by oracle_4U;
    
35. 
    
36. User altered.
    
37. 
    
38. SQL> alter user hr identified by oracle_4U account unlock;
    
39. 
    
40. User altered.
    
41. 
    
42. SQL> exit
    
43. Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    
44. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    
45. Advanced Analytics and Real Application Testing options
    
46. [oracle@server4 ~]$ exit
    
47. logout
    
48. [root@server4 ~]# crs_stat -t
    
49. Name           Type           Target    State     Host        
    
50. ------------------------------------------------------------
    
51. ora.DATA.dg    ora....up.type ONLINE    ONLINE    server4     
    
52. ora.FRA.dg     ora....up.type ONLINE    ONLINE    server4     
    
53. ora....ER.lsnr ora....er.type ONLINE    ONLINE    server4     
    
54. ora....N1.lsnr ora....er.type ONLINE    ONLINE    server5     
    
55. ora....N2.lsnr ora....er.type ONLINE    ONLINE    server4     
    
56. ora....N3.lsnr ora....er.type ONLINE    ONLINE    server4     
    
57. ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    server4     
    
58. ora.asm        ora.asm.type   ONLINE    ONLINE    server4     
    
59. ora.cvu        ora.cvu.type   ONLINE    ONLINE    server4     
    
60. ora.mgmtdb     ora....db.type ONLINE    ONLINE    server4     
    
61. ora....network ora....rk.type ONLINE    ONLINE    server4     
    
62. ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    server4     
    
63. ora.ons        ora.ons.type   ONLINE    ONLINE    server4     
    
64. ora.racdb.db   ora....se.type ONLINE    ONLINE    server5     
    
65. ora.scan1.vip  ora....ip.type ONLINE    ONLINE    server5     
    
66. ora.scan2.vip  ora....ip.type ONLINE    ONLINE    server4     
    
67. ora.scan3.vip  ora....ip.type ONLINE    ONLINE    server4     
    
68. ora....SM1.asm application    ONLINE    ONLINE    server4     
    
69. ora....R4.lsnr application    ONLINE    ONLINE    server4     
    
70. ora....er4.ons application    ONLINE    ONLINE    server4     
    
71. ora....er4.vip ora....t1.type ONLINE    ONLINE    server4     
    
72. ora....SM2.asm application    ONLINE    ONLINE    server5     
    
73. ora....R5.lsnr application    ONLINE    ONLINE    server5     
    
74. ora....er5.ons application    ONLINE    ONLINE    server5     
    
75. ora....er5.vip ora....t1.type ONLINE    ONLINE    server5     
    
76. [root@server4 ~]# su - oracle
    
77. Last login: Sat Mar 21 22:13:59 CST 2020 on pts/0
    
78. [oracle@server4 ~]$ sqlplus /nolog
    
79. 
    
80. SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 21 22:20:45 2020
    
81. 
    
82. Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
83. 
    
84. SQL> conn / as sysdba
    
85. Connected.
    
86. SQL> create table hr.t_objects as select  * from dba_objects;
    
87. 
    
88. Table created.
    
89. 
    
90. SQL> con hr/oracle_4U
    
91. SP2-0734: unknown command beginning "con hr/ora..." - rest of line ignored.
    
92. SQL> conn hr/oracle_4U
    
93. Connected.
    
94. SQL> select count(*) from t_objects;
    
95. 
    
96.   COUNT(*)
    
97. ----------
    
98.      91596
    
99. 
    
100. SQL>

复制代码

tns串：

1. /u01/app/oracle/product/12.1.0/dbhome_1/network/admin

复制代码

1. C:\app\Apple\product\11.2.0\dbhome_1\NETWORK\ADMIN

复制代码

3 ACL 组属性上的RWX指的是 ACL, 最好不要用chmod去改这三位，而要用setfacl
3.1

1. [root@classroom pub]# chmod o-r file.html
   
2. [root@classroom pub]# ls -l file.html
   
3. -rw-r----- 1 root root 12 Mar 22 05:21 file.html
   
4. [root@classroom pub]# getfacl file.html
   
5. # file: file.html
   
6. # owner: root
   
7. # group: root
   
8. user::rw-
   
9. group::r--
   
10. other::---
    
11. 
    
12. [root@classroom pub]# setfacl -m u:apache:r file.html
    
13. [root@classroom pub]# ls -l file.html
    
14. -rw-r-----+ 1 root root 12 Mar 22 05:21 file.html
    
15. [root@classroom pub]# getfacl file.html
    
16. # file: file.html
    
17. # owner: root
    
18. # group: root
    
19. user::rw-
    
20. user:apache:r--
    
21. group::r--
    
22. mask::r--
    
23. other::---

复制代码