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>