Xref: alice comp.databases.oracle.server:56298
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: roguedood@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle8i Please Direct me in the right direction
Date: Wed, 07 Jul 1999 07:18:11 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 91
Message-ID: <7luuvd$50r$1@nnrp1.deja.com>
References: <7ltg2u$d5p$1@news.jump.net>
X-Article-Creation-Date: Wed Jul 07 07:18:11 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; MSN 2.5; Windows 98; DigExt)
X-Http-Proxy: 1.0 Nobody (CERN-HTTPD/3.0A), 1.0 x33.deja.com:80 (Squid/1.1.22) for client 205.227.43.52

Shannon,

I tried going to your site to check on it, and it doesn't seem to be
up.  Try a couple of the following URLs on your box to ensure WebDB is
installed properly:

This is the WebDB Home:  url=http://www.xpresstickets.com:80/WebDB/
(assuming you used port 80 as your default WebDB port)
username/password=WEBDB/WEBDB (that's the default, but you may have
changed this?)

for listener & gateway modifications=
  http://www.xpresstickets.com:80/admin_/gateway.htm
  http://www.xpresstickets.com:80/admin_/listener.htm

Add this entry to your tnsnames.ora:
WEBDB.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

Just replace 127.0.0.1 w/ the IP of your server, or the hostname if you
can resolve it locally.  The tnsnames.ora file is a Oracle network host
file of sorts.  It tells your client Net8/SQL*Net software where to
look when you are trying to connect to a database ~somewhere~ on the
network.  It also gives info like protocol, port, SID, et al...  To
test it, just go to a DOS prompt, and type "sqlplus
system/manager@webdb".  A sqlplus session should open and you will get
a "connected." message.  If this is successful, the WEBDB database
alias is working properly.

I would recommend joining the Oracle Technology Network (OTN).  Visit
it and check it out, http://technet.oracle.com.  It's worth a glance.
There is loads of information there available regarding WebDB (and the
rest of the Oracle product line, for that matter).

- Sean

"AcD|ChAoS" <justices@jump.net> wrote:

> Hi,
> I just downloaded Oracle8i because i thought it would be the solution
for
> all my database and website problems. However, i have never had any
previous
> contact with databases of any sort and no knowledge of SQL. I have 3
weeks
> to get this ecommerce site up and running. I know, I know, I'm a fool
> looking for a quick solution, but this has been dumped on me and I
have no
> choice but to follow through. It took me 4 hours to figure out how to
even
> turn on the database. My questions are as follows if anyone feels
gracious
> enough to help me:
> 1. After I installed WebDB it asked me to "Please include an entry
named
> WEBDB in c:\Oracle\WebDB2\net80\admin\tnsnames.ora" I have no idea
what this
> means or why. I think it has something to do with why I cant login to
the
> database from the website. The website addy is www.xpresstickets.com
for
> people that would like to see the exact message it gives me. The pass
and
> username don't matter because even when I enter the correct one in it
says
> the same thing.
>
> 2. I need a good quick reference for dummies type book that will
outline
> getting started with this thing. I know about the getting started
> documentation that comes with it, but I need something that doesnt
assume
> you already have experience with oracle.
>
> Thanks in advance for any help:)
>
> Shannon


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.