Oracle SQL Developer - How To Connect to a Remote Server

How To Connect to a Remote Server

Q

How To Connect to a Remote Server? - Oracle DBA FAQ - Introduction to Oracle SQL Developer

✍: FYIcenter.com

A

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.

2007-04-26, 4951👍, 0💬

💬 2013-03-06 sulochana: Thank you.. It helped me

How To Connect to a Remote Server
How To Connect to a Remote Server? - Oracle DBA FAQ - Introduction to Oracle SQL Developer 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 ... 2007-04-26, 4952👍, 0💬

How To Connect to a Local Oracle 10g XE Server
How To Connect to a Local Oracle 10g XE Server? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Con... 2007-04-26, 4943👍, 0💬

How To Run SQL Statements with Oracle SQL Developer
How To Run SQL Statements with Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Once a connection is established with an Oracle server, you can enter any SQL statements in the SQL Statement area. Try yourself with the following steps: Go to the SQL Statement area Enter S... 2007-04-27, 4480👍, 0💬

Is Oracel SQL Developer written in Java
Is Oracel SQL Developer written in Java? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file. 2007-04-26, 4427👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.