Solution for oracle database errors such as oracle initialization or shutdown in SS

Solution to oracle initialization or shutdown in SS error in oracle Database 1. First, the cause of the problem, this error occurs when a file under oracle \ oradata \ oradb is deleted by mistake. 2. symptom: SQL * Plus cannot be connected, the following error is displayed: ORA-01033: ORACLE initialization or shutdown in progress, the same error is also in the Enterprise Manager Console. Iii. Analysis: After Oracle is started, the user needs to load the original configuration information in the solution during login. During the loading process, the location specified by the original file is not found, therefore, an error is reported. Www.2cto.com 4. Solution Process: 1. I used the Database Configuration Assistant tool to re-create a new Database to temporarily solve the urgent problem, at the same time, it also laid a hidden danger to solve the problem of ora-01033 in the later stage. 2. There is no svrmgrl command in 9i. Use sqlplus. 3. Run cmd in windows to enter the DOS environment. 4. Log On as a dba user. The specific command is: wangzihu/as sysdbaSQL> connect sys/change_on_install as sysdba prompt: successful SQL> shutdown normal prompt: the database has been disabled and the database has been uninstalled. The SQL> startup mount prompt is displayed: the ORACLE routine has started the Total System Global Area 118255568 bytesFixed Size 282576 bytesVariable Size 82886080 bytesDatabase Buffers 33554432 bytesRedo Buffers 532480 bytes database Loading completed www.2cto.com SQL> alter database open; prompt: Row 1st has an error: ORA-01157: unable to identify/lock data file 19-Parameters Read DBWR trace file ORA-01110: Data File 19: '''c: \ oracle \ oradata \ oradb \ FYGL. ORA ''the prompt FILE Section varies depending on your situation. Continue to input SQL> alter database datafile 19 offline drop; prompt: the database has been changed. Loop through the last two steps until alter database open; then no error is prompted, "the database has been changed ". Then enter the SQL> shutdown normal prompt: the database has been disabled and the database has been uninstalled. The ORACLE routine has been disabled. www.2cto.com SQL> startup prompt: the ORACLE routine has started the Total System Global Area 118255568 bytesFixed Size 282576 bytesVariable Size 82886080 bytesDatabase Buffers 33554432 bytesRedo Buffers 532480 bytes database. 5. Finally, let's talk about the hidden danger mentioned in the first article. Because a new database is created, ORACLE_SID also changes. When a user logs on, there will be a ORA-12560 error, to solve this problem, modify the HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOME0 \ ORACLE_SID key value in the system registry to the previous SID, and the user can log on to the author wangzihu normally.