Oracle FAQs Solutions

1. How to unlock Scott account
 cause: The default oracle10g Scott cannot log in.
Solution:
(1) Conn Sys/sys as sysdba;//logged in as DBA
(2) ALTER user Scott account unlock;//then unlock
(3) Conn Scott/tiger//Popup A Password Change dialog box, modify the password can be

The following are the steps:
c:> sqlplus
Please enter user name: Sys
Enter password: SYS as SYSDBA//NOTE: The password entered here must be followed by the as SYSDBA.
sql> alter user Scott account unlock;
The user has changed.
sql> commit;
submit complete.
sql> Conn Scott/tiger
Change Scott Password
New password: Tiger
Retype New password: Tiger
Password has changed
is connected.

Another way: You open a command prompt, do not log in directly to enter the following:
sqlplus Sys/tiger as Sysdba
access the SYS account as a DBA;
alter user Scott account unlock;
unlock the Scott user;

2.sys user and system user differences
(1) SYS is superuser, has the highest privileges, has the SYSDBA role, has the CREATE DATABASE permission, the user's default password is Change_on_install
(2) The system user is a management operator and has a large authority. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager
(3) For database maintenance, using the system user login can be
(4) The biggest difference between SYS and system two users is that there is no permission to create database.

3. Installing Oracle causes Eclipse to report the following error:

Because of Oracle, it changed the original JRE environment.
Workaround:
FIX: In My Computer-advanced-environment variable path, the contents of the system variable path are adjusted, and the contents of Oracle are all moved to the last side,
　　 as is now the:;D: \oracle\bin;d:\oracle\jre\1.4.2\bin\client;d:\oracle\jre\1.4.2\bin; %systemroot%\system32;%systemroot%;%systemroot%\system32\wbem; C:\Program Files\Common Files\thunder Network\kankan\codecs;d:\java\jdk1.7.0\bin;c:\program Files\Microsoft SQL server\90\tools\binn\; C:\Program Files\Microsoft SQL Server\80\tools\binn\; C:\Program Files\Microsoft SQL Server\90\dts\binn\; C:\Program Files\Microsoft SQL Server\90\tools\binn\vsshell\common7\ide\;D: \microsoft Visual Studio 8\common7\ide\ Privateassemblies\;%java_home%\bin; C:\Program Files\mysql\mysql Server 5.5\bin

　　you have to change it :%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem; C:\Program Files\Common Files\thunder Network\kankan\codecs;d:\java\jdk1.7.0\bin;c:\program Files\Microsoft SQL server\90\tools\binn\; C:\Program Files\Microsoft SQL Server\80\tools\binn\; C:\Program Files\Microsoft SQL Server\90\dts\binn\; C:\Program Files\Microsoft SQL Server\90\tools\binn\vsshell\common7\ide\;D: \microsoft Visual Studio 8\common7\ide\ Privateassemblies\;%java_home%\bin; C:\Program files\mysql\mysql Server 5.5\bin;d:\oracle\bin;d:\oracle\jre\1.4.2\bin\client;d:\oracle\jre\1.4.2\bin;

Problem Solving!  

Oracle FAQs Solutions