1. Install Oracle only, do not create DATABASE, if you have already created a database,
2, the simple point is to change the original database Oracle directory to oracle_bak, reinstall the database
Back up the Oracle\product\10.1.10\oradata database file (which database is restored)
Back up oracle\product\10.1.10\admin files (which database to back up whichever)
Spfilexxxx.ora under Backup oracle\product\10.1.10\db_1\database (xxxx as database name)
Pwdxxxx.ora under Backup oracle\product\10.1.10\db_1\database (xxxx as database name)
Spfilexxxx.ora under Backup Oracle\product\10.1.10\db_1\dbs (xxxx as database name)
10.1.10 files are not copied to the previous file
3, C:/Documents and Settings/gxlineji>oradim-new-sid hwdb
Instance has been created.
4, C:/Documents and Settings/gxlineji>set oracle_sid=hwdb
C:/Documents and Settings/gxlineji>sqlplus "/as sysdba"
Sql*plus:release 10.2.0.1.0-production on Saturday February 7 22:54:32 2009
Copyright (c) 1982, +, Oracle. All rights reserved.
You are connected to an idle routine.
Sql> Startup
Ora-01078:failure in processing system parameters
LRM-00109:???????????????? ' E:/oracle/product/10.2.0/db_1/database/inithwdb. ORA '
Copy the Inithwdb.ora under the original directory to the hint path Inithwdb.ora. Startup again,
Sql> Startup
Ora-01078:failure in processing system parameters
Ora-01565:error in identifying file ' E:/oracle/product/10.2.0/db_1/dbs/spfilehwdb.ora '
Ora-27041:unable to open File
OSD-04002:????????????
O/s-error: (OS 2)??????????????????????
Replace the existing Spfilehwdb.ora file with the Spfilehwdb.ora in the old directory. and Startup,ok!
Sql> Startup
The ORACLE routine has started.
Total System Global area 314572800 bytes
Fixed Size 1248768 bytes
Variable Size 83886592 bytes
Database buffers 222298112 bytes
Redo buffers 7139328 bytes
Database loading complete.
The database is already open.
Sql> Conn Scott/tiger
is connected.
======= recovery has been completed 80%
Reference: http://blog.csdn.net/gxlineji/article/details/3868045
http://bbs.csdn.net/topics/350170931
5. Test connection Database with Plsql tool
If 1: Unable to find the listener, open net Configuration Assistant, configuration, you can first restore the original database admin configuration
The past.
http://blog.csdn.net/wwbmyos/article/details/11475551/
