在Oracle21c之后,一些目录发生了变化,如监听配置文件、dbs目录。 示例如下:
Oracle21c安装之后,目录如下
#$ORACLE_BASE目录下admin audit cfgtoollogs dbs diag homes oradata product[oracle@oracle21 oracle]$ pwd/u01/app/oracle# 19c $ORACLE_BASE目录下。ASM[oracle@rac19c oracle]$ lsadmin audit cfgtoollogs checkpoints diag product#检查Oracle21c目录[oracle@oracle21 oracle]$ orabasehome /u01/app/oracle/homes/OraDB21Home1[oracle@oracle21 oracle]$ orabaseconfig /u01/app/oracle[oracle@oracle21 oracle]$ #检查19c目录[oracle@rac19c ~]$ orabasehome /u02/app/oracle/product/19.0.0/db_1[oracle@rac19c ~]$ orabaseconfig /u02/app/oracle/product/19.0.0/db_1[oracle@rac19c ~]$ orabase/u02/app/oracle[oracle@rac19c ~]$ #检查21c监听状态及文件位置,如下所示,已经在/homes/OraDB21Home1/network/admin/listener.ora目录下,配置tnsnames也需要在该目录下[oracle@oracle21 oracle]$ lsnrctl statLSNRCTL for Linux: Version 21.0.0.0.0 - Production on 20-AUG-2021 13:52:09Copyright (c) 1991, 2021, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle21)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 21.0.0.0.0 - ProductionStart Date 20-AUG-2021 13:33:24Uptime 0 days 0 hr. 18 min. 45 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/homes/OraDB21Home1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/oracle21/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle21)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Services Summary...Service "c8209f27c6b16005e053362ee80ae60e" has 1 instance(s). Instance "mydb21", status READY, has 1 handler(s) for this service...Service "c9e6ddb27463ad21e0531550a8c0a46d" has 1 instance(s). Instance "mydb21", status READY, has 1 handler(s) for this service...Service "mydb21" has 1 instance(s). Instance "mydb21", status READY, has 1 handler(s) for this service...Service "mydb21XDB" has 1 instance(s). Instance "mydb21", status READY, has 1 handler(s) for this service...Service "mypdb21" has 1 instance(s). Instance "mydb21", status READY, has 1 handler(s) for this service...The command completed successfully[oracle@oracle21 oracle]$
检查数据库中一些信息
--检查spfile文件,已不在原来的ORACLE_HOME目录下SQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /u01/app/oracle/dbs/spfilemydb21.oraSQL>
虽然Oracle21c中想变化为只读目录,但目前查看目录权限,仍然可写。 权限如下:
SQL> Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - ProductionVersion 21.3.0.0.0[oracle@oracle21 oracle]$ pwd/u01/app/oracle[oracle@oracle21 oracle]$ ls -lrttotal 32drwxr-xr-x. 3 oracle oinstall 4096 Aug 19 16:18 productdrwxrwxr-x. 23 oracle oinstall 4096 Aug 19 16:35 diagdrwxr-x---. 3 oracle oinstall 4096 Aug 19 16:35 homesdrwxr-x---. 5 oracle oinstall 4096 Aug 19 16:42 cfgtoollogsdrwxr-x---. 3 oracle oinstall 4096 Aug 19 16:53 admindrwxr-x---. 3 oracle oinstall 4096 Aug 19 16:53 oradatadrwxr-x---. 3 oracle oinstall 4096 Aug 19 16:55 auditdrwxr-x---. 2 oracle oinstall 4096 Aug 20 13:53 dbs[oracle@oracle21 oracle]$
目前Oracle21c已经将一些目录分离出来,权限管理可以越来越细化,更好保障数据库的安全,后续继续测试。
