非Oracle Linux下Oracle 19c CDB数据库安装

cp /etc/init.d/oracledb_ORCLCDB-19c /etc/init.d/oracledb_pdbisal-19c

vi oracledb_bisal-pdb19c
export ORACLE_VERSION=19c
export ORACLE_SID=PDBISAL
export TEMPLATE_NAME=General_Purpose.dbc
export CHARSET=AL32UTF8
export PDB_NAME=BISALPDB1
export LISTENER_NAME=PDBLISTENER
export NUMBER_OF_PDBS=1
export CREATE_AS_CDB=true


# General exports and vars
export PATH=$ORACLE_HOME/bin:$PATH
LSNR=$ORACLE_HOME/bin/lsnrctl
SQLPLUS=$ORACLE_HOME/bin/sqlplus
DBCA=$ORACLE_HOME/bin/dbca
NETCA=$ORACLE_HOME/bin/netca
ORACLE_OWNER=oracle
RETVAL=0
CONFIG_NAME="oracledb_$ORACLE_SID-$ORACLE_VERSION.conf"
CONFIGURATION="/etc/sysconfig/$CONFIG_NAME"
...

cp /etc/sysconfig/oracledb_BISAL-19c.conf /etc/sysconfig/oracledb_PDBISAL-19c.conf

vi oracledb_PDBISAL-19c.conf
#This is a configuration file to setup the Oracle Database. 
#It is used when running '/etc/init.d/oracledb_ORCLCDB configure'.
#Please use this file to modify the default listener port and the
#Oracle data location.


# LISTENER_PORT: Database listener
LISTENER_PORT=1522


# ORACLE_DATA_LOCATION: Database oradata location
ORACLE_DATA_LOCATION=/opt/oracle/pdboradata


# EM_EXPRESS_PORT: Oracle EM Express listener
EM_EXPRESS_PORT=5600

[root@bisal init.d]# ./oracledb_bisal-pdb19c configure
Configuring Oracle Database PDBISAL.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/PDBISAL.
Database Information:
Global Database Name:PDBISAL
System Identifier(SID):PDBISAL
Look at the log file "/opt/oracle/cfgtoollogs/dbca/PDBISAL/PDBISAL.log" for further details.


Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

SQL> select cdb from v$database;
CDB
---
YES

SQL> show pdbs;
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 BISALPDB1                      READ WRITE NO

 $SU -s /bin/bash  $ORACLE_OWNER -c "$DBCA -silent -createDatabase -gdbName $ORACLE_SID -templateName $TEMPLATE_NAME 
 -characterSet $CHARSET -createAsContainerDatabase $CREATE_AS_CDB -numberOfPDBs $NUMBER_OF_PDBS -pdbName $PDB_NAME 
 -createListener $LISTENER_NAME:$LISTENER_PORT -datafileDestination $ORACLE_DATA_LOCATION -sid $ORACLE_SID 
 -autoGeneratePasswords -emConfiguration DBEXPRESS -emExpressPort $EM_EXPRESS_PORT"

export TEMPLATE_NAME=General_Purpose.dbc
-templateName $TEMPLATE_NAME

[root@bisal /]# find . -name General_Purpose.dbc
./opt/oracle/product/19c/dbhome_1/assistants/dbca/templates/General_Purpose.dbc