Corporation Server User Manual

mod_plsql
7-34 Oracle HTTP Server Administrator’s Guide
PlsqlDatabaseConnectString Specifies the connection to an Oracle database.
Category Value
Syntax PlsqlDatabaseConnectString
stringServiceNameFormat/SIDFormat/TNSFormat/NetServiceNameFormat,
where string can be one of the following based on the second argument:
■ ServiceNameFormat: HOST:PORT:SERVICE_NAME format where HOST
is the hostname running the database, PORT is the port number the TNS
listener is listening on, SERVICE_NAME is the database service name.
■ SIDFormat: HOST:PORT:SID format where HOST is the hostname
running the database, PORT is the port number the TNS listener is
listening on, SID is the database SID.
■ TNSFormat: A valid TNS alias which resolves using Net8 utilities like
tnsping and SQL*Plus.
■ NetServiceNameFormat: A valid net service name which resolves to a
connect descriptor. A connect descriptor is a specially formatted
description of the destination for a network connection. A connect
descriptor contains destination service and network route information.
If the format argument is not specified, then mod_plsql assumes that ‘string’
is either in the HOST:PORT:SID format, or resolvable by Net8. The
differentiation between the two is made by the presence of the colon in the
specified string.
It is recommended that newer DADs do not use the SIDFormat syntax. This
exists only for backward compatibility reasons. Use the new two argument
format for newly created DADs.
Default None
Example ■ PlsqlDatabaseConnectString
myhost.com:1521:myhost.iasdb.inst ServiceNameFormat
■ PlsqlDatabaseConnectString myhost.com:1521:iasdb
SIDFormat
■ PlsqlDatabaseConnectString myhost_tns TNSFormat
■ PlsqlDatabaseConnectString cn=oracle,cn=iasdb
NetServiceNameFormat
■ PlsqlDatabaseConnectString
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=myhost.com)(
Port= 1521))(CONNECT_DATA=(SID=iasdb))) TNSFormat
■ PlsqlDatabaseConnectString myhost_tns
■ PlsqlDatabaseConnectString myhost.com:1521:iasdb