课程第22次：2020-03-21星期六
1 以GRID用户CREATE第二个磁盘组1.1 图形界面asmca
2 以ORACLE用户CREATE RAC数据库
$ ps aux |grep ora_smon
oracle 131650.01.9 2161696 134340 ? Ss 21:48 0:00 ora_smon_racdb_2
oracle 151950.00.0121081028 pts/0 R+ 22:14 0:00 grep --color=auto ora_smon
$ vim .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US.UTF-8
export ORACLE_SID=racdb_2
~
~
~
~
~
~
~
$ . .bash_profile
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 21 22:15:06 2020
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn/ as sysdba
Connected.
SQL> alter user sys identified by oracle_4U;
User altered.
SQL> alter user hr identified by oracle_4U account unlock;
User altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
$ exit
logout
# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE server4
ora.FRA.dg ora....up.type ONLINE ONLINE server4
ora....ER.lsnr ora....er.type ONLINE ONLINE server4
ora....N1.lsnr ora....er.type ONLINE ONLINE server5
ora....N2.lsnr ora....er.type ONLINE ONLINE server4
ora....N3.lsnr ora....er.type ONLINE ONLINE server4
ora.MGMTLSNR ora....nr.type ONLINE ONLINE server4
ora.asm ora.asm.type ONLINE ONLINE server4
ora.cvu ora.cvu.type ONLINE ONLINE server4
ora.mgmtdb ora....db.type ONLINE ONLINE server4
ora....network ora....rk.type ONLINE ONLINE server4
ora.oc4j ora.oc4j.typeONLINE ONLINE server4
ora.ons ora.ons.type ONLINE ONLINE server4
ora.racdb.db ora....se.type ONLINE ONLINE server5
ora.scan1.vipora....ip.type ONLINE ONLINE server5
ora.scan2.vipora....ip.type ONLINE ONLINE server4
ora.scan3.vipora....ip.type ONLINE ONLINE server4
ora....SM1.asm application ONLINE ONLINE server4
ora....R4.lsnr application ONLINE ONLINE server4
ora....er4.ons application ONLINE ONLINE server4
ora....er4.vip ora....t1.type ONLINE ONLINE server4
ora....SM2.asm application ONLINE ONLINE server5
ora....R5.lsnr application ONLINE ONLINE server5
ora....er5.ons application ONLINE ONLINE server5
ora....er5.vip ora....t1.type ONLINE ONLINE server5
# su - oracle
Last login: Sat Mar 21 22:13:59 CST 2020 on pts/0
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 21 22:20:45 2020
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> create table hr.t_objects as select* from dba_objects;
Table created.
SQL> con hr/oracle_4U
SP2-0734: unknown command beginning "con hr/ora..." - rest of line ignored.
SQL> conn hr/oracle_4U
Connected.
SQL> select count(*) from t_objects;
COUNT(*)
----------
91596
SQL>
tns串：
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin
C:\app\Apple\product\11.2.0\dbhome_1\NETWORK\ADMIN
3 ACL 组属性上的RWX指的是 ACL, 最好不要用chmod去改这三位，而要用setfacl
3.1
# chmod o-r file.html
# ls -l file.html
-rw-r----- 1 root root 12 Mar 22 05:21 file.html
# getfacl file.html
# file: file.html
# owner: root
# group: root
user::rw-
group::r--
other::---
# setfacl -m u:apache:r file.html
# ls -l file.html
-rw-r-----+ 1 root root 12 Mar 22 05:21 file.html
# getfacl file.html
# file: file.html
# owner: root
# group: root
user::rw-
user:apache:r--
group::r--
mask::r--
other::---
页:
[1]