Oracle11g and PL/SQL11.0 login issu

Shulou Source: shulou.com Published: 2022-06-01 13:30:23 10月01日 Update

ORA-12560:TNS: protocol adapter error

Solution:

1) the monitoring service is not up. The windows platform operates as follows: start-programs-management tools-services, open the services panel

Start the oraclehome92TNSlistener service.

2) database instance did not rise up. The windows platform operates as follows: start-programs-management tools-services, open services

Panel, launch oracleserviceXXXX,XXXX is your database SID.

3) Registry problem. Regedit, and then enter HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE\ HOME0 to change the environment variable ORACLE_SID

Setting it to XXXX,XXXX is your database SID. Or right-click 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, under command line

Losing set oracle_sid=XXXX,XXXX is your database SID.

This question is solved through the third point.

2.ORA-28009:connection as SYS should be as SYSDBA or SYSOPER

Solution: enter [pass] as sysdba in the password

3.PL/SQL 11.0 Login issu

Solution:

1. Download 32-bit Oracle client

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

2. Decompression

Extract 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 and cancel to enter PLSQL Developer,Tools- without login point > > 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 code problem:

Solution:

Add environment variables: NLS_LANG-> AMERICAN_AMERICA.UTF8