| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Installation problem with Webdb on Oracle 8i and NT server.
Thanks for your post. I've never seen a such crappy product which does
not even work with its own native database! I had problems with 8.0.4x!
In article <19990518223229.18060.00002061_at_ng124.aol.com>,
timkarnold_at_aol.com (TimKArnold) wrote:
> 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:
>
> 1. 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.
>
> 2. 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:
>
> a. HKEY_LOCAL_MACHINE.
>
> b. Double Click on SOFTWARE.
>
> c. Single Click on ORACLE.
>
> d. Click on Edit at the top of the box.
>
> e. Click on Add Value.
>
> f. In the Add Value Box, type the following:
> i. Value Name: TNS_ADMIN.
> ii. Data Type: REG_SZ.
>
> g. In the String Editor box, type the following:
> i. String: E:\ora81home\network\admin (alter to fit
your 8i home)
>
> h. 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#.
> a. 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.
>
> b. Host name: Verify the host name displayed is correct.
>
> c. Port#: You can change the port#.
>
> 5. 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.
>
> a. Select Oracle 8i.
>
> 6. 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
>
> a. 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.
>
> b. Click Apply
>
> 3. 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.
>
> 1. tnsnames.ora
> a. This CANNOT be the same format as the 8i tnsnames.ora
>
> b. Make sure the alias(V815) is the same as the connect_string
you have
> placed in the admin_/gateway.htm page in the browser.
>
> b. 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
> a. This also CANNOT be the same format as the 8i sqlnet.ora
>
> b. 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
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 13:04:58 CDT
 |
 |