ORACLE11G and pl/sql11.0 Login issues

1. ORA-12560:TNS: Protocol Adapter error

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5F/A4/wKiom1UqNuSy0GtzAADQ24k3hAA982.jpg "title=" 1.png " alt= "Wkiom1uqnusy0gtzaadq24k3haa982.jpg"/>

Workaround:

1) The monitoring service is not up. Windows platform: Start---program---management tools---services, open the Services panel,

Start the Oraclehome92tnslistener service.

2) database instance not up. The Windows platform: start---program---administrative tools---services, open services

Panel, start oracleservicexxxx,xxxx is your database SID.

3) Registry issues. regedit, and then enter HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 to set the environment variable Oracle_sid

Set to Xxxx,xxxx is your database SID. or right-click on My Computer, properties--advanced--environment variable---System variables--new,

Variable name =oracle_sid, variable value =xxxx,xxxx is your database SID. Or before entering Sqlplus, under command line

The lost set ORACLE_SID=XXXX,XXXX is your database SID.

This question is addressed through the 3rd.

2.ora-28009:connection as SYS should be as SYSDBA or sysoper

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5F/A5/wKiom1UqN1Ti-p8AAAC2RZ_1Qbk841.jpg "title=" 2.png " alt= "Wkiom1uqn1ti-p8aaac2rz_1qbk841.jpg"/>

Workaround: Enter the password: [Pass] as Sysdba

3.pl/sql 11.0 Login Issues

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5F/A1/wKioL1UqOSCANWh1AAHcgisa2D0190.jpg "title=" 3.png " alt= "Wkiol1uqoscanwh1aahcgisa2d0190.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5F/A4/wKioL1UqO6PBfaslAALxy4veW3Y595.jpg "title=" 6.png " alt= "Wkiol1uqo6pbfaslaalxy4vew3y595.jpg"/>

Workaround:

1. Download 32-bit Oracle Client

http://www.oracle.com/technetwork/topics/winsoft-085727.html, I downloaded the instantclient-basic-nt-11.2.0.2.0.zip.

2. Decompression

Unzip the Instantclient-basic-nt-11.2.0.2.0.zip, for example to D:\DevSoftWare\instantclient-basic-nt-12.1.0.2.0

3, set Plsql Developer

Start Plsql Developer, no sign-in point to cancel into Plsql developer,tools->>preferences:

Oracle home:f:\app\think\product\11.2.0

OCI Library:d:\devsoftware\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1\oci.dll

4. Add Environment variables

Tns_admin->>f:\app\think\product\11.2.0\dbhome_1\network\admin

Chinese garbled problem:

Workaround:

Add environment variable: Nls_lang->> american_america. UTF8

This article is from the "J-Wind Know Strength Grass" blog, please make sure to keep this source http://gifilee.blog.51cto.com/8930516/1631553

ORACLE11G and pl/sql11.0 Login issues