AIX 安装 Oracle 19c-install.rsp响应文件.txt

CHEN Y.F.

277

3页

3次

2023-04-23

免费下载

[oracle@adg19c ~]$ cat /home/oracle/19c_db_install.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_sch

ema_v19.0.0

oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/opt/oracle/oraInventory

ORACLE_BASE=/home/oracle/app

ORACLE_HOME=/home/oracle/app/product/19.3.0/dbhome_1

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=dba

oracle.install.db.OSOPER_GROUP=oper

oracle.install.db.OSDGDBA_GROUP=dgdba

oracle.install.db.OSKMDBA_GROUP=kmdba

oracle.install.db.OSRACDBA_GROUP=racdba

oracle.install.db.OSBACKUPDBA_GROUP=oinstall

oracle.install.db.rootconfig.executeRootScript=true

oracle.install.db.rootconfig.configMethod=ROOT

# 运行安装命令

[oracle@adg19c ~]$ $ORACLE_HOME/runInstaller -silent -force -noconfig

-ignorePrereq -responseFile /home/oracle/19c_db_install.rsp

$ORACLE_HOME/runInstaller -silent -responseFile /home/oracle/19c_db_install.rsp

================================================================================

=========================================================

mkdir /oradata/

mkdir -p /oradata/fast_recovery_area

chmod 775 /oradata/datafile

chmod 775 /oradata/fast_recovery_area

vi /home/oracle/19c_dbca.rsp

responseFileVersion=/home/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0

templateName=General_Purpose.dbc

gdbName=oxdb19c

sid=oxdb19c

createAsContainerDatabase=FALSE

sysPassword=oracle

systemPassword=oracle

datafileDestination=/oradata/

recoveryAreaDestination=/oradata/fast_recovery_area

storageType=FS

characterSet=AL32UTF8

nationalCharacterSet=AL16UTF16

sampleSchema=true

totalMemory=20480

databaseType=OLTP

emConfiguration=NONE

$dbca -silent -createDatabase -responseFile /home/oracle/19c_dbca.rsp

================================================================================

=========================================================

编写监听配置文件

vi /home/oracle/19c_netca.rsp

[GENERAL]

RESPONSEFILE_VERSION="19.3"

CREATE_TYPE="CUSTOM"

[oracle.net.ca]

INSTALLED_COMPONENTS={"server","net8","javavm"}

INSTALL_TYPE=""typical""

LISTENER_NUMBER=1

LISTENER_NAMES={"LISTENER"}

LISTENER_PROTOCOLS={"TCP;1521"}

LISTENER_START=""LISTENER""

NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}

NSN_NUMBER=1

NSN_NAMES={"EXTPROC_CONNECTION_DATA"}

NSN_SERVICE={"PLSExtProc"}

NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

# 静默配置监听

$ netca /silent /responsefile /home/oracle/19c_netca.rsp

================================================================================

=========================================================

select * FROM DBA_DATA_FILES;

查看表空间的名称及大小

select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size

from dba_tablespaces t, dba_data_files d

where t.tablespace_name = d.tablespace_name

group by t.tablespace_name;

查看表空间物理文件的名称及大小

set linesize 400

col TABLESPACE_NAME for a15

col file_id for 99

col file_name for a50

select tablespace_name, file_id, file_name,

round(bytes/(1024*1024),0) total_space

from dba_data_files

order by tablespace_name;

查看控制文件

set linesize 300

col name for a70

select * from v$controlfile;

查看日志文件

set linesize 300

col MEMBER for a70

select * from v$logfile;

查看表空间的使用情况

select sum(bytes)/(1024*1024) as free_space,tablespace_name

from dba_free_space

group by tablespace_name;

查看数据库库对象

select owner, object_type, status, count(*) count# from all_objects group by

owner, object_type, status;

查看数据库的版本

select version FROM Product_component_version

where SUBSTR(PRODUCT,1,6)='Oracle';

查看数据库的创建日期和归档方式

select Created, Log_Mode, Log_Mode From V$Database;

of 3

免费下载

aix7.1 oracle19c 自动建库响应文件脚本

相关文档

评论