銀河麒麟系統安裝ORACLE資料庫問題處理
問題一：軟體安裝報錯，需要手動安裝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###
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29785807/viewspace-2937706/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 銀河麒麟系統安裝mongodb副本集故障處理MongoDB
- 銀河麒麟系統部署keepalived.故障處理
- 國產化之銀河麒麟安裝達夢資料庫DM8資料庫
- vmware安裝銀河麒麟V10系統宿主機斷電異常關機銀河麒麟開機報錯
- 國產化之Arm64 CPU+銀河麒麟系統安裝.NetCoreNetCore
- 國產化之虛擬ARM64-CPU安裝銀河麒麟作業系統作業系統
- 在銀河麒麟高階伺服器作業系統V10上安裝docker伺服器作業系統Docker
- 銀河麒麟系統如何建立rc-local.service服務？
- 銀河麒麟V10安裝MySQL8.0.28並實現遠端訪問MySql
- Oracle資料庫無效物件問題處理Oracle資料庫物件
- Oracle資料庫中的逐行處理問題NEOracle資料庫
- 近期處理的Oracle資料庫問題總結Oracle資料庫
- 國產化之銀河麒麟安裝.NetCore-包管理器方式NetCore
- Oracle日常問題處理-資料庫無法啟動Oracle資料庫
- Arm架構下麒麟作業系統安裝配置Mariadb資料庫架構作業系統資料庫
- 常見問題--oracle資料庫安裝準備Oracle資料庫
- Oracle資料庫系統緊急故障處理方法(轉)Oracle資料庫
- 如何處理Oracle資料庫中的壞塊問題(轉)Oracle資料庫
- 資料庫響應慢問題處理資料庫
- 安裝資料庫和資料庫解決問題資料庫
- jive安裝連資料庫問題？資料庫
- 麒麟系統開發筆記（五）：製作安裝麒麟系統、物理機安裝麒麟系統搭建Qt開發環境筆記QT開發環境
- ORACLE LINUX 6 安裝telnet包問題處理OracleLinux
- 資料庫升級問題處理一則資料庫
- oracle系統表空間過大問題處理Oracle
- linux系統和oracle資料庫安裝簡介LinuxOracle資料庫
- 國產化之銀河麒麟.netcore3.1訪問https服務的兩個問題NetCoreHTTP
- 聯瑞網路卡獲得銀河麒麟作業系統適配認證證書作業系統
- 專案實施之windows server平臺上安裝oracle資料庫幾個問題的處理記錄WindowsServerOracle資料庫
- 「Oracle」Oracle 資料庫安裝Oracle資料庫
- 銀河麒麟、中標麒麟學習實操資料彙總（含V4、V7、V10）
- oracle資料庫安裝Oracle資料庫
- 一次OWB資料庫效能問題處理資料庫
- Mac遊戲安裝常見問題處理Mac遊戲
- mysql5.7安裝及問題處理MySql
- Docker Centos安裝Redis以及問題處理DockerCentOSRedis
- 記一次：歸檔檔案系統問題導致資料庫hang處理資料庫
- 企業實踐 | 國產作業系統之光? 銀河麒麟KylinOS-V10(SP3)高階伺服器作業系統基礎安裝篇作業系統伺服器