11g升级

📅 发布时间：2026/9/3 6:42:48
11g升级 修改响应文件cat/home/oracle/db_install_11204.rspEOF oracle.install.responseFileVersion/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.optionINSTALL_DB_SWONLY ORACLE_HOSTNAMEbdhg UNIX_GROUP_NAMEoinstall INVENTORY_LOCATION/u01/app/oraInventory SELECTED_LANGUAGESen,zh_CN ORACLE_HOME/data/app/oracle/product/11.2.0.4/db_1 ORACLE_BASE/u01/app/oracle oracle.install.db.InstallEditionEE oracle.install.db.EEOptionsSelectionfalse #oracle.install.db.optionalComponentsoracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0 oracle.install.db.DBA_GROUPdba oracle.install.db.OPER_GROUPdba oracle.install.db.CLUSTER_NODES oracle.install.db.isRACOneInstall oracle.install.db.racOneServiceName oracle.install.db.config.starterdb.type oracle.install.db.config.starterdb.globalDBName oracle.install.db.config.starterdb.SID oracle.install.db.config.starterdb.characterSet oracle.install.db.config.starterdb.memoryOptiontrue oracle.install.db.config.starterdb.memoryLimit oracle.install.db.config.starterdb.installExampleSchemasfalse oracle.install.db.config.starterdb.enableSecuritySettingstrue oracle.install.db.config.starterdb.password.ALLoracle 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.controlDB_CONTROL oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL oracle.install.db.config.starterdb.automatedBackup.enablefalse 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 DECLINE_SECURITY_UPDATEStrue PROXY_HOST PROXY_PORT PROXY_USER PROXY_PWD PROXY_REALM COLLECTOR_SUPPORTHUB_URL oracle.installer.autoupdates.option oracle.installer.autoupdates.downloadUpdatesLoc AUTOUPDATES_MYORACLESUPPORT_USERNAME AUTOUPDATES_MYORACLESUPPORT_PASSWORD EOF查看用户对应的表空间SQLSELECT USERNAME, DEFAULT_TABLESPACE2FROM DBA_USERS3WHERE USERNAMEYW_GDZC;USERNAME DEFAULT_TABLESPACE ------------------------------ ------------------------------导出用户CREATE OR REPLACE DIRECTORY EXP_DIR AS/u01/app/oracle/expdp;GRANT READ, WRITE ON DIRECTORY EXP_DIR TO PUBLIC;SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAMEEXP_DIR;GRANT EXP_FULL_DATABASE TO YW_GDZC;expdp sys/oracleDIRECTORYEXPDUMPFILEEXP_DIR0831.dmpLOGFILEEXP_DIR.log修改环境配置exportORACLE_BASE/data/oracleexportORACLE_HOME$ORACLE_BASE/product/11.2.0/db_1exportPATH$ORACLE_HOME/bin:$PATHexportORACLE_SIDorcl[oraclebdhg ~]$cp.bash_profile .bash_profile0831[oraclebdhg db_1]$cddbs/[oraclebdhg dbs]$ ll8-rw-rw----1oracle dba15449132018hc_DBUA0.dat -rw-rw----1oracle dba154482804:39 hc_orcl.dat -rw-r--r--1oracle dba28515152009init.ora -rw-r-----1oracle dba249132018lkORCL -rw-r-----1oracle dba249132018lkORCL11G -rw-r-----1oracle dba15365262025orapworcl -rw-r-----1oracle dba25609108:19 spfileorcl.ora[oraclebdhg dbs]$echo$ORACLE_HOME/data/app/oracle/product/11.2.0.4/db_1[oraclebdhg dbs]$[oraclebdhg dbs]$[oraclebdhg dbs]$ *磁盘 -bash: *磁盘:commandnot found[oraclebdhg dbs]$[oraclebdhg dbs]$[oraclebdhg dbs]$cp-r* /data/app/oracle/product/11.2.0.4/db_1/[oraclebdhg dbs]$cat~/.bash_profileEOF ORACLE_HOME/data/app/oracle/product/11.2.0.4/db_1 ORACLE_BASE/u01/app/oracle export PATH$ORACLE_HOME/bin:$PATH export ORACLE_SIDorcl export ORACLE_HOME ORACLE_BASE EOF[oraclebdhg ~]$source.bash_profile[oraclebdhg ~]$ sqlplus / as sysdba SQL*Plus: Release11.2.0.4.0 Production on Tue Sep108:38:352026Copyright(c)1982,2013, Oracle. All rights reserved. Connected to an idle instance. SQL[oraclebdhg ~]$source.bash_profile0831[oraclebdhg ~]$ sqlplus / as sysdba SQL*Plus: Release11.2.0.1.0 Production on Tue Sep108:42:292026Copyright(c)1982,2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQLalter system chechpoint;alter system chechpoint * ERROR at line1: ORA-02065: illegal optionforALTER SYSTEM SQLalter system checkpoint;System altered. SQLSQLSQLSQLSQLDisconnected from Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options[oraclebdhg ~]$ lsnrctl status LSNRCTLforLinux: Version11.2.0.1.0 - Production on 01-SEP-2026 08:43:31 Copyright(c)1991,2009, Oracle. All rights reserved. Connecting to(DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOSTbdhg)(PORT1521)))STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNRforLinux: Version11.2.0.1.0 - Production Start Date28-AUG-2026 04:39:50 Uptime4days4hr.3min.41sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/bdhg/listener/alert/log.xml Listening Endpoints Summary...(DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOSTlocalhost.localdomain)(PORT1521)))Services Summary... Serviceorclhas1instance(s). Instanceorcl, status UNKNOWN, has1handler(s)forthis service... Serviceorcl11g.us.oracle.comhas1instance(s). Instanceorcl, status READY, has1handler(s)forthis service... ServiceorclXDB.us.oracle.comhas1instance(s). Instanceorcl, status READY, has1handler(s)forthis service... Thecommandcompleted successfully[oraclebdhg ~]$升级CREATE OR REPLACE DIRECTORY EXP AS/u01/app/oracle/expdp;GRANT READ, WRITE ON DIRECTORY EXP_DIR TO PUBLIC;SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAMEEXP;GRANT EXP_FULL_DATABASE TO YW_GDZC;expdp user/****DIRECTORYEXPDUMPFILEEXP0831.dmpLOGFILEEXP_DIR.logexportORACLE_BASE/data/oracleexportORACLE_HOME$ORACLE_BASE/product/11.2.0/db_1exportPATH$ORACLE_HOME/bin:$PATHexportORACLE_SIDorcl[oraclebdhg ~]$cp.bash_profile .bash_profile0831[oraclebdhg db_1]$cddbs/[oraclebdhg dbs]$ ll8-rw-rw----1oracle dba15449132018hc_DBUA0.dat -rw-rw----1oracle dba154482804:39 hc_orcl.dat -rw-r--r--1oracle dba28515152009init.ora -rw-r-----1oracle dba249132018lkORCL -rw-r-----1oracle dba249132018lkORCL11G -rw-r-----1oracle dba15365262025orapworcl -rw-r-----1oracle dba25609108:19 spfileorcl.ora[oraclebdhg dbs]$echo$ORACLE_HOME/data/app/oracle/product/11.2.0.4/db_1[oraclebdhg dbs]$[oraclebdhg dbs]$[oraclebdhg dbs]$ *磁盘 -bash: *磁盘:commandnot found[oraclebdhg dbs]$[oraclebdhg dbs]$[oraclebdhg dbs]$cp-r* /data/app/oracle/product/11.2.0.4/db_1/[oraclebdhg dbs]$cat~/.bash_profileEOF ORACLE_HOME/data/app/oracle/product/11.2.0.4/db_1 ORACLE_BASE/u01/app/oracle export PATH$ORACLE_HOME/bin:$PATH export ORACLE_SIDorcl export ORACLE_HOME ORACLE_BASE EOF[oraclebdhg ~]$source.bash_profile[oraclebdhg ~]$ sqlplus / as sysdba SQL*Plus: Release11.2.0.4.0 Production on Tue Sep108:38:352026Copyright(c)1982,2013, Oracle. All rights reserved. Connected to an idle instance. SQLSQLshow parameter control;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer7control_files string /home/oracle/datafile/orcl/orc l11g/control01.ctl, /data/orac le/flash_recovery_area/orcl11g /control02.ctl control_management_pack_access string DIAGNOSTICTUNING SQLshutdownimmediate;Database closed. Database dismounted. ORACLE instance shut down.升级数据字典编译失效对象startup upgrade spool /home/oracle/upgrade.log $ORACLE_HOME/rdbms/admin/utlu112i.sql $ORACLE_HOME/rdbms/admin/catupgrd.sql $ORACLE_HOME/rdbms/admin/utlrp.sql alter systemsetcompatible11.2.0.4.0scopespfile;

相关新闻