CODEWITHSUNDEEP
oracle-databaseoracle11g
Sahib Singh
Sahib Singh

Reputation: 19

Oracle and Sql developer Connection

How do I find out the SID of my Oracle Database. I have Oracle 11g installed in my system, and i want to make a connection between SQL developer and oracle. But when I test the connection using the default SID ie xe it gives me an error of ORA-12505.

Upvotes: 1

Views: 22895

Answers (2)

Avi
Avi

Reputation: 300

In SQL Developer Default connection for oracle 11g:

Go to connection > New Connection

Connection Name =  HR or use any other name
User name = hr
Password = Your Password (This is the password that you selected during the installation of the of Oracle 11g)

Check the "Save" option

role: default
port 1521
SID : orcl

If you want to create the SYSDBA Account: (Administrator account)

Connection Name =  admin ORCL or use any other name
User name = sys

Password = Your Password (This is the password that you selected during the installation of the of Oracle 11g) 

role: sysdba (from the drop down)
port 1521
SID : orcl

TEST and Save Connect

Just in case if your HR account is locked because you have connected multiple number of times than you can fix this by logging into your SYS DBA account.

In the objects list on your list go to the OTHER USERS.

GO to HR Account > Right Click

EDIT USER

Choose the password you want and uncheck The account locked and the Password Expired options if they are checked.

Upvotes: 0

Joachim Isaksson
Joachim Isaksson

Reputation: 180867

If you can connect to the database using sqlplus, just show the SID / instance name by doing;

show parameter instance_name

or alternately

select instance_name from v$instance;

Upvotes: 7

Related Questions