Home » RDBMS Server » Server Utilities » Export Command Related
Export Command Related [message #267596] Thu, 13 September 2007 16:54 Go to next message
dineshcr
Messages: 8
Registered: November 2006
Junior Member
When I try to run the oracle “export “ command on UNIX environment , I got the following error message, I am not sure what setting should I check on UNIX to fix this error, I have verified the listener status, listener seems to be working fine and I can connect to database from windows client.

Please let me know, what environment variables needs to set ( I tried setting ORACLE_HOME and LIBPATH but export still not working )

Thanks

EXP-00056: ORACLE error 12541 encountered
ORA-12541: TNS:no listener
EXP-00000: Export terminated unsuccessfully
Re: Export Command Related [message #267598 is a reply to message #267596] Thu, 13 September 2007 17:03 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Here is what we know:
>EXP-00056: ORACLE error 12541 encountered
>ORA-12541: TNS:no listener
>EXP-00000: Export terminated unsuccessfully

Here is what we don't know:
Actual OS name and version.
Oracle version to FOUR decimal places
The actual command syntax that failed.
Where (on which system) is the database you want to export from actually exists; relative to where this "Unix environment" is.
>listener seems to be working fine and I can connect to database from windows client.
Above is positive news, but what happens when you try using SQL*Plus from unix environment?

Use CUT & PASTE plus use of <code tags> to respond as described in the #1 STICKY post at top of this forum.

[Updated on: Thu, 13 September 2007 17:04] by Moderator

Report message to a moderator

Re: Export Command Related [message #267744 is a reply to message #267598] Fri, 14 September 2007 10:51 Go to previous messageGo to next message
dineshcr
Messages: 8
Registered: November 2006
Junior Member
Thanks for your reply.

Here are the details:
OS Name and Version: HP-UX ssaora B.11.00 A 9000/800
Oracle version : Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

Tnsnames:

listener=(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL=tcp)(HOST=10.10.211.222)(PORT=1525))
)
(CONNECT_DATA=(SID=SCAR)
)
)

Command failed:

connect bac/bac@listener
ORA-12154: TNS:could not resolve service name

Am I using the wrong connect string, I can connect to database from windows oracle SQL*Plus client. Using following command

connect bac/bac@listener
Re: Export Command Related [message #267750 is a reply to message #267596] Fri, 14 September 2007 12:17 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Please use CUT & PASTE plus <code tags> to post the following results:

env | sort

& does this while logged onto the unix environment as the same user which is attempting to invoke expotr.
Re: Export Command Related [message #267751 is a reply to message #267750] Fri, 14 September 2007 12:44 Go to previous messageGo to next message
dineshcr
Messages: 8
Registered: November 2006
Junior Member
$ env | sort
COLUMNS=80
EDITOR=vi
ERASE=^H
HOME=/home/orauser
LINES=25
LOGNAME=u017176
MAIL=/var/mail/u017176
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man /%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man/%L:/opt/hparray/share/man: /opt/ignite/share/man/%L:/opt/ignite/share/man
PATH=/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/us r/contrib/bin/X11:/opt/hparray/bin:/wf/sw/bin:.
PWD=/home/u017176
SHELL=/usr/bin/sh
SWDIR=/wf/sw
TERM=ansi
TZ=EST5EDT
_=/usr/bin/env
Re: Export Command Related [message #267752 is a reply to message #267596] Fri, 14 September 2007 13:24 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You do NOT have ORACLE_HOME defined, so I am not surprised that it did not work.
Re: Export Command Related [message #267753 is a reply to message #267752] Fri, 14 September 2007 13:32 Go to previous messageGo to next message
dineshcr
Messages: 8
Registered: November 2006
Junior Member
I did set ORACLE_HOME, using following, it's not in the previous env list since I logged out and logged in back after this settings.

Any other settings that I am missing other than ORACLE_HOME, I am sure this might not be the issue.

export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_BIN=$ORACLE_HOME/bin
export PATH=$PATH:$ORACLE_HOME:$ORACLE_BIN
Re: Export Command Related [message #267870 is a reply to message #267596] Sat, 15 September 2007 21:52 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Your listener either is not running or you specified wrong one.
Previous Topic: Having Problems with SQL Loader
Next Topic: "Original" IMP transportable tablespace. IMP wants a datafile?
Goto Forum:
  


Current Time: Sun Dec 04 22:32:36 CST 2016

Total time taken to generate the page: 0.08233 seconds