Solution to failure to use ORACLE normally (Oracle10g express)

I have never played Oracle before. No experience. Provide more advice on errors.

The following uses Oracle10g express edition (Oracle Database Xe) as an experimental environment.

Oracle Database Xe is a free and lightweight database system launched by Oracle for beginners. The installation file is only 200 MB in size. Easy to install and manage. You can log onto the ooracle database Xe home page http://www.oracle.com/technology/products/database/xe/index.html to download.

Oracle also provides a document library for download. It can be divided into the full version and Lite version.
:
Http://www.oracle.com/technology/documentation/database10gR2.html

Installation and configuration

Before installation. To avoid unexpected errors. You need to uninstall oracle of other versions.

You may need the following tools:
• Master of Windows optimization. Used to uninstall oracle. Search for them online.
• Clears the Registry script for residual information in the inventory table. Save the following file as delpoliclereg. Reg and double-click it to import the registry.
• Windows Registry Editor Version 5.00

  This registry script is used to clear the residual information of the Oracle registry. Applicable to Windows XP
  Welcome to my blog: http://diylab.cnblogs.com
  
  [-HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle]

  [HKEY_LOCAL_MACHINE \ SYSTEM \ controlset001 \ Control \ Session Manager \ environment]
  "Oracle_sid" =-

• Clear the system services registered with Oracle. Save the following vbs script as deloracleserv. vbs and double-click it.
• Strcomputer = "."
  Set ob1_miservice = GetObject ("winmgmts :"_
  & "{Impersonationlevel = impersonate }! \ "& Strcomputer &" \ Root \ cimv2 ")
  Set collistofservices = obw.miservice. execquery _
  ("Select * From win32_service where name like 'oracle % '")
  For each objservice in collistofservices
  Objservice. stopservice ()
  Objservice. Delete ()
  Next

Then, you need to find the Oracle installation directory and delete all the files under the Oracle installation directory.

Restart. Now you can install it.

The installation process is very simple. Just press Enter. In less than ten minutes.

During installation, you need to enter the password of the System user. Never forget what you entered. I use 123456.

After the installation is complete, you can choose "start"> "program"> "Oracle Database 10g express edition"> "go to database Homepage ".

Start your Oracle journey!

If you want to be more professional. Use the dark command line.

"Start"-> Run "sqlplus" and you will be prompted to enter the user name and password (no star number will be displayed when you enter the password ).
If you still have trouble using the command line. Please refer to the following article:

<! -- Sorry, I forgot the source. -->
Today, I encountered the problem of ORA-12560: TNS: protocol adapter error. After some efforts, the problem has been solved and shared with everyone.
There are three reasons for the problem that caused the ORA-12560: TNS: protocol adapter error:
1. The listening service is not started. On the Windows platform, perform the following operations: start --- program --- management tools --- Service, open the service panel, and start the oraclehome92tnslistener service.
2. The database instance is not started. On Windows, perform the following operations: start --- program --- management tools --- Service, open the service panel, start oracleservicexxxx, and XXXX is your database Sid.
3. Registry issues. Regedit, and enter HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ home0 to set the environment variable oracle_sid to xxxx. XXXX is your database Sid. or on the right, my computer, property -- Advanced -- environment variable -- System variable -- New, variable name = oracle_sid, variable value = XXXX, XXXX is your database Sid. or, before entering sqlplus, enter SET oracle_sid = XXXX under command line, and XXXX is your database Sid.
After the above steps, you can solve the problem.

Note:
1. The article referenced above is for Oracle9i. In the Oracle database Xe environment, SID = Xe.
2. In the third part of the article referenced above, set the system variables. If you don't, you can directly Save the following code as setenvvariables. Reg, and double-click to import the registry. Windows Registry Editor Version 5.00
This registry script is used to set the Oracle database Xe environment variable. Applicable to Windows XP
Welcome to my blog: http://diylab.cnblogs.com


[HKEY_LOCAL_MACHINE \ SYSTEM \ controlset001 \ Control \ Session Manager \ environment]
"Oracle_sid" = "XE"

3. firewall issues should also be considered if the database cannot be connected.