How to connect to an Oracle database?
When you want to reverse engineer an Oracle database you've got two options:
- Reverse engineer an Oracle database by connecting to the database directly
- Reverse engineer an Oracle database by importing an Oracle SQL file
When reverse engineering an Oracle database with a direct/native database connection, you don't need to install the Oracle client software. DeZign for Databases connects to Oracle directly through the TCP/IP protocol and doesn't require Oracle client software.
To connect to the Oracle server you need to know the address of computer where the Oracle server is (Host), port number (Port) to connect, and the database global system identifier (Database name, SID, the system identifier that specifies Global Database Name).
Example: Server's IP address is 205.227.44.44, port number is 1521 (most commonly used), 'orcl' is Global Database Name.
See also: Connecting to a remote MySQL server