ORACLE11G Ora-12560:tns: Protocol Adapter Error ____oracle

Source: Internet
Author: User
Tags sqlplus

When installing the language to choose Al32utf8

The Nls_lang=american_america of the registry. Al32utf8

Sqlplus/as SYSDBA

Ora-12560:tns: There are three reasons for the problem with the protocol adapter error:

1. The monitoring service did not rise. Windows platform: Run "services.msc" to start the Oracleoradb11g_home1tnslistener service.

2.database instance did not rise. Windows platform: Run "services.msc", start Oracleservicexxxx,xxxx is your oraclesid.

3. Registry issues. regedit, and then enter the hkey_local_machine\software\oracle\key_oradb11g_home1 to put the environment variable

Oracle_sid set to Xxxx,xxxx is your database SID. Or right My computer, attributes--advanced--environment variable---system

Variable--New, variable name =oracle_sid, variable value =xxxx,xxxx is your database SID. Or before entering the Sqlplus,

Command line down set Oracle_sid

If server and client are installed at the same time, Sqlplus should be open with the client directory

Copy this oracle_sid from Hkey_local_machine\software\oracle\key_oradb11g_home1\oracle_sid to Key_oraclient11g_home1

Ora-28009:connection as SYS should be as SYSDBA or sysoper

After playing the Sqlplus, to enter, directly in the user name of the sys/password as SYSDBA can be

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.