Re: Manual DB Creation and TNS Problem on IBM-AIX (UNIX) System

On 24 Oct 2002 12:24:33 -0700, manojkithany_at_yahoo.com (Manoj G. Kithany) wrote:

>Hi ORAPERTS (ORAcle exPERTS),
>
>I am using Oracle 9 on IBM AIX (Unix) System.
>I created 1 DB (gauri) using DBCA and other DB (test) MANUALLY using
>Create Database.
>
>When I try to Connect to GAURI DB - it works fine - no probs. BUT,
>when I try to connect to my TEST Database - it gives following error:
>-----------------------------------------------------------------
>SQL> conn system/manager_at_test as sysdba;
>ERROR: ORA-12154: TNS:could not resolve service name
>-----------------------------------------------------------------
>
>What is this error about? I checked my TNSNAMES.ORA file and did'nt
>find any entry for my TEST Database but did see an entry for GAURI
>database.... What is the solution to this problem. Does this mean that
>one has to MANUALLY ADD an entry to TNSNAMES.ORA file whenever you
>create DB MANUALLY?
>
>Any information on this would be very helpful.
>
>THANKS!
"Does this mean that one has to MANUALLY ADD an entry to TNSNAMES.ORA file whenever you create DB MANUALLY?"

In a word -- 'Yes.'

Long story: Creating a database is creating a database. It has nothing to do with SQLNet config.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)