D Appendix: URL Reference

Both the database schema and application installers for the Central Office product prompt for several different URLs. These include the following:

JDBC URL for a Database

Used by the Java application and installer to connect to the database.

Using the SID

Syntax:

jdbc:oracle:thin:@[host]:[tcpPort]:[SIDname]

• [host]: host name of the database server

• [tcpPort]: database listener port

• [SIDname]: system identifier for the database

Example:

jdbc:oracle:thin:@myhost:1525:mySIDdatabase

Using the Service Name

Syntax:

jdbc:oracle:thin:@//[host]:[tcpPort]/[service_name]

• [host]: host name of the database server

• [tcpPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@//myhost:1525/myserviceDB

Using the Oracle Net Connection

Syntax:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=[host])
(PORT=[tcpPort]))(CONNECT_DATA=(SERVICE_NAME=[service_name])))

• [host]: host name of the database server

• [tcpPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost1)
(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=mydatabase1)))

Using the Oracle Net Connection in Oracle RAC

Syntax:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=tcp)(HOST=[host](PORT=[tcpPort]))
(ADDRESS=(PROTOCOL=tcp)(HOST=[host](PORT=[tcpPort]))
(CONNECT_DATA=(SERVICE_NAME=[service_name])))

• [host]: host name of the database server

• [tcpPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=tcp)(HOST=myhost1)(PORT=1525)) (ADDRESS=(PROTOCOL=tcp)(HOST=myhost2)(PORT=1525))
(CONNECT_DATA=(SERVICE_NAME=myserviceDB1)))

Secure JDBC URL for a Database

Used by the Java application and installer to connect to the database.

Using the Secure Oracle Net Connection

Syntax:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=[host])
(PORT=[tcpsPort]))(CONNECT_DATA=(SERVICE_NAME=[service_name])))

• [host]: host name of the database server

• [tcpsPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=myhost1)
(PORT=7004))(CONNECT_DATA=(SERVICE_NAME=mydatabase1)))

Using the Secure Oracle Net Connection in Oracle RAC

Syntax:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=tcps)(HOST=[host](PORT=[tcpsPort]))
(ADDRESS=(PROTOCOL=tcps)(HOST=[host](PORT=[tcpsPort]))
(CONNECT_DATA=(SERVICE_NAME=[service_name])))

• [host]: host name of the database server

• [tcpsPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=tcps)(HOST=myhost1)(PORT=7004))
(ADDRESS=(PROTOCOL=tcps)(HOST=myhost2)(PORT=7004))
(CONNECT_DATA=(SERVICE_NAME=myserviceDB1)))

JNDI Provider URL for an Application

Used for server-to-server calls between applications.

Syntax:

t3://<host>:<port>

• <host>: host name selected when the WebLogic domain was created

• <port>: port number selected when the WebLogic domain was created

Example:

t3://adminserver:7001

Deployer URI

Used by the Oracle Ant tasks to deploy an application to a WebLogic domain. The application installer does not prompt for this value. It is constructed based on other inputs and written to the ant.install.properties file for input to the installation script. For repeat installations using silent mode, you may need to correct mistakes in the deployer URI.

Syntax:

input.deployer.uri = t3://<host>:<port>

• <host>: host name selected when the WebLogic domain was created

• <port>: port number selected when the WebLogic domain was created

Example:

input.deployer.uri = t3://localhost:7003