CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
rajeev
rajeev

Reputation: 323

Connecting SQL developer to Oracle 12c

I am a little new at setting up this Oracle Stuff so hopefully you bear with me.

How do I setup a connection from SQL developer to Oracle? I did read the manual. What are the parameters that need to be given for the connection, the user name and the password in case I need to connect to the HR database?

Upvotes: 2

Views: 7550

Answers (2)

rajeev
rajeev

Reputation: 323

My pluggable database had to be force closed first and then I was able connect successfully.

Upvotes: 0

krokodilko
krokodilko

Reputation: 36127

Run SQLPlus, connect as SYS user (use administrator's password you have entered during installation) and unlock HR user and give him a new password:

C:\>sqlplus  sys as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 19 18:10:51 2015

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

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter user hr identified by new_password;

User altered.

SQL> alter user hr account unlock;

User altered.

If you are using Windows, then run firewall configuration and allow connections to TCP/IP port 1521.

Run SQL Developer and click big green "+" icon in "Connections" panel.

enter image description here

You will see a dialog box like below: enter image description here

Fill in fields in this form like in the above picture.
SID is your database name you have entered during instalation (default is ORACL).
Click "Test" button to verify if everything is OK, if yes, then click "Save" button to remember connection's configuration, and then click "Connect".

Upvotes: 4

Related Questions