CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
Yuvi
Yuvi

Reputation: 149

How to connect to local Database in Sql Developer

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.

Upvotes: 2

Views: 10412

Answers (1)

woot
woot

Reputation: 7616

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;

Upvotes: 2

Related Questions