Oracle FAQs and Solutions

Source: Internet
Author: User
Tags dedicated server

No one would deny that Oracle is one of the most influential database products in the world. However, a large system always has various problems, and many inexperienced users are helpless in the face of error prompts. This article lists some common problems and solutions in the use of Oracle databases, hoping to provide some inspiration for beginners.

1. ORA-12541: TNS: No listener

Cause: the listener is not started or damaged. If it is the former, use the command Net start oracleorahome81tnslistener (the name may be different); if it is the latter, use the "net8 configuration assistant" tool Wizard to "ListenProgramAdd a listener (no need to write any information, all the way OK. You may need to delete all listeners before adding them !)

2. ORA-12500: TNS: The Listener cannot start a dedicated server process or ORA-12560: TNS: protocol adapter Error

Cause: Oracle Database Service is not started. Run the Net start oracleserviceoradb command (oradb is the database name.

3. If the database service fails to be started, the registry key value may be corrupted. The best practice is to perform the following two steps:

1) oradim-delete-Sid oradb deletes database service items

2) oradim-New-Sid oradb adds database service items

Note: if an error occurs during this process, restart the computer!

4, ORA-12154: TNS: can resolve the service name

Cause: the network service name of Oracle is not correctly configured. Use "Local Network Service name configuration" in the "net8 configuration assistant" tool Wizard to configure TNS. If the problem persists, proceed to the following section.

5. ORA-1034: TNS: Oracle unavailable

Cause: the Oracle Database Service is correctly started, but the database is not opened!

Solution:

Run the following command:

1) svrmgrl start the Service Manager

2) connect internal logs in as internal

3) Startup open the database

6. ORA-12560: TNS: protocol adapter error (stubborn)

Cause: unknown.

Solution: Be sure to activate the Windows Task Manager, kill oracle.exeand oradim.exe processes, write your own ora_startup.bat, and execute it!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.