Just work this morning, the customer called to say that the system can not access, enter the user name, user number can not be loaded out! Hear this question, the first time to think of is whether the server restarted, the Oracle database related services did not start the cause, when viewing the service, found that the relevant services are started state. The second idea is to see if the program configuration file has been modified or not, and the third is to connect the Oracle database with PL/SQL, enter the login name and password, and then prompt the following error: Ora-01033:oracle initialization or shutdown In progress;
Search on the Internet a lap, and finally found a few more detailed steps of the solution, refer to the following:
The first solution:
First step, run cmd
First step, Sqlplus/nolog
Step two, Sql>connect Sys/change_on_install as Sysdba
Tip: Successfully
Step three, Sql>shutdown normal
Tip: The database has been shut down already unloaded the database ORACLE routine has been closed
Fourth step, Sql>startup Mount
Fifth step, Sql>alter database open;
Hint: (I did not encounter the bottom of the error in the operation)
Line 1th Error: ORA-01157: Unable to identify/lock data file 19-see DBWR trace file
ORA-01110: Data file: "' C:\oracle\oradata\oradb\FYGL. ORA '
This hint file section is somewhat different depending on the circumstances of each person.
Continue to enter sixth step, Sql>alter database datafile offline drop;
Step seventh, repeat steps fifth sixth, until the "database changed" prompt appears, and then, for example,
Continue typing shutdown normal,startup mount is ok.
Content Source: http://www.2cto.com/database/201202/118194.html
http://yuxisanren.iteye.com/blog/1754018
Tested again, found that still did not solve my problem;
The second method:
After you have stopped the related services for Oracle, you will be able to log in after restarting and discovering.
--------------------------
Oracle Listener Startup error: The Oracleoradb11g_home1tnslistener service on the local computer starts and then stops the solution
I. Description of the error
Log on PL/SQL developer Log on to the local database without a listener, viewing the service found that the Oracle monitoring service did not start. Right-click to start the Listener, error:
Error description: The Oracleoradb11g_home1tnslistener service on the local computer was started and stopped. Some services stop automatically if they have nothing to do, such as the "Performance Logs and Alerts" service.
Second, reason analysis
When you install Oracle, you are connected to the network, and then the Listener.ora file has an IP address assigned to it by the host= networks, and it happens when you break the network.
Iii. Solutions
Method One: Listener
Modify the listener configuration through Listener.ora or net Manager. Change the original local string 127.0.0.1 or localhost to the host name.
First look at the "Tnsnames.ora" and "Listener.ora" two files in your **\product\11.2.0\dbhome_1\network\admin directory, then check the "HOST" information inside See if it is your current IP address, if you are not trying to change this 2 file to your IP address, or simply change it to 127.0.0.1 (or computer name):
Note: the contents of the host= (IP or hostname) inside the Listening profile "Listener.ora" must be the same as the contents of the service profile "Tnsnames.ora", and the host= content of the service you want to link to is exactly the same. It means either an IP address or a host name. If there are multiple services (network services configured in Net Manager) then look at the "Tnsnames.ora" file in accordance with the listening host content of PL/SQL to log in normally, otherwise there is no listener. Such as:
Above here is "Listener.ora" inside of the host, my is the host name.
Here is the "Tnsnames.ora" configuration information, because my machine is loaded with two database db1,db2. The connection service is also called DB1,DB2, respectively. (Do not know what the situation, after the Tnsnames.ora a host is the IP address, the other is my hostname.) The result is that DB1 PL/SQL normal connection enters (because the IP address and Listener.ora's host address exactly match), and DB2 PL/SQL does not indicate a listener. (What is the case, DB1 not all normal to enter the why has not been listening yet.) I go to ~ ~) Later on-line to find the tutorial said to be "modified" Listener.ora "the host address, if the IP is changed to host name" so copied. Run PL/SQL,DB2 landing success, cool AH. The result DB1 no listener (what is the case). Later see "Listener.ora" found this problem, that the contents of the host of the two files need to exactly match the line, all changed to hostname, two database landing are successful, done!
Method Two: Environment variables
Change the environment variable oracle_home to: * * * (your own installation path) \product\11.2.0\dbhome_1
In some cases, it seems that the installation client is automatically changed to **:\ora11instantclient.
Method Three: Registration form
Key_local_machine/system/currentcontrolset/services/oracleoradb11g_home1tnslistener
Replace the ImagePath in the following: D:\oracle\product\10.2.0\db_1/bin/tnslsnr. EXE (Before the. EXE is not).
-----------------
You've been testing your server's migration issues, creating table spaces, creating databases, and creating users. Later feel to create so many things too occupy disk space, thought to delete it, so, we executed the DBCA command, will not use the database removed all the DBF and DMP files are deleted, and then found that the service can not be started, the connection will prompt Oracle initialization or shutdown in progress, later through the query found that the original DBF and DMP is not said to delete can be deleted (when we clearly found that some do not allow the deletion, I still deliberately stop the Oracle service, and then remove it), resulting in the database instance will not start.
My resolution is as follows: Microsoft Windows [version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\administrator>sqlplus/nologSql*plus:release 10.2.0.1.0-production on Fri March 4 18:40:13 Copyright (c) 1982, 2005, Oracle. All rights reserved.
sql> connect system/hope;Error:ora-01033:oracle initialization or shutdown in progress "that's the mistake."
"Workaround"
sql> Connect Sys/hope as Sysdbais connected.
sql> shutdown NormalORA-01109: The database is not open and the database has been unloaded. The ORACLE routine has been closed.
sql> Start MountSP2-0310: Unable to open file "Mount.sql" Sql> startup Mountoracle routine has been started. Total System Global area 612368384 bytesfixed size 1332348 bytesvariable size 183151492 byte Sdatabase buffers 423624704 Bytesredo buffers 4259840 bytes database loaded. sql> ALTER DATABASE Open;alter database open* 1th Row error: ORA-01157: Unable to identify/lock data file 5-see DBWR trace file ORA-01110: Data file 5: ' C:\t YKM. DBF '
sql> ALTER DATABASE datafile 5 offline drop; "5 is 5 in data file"The database has changed.
sql> ALTER DATABASE open; "We've been looping this statement until we don't prompt the error"The database has changed.
sql> shutdown NormalThe database is closed. The database has been uninstalled. The ORACLE routine has been closed.
sql> StartupThe ORACLE routine has been started. Total System Global area 612368384 bytesfixed size 1332348 bytesvariable size 187345796 byte Sdatabase buffers 419430400 Bytesredo buffers 4259840 bytes database loaded. The database is already open. This will solve the ~ ~ ~ Hahaha ~~~~~~~~~~~~~~~~~~~~
Go to Oracle Listener startup error: The Oracleoradb11g_home1tnslistener service on the local computer starts and then stops the solution