Shulou(Shulou.com)06/01 Report--

Today, the win system appears when logging in to the test database. The oracle database is 11.2.0.1.0. The following error occurred when logging in using sqlplus:

There are many solutions on the Internet. Tell me about my solution process:

The following is to learn from other people's solutions.

The listening service is not up. The windows platform operates as follows: start-programs-management tools-services, open the services panel, and start OracleOraDb11g_home1TNSListener services.

2.database instance didn't get up. The windows platform operates as follows: start-programs-management tools-services, open the services panel, start oracleserviceXXXX,XXXX is your database SID.

3. There is a registry problem. Regedit, then go to HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE\ HOME0 and set the environment variable ORACLE_SID to XXXX,XXXX, which is your database SID. Or on the right, my computer, properties-- advanced-- environment variables-system variables-- New, variable name = oracle_sid, variable value = XXXX,XXXX is your database SID. Or before entering sqlplus, typing set oracle_sid=XXXX,XXXX under command line is your database SID. (be sure to see the path clearly)

4. After installing the client, click the path of the Oracle client at the front of the Path path and click on the computer right-click Properties-> Advanced system Settings-> Environment variables-> PATH path in the system variable, and whether the path of the data is in the first place. Our habit is to install the client software after installing the data so that the client software comes first.

The above four steps are the solution given by netizens. My problem is that there is no problem in the first three steps, and there is indeed a problem in the fourth part. after the fourth step modification is completed, the database still reports an error, and finally there is no way to restart the host. After the restart is completed, the database can log in normally.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.