How to connect to local Database in Sql Developer

2
votes

I'm absolute beginner to ORACLE ,so I installed SQL developer to start practising query then I installed Oracle Database, after which I got the following screen

Oracle DB Installation screen

Then when I tried to create new connection with the following credentials 

>Connection name: HR_DB
>Username :HR
>Password :HR
>Hostname :localhost
>port     :1521
>sid      :orcl

Now I get the following error

Status: Failure -Test Failed:ORA-01017 invalid username/password; logon denied

Please help me to get connected to local Database account ,I have absolutely no idea what's happening.

1
sqloracleoracle-sqldeveloper
invalid username/password; - what's unclear about that message exactly? - Mat
so how do I login,like how to create new user credentials or is there a default username and password available? - Yuvi
You specified passwords when you created the database. Please search for and read the docs on user management, this is all documented. - Mat
@Yuvi When installing Oracle DB you need to specify password for system schema. Use that password to log in as user system and alter the password of HR schema and re-connect. But AFAIK default password for HR schema is HR. So I'm not sure what's going wrong in your case. - Ravi.

1 Answers

2
votes

I don't have an Oracle installation in front of me right now, so I can't remember if you'll get this error if the account is locked or not. But the HR user is locked by default if I remember correctly. Docs on unlocking HR

Also, if you haven't created the HR schema, yet, you'll need to do that. Here are the docs for that.

Alternatively, if you created it with the wrong password, or changed the password, you'll have to login as a dba user ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY Password;