1

Yesterday I have installed oracle database 10g XE and after installation I have created my own password and after that whenever I try to use sqlplus and then it asks for the username password. SO for that I type username - system and password -(what I created) but after that I am not able to login. By the way I am able to use it in browser but I am not able to use it in sqlplus. Help me please with it. Here is the screenshot of the problem. this is the login problem that I am getting

Plus I am also having one more problem and that is I am not able to use scott schema . Help me for that so that I can use that.

Improve this question
7
  • 2
    At least on the screenshot, you actually typed systme... To be on the safe side, you could type sqlplus username/password (with the actual values) to rule out typos... What exactly do you mean by "I am not able to use scott schema"? Commented Aug 22, 2015 at 0:59
  • oh sorry for the wrong typing but the problem is still there and also I ahve tried but after it I am getting error. username password not found Commented Aug 22, 2015 at 1:59
  • yeah that is working in browser (chrome and mozilla both) but it is not working in sqlplus. There is one more problem - I think sqlplus is not working properly. Commented Aug 22, 2015 at 2:12
  • Let me tell you all the things. At the time of installation I have created password for sys and system. Through that i am able to login using my browser. But when I use same info in sqlplus then it shows me error message. And for the Scott/tiger it is saying that I am interring wrong username password. Now same software my friend is using in windows 7 and he is using it fine, but I am windows 8 user and I am not able to use it. Please help me with it. Commented Aug 22, 2015 at 8:58
  • When you spell system correctly and supply the right password, do you still get ORA-01017, or something else? Can you log in with scott/tiger in your browser (I assume the XE home page on port 8080)? Commented Aug 22, 2015 at 9:34

4 Answers 4

Reset to default
3
  1. sqlplus /nolog
  2. select username, account_status from dba_user;

after hitting enter... it will show the list of the databases... then at the last you'll find a username as SYSTEM with the account_status as OPEN

so

  1. sqlplus

  2. enter username: SYSTEM

    enter password: the one you specified at the time of installation

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Can you try to format this a little better so it's easier to read? Make use of the "code" tags when possible.
These commands are for Command Prompt.. that explains it all i guess
0
  1. you have to check your spelling in username/password.
  2. password is case sensetive, if you entered Initial letter you should use Initial lettaers, same thing for uppers, and lowers letters in password.
  3. are you able to login to scott in browser? if there is no scott schema you have to install scott schema from sample schemas first.
Improve this answer

1 Comment

yeah it looks like there is no scott schema in my oracle 10g but same setup is installed by my friend and he is having that how ?
0

You can try step by step:

  1. run CMD
  2. typing sqlplus
  3. user-name: sys/password@dbname as sysdba
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
SQL>

Reference: https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/Windows_DB_Install_OBE/Installing_Oracle_Db12c_Windows.html https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/security.htm#DMADM013

Improve this answer

Comments

-1

I had that same issue. Does your password contain a @ character? Mine did. After I changed the password (without @), it worked.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.