Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to make connection to the local database using Personal Oracle 7.2
Chris:
I've been asking how to connect to Personal Oracle7 out here for a
long time and you've given me a clear answer. I did as you suggested
to Dmitry and installed TCP/IP from Windows95.
Next, I installed SQLNet from the easy configuration.
My TNSNAMES.ORA file now contains the following entry:
GregStock.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Greg)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Greg)
(Port = 1526)
)
Then I tried the following as shown in the SQLNet documentation: C:\>tnsping GregStock
I got the following:
TNS Ping Utility for WINDOWS 32: Version 2.2.2.0.0 - Production on
14-JAN-98 23:
45:43
Copyright (c) Oracle Corporation 1995. All rights reserved.
Attempting to contact
(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=Greg)(Port=1521))
TNS-12545: Connect failed because target host or object does not exist
Can you explain to me what is going wrong?
I really appreciate your help.
Thanks,
Greg in Cincinnati
On Wed, 14 Jan 1998 11:17:38 GMT, Chris Balmain <C.Balmain_at_cs.ucl.ac.uk> wrote:
>Dmitry wrote: >> >> All my trying to connect to local database were failed with message >> ORA-12203: TNS: Unable to connect to destination. >> >> Here I have file readme.doc where saing that I have to wait some time and >> try connect again. >> What is it? Joke? I tried it without visible successfull some times. >> >> Have anyone some expierence of solve this problem and can it to be solved >> anywhere? >> Perhaps I'm searching a black can inside dark room... >> >> Dmitry. >> e-mail: Dimon_at_diogen.nstu.nsk.su > >You must also install TCP/IP onto your computer (even though you are or >are >not networked. Go to Control Panel, select Network, then add Microsoft >network and install protocol TCP/IP. > >When you then try and connect to local database, your users should then >come >up. A good book to look at is "Oracle 7 for dummies" - I thought it was >very >good for beginners. > >You can then use your SQL*Plus commands to create a user and then >connect the user to the database. > >Bye! > >chris. >Received on Thu Jan 15 1998 - 00:00:00 CST