2017年7月24日 星期一
oracle upgrade patch
SQL> startup
ORACLE instance started.
Total System Global Area 4.9973E+10 bytes
Fixed Size 2264816 bytes
Variable Size 3.3018E+10 bytes
Database Buffers 1.6911E+10 bytes
Redo Buffers 42065920 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open RESETLOGS ;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 18438
Session ID: 66 Serial number: 3
SQL> startup UPGRADE;
ORACLE instance started.
Total System Global Area 4.9973E+10 bytes
Fixed Size 2264816 bytes
Variable Size 3.3018E+10 bytes
Database Buffers 1.6911E+10 bytes
Redo Buffers 42065920 bytes
Database mounted.
Database opened.
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/utlrp.sql
訂閱:
張貼留言 (Atom)
RHEL install EPEL
https://www.linuxtechi.com/install-epel-repo-on-rhel-system/ EPEL dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest...
-
記事本開啟 HKEY_CLASSES_ROOT\*\shell] [HKEY_CLASSES_ROOT\*\shell\NotePad] @="用記事本開啟" [HKEY_CLASSES_ROOT\*\shell\NotePad\command] @=...
-
下載 http://dba-tips.blogspot.tw/2015/05/oracle-database-health-check-script.html Oracle Database Health Check Script Do you wan...
-
旋轉泡泡: Oracle DataGuard 相關 Oracle DataGuard 檢查開啟狀態 -- 請全貼 -- ===check=== select dbid,name from v$database; select log_mode , OPE...
沒有留言:
張貼留言