问题一：软件安装报错，需要手动安装libnsl
There was an error trying to initialize the HPI library. Please check your installation, HotSpot does not work correctly when installed in the JDK 1.2 Linux Production Release, or with any JDK 1.1.x release.
问题二：软件安装完成后，无法执行sqlplus等命令，报错如下，需要手动拷贝文件
sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
问题三：软件安装完成后，$ORACLE_HOME/bin下多个文件大小为0，需要手动拷贝文件
sqlldr rman oracle lsnrctl expdp exp adrci tkprof tnsping tnslsnr ......
问题四：执行检查监听、rman等命令，报错找不到libclntsh.so.11.1文件，需要手动拷贝文件
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$lsnrctl lsnrctl: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
问题五：软件安装后，提示找不到rootadd_rdbms.sh、rootadd_filemap.sh，
检查安装介质完整性，两个文件是否全部解压成功
/oracle/app/oracle/product/11.2/db/root.sh: line 14: /oracle/app/oracle/product/11.2/db/rdbms/install/rootadd_rdbms.sh: No such file or directory /oracle/app/oracle/product/11.2/db/root.sh: line 16: /oracle/app/oracle/product/11.2/db/rdbms/install/rootadd_filemap.sh: No such file or directory
过程如下：
操作系统信息：
oracle@CJC-DB-01:/home/oracle$nkvers ############## Kylin Linux Version ################# Release: Kylin Linux Advanced Server release V10 (Tercel) Kernel: 4.19.90-23.30.v2101.ky10.x86_64 Build: Kylin Linux Advanced Server release V10 (SP1) /(Tercel)-x86_64-Build20/20210518 #################################################
一：整理Oracle软件静默安装响应文件
oracle@CJC-DB-01:/soft/oracle$cat 04_soft.sh install_database_log=/soft/log/install_database.log install_database_rsp_file=/soft/scripts/install_database.rsp oracle_base=/oracle/app/oracle oracle_home=/oracle/app/oracle/product/11.2/db oraInventory_dir=/oracle/app/oracle/oraInventory hostname=CJC-DB-01 cat > /soft/scripts/install_database_rsp_file.rsp << EOF oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=$hostname UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/oracle/app/oracle/oraInventory SELECTED_LANGUAGES=en ORACLE_BASE=$oracle_base ORACLE_HOME=$oracle_home oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.optionalComponents= oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oper oracle.install.db.CLUSTER_NODES= oracle.install.db.isRACOneInstall=false oracle.install.db.racOneServiceName= oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption=false oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.SYSMAN= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= oracle.install.db.config.starterdb.automatedBackup.enable=false oracle.install.db.config.starterdb.automatedBackup.osuid= oracle.install.db.config.starterdb.automatedBackup.ospwd= oracle.install.db.config.starterdb.storageType= oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword= MYORACLESUPPORT_USERNAME= MYORACLESUPPORT_PASSWORD= SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD= PROXY_REALM= COLLECTOR_SUPPORTHUB_URL= oracle.installer.autoupdates.option=SKIP_UPDATES oracle.installer.autoupdates.downloadUpdatesLoc= AUTOUPDATES_MYORACLESUPPORT_USERNAME= AUTOUPDATES_MYORACLESUPPORT_PASSWORD= EOF su - oracle -c "LANG=C; /soft/oracle/database/runInstaller -silent -noconfig -ignoreSysPrereqs -ignorePrereq -showprogress -responseFile /soft/scripts/install_database_rsp_file.rsp &" | tee /soft/log/install_database.log sh /oracle/app/oracle/product/11.2/db/root.sh
二：执行脚本，安装数据库软件
root@CJC-DB-01:/soft/oracle#sh 04_soft.sh Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 3600 MB Passed Checking swap space: must be greater than 150 MB. Actual 2043 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-03-01_10-38-35AM. Please wait ...Could not create the Java virtual machine. There was an error trying to initialize the HPI library. Please check your installation, HotSpot does not work correctly when installed in the JDK 1.2 Linux Production Release, or with any JDK 1.1.x release. sh: /oracle/app/oracle/product/11.2/db/root.sh: No such file or directory
报错：
There was an error trying to initialize the HPI library. Please check your installation, HotSpot does not work correctly when installed in the JDK 1.2 Linux Production Release, or with any JDK 1.1.x release.
检查java版本
root@CJC-DB-01:/soft/oracle#java -version -bash: java: command not found
手动安装libnsl
root@CJC-DB-01:/soft/oracle#yum install libnsl Last metadata expiration check: 0:07:27 ago on Wed 01 Mar 2023 10:48:38 AM CST. Dependencies resolved. =================================================================================================================================================== Package Architecture Version Repository Size =================================================================================================================================================== Installing: libnsl x86_64 2.28-36.1.p03.ky10 Kylin 45 k Transaction Summary =================================================================================================================================================== Install 1 Package Total download size: 45 k Installed size: 94 k Is this ok [y/N]: y Downloading Packages: libnsl-2.28-36.1.p03.ky10.x86_64.rpm 15 MB/s | 45 kB 00:00 --------------------------------------------------------------------------------------------------------------------------------------------------- Total 4.4 MB/s | 45 kB 00:00 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : libnsl-2.28-36.1.p03.ky10.x86_64 1/1 Running scriptlet: libnsl-2.28-36.1.p03.ky10.x86_64 1/1 Verifying : libnsl-2.28-36.1.p03.ky10.x86_64 1/1 Installed: libnsl-2.28-36.1.p03.ky10.x86_64 Complete!
再次安装
root@CJC-DB-01:/soft/oracle#sh 04_soft.sh Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 3384 MB Passed Checking swap space: must be greater than 150 MB. Actual 1993 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-03-01_11-11-48AM. Please wait ...[WARNING] [INS-32055] The Central Inventory is located in the Oracle base. CAUSE: The Central Inventory is located in the Oracle base. ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory. You can find the log of this install session at: /oracle/app/oracle/oraInventory/logs/installActions2023-03-01_11-11-48AM.log Prepare in progress. .................................................. 9% Done. Prepare successful. Copy files in progress. .................................................. 14% Done. .................................................. 20% Done. .................................................. 26% Done. .................................................. 31% Done. .................................................. 36% Done. .................................................. 41% Done. .................................................. 46% Done. .................................................. 51% Done. .................................................. 56% Done. .................................................. 63% Done. .................................................. 68% Done. .................................................. 73% Done. .................................................. 78% Done. .................................................. 83% Done. .............................. Copy files successful. Link binaries in progress. .......... Link binaries successful. Setup files in progress. .................................................. 88% Done. .................................................. 94% Done. Setup files successful. The installation of Oracle Database 11g was successful. Please check '/oracle/app/oracle/oraInventory/logs/silentInstall2023-03-01_11-11-48AM.log' for more details. Execute Root Scripts in progress. As a root user, execute the following script(s): 1. /oracle/app/oracle/oraInventory/orainstRoot.sh 2. /oracle/app/oracle/product/11.2/db/root.sh .................................................. 100% Done. Execute Root Scripts successful. Successfully Setup Software. Check /oracle/app/oracle/product/11.2/db/install/root_CJC-DB-01_2023-03-01_11-13-22.log for the output of root script
检查安装日志
root@CJC-DB-01:/soft/oracle#vi /oracle/app/oracle/product/11.2/db/install/root_CJC-DB-01_2023-03-01_11-13-22.log Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/app/oracle/product/11.2/db Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Finished product-specific root actions. Finished product-specific root actions.
检查数据库软件版本，报错没有libclntsh.so.11.1文件
oracle@CJC-DB-01:/home/oracle$sqlplus -V sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory oracle@CJC-DB-01:/home/oracle$sqlplus / as sysdba sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory oracle@CJC-DB-01:/home/oracle$
查找文件
root@CJC-DB-01:/soft/oracle#find / -name libclntsh.so.11.1 /tmp/OraInstall2023-03-01_10-38-35AM/ext/lib/libclntsh.so.11.1 /soft/oracle/database/stage/ext/lib/libclntsh.so.11.1 /oracle/app/oracle/product/11.2/db/inventory/Scripts/ext/lib/libclntsh.so.11.1 /oracle/app/oracle/product/11.2/db/inventory/backup/2023-03-01_11-11-48AM/Scripts/ext/lib/libclntsh.so.11.1 oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/lib$ls |wc -l 262
手动拷贝文件
root@CJC-DB-01:/root#cp /soft/oracle/database/stage/ext/lib/libclntsh.so.11.1 /oracle/app/oracle/product/11.2/db/lib/ root@CJC-DB-01:/root#chown oracle.oinstall /oracle/app/oracle/product/11.2/db/lib/libclntsh.so.11.1
可以正常执行sqlplus命令
oracle@CJC-DB-01:/home/oracle$sqlplus -v SQL*Plus: Release 11.2.0.4.0 Production
三:配置监听
su - oracle cd $ORACLE_HOME/network/admin ls listener.ora vi $ORACLE_HOME/network/admin/listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.30)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = test) (ORACLE_HOME = /oracle/app/oracle/product/11.2/db) (SID_NAME = test) ) )
执行监听命令，没有任何输出，也没有报错
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/network/admin$lsnrctl oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/network/admin$lsnrctl staus oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/network/admin$tnsping test
检查文件大小，0
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$ls -lrth lsnrctl -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 lsnrctl
按照文件大小进行排列，检查是否有其他文件大小为0
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$ls -Slr -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 wrap -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 uidrvci -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 tstshm -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 trcroute -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 trcldr -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 tnsping -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 tnslsnr -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 tnnfg -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 tkprof -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 sqlldr -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 skgxpinfo -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 setasmgid -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 sbttest -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 rman -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 renamedg -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 rawutl -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 proc -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 plshprof -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 orapwd -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 oracle -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 oklist -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 okinit -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 okdstry -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ojmxtool0 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ojmxtool -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmupm0 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmupm -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmosudo0 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmosudo -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmocat0 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmocat -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmo0 -rws--x--- 1 root oinstall 0 Aug 24 2013 nmo -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmhs0 -rws--x--- 1 root oinstall 0 Aug 24 2013 nmhs -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmei0 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmei -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 nmb0 -rws--x--- 1 root oinstall 0 Aug 24 2013 nmb -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 nid -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 maxmem -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 mapsga -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 lsnrctl -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapsearch -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapmodifymt -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapmodify -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapmoddn -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapdelete -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapcompare -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapaddmt -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 ldapadd -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 kfod -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 kfed -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 impdp -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 imp -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 hsots -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 hsdepxa -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 hsalloci -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 grdcscan -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 extproc -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 expdp -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 exp -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 emtgtctl20 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 emtgtctl2 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 emdctl0 -rwx------ 1 oracle oinstall 0 Aug 24 2013 emdctl -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 emagtmc -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 emagtm -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 emagent0 -rwx------ 1 oracle oinstall 0 Aug 24 2013 emagent -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 e2eme0 -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 e2eme -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 dumpsga -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 dsml2ldif -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 dgmgrl -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 dg4pwd -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 dg4odbc -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 dbv -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 dbfsize -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 cursize -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 ctxload -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 ctxlc -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 ctxkbtc -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 amdu -rwxr-x--- 1 oracle oinstall 0 Aug 24 2013 agtctl -rwxr-xr-x 1 oracle oinstall 0 Aug 24 2013 adrci
和其他正常的数据库做对比，多了19个空文件，对应的命令无法正常执行。
尝试手动将其他库上的文件拷贝过来。
oracle@ebtedb-daw-01:/oracle/app/oracle/product/11.2/db/bin$scp -P 16022 sqlldr rman oracle lsnrctl expdp exp adrci tkprof tnsping tnslsnr oracle@25.2.32.204:/home/oracle/tmp Warning: Permanently added '[25.2.32.204]:16022' (ECDSA) to the list of known hosts.
再次启动监听、rman等命令，报错找不到libclntsh.so.11.1文件
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$lsnrctl lsnrctl: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$rman rman: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
查找文件
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$find /oracle -name libclntsh.so.11.1 /oracle/app/oracle/product/11.2/db/inventory/Scripts/ext/lib/libclntsh.so.11.1 /oracle/app/oracle/product/11.2/db/inventory/backup/2023-03-01_02-55-23PM/Scripts/ext/lib/libclntsh.so.11.1
手动拷贝文件
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$cp /oracle/app/oracle/product/11.2/db/inventory/Scripts/ext/lib/libclntsh.so.11.1 /oracle/app/oracle/product/11.2/db/lib/
监听可以正常启动
oracle@CJC-DB-01:/oracle/app/oracle/product/11.2/db/bin$lsnrctl LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 01-MAR-2023 15:32:54 Copyright (c) 1991, 2013, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL>
启动监听
oracle@CJC-DB-01:/home/oracle$lsnrctl start
四：DBCA创建实例
整理Oracle创建实例静默安装响应文件
root@CJC-DB-01:/soft/scripts#cat dbca.rsp [GENERAL] RESPONSEFILE_VERSION = "11.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE] GDBNAME = "test" SID = "test" TEMPLATENAME = "General_Purpose.dbc" CHARACTERSET = "AL32UTF8" NATIONALCHARACTERSET = "AL16UTF16" DATAFILEDESTINATION="/oradata" STORAGETYPE = "FS" SYSPASSWORD = "xxxxxx" SYSTEMPASSWORD = "xxxxxx" EMCONFIGURATION = NONE
执行静默建库
su - oracle oracle@CJC-DB-01:/home/oracle$dbca -silent -responseFile /soft/scripts/dbca.rsp | tee /soft/log/dbca.log Copying database files 1% complete 2% complete 4% complete 37% complete Creating and starting Oracle instance 38% complete 40% complete 45% complete 50% complete 51% complete 56% complete 57% complete 61% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 74% complete 85% complete 86% complete 98% complete 100% complete Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/test/test.log" for further details.
检查安装日志
oracle@CJC-DB-01:/home/oracle$cat /oracle/app/oracle/cfgtoollogs/dbca/test/test.log Copying database files DBCA_PROGRESS : 1% DBCA_PROGRESS : 3% DBCA_PROGRESS : 11% DBCA_PROGRESS : 18% DBCA_PROGRESS : 26% DBCA_PROGRESS : 37% Creating and starting Oracle instance DBCA_PROGRESS : 40% DBCA_PROGRESS : 45% DBCA_PROGRESS : 50% DBCA_PROGRESS : 55% DBCA_PROGRESS : 56% DBCA_PROGRESS : 60% DBCA_PROGRESS : 62% Completing Database Creation DBCA_PROGRESS : 66% DBCA_PROGRESS : 70% DBCA_PROGRESS : 73% DBCA_PROGRESS : 85% DBCA_PROGRESS : 96% DBCA_PROGRESS : 100% Database creation complete. For details check the logfiles at: /oracle/app/oracle/cfgtoollogs/dbca/test. Database Information: Global Database Name:test System Identifier(SID):test
五：检查数据库
oracle@CJC-DB-01:/home/oracle$sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 1 15:38:21 2023 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- TEST READ WRITE
###chenjuchao 20230301###