Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Manula DB creation and TNS Problems on IBM AIX System
"Manoj G. Kithany" <manojkithany_at_yahoo.com> schreef in bericht
news:ad4fd258.0210241125.12ab086e_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!
Indeed this is the case. You can use "netca" or "netmgr" to add the entry to
tnsnames.ora, or just add it manually. Be careful if you use netca AND have
TNS_ADMIN pointing to another (then default) location: it won't be
respected, as I discovered this week.
Peter Received on Thu Oct 24 2002 - 14:52:04 CDT