Hi Everyone,
We will find a way, when there is a need…
One such situation is connectivity of Local database with the SQL Developer.
Here I am going to tell you how exactly we should make connection with screenshots.
Assumptions
1. Oracle database is installed in the PC.
2. SQL developer also installed in the PC.
How to connect to local DB??
Step 1 : Add the entry of local connection in the tnsnames.ora file.
Path : C:\oracle_1\....\NETWORK\ADMIN\tnsnames.ora
LOCAL =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = localhost) (Port = 1521)))
(CONNECT_DATA =
(SID = orcl)))
In this
LOCAL - Name of the local database. User can name it as anything he wants.
localhost - since the sql developer connects to the db present in the same system.
orcl - Global database name. This is default and doesn’t change unless or otherwise we changed it while installation of the oracle DB.
Step 2 :
This is the view of the SQL Developer initially.
Step 3: Add Connection
Go to
View -> Connections
in the SQL Developer.
A connection window will get open.
Click to add New connection.
Step 4 : Fill the details for a new connection
This screen gets the details about the database to be connected to SQL Developer.
Connection Name : LOCAL
Hostname : localhost
Username and password of the local database. Example : SCOTT and TIGER.
Enter Hostname, Port and Service name as mentioned in the tnsnames.ora.
Step 5: Test the connection.
Step 6: Connect to the local database
Step 7: Test the connection by executing the queries in the database.
Connect to local database and rock on Friends!!.....
Thanks…
