Re: Installation problem with Webdb on Oracle 8i and NT server.

From: TimKArnold <timkarnold_at_aol.com>
Date: 19 May 1999 02:32:29 GMT
Message-ID: <19990518223229.18060.00002061@ng124.aol.com>

Article-ID:         <Note:69776.1>
Circulation:        PUBLISHED (EXTERNAL)
Platform:           912  MS Windows NT
Subject:            Installing WebDB 2.0.5 Against Oracle 8i On Windows NT
Modified-Date:      06-MAY-1999 20:56:44
Document-Type:      BULLETIN
Content-Type:       TEXT/PLAIN
Impact:             MEDIUM

PURPOSE This bulletin will give detailed instructions on how to install WebDB on Windows NT to use against an Oracle 8i database. Since WebDB is based on 8.0.5, the listener needs to be installed into an 8.0.5 type home.

This setup requires the WebDB listener to use a connect_string to connect to the database. Since the listener is in a separate home, you must treat this as a remote installation.

SCOPE & APPLICATION Assumptions:

You have an Oracle 8i database installed in its own Oracle Home (NON default home i.e, DEFAULT_HOME c:\orant). It should be installed in a home like Name: Ora8iHome Directory: c:\Ora8ihome.
Using SQL*Plus from the Oracle 8i home, you can connect to any user using a connect_string, for example:

                connect username/password_at_connect_string
 		connect scott/tiger_at_V815

3. The TNS_ADMIN variable in the registry has been set. This will allow all

Oracle Products to view only one tnsnames.ora, this simplifies updating SQL*Net. NOTE: Please do not edit the registry unless you are familiar with making changes here. Any mistake could corrupt Windows NT O/S:

HKEY_LOCAL_MACHINE.
Double Click on SOFTWARE.
Single Click on ORACLE.
Click on Edit at the top of the box.
Click on Add Value.
In the Add Value Box, type the following:
Value Name: TNS_ADMIN. ii. Data Type: REG_SZ.
In the String Editor box, type the following:
String: E:\ora81home\network\admin (alter to fit your 8i home)
Exit out of the Registry.

Installing WebDB against Oracle 8i
1. Run Installer.

2. Select a Home remote to Oracle 8i, for example:

      Name:  OraWebDB
      Home:  D:\OraWebDB

3. Select a Typical Install.

4. The next screen will ask for the database SYS password, host name, and port#.

Password: WebDB needs to be able to find the database in order to use the password, if your environment variables are not set correctly, you will receive an incorrect SYS password error.
Host name: Verify the host name displayed is correct.
Port#: You can change the port#.
The next screen has you select the name of the target database. This allows the installer to determine if it needs to install the listener in its own home.
Select Oracle 8i.
It will first install the listener into its own home. For example if your Oracle Home is:

D:\Ora8ihome

It will create a WebDB home under:

D:\OraWebDB

This WebDB directory will contain an 8.0.5 type home to store all the listener files and client libraries.

7. After installing the listener and all its directories, it will begin

installation of the PLSQL toolkit and WebDB packages. WebDB installs the 4.0.5.4.0 toolkit version. If you already have the toolkit installed for OAS 4.0.7.0.0, it will prompt you to either overwrite the toolkit or proceed without installing the toolkit. You want to proceed without installing the toolkit.

8. It will now install the database packages. This will take a long time to

install. Task #7 usually takes the longest and may seem to hang but it does not.

Connecting to WebDB
1. The listener should have started automatically. You can verify this in

Services.

2. Go to the following URL:

http://<host>:<port>/admin_/gateway.htm http://intprod.us.oracle.com:20561/admin_/gateway.htm

Under the WebDB DAD information section, there is a text box called connect string. Currently the default connect string is WebDB, change this to your correct connect string that you used earlier to test SQL*Plus, such as: V815.
Click Apply
Go to the following URL:

http://<host>:<port>/WebDB/
http://intprod.us.oracle.com:20561/WebDB/

This should bring up the WebDB home page. Login as the username: webdb password: webdb.

Last Resort

If for some reason you receive a TNS error upon login, it means that WebDB is still looking in its own ORACLE_HOME for that connect_string.

In your WebDB home, add the following files to your Net80\admin directory.

tnsnames.ora
This CANNOT be the same format as the 8i tnsnames.ora
Make sure the alias(V815) is the same as the connect_string you have placed in the admin_/gateway.htm page in the browser.
The file should look like below. You will need to alter the SID, PORT(same as port in 8i tnsnames.ora), HOST and alias(V815) to fit your setup:

         V815.world =
              (DESCRIPTION =
                (ADDRESS_LIST =


                 (ADDRESS = (PROTOCOL = TCP)(HOST = intprod)(PORT = 20521))


                  )


                 (CONNECT_DATA =


                 (SID = V815)


                  )
                  )

2. sqlnet.ora

This also CANNOT be the same format as the 8i sqlnet.ora
The file should look similiar to the one below.

        TRACE_LEVEL_CLIENT = OFF
        #sqlnet.authentication_services = (NONE)
        names.directory_path = (TNSNAMES, HOSTNAME)
        names.default_domain = world
        name.default_zone = world
        automatic_ipc = off
_______________________________________________________________________________
                                                        Oracle Support Services

Received on Tue May 18 1999 - 21:32:29 CDT