Re: WebDb Installation

Thanks John and Eugene.. I will try this out. Eugene.. I did not quite understood the Listener part..

In the mean time I was trying to install WebDb manually. Got some doc from metalink. Very first step was to install PL/SQL Toolkit Packages by connecting to Remote DB using SYS and running the following script:

_at_owaload.sql username def_tabspce tmp_tblspc logfile usrpasswd

when doing this, part of the script ran OK, but most of it errored out. Found out that the script has connect statement as follows:

connect &&1/&&1

This should have been connect &&1/&&5 ( Since my fifth param has passwd_at_DB_ALIAS ). Does this has anything to do with having to put LOCAL entry in Registry?

In article <3859de39.10848659_at_super.news-ituk.to>,   See Message body for real address wrote:
>
> The part about the connect string lack is correct - I failed to add
that the
> LOCAL value had to be set to the tnsnames.ora alias for the remote
DB....
>
> As for the listener, once you set the /_admin/gateway.htm and
> /_admin/listener.htm correctly
> WebDb uses that info to connect and does not need a LOCAL set on the
client -
> it uses the tnsnames.ora ( the one on the server that is running the
listener )
> file entry corresponding to the DAD ( for building the default is
WEBDB )...
>
> John Greco
>
> "Eugene Popov" <epopov_at_rdtex.msk.ru> wrote:
>
> >The following is my IMHO.
> >I don't think this is enough. When installing database packages
(PL/SQL
> >cartridge and WebDB itself) Installer attempts to access database by
> >user/password, without connect string. So you have to specify LOCAL
> >parameter in Registry in the following way:
> >Path: <HKEY_LOCAL_MACHINE>\<Software>\<Oracle>
> >String Name: LOCAL
> >String Value: <your connect string, as in tnsnames.ora>
> >Machine name and port are used by listener when stating and
listening, not
> >when connecting to database. Moreover, if you install WebDB this way,
you'll
> >have listener installed on your machine and you'll have to have this
> >Registry parameter set for the database containing WebDB for
listener's
> >proper work, because it accesses DB without connect string.
> >At least I had to install WebDB this way.
> >
> >TurkBear <johng_at_mm.com> wrote in message
> >news:3856a612.20454622_at_super.news-ituk.to...
> >>
> >> It needs the sys password for the remote database - for
> >> HOST and PORT# , use the info in the tnsnames.ora file, or get the
specs
> >from
> >> the DBA of the remote database - that's where it is set ( in
> >Listener.ora )
> >>
> >>
> >> bandhu1_at_my-deja.com wrote:
> >>
> >> >Hi,
> >> >
> >> > I am trying to install WebDb 2.0.5 on Win NT SP5. I do not have
> >> > oracle on this box. I want to use remote database instead.
During
> >> > the installation of WebDb it asks for following information:
> >> >
> >> > PASSWORD
> >> > HOSTNAME
> >> > PORT #
> >> >
> >> > What do I enter for above information in my case.
> >> >
> >> > Anyone please?
> >> >
> >> > Thanks in advance
> >> >
> >> >
> >> >Sent via Deja.com http://www.deja.com/
> >> >Before you buy.
> >>
> >>
> >>
> >> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
> >==----------
> >> http://www.newsfeeds.com The Largest Usenet Servers in the
World!
> >> ------== Over 73,000 Newsgroups - Including Dedicated Binaries
Servers
> >==-----
> >
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the
World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries
Servers ==-----
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 23:00:45 CET