Client Windows blue screen, and then the customer in the computer a random delete, really cold.
Oracle failed to start and reported ora-01172,01151 error.
Processing process:
| The code is as follows |
Copy Code |
Microsoft Windows [version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:documents and Settingsadministrator>tnsping dbtest
TNS Ping Utility for 32-bit windows:version 10.2.0.1.0-production on 1 April-December-
2011 16:34:10
Copyright (c) 1997, +, Oracle. All rights reserved.
|
Parameter file used:
| The code is as follows |
Copy Code |
| E:oracleproduct10.2.0db_1networkadminsqlnet.ora |
Used the TNSNAMES adapter to resolve the alias
| The code is as follows |
Copy Code |
Attempting to contacts (DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = Mqdyj) (P
ORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = dbtest)))
OK (10 ms)
C:documents and Settingsadministrator>sqlplus/as Sysdba
Sql*plus:release 10.2.0.1.0-production on Wednesday December 14 16:34:34 2011
Copyright (c) 1982, +, Oracle. All rights reserved.
ERROR:
ORA-12560:TNS: Protocol Adapter error |
-This is because the service inside the Service.msc is not started. It's OK to start up.
| The code is as follows |
Copy Code |
C:documents and Settingsadministrator>
C:documents and settingsadministrator>sqlplus/@dbtest as Sysdba
Sql*plus:release 10.2.0.1.0-production on Wednesday December 14 16:34:46 2011
Copyright (c) 1982, +, Oracle. All rights reserved.
ERROR:
Ora-12514:tns: The listener is currently unable to recognize the service requested in the connection descriptor
|
Please enter user name: Exit
Enter Password:
| The code is as follows |
Copy Code |
ERROR:
ORA-12560:TNS: Protocol Adapter error |
--The reason for the error is ditto. This is because the service inside the Service.msc is not started. It's OK to start up.
--Here I modified the Listener.ora and registered it as a static listener.
is to add sid_desc that paragraph, add good will have two sid_desc.
| The code is as follows |
Copy Code |
C:documents and Settingsadministrator>
C:documents and Settingsadministrator>lsnrctl stop
Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 1 April-December-2011 16:3
6:59
Copyright (c) 1991, +, Oracle. All rights reserved.
|
Is connecting to
| The code is as follows |
Copy Code |
(Description= (address= (PROTOCOL=IPC) (Key=extproc1))
|
Command execution succeeded
| The code is as follows |
Copy Code |
| C:documents and Settingsadministrator>lsnrctl start
Lsnrctl for 32-bit windows:version 10.2.0.1.0-production on 1 April-December-2011 16:3
7:06
Copyright (c) 1991, +, Oracle. All rights reserved.
Start Tnslsnr: Please wait ... Tnslsnr for 32-bit windows:version 10.2.0.1.0-production
System parameter file is E:oracleproduct10.2.0db_1networkadminlistener.ora
Write log information for E:oracleproduct10.2.0db_1networkloglistener.log
Listening: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=\.PIPEEXTPROC1IPC))
Listening: (Description= (Address= (protocol=tcp) (Host=mqdyj) (port=1521))
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 32-bit windows:version 10.2.0.1.0-produ
Ction
Launch date 1 April-December-2011 16:37:11
Uptime 0 days 0 hours 0 minutes 5 seconds
Trace level off
Security On:local OS Authentication
SNMP off
Listener parameter File E:ORACLEPRODUCT10.2.0DB_1NETWORKADMINLISTENER.O
Ra
Listener log File E:oracleproduct10.2.0db_1networkloglistener.log
Monitor Endpoint Summary ...
(Description= (address= (PROTOCOL=IPC) (PIPENAME=\.PIPEEXTPROC1IPC))
(Description= (address= (protocol=tcp) (Host=mqdyj) (port=1521))
Service summary.
The service "Dbtest" contains 1 routines.
Routine "dbtest", State UNKNOWN, contains 1 handlers for this service ...
The service "Plsextproc" contains 1 routines.
Routine "Plsextproc", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
C:documents and Settingsadministrator>tnsping dbtest
TNS Ping Utility for 32-bit windows:version 10.2.0.1.0-production on 1 April-December-
2011 16:37:17
Copyright (c) 1997, +, Oracle. All rights reserved.
Parameter file used:
E:oracleproduct10.2.0db_1networkadminsqlnet.ora
Sql> Conn ORACLE/IAMDBA
ERROR:
Ora-01033:oracle initialization or shutdown in progress
--I reported this mistake when I was in the database.
sql> shutdown Immediate
ORA-01109: Database not open
The database has been unloaded.
The ORACLE routine has been closed.
Sql>startup
ERROR is on line 1th:
ORA-01172: Thread 1 recovery stopped at block 253011 (in file 2)
ORA-01151: If necessary, use media recovery to recover blocks and restore backups
--Start database times: Ora-01172,01151,undo file error.
The cause of this error is the Windows blue screen.
Workaround (It is best to back up the various Oracle files before you do it):
Sql> Startup Mount
The ORACLE routine has started.
Total System Global area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 159386500 bytes
Database buffers 444596224 bytes
Redo buffers 7135232 bytes
Database loading complete.
sql> recover datafile 2;
Complete media recovery.
sql> ALTER DATABASE open;
|
The database has changed.
Sql>
