Re: Need Help with WebDB Install

From: navychief_rmc <navychief_rmcNOnaSPAM_at_hotmail.com.invalid>
Date: Wed, 03 Nov 1999 10:03:39 -0800
Message-ID: <09920fb9.6beeca95@usw-ex0102-009.remarq.com>

Here are my notes to install WebDB.
The TNSNames.ORA is at the end.
Hope it helps.

WebDB 2.1
You will run the install/setup twice. The first time it will error out. To fix the error you’ll replace some files then re-run the setup. Run \nt\setup.exe
company name = computer name
oracle home name = Orawebdb
location = d:\oracle\webdb
language = english
ok
screen flashes and comes back, click ok again Use typical install
If you get an out of space error and know other wise, click yes to contiune.
Database is Oracle 8I
Password = change_on_install
TNS Name Alias = v815
Host may default to computer host name
Webdb listener port # default to 80
Select ok

At this point you will get a General Information box saying the TNS names alias v815 was not found
In the d:\oracle webdb\net80\admin\tnsnames.ora. The install program might start the net8 Easy Configuration wizard to help you create the TNS names alias v815. At any rate, when possible, cancel out of the install program. You might also get a Dr. Watson error or Net8 Assistant Warning. Either case do not continue, cancel the install.

Rename the d:\oracle\webdb\net80\admin\*.ora files to d:\oracle\webdb\net80\admin\*.old.
Replace the following files: tnsname.ora and sqlnet.ora in d:\oracle\webdb\net80\admin directory. These files were modified by Oracle Corp. and sent to me and are on the WebDB CD I sent you in a separate directory by themselves.
Take off the read only attibute on TNSNAMES.ORA file. Edit the tnsnames.ora file. Find the v815.world entry. Change Host = hostname to Host = to nwdc-db-s and SID = ORCL to SID = nwdc entries.

Restart the install: \nt\setup.exe
company name = nwdc
oracle home name = Orawebdb
location = d:\oracle\webdb
language = english
Use typical install
Database is Oracle 8I
Password = change_on_install
TNS Name Alias = v815
Host should default to computer host name Webdb listener port # default to 80
On Webdb schema select ok without changing anything. Note password for user webdb is webdb and select ok. On choose languages, select only ok.
Select ok to start install.

It will look like the system has stalled, but it is working. Eventually the progress bar will come up and show completion.

After it finishes, write down the web sites at the end of install. You’ll need these later.
select ok to exit the setup.
Reboot

TNSNAMES.ORA file from Oracle

Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = BEQ)


          (PROGRAM = oracle80)


          (ARGV0 = oracle80ORCL)


          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 127.0.0.1)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

TcpExample.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = Production1)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

SpxExample.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = SPX)


          (Service = Server_lsnr)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

NmpExample.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = NMP)


          (Server = FinanceServer1)


          (Pipe = ORAPIPE)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

CMExample.world =
  (DESCRIPTION=(address_list=

      (ADDRESS=


          (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))


      (ADDRESS=


          (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))


      (CONNECT_DATA=(SID=ORCL))
         (SOURCE_ROUTE=yes)

  )

extproc_connection_data.world =
  (DESCRIPTION =
    (ADDRESS =

        (PROTOCOL = IPC)
        (KEY = EXTPROC5)

    )
    (CONNECT_DATA = (SID = extproc)
    )
  )
v815.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = hostname)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Wed Nov 03 1999 - 12:03:39 CST