Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Manual DB Creation and TNS Problem on IBM-AIX (UNIX) System

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

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Thu, 24 Oct 2002 21:53:08 +0200
Message-ID: <ap9itq$n31$1@news.hccnet.nl>


Since many people read both newsgroups there is no use in crossposting.

"Manoj G. Kithany" <manojkithany_at_yahoo.com> schreef in bericht news:ad4fd258.0210241124.4732063d_at_posting.google.com...
> 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!
Received on Thu Oct 24 2002 - 14:53:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US