This content has been marked as final. Show 7 replies
Which User name ??
Password no one can help with that since you are the only one who knows that question , What did you set the password while the installation .
if you forgot the passwords use
sqlplus / as sysdba alter user <Username> identified by <New password>
whenever i open SQL PLUS it is asking me a username and password.
but i dont know where to get that username and password...
i am totally new to this oracle....
then you have to start reading
open command prompt
cmd>sqlplus / as sysdba
sqlplus>alter user hr identifird by hr;
use this username/password (HR/HR)schema for other tasks.
Also after setting the password make sure that the user account (schema) is not locked
Alter user scott account UNLOCK;
chinmayi wrote:SQLPlus is just a command processor. SQLPLus does not have a username or password. Database accounts (usernames) have passwords and that is irrespective of your front-end tool (sqlplus , sql developer, some-end-user-app).
can anyone tell me what is username and password for SQL PLUS of oracle 11g??
Did you install and create this database yourself? If so, during the installation process you were prompted for password for users SYS and SYSTEM. We have no idea what values you supplied there.
As others suggested, connect with sysdba authority and change the password for the user you are interested in.
Thank you so much for ur help :-)