Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!h48g2000cwc.googlegroups.com!not-for-mail
From: "fitzjarrell@cox.net" <fitzjarrell@cox.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Error on eXP
Date: 10 Oct 2006 06:22:30 -0700
Organization: http://groups.google.com
Lines: 44
Message-ID: <1160486550.546394.292480@h48g2000cwc.googlegroups.com>
References: <1160485084.300419.19760@k70g2000cwa.googlegroups.com>
NNTP-Posting-Host: 192.85.47.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160486555 31667 127.0.0.1 (10 Oct 2006 13:22:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 13:22:35 +0000 (UTC)
In-Reply-To: <1160485084.300419.19760@k70g2000cwa.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: h48g2000cwc.googlegroups.com; posting-host=192.85.47.1;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276916


disney.walter@gmail.com wrote:
> Hi everybody. My old TNSnames.ora file had the following entry:
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = NTS04.bettojahotels.local)(PORT =
> 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl)
> )
> )
>
> As I used to execute exporting data with the command "exp
> system/manager full=yes file=AAB_FULL.dmp log=AAB_FULL.log" directly on
> the server everything was OK;
>  Actually I reinstalled Oracle on the server and the entry in
> TNSnames.ora file  changed as following:
> ORCL.BETTOJAHOTELS.LOCAL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = nts04)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORCL)
> )
> )
>
> and the command Exp gave the errors:
> EXP-00056: errore ORACLE 12560 rilevato
> ORA-12560: TNS: errore dell'adattatore del protocollo
> EXP-00000: Operazione di esportazione terminata con errore
> so I changed the Exp statement into: "exp system/manager@ORCL full=yes
> file=AAB_FULL.dmp log=AAB_FULL.log" and everything backed fine: can
> anyone tell me what is wrong with the configuration files?
> P.S. I always typed the exp statement directly on the server

Nothing.  Check to see that ORACLE_SID is properly set in your
environment.


David Fitzjarrell