Oracle usernames
Home > IT Answers > Oracle > Oracle usernames
ITKE
10345 pts.
0
Q:
Oracle usernames
Oracle 10, Oracle User Profiles, username
I have installed Oracle but when I’m starting Oracle *Plus it is not accepting the username and password 'scott and tiger' and 'system manager.' It is also not accepting these user names and passwords.

Software/Hardware used:
Oracle 10g
ASKED: Oct 26 2009  2:37 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Zagrim
105 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Short answer is RTFM, but from http://faq.programmerworld.net/database/installing-oracle-10g.html

"Note: Oracle 10g still keeps scott / tiger username and password (UID=scott, PWD=tiger) from the old version of oracle. In the old version of oracle, scott/tiger user ID is available by default, but not in oracle 10g. If you want to use scott /tiger account, you must unlock it by clicking “Password Management” at the last window.
Password Management window will appear like the one shown below. Find the user name “Scott” and uncheck the “Lock Account?” column for the user name. "
Last Answered: Oct 27 2009  11:56 AM GMT by Zagrim   105 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Jcmdba   495 pts.  |   Oct 27 2009  9:36PM GMT

If you installed the software, you should know that you can use sqlplus “/ as sysdba” without a password. Also, during the installation, you should have been prompted to change the password for sys and system which would give you insight into the actual password for the system account. While in sqlplus as sys or system, you can check on the scott username in “dba_users” and if the account is locked, you can issue the “alter user …. account unlock;” You can also change the password with the appropriate command. I suggest training and manuals.  <a href="http://www.oracle.com/technology/documentation/index.html" title="http://www.oracle.com/technology/documentation/index.html" target="_blank">http://www.oracle.com/technology/documen…</a>

 
0