Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what to do if oracle cannot start normally after modifying the hardware time". In the daily operation, I believe that many people have doubts about how to make oracle unable to start normally after modifying the hardware time. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for everyone to answer the doubt that "what to do if oracle can not start normally after modifying the hardware time". Next, please follow the editor to study!

[root@lzr1 ~] # hwclock-- set-- date= "01 prime 19 18:06" [root@lzr1 ~] # hwclock-- hctosys

Modified the system time

Then restart the machine.

[root@lzr1 ~] # reboot [root@lzr1 ~] # Broadcast message from root@lzr1 (/ dev/pts/0) at 18:06... The system is going down for reboot NOW!

Enter sqlplus after reboot

[oracle@lzr1] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 19 18:08:04 2019Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL >

Find an empty instance and startup it

SQL > startupORA-01078: failure in processing system parametersORA-01565: error in identifying file'+ DATA01/orcl/spfileorcl.ora'ORA-17503: ksfdopn:2 Failed to open file + DATA01/orcl/spfileorcl.oraORA-15056: additional error messageORA-17503: ksfdopn:2 Failed to open file + DATA01/orcl/spfileorcl.oraORA-15001: diskgroup "DATA01" does not exist or is not mountedORA-06512: at line 4

Prompt that control file and parameter file are not recognized

Start to nomount state with the previous parameter file first

[oracle@lzr1 pfile] $pwd/u01/app/oracle/admin/orcl/pfile [oracle@lzr1 pfile] $lsinit.ora.11142018235636 [oracle@lzr1 pfile] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 19 18:11:19 2019Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL > startup nomount pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.11142018235636';ORACLE instance started.Total System Global Area 1202556928 bytesFixed Size 2252704 bytesVariable Size 822083680 bytesDatabase Buffers 369098752 bytesRedo Buffers 9121792 bytesSQL > create spfile from pfile;File created.

Go to the control file cat init.ora.11142018235636 again.

The bottom line is

Control_files= ("+ DATA01/orcl/controlfile/current.260.996015513", "+ FRA/orcl/controlfile/current.256.994895415")

Go to the disk and take a look at the control file

[grid@lzr1 ~] $asmcmdASMCMD > lsDATA/DATA01/FRA/ASMCMD > cd + DATA01/orcl/controlfile

Modify the file names of the DATA01 and FRA control files to the pfile parameter file, save them, and then start the database.

Note:

Do not modify the hardware time, which will cause a prompt at boot time

Checking filesystems

/ dev/mapper/VolGroup-lv_root: Superblock last mount time (Thu Jul 31 11:12:34 2014

Now = Mon Jul 28 11:15:32 2014) is in the future.

/ dev/mapper/VolGroup-lv_root: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY.

(I. e., without-an or-p options)

[FAILED]

* An error occurred during the file system check.

* Dropping you to a shell; the system will reboot

* when you leave the shell

* Warning-SELinux is active

* Disabling security enforcement for system recovery.

* * Run * setenforce 1 * to reenable.

Give root password for maintenance

(or type Control-D to continue):

The last time the superblock was loaded is inconsistent with the current time, and the disk is not working properly.

Solution:

1. Start with the installation disk

two。 Change the date to an earlier time

3. Disk check

4. Hard disk boot, change the time to normal

At this point, the study on "what to do if oracle can not start normally after modifying the hardware time" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.