Scribd
Upload
10 views4 pages

Starting SQL Developer via Command Prompt

To start using SQL Developer (Oracle), open the command prompt and use 'lsnrctl services' to check the hostname and port number of the database. Open SQL Developer and configure it with the same hostname, port, SID, and username and password found in the command prompt output. Click test and OK to connect to the database and begin using SQL commands.

Uploaded by

Johan Jauhari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views4 pages

Starting SQL Developer via Command Prompt

To start using SQL Developer (Oracle), open the command prompt and use 'lsnrctl services' to check the hostname and port number of the database. Open SQL Developer and configure it with the same hostname, port, SID, and username and password found in the command prompt output. Click test and OK to connect to the database and begin using SQL commands.

Uploaded by

Johan Jauhari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

HOW TO START USING SQL Developer (ORACLE)

1. Type ‘cmd’ at search window

2. Type ‘lsnrctl services’ in [Link] window.


3. Check the hostname and port from [Link] window. In the following figure, the hostname
is ‘fsk5_02’ and the port is ‘1057’.

4. Click and open SQL Developer

5. Right Click at ‘Test’ and choose Properties.


6. Configure the hostname and port no same as you find in your [Link] window. The SID is
‘ora2’. Insert Username ‘hr’ and password ‘123456’ (Reminder: Some PCs in FSK5 use
password ‘12345’).

7. Click Test Button and see status: Success.

8. Enter password ‘123456’ and click button OK.


9. Now, you may start use the SQL command.

You might also like