| Computers Forum Index » Computer - Databases - Oracle (Server) » Problem with with exp... |
|
Page 1 of 1 |
|
| Author |
Message |
| Georg Scholz... |
 Posted: Sun Oct 25, 2009 1:34 pm |
|
|
|
Guest
|
Dear all,
I installed the Oracle Client 10.2.0.1.0 on a new machine with Windows
XP.
SQLPLUS and TNSPING are working fine; however, there there is a
problem with EXP:
I'm getting the error ORA-12154: TNS:could not resolve the connect
identifier specified
It use it like this:
exp user/pw at (no spam) db full=Y direct=y file=c:\db.dmp
The tnsnames.ora is okay (otherwise, sqlplus and tnsping would fail)
The help doesn't really help me.
Anyone has an idea about what could be the problem?
Thank you in advance!
Georg |
|
|
| Back to top |
|
|
|
| Ruud de Koter... |
| Posted: Sun Oct 25, 2009 9:34 pm |
|
|
|
Guest
|
Hi Georg,
Quote: Dear all,
I installed the Oracle Client 10.2.0.1.0 on a new machine with Windows
XP.
SQLPLUS and TNSPING are working fine; however, there there is a
problem with EXP:
I'm getting the error ORA-12154: TNS:could not resolve the connect
identifier specified
It use it like this:
exp user/pw at (no spam) db full=Y direct=y file=c:\db.dmp
The tnsnames.ora is okay (otherwise, sqlplus and tnsping would fail)
The help doesn't really help me.
Anyone has an idea about what could be the problem?
Thank you in advance!
Georg
First points on my checklist:
- check the Windows path for the execution environment,
- check how many tnsnames.ora files there actually are on the machine;
make sure exp uses the right one.
I can probably sum this up as: might there be (or have been) another
Oracle installation on the machine?
Regards,
Ruud de Koter. |
|
|
| Back to top |
|
|
|
| Arne Ortlinghaus... |
| Posted: Mon Oct 26, 2009 10:59 am |
|
|
|
Guest
|
Perhaps exp is started from another Oracle home directory? Or another
tnsnames is somewhere? (may also in some other directories for example in
the user settings).
Arne Ortlinghaus
ACS Data Systems |
|
|
| Back to top |
|
|
|
| ddf... |
| Posted: Mon Oct 26, 2009 5:02 pm |
|
|
|
Guest
|
On Oct 26, 12:59 am, "Arne Ortlinghaus" <Arne.Ortlingh... at (no spam) acs.it>
wrote:
Quote: Perhaps exp is started from another Oracle home directory? Or another
tnsnames is somewhere? (may also in some other directories for example in
the user settings).
Arne Ortlinghaus
ACS Data Systems
And perhaps the OP solved his own problem which is why the original
has been removed.
David Fitzjarrell |
|
|
| Back to top |
|
|
|
| Steve Howard... |
| Posted: Mon Oct 26, 2009 10:06 pm |
|
|
|
Guest
|
On Oct 26, 1:02 pm, ddf <orat... at (no spam) msn.com> wrote:
Quote: And perhaps the OP solved his own problem which is why the original
has been removed.
David Fitzjarrell
The responder can probably still see the original, as he isn't posting
through Google Groups. |
|
|
| Back to top |
|
|
|
| Ruud de Koter... |
| Posted: Tue Oct 27, 2009 3:14 am |
|
|
|
Guest
|
Thanks, Steve,
Quote: On Oct 26, 1:02 pm, ddf <orat... at (no spam) msn.com> wrote:
And perhaps the OP solved his own problem which is why the original
has been removed.
David Fitzjarrell
The responder can probably still see the original, as he isn't posting
through Google Groups.
for solving the riddle David dumped on my desk. Makes me feel even more
like a dinosaur, but at least I got Joel's company while waiting...
Regards,
Ruud de Koter |
|
|
| Back to top |
|
|
|
|
