Help with Oracle8i PE and Designer6i connection
Date: Tue, 27 Nov 2001 21:54:45 -0800
Message-ID: <uWxSSF9dBHA.2168_at_cpimsnntpa04>
[Quoted] 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 [Quoted] to connect to the database with Designer itself or the repository administration utility . My class assignment is seriously behind because of [Quoted] this. I've been trying to figure this out for over a week! I've tried to use [Quoted] 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.
[Quoted] - 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
[Quoted] 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 - 06:54:45 CET