/text/shared/explorer/database/dabawiz02oracle.xhp UFI: Database Wizard Oracle page DEDR: Reviewed Oracle databases (base) mw added one index entry Oracle Database Connection Specifies the options to access an Oracle database.copied text from shared\explorer\database\11110000 Oracle database You can use a JDBC driver to access an Oracle database from Solaris or Linux. To access the database from Windows, you need an ODBC driver. On UNIX, ensure that the Oracle database client is installed with JDBC support. The JDBC driver class for the Solaris Oracle client version 8.x is located in the <Oracle client>/product/jdbc/lib/classes111.zip directory. You can also download the latest version of the driver from the Oracle web site: http://otn.oracle.com/tech/java/sqlj_jdbc/content.html In the Data source URL box, enter the location of the Oracle database server. The syntax of the URL depends on the database type. See the documentation that came with the JDBC driver for more information. For an Oracle database, the syntax of the URL is: oracle:thin:@hostname:port:database_name hostname is the name of the machine that runs the Oracle database. You can also replace hostname with the IP address of the server. port is the port where the Oracle database listens. Ask your database administrator for the correct port address. database_name is the name of the Oracle database. Ask your database administrator for the correct name. Name of the Oracle database Enter the name of the Oracle database. Server URL Enter the URL for the database server. Port number Enter the port number for the database server. Oracle JDBC Driver Class Enter the name of the JDBC driver. Test Class Tests the connection with the current settings. Authentication Database Wizard