Oracle usernames

344900 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

Short answer is RTFM, but from <a href=”http://faq.programmerworld.net/database/installing-oracle-10g.html”>http://faq.programmerworld.net/database/installing-oracle-10g.html</a>

“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. “

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jcmdba
    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. http://www.oracle.com/technology/documentation/index.html
    555 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following