Re: Oracle8i Please Direct me in the right direction

From: <roguedood_at_my-deja.com>
Date: Wed, 07 Jul 1999 07:18:11 GMT
Message-ID: <7luuvd$50r$1@nnrp1.deja.com>

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_at_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_at_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. Received on Wed Jul 07 1999 - 02:18:11 CDT