银河麒麟系统安装ORACLE数据库问题处理

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: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
复制

sqlldr rman oracle lsnrctl expdp exp adrci tkprof tnsping tnslsnr ......
复制

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/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@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.
复制

root@CJC-DB-01:/soft/oracle#java -version
-bash: java: command not found
复制

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.
复制

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 
复制

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.10)(PORT = 25211))
    )
  )


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
复制

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
复制

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
复制

/oracle/app/oracle/product/11.2/db/bin$scp -P 16022 sqlldr rman oracle lsnrctl expdp exp adrci tkprof tnsping tnslsnr oracle@CJC-DB-01:/home/oracle/tmp
复制

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
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 01-MAR-2023 15:34:43
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Starting /oracle/app/oracle/product/11.2/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/11.2/db/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/CJC-DB-01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.10)(PORT=25211)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.10)(PORT=25211)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                01-MAR-2023 15:34:43
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/11.2/db/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/CJC-DB-01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.10)(PORT=25211)))
Services Summary...
Service "test" has 1 instance(s).
  Instance "test", status UNKNOWN, has 1 handler(s) for this service...
复制

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
复制