First, Conn Sys/sys as SYSDBA; The following error occurred while logged on as a DBA
After investigation
There are three reasons for the problem with the protocol adapter error
The monitoring service is not up. Windows platform: Start---program---management tools---services, open the Services panel, start the Oraclehome92tnslistener service.
- The. Database instance is not up. The Windows platform: start---program---management tools---services, open the Services panel, start oracleservicexxxx,xxxx is your database SID.
- Registry issues. Regedit and then go to HKEY_LOCAL_MACHINESOFTWAREORACLEHOME0 set the environment variable ORACLE_SID to XXXX,XXXX is your database Sid. Or right My Computer, attribute--advanced--environment variable---system variable--new, variable name =oracle_sid, variable value =xxxx,xxxx is your database SID. Or enter sqlplus before the command Line down the set ORACLE_SID=XXXX,XXXX is your database SID.
I'm here is oracleserviceoracle didn't start
Return to normal after startup
It is important to note that after sql> enter the ALTER user Scott account unlock carriage return, you will see 2.
Note that each sentence must be completed with the end of the
It should be Sql>alter user Scott account unlock, that's right!
Sql> commit; The word "submit complete" will appear. Sql> Conn scott/tiger//Please enter a new password, and confirm after OK then to plsql developer inside to Scott/tiger login on it can be. To sort out the solution:
(1) Conn Sys/sys as SYSDBA; Log in as a DBA
(2) Alter user Scott account unlock;//then unlock
(3) Conn Scott/tiger//Popup A Password Change dialog box, modify the password can be
In the run input cmd in the DOS mode input sqlplus, the system user name login, password is just loaded Oracle self-filled password orcl, log in after.
Sql> Conn Sys/sys as SYSDBA; (Semicolons are required but I am logged in as system this should not be written Conn Sys/sys as SYSDBA should write Conn SYSTEM/ORCL as SYSDBA;)
is connected
sql> alter user Scott account unlock;
User has changed
Sql> commit;
Submit Complete
Sql> Conn scott/tiger//Please enter a new password and confirm the OK
is connected
At this time again to plsql developer inside to Scott/tiger log on can.
Issues and workarounds for unlocking Scott