Basic Oracle Concepts and Programming Question:
Download Questions PDF

How To Connect to a Remote Server?

Answer:

If you have an Oracle server running remotely on a network, and you know all the access information needed, you can following steps to connect your Oracle SQL Developer:

► Start Oracle SQL Developer
► Right-click on Connections
► Select New Database Connection
► Enter Connection Name as: Remote_Server
► Enter Username as: _username_
► Enter Password as: _password_
► Enter Hostname as: _hostname_
► Enter SID as: _sidname_
► Click Test
► Click Connect, if you see Status changed to Success

You will see the SQL Statement area opened ready to take any SQL statements.

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Connect to a Local Oracle 10g XE Server?How To Run SQL Statements with Oracle SQL Developer?