Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets (‘[]’). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done

Welcome to fdisk (util-linux 2.37.4).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table.
Created a new DOS disklabel with disk identifier 0x12345678.

Command (m for help): n
Partition type
p primary (0 primary, 0 extended, 4 free)
e extended (container for logical partitions)
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-419430399, default 2048):
Last sector, +/-sectors or +/-size{K,M,G,T,P} (2048-419430399, default 419430399):

Created a new partition 1 of type ‘Linux’ and of size 200 GiB.

Command (m for help): w
The partition table has been altered.
Calling ioctl() to re-read partition table.
Syncing disks.

# 创建ASM磁盘
# oracleasm createdisk DATA01 /dev/sdc1
Writing disk header: done
Instantiating disk: done

# 查看ASM磁盘
# oracleasm listdisks
DATA01

# 应用RU补丁（19.7）
$ unzip -q /backup/LINUX.X64_197000_db_ojvm_home.zip
$ cd /oracle/app/oracle/product/19c/db_1
$ ./runInstaller -applyRU /backup/30783543/30869156 -applyOneOffs /backup/30783543/30805684,/backup/30783543/29585399

# 执行图形化安装
$ cd /oracle/app/oracle/product/19c/db_1
$ ./runInstaller

# 安装过程中的关键步骤：
1. 选择”Install database software only”
2. 选择”Single instance database installation”
3. 选择企业版
4. 设置Oracle基目录：/oracle/app/oracle
5. 设置软件位置：/oracle/app/oracle/product/19c/db_1
6. 选择”Use Oracle Automatic Storage Management”
7. 选择ASM磁盘组：DATA
8. 设置ASM密码
9. 检查先决条件，点击”下一步”
10. 点击”完成”开始安装
11. 安装完成后，运行root脚本

Changing groupname of /oracle/app/oraInventory to oinstall.
The execution of the script is complete.

# /oracle/app/oracle/product/19c/db_1/root.sh
Check /oracle/app/oracle/product/19c/db_1/install/root_fgedudb01_202403291000.log for the output of root script

# 创建数据库的关键步骤：
1. 选择”创建数据库”
2. 选择”高级配置”
3. 数据库标识符：
– 全局数据库名：fgedudb
– 系统标识符(SID)：fgedudb
4. 选择”使用Oracle Automatic Storage Management”
5. 选择ASM磁盘组：DATA
6. 配置管理选项：选择”使用Enterprise Manager”
7. 设置数据库密码
8. 选择”文件系统”
9. 指定数据库文件位置：+DATA
10. 指定快速恢复区：+DATA/FRA
11. 不启用自动维护任务
12. 配置内存参数：
– SGA：40GB
– PGA：8GB
13. 配置字符集：AL32UTF8
14. 配置示例方案
15. 点击”完成”开始创建

SQL> STARTUP

— 开启归档模式
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;

— 配置归档日志位置
SQL> ALTER SYSTEM SET log_archive_dest_1=’LOCATION=+DATA/FRA’ SCOPE=SPFILE;

— 配置强制归档
SQL> ALTER SYSTEM SET log_archive_format=’fgedudb_%t_%s_%r.arc’ SCOPE=SPFILE;

— 检查归档模式
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/FRA
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2

— 配置监听器的关键步骤：
1. 选择”监听程序配置”
2. 选择”添加”
3. 输入监听程序名称：LISTENER
4. 选择协议：TCP
5. 输入端口号：1521
6. 选择”不”
7. 点击”完成”

— 启动监听器
$ lsnrctl start

— 检查监听器状态
$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 29-MAR-2024 10:00:00

Copyright (c) 1991, 2023, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fgedudb01)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 29-MAR-2024 10:00:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/19c/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/fgedudb01/listener/alert/log.xml

Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fgedudb01)(PORT=1521)))

Services Summary…
Service “fgedudb” has 1 instance(s).
Instance “fgedudb”, status READY, has 1 handler(s) for this service…
Service “fgedudbXDB” has 1 instance(s).
Instance “fgedudb”, status READY, has 1 handler(s) for this service…

FGEDUDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fgedudb01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fgedudb)
)
)

— 测试连接
$ sqlplus system/Oracle123@fgedudb

SQL*Plus: Release 19.0.0.0.0 – Production on Fri Mar 29 10:00:00 2024
Version 19.7.0.0.0

Copyright (c) 1982, 2023, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.7.0.0.0

SQL>

BANNER
——————————————————————————–
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.7.0.0.0

PL/SQL Release 19.0.0.0.0 – Production
CORE 19.0.0.0 Production
TNS for Linux: Version 19.0.0.0.0 – Production
NLSRTL Version 19.0.0.0.0 – Production

— 检查数据库状态
SQL> SELECT status FROM v$instance;
STATUS
————
OPEN

— 检查数据文件状态
SQL> SELECT name, status FROM v$datafile;

NAME STATUS
————————————————– ——–
+DATA/fgedudb/system01.dbf SYSTEM
+DATA/fgedudb/sysaux01.dbf ONLINE
+DATA/fgedudb/undotbs01.dbf ONLINE
+DATA/fgedudb/users01.dbf ONLINE

— 检查表空间状态
SQL> SELECT tablespace_name, status FROM dba_tablespaces;

TABLESPACE_NAME STATUS
—————————— ——–
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE

NAME TOTAL_MB FREE_MB
———- ———- ———-
DATA 204800 102400

— 检查ASM磁盘
SQL> SELECT name, path, total_mb FROM v$asm_disk;

NAME PATH TOTAL_MB
——– ————- ———-
DATA01 ORCL:DATA01 204800

— 检查归档日志
SQL> SELECT name, sequence#, first_change# FROM v$archived_log ORDER BY sequence#;

NAME SEQUENCE# FIRST_CHANGE#
—————————————— ———- ————–
+DATA/FRA/fgedudb_1_1_123456789.arc 1 123456789
+DATA/FRA/fgedudb_1_2_123456789.arc 2 123456790