admin 管理员组

文章数量: 1184232


2023年12月23日发(作者:shell脚本if用法)

[DELETEINSTANCE]DB_UNIQUE_NAME =""INSTANCENAME = "orcl12c"SYSDBAUSERNAME = "sys"[CREATEPLUGGABLEDATABASE]SOURCEDB = "orcl"PDBNAME = "PDB1"[UNPLUGDATABASE]SOURCEDB = "orcl"PDBNAME = "PDB1"ARCHIVETYPE = "TAR"[DELETEPLUGGABLEDATABASE]SOURCEDB = "orcl"PDBNAME = "PDB1"[CONFIGUREPLUGGABLEDATABASE]SOURCEDB = "orcl"PDBNAME = "PDB1"[oracle@localhost ~]$

创建数据库

[oracle@localhost ~]$ dbca -silent-createDatabase -responseFile /opt/oracle/oracinstall/database/response/

Enter SYS user password: sys

Enter SYSTEM user password: system

Copying database files1% complete3% complete11% complete18% complete26% complete33% complete37% completeCreating and starting Oracle instance

40% complete45% complete50% complete55% complete56% complete60% complete62% completeCompleting Database Creation66% complete70% complete73% complete85% complete96% complete100% completeLook at the log file"/usr/oracle/cfgtoollogs/dbca/orcl12c/" for furtherdetails.

5、查看状态

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on ThuMar 29 17:37:06 2018

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

Connected to:Oracle Database 12c Standard Edition Release12.1.0.2.0 - 64bit Production

SQL> select * from dual;

D-X


本文标签: 脚本 数据库 状态 创建 查看