6
Configuring Variables and General Configuration

This chapter provides information about setting up your environment variables which is the last step to ensuring that Oracle WebDB is properly installed and operating successfully. Also discussed are general configuration issues.

The chapter contains the following sections:

6.1 Environment Variable Check List

Before starting the WebDB Listener, WebDB CGI executable, or the WebDB cartridge, you should ensure that the following environment variables are set correctly.

WV_GATEWAY_CFG should point to the gateway configuration file, wdbsvr.app.

Windows NT

This value is set automatically during installation. To check it, click Settings on the Windows NT Start menu, then Control Panel, System, and finally the Environment tab on the System Properties dialog box. The system variable WV_GATEWAY_CFG should have the value:
```
WV_GATEWAY_CFG=<ORACLE_HOME>\webdb\listener\cfg\wdbsvr.app
```
Solaris

The WV_GATEWAY_CFG variable is configured in a script file named wdbstart. The default value is:
```
setenv WV_GATEWAY_CFG <ORACLE_HOME>/webdb/listener/cfg/wdbsvr.app
```
On a single machine, multiple WebDB Listeners can be configured to run in different configurations by setting this parameter appropriately before starting the WebDB Listener.

Additional information:
see Chapter 5, "Configuring the WebDB Listener and PL/SQL Gateway".
LD_LIBRARY_PATH (Solaris only)

This parameter is set to <ORACLE_HOME>/lib for the following script files:
- wdbstart (for the WebDB Listener)
- wdbcgiw (for WebDB CGI executable)
where ORACLE_HOME is the location of your WebDB installation.

6.2 Creating a TNS Names Alias

You must create a TNS names alias if you plan to:

Install WebDB 2.2 on Solaris
Install WebDB on Windows NT in the Oracle8i (version 8.1.5) database
Install the WebDB Listener in a different machine than WebDB

You can use Oracle Net8 Easy Configuration to set up a TNS names alias to your database. Net8 Easy Configuration is located on your product CD and can be installed using the Software Asset Manager (follow the steps for a Custom install on Windows NT or a Typical install on Solaris to display the Software Asset Manager).

In addition, you can manually set up a TNS names alias by following these steps:

Open the tnsnames.ora file in the Oracle Home where you have installed WebDB.
- On Windows NT, the default location for the tnsnames.ora file is:
```
<ORACLE_HOME>\net80\admin
```
- On Solaris, the default location for the tnsnames.ora file is:
```
<ORACLE_HOME>/network/admin
```
Note:
If you set up a TNS_ADMIN environment variable, its path points to the tnsnames.ora file containing the TNS names alias that WebDB uses.

Add a TNS names alias that points to your database.

The following sample tnsnames.ora file contains a TNS names alias called USER1. The alias is to a non-8i database; for example, Oracle 7.3.4 or 8.0.5. The database is installed on the server Webdb_serv1.

# F:\ORACLEHOME\NETWORK\ADMIN\TNSNAMES.ORA Configuration 
File:F:\OracleHome\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

EXTPROC_CONNECTION_DATA.US.ORACLE.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

USER1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = Webdb_serv1))
    )
    (CONNECT_DATA =
      (SID = ORCL)
    )

In your Web browser, go to:
```
http://servername:port/admin_/gateway.htm
```
where:
- servername is the name of the server on which you installed WebDB.
- port is the port you specified during installation of WebDB.
On the Change PL/SQL Gateway Settings page, scroll down to the Oracle TNS names alias field for the WebDB Data Access Descriptor (if you selected a typical install, the name of the DAD is WebDB). Enter the TNS names alias you added to the tnsnames.ora file in Step 2.
Click Apply.

6.3 Changing the Language for a WebDB Site

To make your WebDB site available in a language other than the one in which it was created:

Navigate to support/sitenls on your product CD or stage area.
Log on to SQL*Plus by typing:
```
<site_schema>/<site_schema_password>
```
where

site_schema is the schema that owns the site.

site_schema_password is the password for the schema.

These scripts should be run after a WebDB site has been successfully installed. Type the following from the SQL*Plus prompt:

@initnls (You need to execute this script just once)

@sitenls <lang> (You need to execute this script for every language that you want the site to be available in)

where <lang> is one of the following:

<lang>	Language
ar	Arabic
cs	Czech
d	German
dk	Danish
e	Spanish
el	Greek
esa	Latin American Spanish
f	French
sf	Finnish
hu	Hungarian
i	Italian
iw	Hebrew
ja	Japanese
ko	Korean
n	Norwegian
nl	Dutch
pl	Polish
pt	Portugese
ptb	Brazilian-Portugese
ro	Romanian
ru	Russian
s	Swedish
sk	Slovak
tr	Turkish
th	Thai
zhs	Chinese/China
zht	Chinese/Taiwan

Note:
The English version of the site is available by default, even if you installed the WebDB site in another language.

6.4 Date and Time Configuration

To view your local date and time format, ensure that your NLS_lang settings are set to the appropriate language.

On Windows NT, you can choose your language from Regional Settings (located on the Control Panel), and use this language as the default local setting. Then, reboot your machine.

6.5 Viewing Arabic Characters

To view Arabic characters in your browser, WebDB requires a bidirectional plug-in. One plug-in that you can download is Sindbad, Version 4 which can be downloaded from

http://www.sakhrsoft.com/lproducts/linter/standard.htm.

After you install the plug-in, load the Arabic files you want to view into the WebDB system table. Add your language as Arabic[ar-AR] and set your encoding to user-defined. There is an option in Sindbad which allows bidirectional viewing of the characters.

6Configuring Variables and General Configuration