Re: Oracle8i Please Direct me in the right direction

The tnsnames.ora file is what allows sqlnet connections to a database from remote locations.
If you look at a sample in that same directory area you can probably figure it out.
Here is a sample entry from my tnsnames.ora file although it is not web enabled at this time, the entry you need should be similar... DM1 = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host=njnbudm01)(Port= 1521))(CONNECT_DATA = (SID = DM1))) You will have to use IP address instead of hostname (njnbudm01 above) if you do not have a 'hosts' file setup. An IP address looks like 100.101.102.103 (but your numbers will be different).

Hope this helps.
:)
Yours truly,
Jesse F. Josserand
President and Directing Consultant
Josserand and Associates
Consulting Group
12522 Texas Army Trail
Cypress, TX 77429
Toll free: 1-877-FOR-UNiX
or direct: 281-970-6790 voice
Fax: 281-807-1768

Personal direct e-mail: jesse_at_josserand.com Company e-mail: consulting_at_josserand.com

Technical Support e-mails...
TheOracle_at_Delphi.com
unix-quesions_at_millennium-mall.com
gemms-questions_at_millennium-mall.com
oracle-questions_at_millennium-mall.com
orafin-questions_at_millennium-mall.com

Websites...
http://www.josserand.com

http://www.millennium-mall.com

Specialties...
Unix specialists since 1984
Oracle specialists since 1988
Client/Server specialists since 1991
Multi-tier specialists since 1993
GEMMS specialists since 1994
Advocates of Network Computers &
  Associated Architectures since 1995
28 years industry-wide experience

Josserand and Associates Consulting Group. Products and Services...
Offering Superior Technical Project Management, American Business Solutions(tm),
Y2k Impact Analysis and Resolution,
a unique solution for late Y2k conversions, Fault Resilient Architectures(tm),
Rapid Implementation Technologies(tm),
Rapid Site Assessments(tm),
and The Josserand Life Cycle Method(c), a state-of-the-art life cycle methodology designed specifically for RAD and Rapid Implementation Technologies(tm) and that can reduce time-to-complete or time-to-market by as much as 100%!

AcD|ChAoS wrote in message <7ltg2u$d5p$1_at_news.jump.net>...
>
>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
>
>
Received on Tue Jul 06 1999 - 14:22:18 CDT