This discussion is archived
12 Replies Latest reply: May 3, 2013 11:56 PM by saratpvv RSS

SQL PLUS

1007061 Newbie
Currently Being Moderated
Hi guys,

I already downloaded and installed Oracle 11g release 2 32-bit for windows 7
(i used 32-bit oracle installer for my 64-bit windows 7 because the 64-bit installer can't install succesfully)
After that i opened SQL Plus, and it asks me for username and password but i don't have it.
Can you guys help me with this? Do you know some username/password that i can use?

anyway i installed ORACLE 11g database for studying purposes.
and i follwed the instructions here: http://www.tutorialspoint.com/plsql/plsql_environment_setup.htm

THANKS!
  • 1. Re: SQL PLUS
    SomeoneElse Guru
    Currently Being Moderated
    it asks me for username and password but i don't have it.
    The installer asks you to set the initial passwords to whatever you want.

    Are you sure you installed the full database product and not just the client?
  • 2. Re: SQL PLUS
    sb92075 Guru
    Currently Being Moderated
    1004058 wrote:
    Hi guys,

    I already downloaded and installed Oracle 11g release 2 32-bit for windows 7
    (i used 32-bit oracle installer for my 64-bit windows 7 because the 64-bit installer can't install succesfully)
    After that i opened SQL Plus, and it asks me for username and password but i don't have it.
    Can you guys help me with this? Do you know some username/password that i can use?

    anyway i installed ORACLE 11g database for studying purposes.
    and i follwed the instructions here: http://www.tutorialspoint.com/plsql/plsql_environment_setup.htm

    THANKS!
    sqlplus
    / as sysdba
    alter user scott identified by tiger account enabled;
    connect scott/tiger
  • 3. Re: SQL PLUS
    994218 Newbie
    Currently Being Moderated
    Since, there are few default user created into the database. So, you can use them like scott/tiger, but this might be locked.

    You can check account status with.

    sql> select USERNAME, ACCOUNT_STATUS, LOCK_DATE, DEFAULT_TABLESPACE , CREATED from dba_users;

    if ACCOUNT_STATUS is open, you can login to this user using

    sqlplus scott/tiger

    other wise you need to unlock the account and then you can work.

    sql> alter user uesr_name account unlock;

    Thanks,
    http://www.dbas-oracle.com/

    Edited by: 991215 on May 3, 2013 9:58 PM
  • 4. Re: SQL PLUS
    1007061 Newbie
    Currently Being Moderated
    I just followed the instructions from the link above.
    I opened the SQL PLUS and here is the whole text displayed:

    SQL*Plus: Release 11.2.0.1.0 Production on Sat May 4 14:08:50 2013

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Enter user-name:
  • 5. Re: SQL PLUS
    1007061 Newbie
    Currently Being Moderated
    itried the scott/tiger but it displayed:

    Enter user-name: scott/tiger
    ERROR:
    ORA-28000: the account is locked
  • 6. Re: SQL PLUS
    1007061 Newbie
    Currently Being Moderated
    Thanks for help my sql plus displays initially as this:

    SQL*Plus: Release 11.2.0.1.0 Production on Sat May 4 14:24:12 2013

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Enter user-name:

    I cannot see the "SQL>"
    I followed the instructions to find the users from this link: http://www.dbas-oracle.com/

    BUT IT DISPLAYED this:

    Enter user-name: desc dba_users;

    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
    where <logon> ::= <username>[<password>][@<connect_identifier>]
    <proxy> ::= <proxyuser>[<username>][<password>][@<connect_identifier>]

    Enter user-name: select username, account_status, lock_date, default_tablespace,
    created from dba_users;

    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
    where <logon> ::= <username>[<password>][@<connect_identifier>]
    <proxy> ::= <proxyuser>[<username>][<password>][@<connect_identifier>]
  • 7. Re: SQL PLUS
    saratpvv Journeyer
    Currently Being Moderated
    In the link you have mentioned - when are you in Step 5 - what is the Adminstrative Password you have given..? - Use that password to connect to sys - Later unlock scott user like - alter user scott account unlock
  • 8. Re: SQL PLUS
    994218 Newbie
    Currently Being Moderated
    1004058 wrote:
    Thanks for help my sql plus displays initially as this:

    SQL*Plus: Release 11.2.0.1.0 Production on Sat May 4 14:24:12 2013

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Enter user-name:
    Here put user name = sys as sysdba

    this will ask for password, press enter. Here you will see

    sql>

    sql> alter user scott account unlock;

    sql> connect scott/tiger

    Now, you can work.

    Thanks,
    http://www.dbas-oracle.com/
  • 9. Re: SQL PLUS
    1007061 Newbie
    Currently Being Moderated
    i got it thanks!

    Thanks! ^_^

    Edited by: 1004058 on May 3, 2013 11:53 PM
  • 10. Re: SQL PLUS
    1007061 Newbie
    Currently Being Moderated
    THANK YOU VERY MUCH ^_^!
  • 11. Re: SQL PLUS
    994218 Newbie
    Currently Being Moderated
    Please mark this question as answered.

    Thanks,
    http://www.dbas-oracle.com/
  • 12. Re: SQL PLUS
    saratpvv Journeyer
    Currently Being Moderated
    Okay i think you need the clear steps ..

    1) In Windows 7 ->> Press Start Button ->> Search Programme files->> Enter SQL Plus press enter ->> in the Username box type ( sys as sysdba) ->> it will prompt password (give the password of sys which you remembered) ->> Sql> alter user scott account unlock;

    Hope it will clear

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points