Re: Help with Oracle8i PE and Designer6i connection

You must run Oracle Net8 Easy Config to add new TNS connection. First, choose Add New Service and type New service name. Because, you have Oracle8i PE, network protocol should be Bequeath (Local Database) and after entering the protocol you must supply database SID. At the end, you can test new service name (database must be up). That's should be enough.
When you start Designer, in the connect string put service name that you just add.

Sorry for bad english.
Bye !

"Otter" <vwr_at_hotmail.com> wrote in message news:uWxSSF9dBHA.2168_at_cpimsnntpa04...
> I have 8i installed on a Windows98 machine. I can connect to SQL/Plus and
> Navigator. I then installed Designer6i, but get the message below when I
try
> to connect to the database with Designer itself or the repository
> administration utility . My class assignment is seriously behind because
of
> this. I've been trying to figure this out for over a week! I've tried to
use
> the suggestions mentioned in the error messages even to the extent of
> getting inside the registry with
> \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\TNS_ADMIN for example as well as the
> Net8 assistant and putting the TNSNAMES.ORA file in various spots, but I
> haven't gotten very far with the various things I've tried. Any help would
> be greatly appreciated.
>
> Message
> -------
> ORA-12154: TNS:could not resolve service name
> ---------
> Cause:
> The service name specified is not defined correctly in the TNSNAMES.ORA
> file.
>
> Action:
> Make the following checks and correct the error:
> - Verify that a TNSNAMES.ORA file exists and is in the proper place and
> accessible. See the operating system specific manual
> for details on the required name and location.
> - Check to see that the service name exists in one of the TNSNAMES.ORA
files
> and add it if necessary.
> - Make sure there are no syntax errors anywhere in the file.
> Particularly look for unmatched parentheses or stray characters.
> Any error in a TNSNAMES.ORA file makes it unusable. See Chapter 4 in the
> SQL*Net V2 Administrator's Guide. If possible, regenerate the
configuration
> files using the Oracle Network Manager.
> ***************
> Message
> -------
> RME-00220: Failed to connect to Repository
> --------
> Cause:
> Failed to connect to the requested Repository.
>
> Action:
> Examine other reported errors for specific details.
> ************
>
> Thanks,
> Otter
>
>
>
>
Received on Wed Nov 28 2001 - 11:44:23 CET